From adb1a6e95b2087e44c845edc15c28a87f5ba7ac1 Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Fri, 25 Mar 2005 21:58:00 +0000
Subject: 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.

---
 src/backend/executor/functions.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src/backend/executor/functions.c')

diff --git a/src/backend/executor/functions.c b/src/backend/executor/functions.c
index df54b56ff57..fdbd6107a0f 100644
--- a/src/backend/executor/functions.c
+++ b/src/backend/executor/functions.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/src/backend/executor/functions.c,v 1.92 2005/03/16 21:38:07 tgl Exp $
+ *	  $PostgreSQL: pgsql/src/backend/executor/functions.c,v 1.93 2005/03/25 21:57:58 tgl Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -399,8 +399,8 @@ postquel_end(execution_state *es, SQLFunctionCachePtr fcache)
 		{
 			ActiveSnapshot = es->qd->snapshot;
 
+			AfterTriggerEndQuery(es->qd->estate);
 			ExecutorEnd(es->qd);
-			AfterTriggerEndQuery();
 		}
 		PG_CATCH();
 		{
-- 
cgit v1.2.3