]> granicus.if.org Git - postgresql/commit
Add TIMING option to EXPLAIN, to allow eliminating of timing overhead.
authorRobert Haas <rhaas@postgresql.org>
Tue, 7 Feb 2012 16:23:04 +0000 (11:23 -0500)
committerRobert Haas <rhaas@postgresql.org>
Tue, 7 Feb 2012 16:23:04 +0000 (11:23 -0500)
commitaf7914c6627bcf0b0ca614e9ce95d3f8056602bf
tree23633b1c4de9e6bbbc9cea30895f8b4ee74e4c01
parent1631598ea204a3b05104f25d008b510ff5a5c94a
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.
contrib/auto_explain/auto_explain.c
doc/src/sgml/ref/explain.sgml
src/backend/commands/explain.c
src/backend/executor/instrument.c
src/include/commands/explain.h
src/include/executor/instrument.h