Re: Patch: add timing of buffer I/O requests
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Stark <stark@mit.edu>
Cc: Robert Haas <robertmhaas@gmail.com>, Peter Geoghegan <peter@2ndquadrant.com>, Ants Aasma <ants@cybertec.at>, Greg Smith <greg@2ndquadrant.com>, pgsql-hackers@postgresql.org
Date: 2012-04-30T15:12:56Z
Lists: pgsql-hackers
Greg Stark <stark@mit.edu> writes: > On Sun, Apr 29, 2012 at 12:26 AM, Robert Haas <robertmhaas@gmail.com> wrote: >> As for track_iotiming -> track_io_timing, I'm fine with that as well. > I'm still grumpy about the idea of a GUC changing the explain analyze > output. How would people feel about adding an explain option that > explicitly requests io timing for this explain analyze and then having > the io timing be enabled if either it's requested by explain analyze > or if it's set on globally? That would make it more consistent with > the other explain analyze options? I think it's going to be hard to decouple that altogether. For instance, if track_io_timing were not on but you did EXPLAIN (TIMING), you'd end up with timing info getting sent to the stats collector for just that one statement. That seems a bit weird too. I see where you're coming from but I don't think it's a good idea to add an EXPLAIN option unless you can make the two behaviors (EXPLAIN reporting and stats collection) truly independent. regards, tom lane