Re: [HACKERS] Expose options to explain? (track_io_timing)

2014-10-14 Thread Robert Haas
On Tue, Oct 14, 2014 at 1:04 PM, Joshua D. Drake wrote: > On 10/14/2014 10:01 AM, Robert Haas wrote: >> Hmm. IIRC, there are only two use cases for I/O timing at present: >> pg_stat_statements (which really only makes sense if it's turned on or >> off system-wide) and EXPLAIN. Rather than invent

Re: [HACKERS] Expose options to explain? (track_io_timing)

2014-10-14 Thread Joshua D. Drake
On 10/14/2014 10:01 AM, Robert Haas wrote: Hmm. IIRC, there are only two use cases for I/O timing at present: pg_stat_statements (which really only makes sense if it's turned on or off system-wide) and EXPLAIN. Rather than inventing more GUC machinery, I think we could just add an explain fla

Re: [HACKERS] Expose options to explain? (track_io_timing)

2014-10-14 Thread Robert Haas
On Thu, Oct 9, 2014 at 2:41 PM, Jeff Janes wrote: > I think the theory for track_io_timing being PGC_SUSET is that if the > superuser turned it on, no one should be able to turn it off. > > But I don't see an argument for the other way around, that no one should be > able to turn it on locally of

Re: [HACKERS] Expose options to explain? (track_io_timing)

2014-10-09 Thread Jeff Janes
On Thu, Oct 9, 2014 at 10:17 AM, Joshua D. Drake wrote: > > Salut! > > Fellow volunteers, I request assistance in understanding the following: > > When I explain a query I can get the following information: > > >| "I/O Read Time": 0.000, >| "I/O Write Time": 0.

[HACKERS] Expose options to explain? (track_io_timing)

2014-10-09 Thread Joshua D. Drake
Salut! Fellow volunteers, I request assistance in understanding the following: When I explain a query I can get the following information: | "I/O Read Time": 0.000, | "I/O Write Time": 0.000 I know why it is 0. My question is this, can we expose it to explai