track plan statistics of all SQL statements executed
pgext.cloud · Source code · Website · License text · Control file
| Package | pg_store_plans |
|---|---|
| Version | 1.10 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | Multiple repositories |
| Extension type | Preloaded |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | Yes |
| Shared libraries | pg_store_plans |
| Stars | 69 |
| Latest commit | 2026-03-24 |
| Latest release | 2026-03-24 |
| Catalogue updated | 2026-08-30 |
| pg_plan_advsr | Automated execution plan tuning extension |
| pg_stat_plans | Track per-plan call counts, execution times, and example EXPLAIN texts. |
| pg_profile | PostgreSQL load profile repository and report builder |
| pg_stat_monitor | The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information. |
| pg_show_plans | show query plans of all currently running SQL statements |
| pg_stat_statements | track planning and execution 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 |
| powa | PostgreSQL Workload Analyser-core |
| pg_overexplain | Allow EXPLAIN to dump even more details |
| pg_wait_sampling | sampling based statistics of wait events |