]> git.ipfire.org Git - thirdparty/postgresql.git/commit
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)
commitadb1a6e95b2087e44c845edc15c28a87f5ba7ac1
tree262134a0f4ec11fe71f1963d4531b71f2534aea3
parent08890b407e976e4871f2024ed5a3071d0fa510a6
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