Track SQL execution statistics using a PostgreSQL 9.4 pg_stat_statements derivative integrated with sql_firewall
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pg_stat_statements2 |
|---|---|
| Version | 1.2 |
| Repository | Unspecified |
| Extension type | Preloaded |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | Yes |
| Shared libraries | sql_firewall, pg_stat_statements2 |
| Stars | 0 |
| Latest commit | 2015-09-20 |
| Catalogue updated | 2026-08-30 |
| sql_firewall | Cluster-wide query allowlist firewall with learning, enforcing, permissive, and disabled modes keyed by user and parse-tree fingerprint. |
| pg_stat_statements | track planning and execution statistics of all SQL statements executed |
| sql_firewall | Cluster-wide query allowlist firewall with learning, enforcing, permissive, and disabled modes keyed by user and parse-tree fingerprint. |
| pg_dbwa | Analyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots. |
| pg_grab_statement | Record detailed SQL statements from successfully committed transactions. |
| pg_sessions | Tracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory. |
| pg_command_fw | DDL and utility command firewall for PostgreSQL |
| pg_stat_sql_plans | Track execution statistics by normalized SQL query and plan ID. |
| pg_stat_cluster_activity | track execution statistics in whole cluster scope |
| 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_stat_plans | Track per-plan call counts, execution times, and example EXPLAIN texts. |