Available in all PostgreSQL installations (requires enabling in postgresql.conf). The extension captures query patterns (normalized with parameter placeholders), execution counts, total/mean/min/max execution times, rows affected, and block I/O statistics. Essential for identifying slow queries, frequently executed queries, and performance regressions. Statistics persist across server restarts when configured. Works with pg_stat_statements_reset() for baseline management. Commonly combined with visualization tools like pgBadger, pgHero, or Percona PMM for dashboards. The extension has minimal performance overhead (typically <5%) making it suitable for production use.
pg_stat_statements
pg_stat_statements is a PostgreSQL core extension that tracks execution statistics for all SQL statements, providing essential performance monitoring without third-party tools.
Tags
Popular tags
open-source17embedding database2free BI tool2open source BI2data quality2vector database2database migration2data governance platform2data observability2database DevOps2natural language BI2AI visualization1analytics engineering1BigQuery AI1BigQuery ML1BigQuery Studio1Copilot analytics1Cortex AI1Cortex Analyst1data transformation1Databricks analytics1DBeaver AI1DBeaver Community1DBeaver Enterprise1