select open change scope Open full search

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

Extensions / Monitoring

pg_sqlog

Provide SQL interface to logs

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

Overview

Packagepg_sqlog
Version1.6
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemasqlog
Stars7
Latest commit2024-11-18
Catalogue updated2026-08-30

Related extensions

Requires

file_fdwforeign-data wrapper for flat file access

See also

log_fdwforeign-data wrapper for Postgres log file access
pg_stat_logTrack cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.
logerrorsFunction for collecting statistics about messages in logfile
pgelogExtended logging via pseudo-autonomous transactions
file_fdwforeign-data wrapper for flat file access
pg_csvFlexible CSV processing for Postgres
aws_s3aws_s3 postgres extension to import/export data from/to s3
pgdisablelogerrorDisable selected SQLSTATE error codes from PostgreSQL server logging.
pgauditprovides auditing functionality
pg_auth_monmonitor connection attempts per user