{"repo":"cybertec-postgresql/pg_show_plans","free":true,"listed":false,"github":"https://github.com/cybertec-postgresql/pg_show_plans","clone":"git clone https://github.com/cybertec-postgresql/pg_show_plans.git","description":"Show query plans of all currently running SQL statements","language":"C","stars":208,"topics":["postgresql-extension","postgresql"],"license":null,"category":"databases-storage","readme_excerpt":"pg show plans PostgreSQL extension that shows query plans of all the currently running SQL statements. Query plans can be shown in several formats, like JSON or YAML . This extension creates a hash table within shared memory. The hash table is not resizable, thus, no new plans can be added once it has been filled up. INSTALL PostgreSQL versions 14 and newer are supported. Install PostgreSQL before proceeding. Make sure to have pg config binary, these are typically included in -dev and -devel packages. Configure Add pg show plans to shared preload libraries within postgresql.conf : Restart the server, and invoke CREATE EXTENSION pg show plans; : USAGE To see the query plans: To get query plans and see the corresponding query expression: BENCHMARKS pgbench -i -s 10 pgbench -c 10 -j 3 -T 60 -S plain PostgreSQL 18.1 : pgbench -c 10 -j 3 -T 60 -S PostgreSQL 18.1 with pg show plans version 2.1.7 : Approximately 14% performance penalty. REFERENCE GUC Variables pg show plans.plan format = text : query plans output format, either of text , json , yaml , and xml . pg show plans.max plan length = 16384 : query plan maximal length in bytes. This value affects the amount of shared memory the extension asks for, the server may not start if the value is too high. pg show plans.is enabled = true : enable or disable the extension by assigning to this variable. Default values are shown after '=' sign. Views pg show plans : defined as SELECT FROM pg show plans(); for convenience. pg show plans ","default_branch":null,"files":null,"tree":[],"storefront":"/r/cybertec-postgresql","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/cybertec-postgresql/pg_show_plans/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}