Track per-plan call counts, execution times, and example EXPLAIN texts.
pgext.cloud · Source code · License text · Control file
| Package | pg_stat_plans |
|---|---|
| Version | 2.1.0 |
| PostgreSQL versions | 16 · 17 · 18 |
| Repository | PGDG |
| Extension type | Preloaded |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | Yes |
| Shared libraries | $libdir/pg_stat_plans |
| Stars | 51 |
| Latest commit | 2026-06-24 |
| Latest release | 2026-06-25 |
| Catalogue updated | 2026-08-30 |
| pg_show_plans | show query plans of all currently running SQL statements |
| pg_store_plans | track plan statistics of all SQL statements executed |
| 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_overexplain | Allow EXPLAIN to dump even more details |
| pg_stat_statements | track planning and execution statistics of all SQL statements executed |
| pg_hint_plan | Give PostgreSQL ability to manually force some decisions in execution plans. |
| hypopg | Hypothetical indexes for PostgreSQL |
| pg_qualstats | An extension collecting statistics about quals |
| online_advisor | Suggest missing indexes and extended statistics online |