Commite2a0fc5

committed

auto_explain: Add logging of trigger execution

Author: Kyotaro HORIGUCHIReviewed-by: Jaime Casanova

1 parent84df54b commite2a0fc5Copy full SHA for e2a0fc5

File tree

+32

-0

lines changed

+32

-0

lines changed

Lines changed: 14 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -25,6 +25,7 @@ static intauto_explain_log_min_duration = -1; /* msec or -1 */`
`25`	`25`	`staticboolauto_explain_log_analyze= false;`
`26`	`26`	`staticboolauto_explain_log_verbose= false;`
`27`	`27`	`staticboolauto_explain_log_buffers= false;`
	`28`	`+staticboolauto_explain_log_triggers= false;`
`28`	`29`	`staticboolauto_explain_log_timing= false;`
`29`	`30`	`staticintauto_explain_log_format=EXPLAIN_FORMAT_TEXT;`
`30`	`31`	`staticboolauto_explain_log_nested_statements= false;`
`@@ -113,6 +114,17 @@ _PG_init(void)`
`113`	`114`	`NULL,`
`114`	`115`	`NULL);`
`115`	`116`
	`117`	`+DefineCustomBoolVariable("auto_explain.log_triggers",`
	`118`	`+"Include trigger statistics in plans.",`
	`119`	`+"This has no effect unless log_analyze is also set.",`
	`120`	`+&auto_explain_log_triggers,`
	`121`	`+ false,`
	`122`	`+PGC_SUSET,`
	`123`	`+0,`
	`124`	`+NULL,`
	`125`	`+NULL,`
	`126`	`+NULL);`
	`127`	`+`
`116`	`128`	`DefineCustomEnumVariable("auto_explain.log_format",`
`117`	`129`	`"EXPLAIN format to be used for plan logging.",`
`118`	`130`	`NULL,`
`@@ -295,6 +307,8 @@ explain_ExecutorEnd(QueryDesc *queryDesc)`
`295`	`307`	`ExplainBeginOutput(&es);`
`296`	`308`	`ExplainQueryText(&es,queryDesc);`
`297`	`309`	`ExplainPrintPlan(&es,queryDesc);`
	`310`	`+if (es.analyze&&auto_explain_log_triggers)`
	`311`	`+ExplainPrintTriggers(&es,queryDesc);`
`298`	`312`	`ExplainEndOutput(&es);`
`299`	`313`
`300`	`314`	`/* Remove last line break */`

Lines changed: 18 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -122,6 +122,24 @@ LOAD 'auto_explain';`
`122`	`122`	`</listitem>`
`123`	`123`	`</varlistentry>`
`124`	`124`
	`125`	`+ <varlistentry>`
	`126`	`+ <term>`
	`127`	`+ <varname>auto_explain.log_triggers</varname> (<type>boolean</type>)`
	`128`	`+ </term>`
	`129`	`+ <indexterm>`
	`130`	`+ <primary><varname>auto_explain.log_triggers</> configuration parameter</primary>`
	`131`	`+ </indexterm>`
	`132`	`+ <listitem>`
	`133`	`+ <para>`
	`134`	`+ <varname>auto_explain.log_triggers</varname> causes trigger`
	`135`	`+ execution statistics to be included when an execution plan is logged.`
	`136`	`+ This parameter is off by default. Only superusers can change this`
	`137`	`+ setting. This parameter has no effect unless`
	`138`	`+ <varname>auto_explain.log_analyze</> parameter is set.`
	`139`	`+ </para>`
	`140`	`+ </listitem>`
	`141`	`+ </varlistentry>`
	`142`	`+`
`125`	`143`	`<varlistentry>`
`126`	`144`	`<term>`
`127`	`145`	`<varname>auto_explain.log_format</varname> (<type>enum</type>)`

Comments

(0)