Allow EXPLAIN to dump even more details
pgext.cloud · Website · Documentation · License text
| Package | pg_overexplain |
|---|---|
| Version | 1.0 |
| PostgreSQL versions | 18 |
| Repository | PostgreSQL contrib |
| Extension type | No DDL |
| Requires CREATE EXTENSION | No |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | No |
| Shared libraries | pg_overexplain |
| Latest commit | 2026-05-14 |
| Latest release | 2026-05-14 |
| Catalogue updated | 2026-07-29 |
| pg_stat_plans | Track per-plan call counts, execution times, and example EXPLAIN texts. |
| pg_show_plans | show query plans of all currently running SQL statements |
| 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_store_plans | track plan statistics of all SQL statements executed |
| pg_stat_statements | track planning and execution statistics of all SQL statements executed |
| 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_qualstats | An extension collecting statistics about quals |
| hypopg | Hypothetical indexes for PostgreSQL |