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