select open change scope Open full search

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

Extensions / Monitoring

pg_log_statements

Enables log_statement=all selectively for chosen PostgreSQL backend processes or newly started backends matching connection filters.

pgext.cloud · Source code · Documentation · License text · Control file · PGXN

Overview

Packagepg_log_statements
Version0.0.2
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16
RepositoryUnspecified
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_log_statements
Stars12
Latest commit2024-02-17
Latest release2022-11-06
Catalogue updated2026-08-30

Related extensions

See also

pgmementoTransaction-based audit trail with schema versioning
table_logrecord table modification logs and PITR for table/row
pglogPostgreSQL log via SQL
loginfoFunctions and views for PostgreSQL to query the postgres log
pg_loggingCaptures PostgreSQL log records in a shared-memory ring buffer and exposes them through SQL functions.
pg_logfebelog via febe framing protocol to a unix socket
logfmtlogfmt log collector
table_log_plPL/pgSQL drop-in replacement for the table_log trigger-based DML auditing extension.