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

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