Clarify TIMING OFF behavior

From: Greg Smith <greg(at)2ndQuadrant(dot)com>
To: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Clarify TIMING OFF behavior
Date: 2013-05-19 05:03:45
Message-ID: 51985D31.1030705@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

While chatting in #pedant today, I noticed that it's not clear that
EXPLAIN (ANALYZE ON, TIMING OFF) will still collect the total runtime of
the statement. Attached patch clarifies that. It also comments why the
related code runs INSTR_TIME_SET_CURRENT in all cases. That's actually
how I noticed that--a read through explain.c now could rightly wonder
"why is it still collecting that bit of time info when TIMING is off?"

There's an argument possible here that a third TIMING option besides
ON/OFF should really exist, one that really doesn't do any timing at
all. I don't think enough use cases for that exist to justify coding
it. The low overhead combination I've wanted for a while is EXPLAIN
(ANALYZE ON, BUFFERS ON, TIMING OFF), and that works.

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com

Attachment Content-Type Size
timing-off-clarify.patch text/plain 1.2 KB

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2013-05-20 02:06:20 Re: Clarify TIMING OFF behavior
Previous Message Thom Brown 2013-05-16 16:35:24 Re: Non-holoalphabetic sentence in docs