pgsql: Add TIMING option to EXPLAIN, to allow eliminating of timing ove

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add TIMING option to EXPLAIN, to allow eliminating of timing ove
Date: 2012-02-07 16:29:48
Message-ID: E1RunvQ-0000Tx-K9@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add TIMING option to EXPLAIN, to allow eliminating of timing overhead.

Sometimes it may be useful to get actual row counts out of EXPLAIN
(ANALYZE) without paying the cost of timing every node entry/exit.
With this patch, you can say EXPLAIN (ANALYZE, TIMING OFF) to get that.

Tomas Vondra, reviewed by Eric Theise, with minor doc changes by me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/af7914c6627bcf0b0ca614e9ce95d3f8056602bf

Modified Files
--------------
contrib/auto_explain/auto_explain.c | 19 ++++++++++++++-
doc/src/sgml/ref/explain.sgml | 16 ++++++++++++
src/backend/commands/explain.c | 45 +++++++++++++++++++++++++++++-----
src/backend/executor/instrument.c | 34 ++++++++++++++++----------
src/include/commands/explain.h | 1 +
src/include/executor/instrument.h | 4 ++-
6 files changed, 97 insertions(+), 22 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2012-02-07 17:08:48 pgsql: Add a transform function for numeric typmod coercisions.
Previous Message Robert Haas 2012-02-07 15:07:24 pgsql: pg_dump: Further reduce reliance on global variables.