show query plans of all currently running SQL statements
pgext.cloud · Source code · Website · License text · Control file
| Package | pg_show_plans |
|---|---|
| Version | 2.1.8 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PGDG |
| Extension type | Preloaded |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | Yes |
| Shared libraries | pg_show_plans |
| Stars | 208 |
| Latest commit | 2026-06-03 |
| Latest release | 2026-06-03 |
| Catalogue updated | 2026-08-30 |
| pg_stat_plans | Track per-plan call counts, execution times, and example EXPLAIN texts. |
| auto_explain | Provides a means for logging execution plans of slow statements automatically |
| explain_ui | easily jump into a visual plan UI for any SQL query |
| pg_stat_statements | track planning and execution statistics of all SQL statements executed |
| pg_store_plans | track plan statistics of all SQL statements executed |
| pg_overexplain | Allow EXPLAIN to dump even more details |
| pg_qualstats | An extension collecting statistics about quals |
| online_advisor | Suggest missing indexes and extended statistics online |
| pgrowlocks | show row-level locking information |
| pg_wait_sampling | sampling based statistics of wait events |