select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Monitoring

pg_grab_statement

Record detailed SQL statements from successfully committed transactions.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagepg_grab_statement
Version1.0
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_grab_statement
Schemagrab
Stars12
Latest commit2016-03-21
Latest release2016-03-14
Catalogue updated2026-08-30

Related extensions

See also

pg_dbwaAnalyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots.
pg_sessionsTracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory.
pg_stat_statementstrack planning and execution statistics of all SQL statements executed
pgtelemetryProvides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics.
gbdchecksDatabase health-check functions and views for bloat, locks, query statistics, and privileges.
pg_stat_statements2Track SQL execution statistics using a PostgreSQL 9.4 pg_stat_statements derivative integrated with sql_firewall
pgmonitorCollector-friendly metric views and background refresh worker
pgfr_analyzeReporting and analysis functions for pgfr_record
pgsamplerExperimental PostgreSQL background worker that collects time-series status and performance metrics.
pg_statvizCapture PostgreSQL statistics snapshots for time-series analysis and visualization