From c113e00fc681289e33f72855d86b93b0d44360d2 Mon Sep 17 00:00:00 2001 From: Atsushi Torikoshi Date: Tue, 17 Jan 2023 22:42:19 +0900 Subject: [PATCH v2] Make auto_explain record query identifier When auto_explain.log_verbose is on, auto_explain should record logs equivalent to VERBOSE option of EXPLAIN. Howerver, when compute_query_id is on, query identifiers are only printed in VERBOSE option of EXPLAIN. This patch makes auto_explain also print query identifier. --- contrib/auto_explain/auto_explain.c | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/contrib/auto_explain/auto_explain.c b/contrib/auto_explain/auto_explain.c index c3ac27ae99..ee6917e605 100644 --- a/contrib/auto_explain/auto_explain.c +++ b/contrib/auto_explain/auto_explain.c @@ -21,6 +21,7 @@ #include "jit/jit.h" #include "nodes/params.h" #include "utils/guc.h" +#include "utils/queryjumble.h" PG_MODULE_MAGIC; @@ -403,6 +404,9 @@ explain_ExecutorEnd(QueryDesc *queryDesc) ExplainQueryText(es, queryDesc); ExplainQueryParameters(es, queryDesc->params, auto_explain_log_parameter_max_length); ExplainPrintPlan(es, queryDesc); + if (es->verbose && queryDesc->plannedstmt->queryId != UINT64CONST(0)) + ExplainPropertyInteger("Query Identifier", NULL, (int64) + queryDesc->plannedstmt->queryId, es); if (es->analyze && auto_explain_log_triggers) ExplainPrintTriggers(es, queryDesc); if (es->costs) base-commit: 15eb1228800a35042ef318f941173aa8b89002d1 -- 2.25.1