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

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

pgsql-patches by date:

Previous
From: Tom Lane
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