Re: WIP: make EXPLAIN ANALYZE show time spent in triggers - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: WIP: make EXPLAIN ANALYZE show time spent in triggers
Date
Msg-id 4243BCC4.3040708@familyhealth.com.au
Whole thread Raw
In response to Re: WIP: make EXPLAIN ANALYZE show time spent in triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WIP: make EXPLAIN ANALYZE show time spent in triggers
List 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

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP: make EXPLAIN ANALYZE show time spent in triggers
Next
From: Tom Lane
Date:
Subject: Re: WIP: make EXPLAIN ANALYZE show time spent in triggers