select open change scope Open full search

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

Extensions / Monitoring

pg_logging

Captures PostgreSQL log records in a shared-memory ring buffer and exposes them through SQL functions.

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

Overview

Packagepg_logging
Version0.2
PostgreSQL versions10 · 11
RepositoryUnspecified
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariespg_logging
Stars15
Latest commit2018-12-27
Catalogue updated2026-08-30

Related extensions

See also

pgmementoTransaction-based audit trail with schema versioning
loggingAdministrative C function to enable or disable logging mode on relations.
table_logrecord table modification logs and PITR for table/row
loginfoFunctions and views for PostgreSQL to query the postgres log
tablelogTrigger-based audit and change-data-capture extension that records INSERT, UPDATE, and DELETE row images in a central log table and can generate replay SQL.
pg_logfebelog via febe framing protocol to a unix socket
pg_log_statementsEnables log_statement=all selectively for chosen PostgreSQL backend processes or newly started backends matching connection filters.
logfmtlogfmt log collector