Improve EXPLAIN ANALYZE to show the time spent in each trigger when
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 25 Mar 2005 21:58:00 +0000 (21:58 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 25 Mar 2005 21:58:00 +0000 (21:58 +0000)
commit72b5e24772a947f4366fda60e5e1bf952c373abf
treeea77389c2c8d9dd46322aa9e682433fb21a8857e
parentb152de15276496b78f5cef921d321a16eb8b38f9
Improve EXPLAIN ANALYZE to show the time spent in each trigger when
executing a statement that fires triggers.  Formerly this time was
included in "Total runtime" but not otherwise accounted for.
As a side benefit, we avoid re-opening relations when firing non-deferred
AFTER triggers, because the trigger code can re-use the main executor's
ResultRelInfo data structure.
16 files changed:
doc/src/sgml/perform.sgml
src/backend/catalog/pg_constraint.c
src/backend/commands/copy.c
src/backend/commands/explain.c
src/backend/commands/portalcmds.c
src/backend/commands/trigger.c
src/backend/executor/execMain.c
src/backend/executor/execProcnode.c
src/backend/executor/functions.c
src/backend/executor/instrument.c
src/backend/executor/spi.c
src/backend/tcop/pquery.c
src/include/catalog/pg_constraint.h
src/include/commands/trigger.h
src/include/executor/instrument.h
src/include/nodes/execnodes.h