select open change scope Open full search

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

Extensions / Monitoring

pg_querylog

Captures current and recently completed backend queries in shared memory for SQL inspection.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagepg_querylog
Version0.1
PostgreSQL versions10 · 11 · 12
RepositoryUnspecified
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariespg_querylog
Stars2
Latest commit2020-07-24
Catalogue updated2026-08-30

Related extensions

See also

pg_turretCapture PostgreSQL logs and export structured events to HTTP, Kafka, or Sentry
loginfoFunctions and views for PostgreSQL to query the postgres log
pg_sampletologSamples statements or whole transactions into PostgreSQL logs through executor and utility hooks.
pgfr_recordServer-side PostgreSQL performance flight recorder
pg_jobmonExtension for logging and monitoring functions in PostgreSQL
query_recorderquery_recorder: record executed SQL queries to rotating files for later analysis or replay
logfmtlogfmt log collector
pg_loggingCaptures PostgreSQL log records in a shared-memory ring buffer and exposes them through SQL functions.
pgtelemetryProvides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics.
pg_otel_tracerRust based Postgres extension that adds query lifecycle events to OTEL traces.