pg_badplan | PostgreSQL extension for logging queries

by trustly C Version: Current License: MIT

X-Ray Key Features Code Snippets Community Discussions Vulnerabilities Install Support

kandi X-RAY | pg_badplan Summary

pg_badplan is a C library. pg_badplan has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can download it from GitHub.

pg_badplan is an PostgreSQL extension that logs when the planners row estimate vs actual is over a specified ratio. This is useful when you want to find queries where the planner might be doing a bad plan becase the statistics is bad. It works by installing execution start and end hooks that first enable row instrumentation and during end check the plans estimated vs executed actual rows. Since it enables instrumentation it will likely impose a performance penelty but how much we haven’t measured.

Support

Quality

Security

License

Reuse

Support

pg_badplan has a low active ecosystem.

It has 37 star(s) with 4 fork(s). There are 12 watchers for this library.

It had no major release in the last 6 months.

pg_badplan has no issues reported. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of pg_badplan is current.

Quality

pg_badplan has no bugs reported.

Security

pg_badplan has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

pg_badplan is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

pg_badplan releases are not available. You will need to build from source code and install.

Installation instructions are available. Examples and code snippets are not available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of pg_badplan

Get all kandi verified functions for this library.

pg_badplan Key Features

No Key Features are available at this moment for pg_badplan.

pg_badplan Examples and Code Snippets

No Code Snippets are available at this moment for pg_badplan.

Community Discussions

No Community Discussions are available at this moment for pg_badplan.Refer to stack overflow page for discussions.

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install pg_badplan

This extension has been developed using Pg 10.2 but should probably work with earlier relases as well. Build and install by running make install. This will consult pg_config with where to install into and where the necessary headers are. Make sure your $PATH lists the correct pg_config. Enable the module by adding shared_preload_libraries = 'pg_badplan' to your postgresql.conf. Then restart PostgreSQL.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: