select open change scope Open full search

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

Extensions / Monitoring

pg_stat_log

Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.

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

Overview

Packagepg_stat_log
Version0.1
PostgreSQL versions18
RepositoryPGDG
Extension typePreloaded
Distributiontencentdb-postgresql
VendorTencent Cloud
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared libraries$libdir/pg_stat_log
Stars27
Latest commit2026-08-17
Latest release2026-08-17
Catalogue updated2026-08-30

Related extensions

See also

pgelogExtended logging via pseudo-autonomous transactions
logerrorsFunction for collecting statistics about messages in logfile
pg_sqlogProvide SQL interface to logs
log_fdwforeign-data wrapper for Postgres log file access
pgauditprovides auditing functionality
pgdisablelogerrorDisable selected SQLSTATE error codes from PostgreSQL server logging.
pg_auth_monmonitor connection attempts per user
pg_tracingDistributed Tracing for PostgreSQL
pg_stat_backtraceCapture or log C-level stack backtraces of PostgreSQL processes
pgfr_recordServer-side PostgreSQL performance flight recorder