track planning and execution statistics of all SQL statements executed
pgext.cloud · Website · Documentation · License text · Control file
| Package | pg_stat_statements |
|---|---|
| Version | 1.11 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PostgreSQL contrib |
| Extension type | Preloaded |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Shared libraries | pg_stat_statements |
| Latest commit | 2026-05-14 |
| Latest release | 2026-05-14 |
| Catalogue updated | 2026-07-29 |
| gbdchecks | Database health-check functions and views for bloat, locks, query statistics, and privileges. |
| pg_dbwa | Analyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots. |
| pg_eyes | SQL monitoring functions and views for PostgreSQL database activity |
| pg_get_queryid | get last queryid generated/used by pg_stat_statements for a given backend pid |
| pg_logqueryid | Logs pg_stat_statements query IDs alongside auto_explain output. |
| pg_shared_plans | Proof-of-concept shared-memory execution-plan cache for PostgreSQL |
| pg_sortstats | Collect per-query sort statistics and estimate required work_mem |
| pg_stat_kcache | Kernel statistics gathering |
| pgtelemetry | Provides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics. |
| powa | PostgreSQL Workload Analyser-core |
| stat_record | Background-worker snapshot recorder and reporting suite for PostgreSQL server statistics. |
| 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_store_plans | track plan statistics of all SQL statements executed |
| auto_explain | Provides a means for logging execution plans of slow statements automatically |
| pg_show_plans | show query plans of all currently running SQL statements |
| powa | PostgreSQL Workload Analyser-core |
| explain_ui | easily jump into a visual plan UI for any SQL query |
| pg_qualstats | An extension collecting statistics about quals |
| online_advisor | Suggest missing indexes and extended statistics online |
| pg_relusage | Log all the queries that reference a particular column |
| pg_wait_sampling | sampling based statistics of wait events |