select open change scope Open full search

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

Extensions / Monitoring

pg_get_queryid

get last queryid generated/used by pg_stat_statements for a given backend pid

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

Overview

Packagepg_get_queryid
Version1.0
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariespg_stat_statements, pg_get_queryid
Stars2
Latest commit2021-02-24
Catalogue updated2026-08-30

Related extensions

Requires

pg_stat_statementstrack planning and execution statistics of all SQL statements executed

See also

pgmonitorCollector-friendly metric views and background refresh worker
pgfr_recordServer-side PostgreSQL performance flight recorder
pg_dbwaAnalyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots.
autovacuum_informationsPostgreSQL extension that adds functions for reporting the autovacuum launcher PID and autovacuum worker information.
pg_grab_statementRecord detailed SQL statements from successfully committed transactions.
pgnodemxCapture node OS metrics via SQL queries
xl_global_viewsCreates global pgxl_ views over Postgres-XL nodes based on pg_ views.
pg_query_stateTool for query progress monitoring in PostgreSQL