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

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: WIP: make EXPLAIN ANALYZE show time spent in triggers
Date: 2005-03-25 07:24:52
Message-ID: 4243BCC4.3040708@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

>>Could we get plain EXPLAIN output as well:
>
> Plain EXPLAIN doesn't run the query, and therefore not the triggers.

But the point of it is to estimate, right? Could it not estimate the
number of time each trigger would be called. Surely that's the same as
estimating the number of rows each clause will return?

Chris

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-03-25 07:35:58 Re: WIP: make EXPLAIN ANALYZE show time spent in triggers
Previous Message Tom Lane 2005-03-25 06:53:57 Re: WIP: make EXPLAIN ANALYZE show time spent in triggers