Skip site navigation (1) Skip section navigation (2)

Re: WIP: make EXPLAIN ANALYZE show time spent in triggers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: WIP: make EXPLAIN ANALYZE show time spent in triggers
Date: 2005-03-25 06:53:57
Message-ID: 20802.1111733637@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> Could we get plain EXPLAIN output as well:

Plain EXPLAIN doesn't run the query, and therefore not the triggers.

> Also, have you considered statement level triggers?

I haven't actually tested that case, but I believe they'll show up
if used.

			regards, tom lane

In response to

Responses

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2005-03-25 07:24:52
Subject: Re: WIP: make EXPLAIN ANALYZE show time spent in triggers
Previous:From: Christopher Kings-LynneDate: 2005-03-25 06:48:51
Subject: Re: WIP: make EXPLAIN ANALYZE show time spent in triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group