Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
>> 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.
> Well I guess the point would be to remind people that there are
> (potentially) expensive triggers that will run, so even though the
> analysis presented indicates that the tested query will be fast, it
> might not be...
If we had any way to estimate the costs of the triggers, I'd agree with
listing those numbers --- but the triggers are just black boxes. So I
don't see the point. We might as well just add one line saying
<ding> You've got triggers!
regards, tom lane
In response to
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2005-03-25 07:48:27|
|Subject: Re: WIP: make EXPLAIN ANALYZE show time spent in triggers |
|Previous:||From: Christopher Kings-Lynne||Date: 2005-03-25 07:44:03|
|Subject: Re: WIP: make EXPLAIN ANALYZE show time spent in triggers|