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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-patches by date

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