Provides a means for logging execution plans of slow statements automatically
pgext.cloud · Website · Documentation · License text
| Package | auto_explain |
|---|---|
| Version | - |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PostgreSQL contrib |
| Extension type | No DDL |
| Requires CREATE EXTENSION | No |
| Requires preload | Yes |
| Trusted | No |
| Shared libraries | auto_explain |
| Latest commit | 2026-05-14 |
| Latest release | 2026-05-14 |
| Catalogue updated | 2026-07-29 |
| pg_logqueryid | Logs pg_stat_statements query IDs alongside auto_explain output. |
| 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 |
| 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 |
| 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_profile | PostgreSQL load profile repository and report builder |