pg_show_plans

pg_show_plans copied to clipboard

Size of Hash table and warning querying catalog

2

Hi Team, 1. When the server starts, pg_show_plans makes a hashtable on the shared-memory in order to temporarily store query plans. The hashtable size cannot be changed, so the plans...

nikhil-postgres

When pg_show_plans is enable, it brings the performance down seriously: Stress testing tool：benchmark （200 Client） - before **(shared_preload_libraries='')**： Measured tpmC = 315000 Measured tpmTOTAL = 694000 - after **(shared_preload_libraries='pg_show_plans')**： Measured...

hslightdb

add using pgxs for install

i0seph

The Readme shows these steps for building and installing the pg_show_plans extension: ``` $ tar xvfj postgresql-12.2.tar.bz2 $ cd postgresql-12.2/contrib $ git clone https://github.com/cybertec-postgresql/pg_show_plans.git $ cd pg_show_plans $ make &&...

alchemistmatt

Hello, pg_show_plans_disable() effect, is disabled after each new backend startup inside pgsp_shmem_startup(), that sets pgsp->is_enable = true; fix proposal: ``` if (!found) { /* First time through ... */ #if...

legrandlegrand

Add somekind of option to start disabled

1

As such troubleshooting / debugging is not always used and has a small performance impact, would be nice if the extension could start in disabled mode and one could enable...

kmoppel

I installed postgresql via brew and then only installed the xcode commandline package (`xcode-select --install`). Installing this extension via `make USE_PGXS=TRUE` failed with ``` λ make USE_PGXS=TRUE clang -Wall -Wmissing-prototypes...

jankatins