select open change scope Open full search

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

Extensions / Monitoring

pg_logqueryid

Logs pg_stat_statements query IDs alongside auto_explain output.

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

Overview

Packagepg_logqueryid
Version0.0.1
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typePreloaded
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_stat_statements, auto_explain, pg_logqueryid
Stars6
Latest commit2025-09-27
Latest release2022-11-12
Catalogue updated2026-08-30

Related extensions

Requires

auto_explainProvides a means for logging execution plans of slow statements automatically
pg_stat_statementstrack planning and execution statistics of all SQL statements executed

See also

pg_overexplainAllow EXPLAIN to dump even more details
pg_stat_plansTrack per-plan call counts, execution times, and example EXPLAIN texts.
explanationEXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree.
pg_repeaterReplicates utility statements and serialized query plans to a remote PostgreSQL node over postgres_fdw.
pg_query_stateTool for query progress monitoring in PostgreSQL
pg_block_if_slowAbort queries that are taking too long based on EXPLAIN estimates.
auto_explainProvides a means for logging execution plans of slow statements automatically
dsefDiffStats and ExplainFull: detailed SQL reports for third party help & support