planinstr

This Release
planinstr 0.0.2
Date
Status
Unstable
Other Releases
Abstract
Measure planner duration
Description
A planner hook to measure planner running time, mainly debug purpose
Released By
umitanuki
License
The PostgreSQL License
Special Files
Tags

Extensions

planinstr 0.0.1
A short description

README

planinstr

planinstr provides a plugin routines to measure planner running time. Once the module is loaded into the backend, additional row that tells "Plan Time" at the end of output rows of EXPLAIN.

To build it, just do this:

make
make install

If you encounter an error such as:

make: pg_config: Command not found

Be sure that you have pg_config installed and in your path. If you used a package management system such as RPM to install PostgreSQL, be sure that the -devel package is also installed. If necessary tell the build process where to find it:

env PG_CONFIG=/path/to/pg_config make && make installcheck && make install

Once make install is done, connect your database with psql or other client and type

LOAD '$libdir/planinstr'

then throw EXPLAIN query. If you prefere the loading operation be automated, add an entry of shared_preload_library in postgresql.conf.

Dependencies

The planinstr data type has no dependencies other than PostgreSQL.