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

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

Right.  So what's the point?  It seems like the printout would just be
useless noise: it'd repeat N times the estimate of the top-level number
of output rows.

            regards, tom lane

pgsql-patches by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: WIP: make EXPLAIN ANALYZE show time spent in triggers
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: WIP: make EXPLAIN ANALYZE show time spent in triggers