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

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: WIP: make EXPLAIN ANALYZE show time spent in triggers
Date: 2005-03-25 07:38:43
Message-ID: 4243C003.30208@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

> 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...

Chris

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-03-25 07:44:03 Re: WIP: make EXPLAIN ANALYZE show time spent in triggers
Previous Message Tom Lane 2005-03-25 07:35:58 Re: WIP: make EXPLAIN ANALYZE show time spent in triggers