From af7914c6627bcf0b0ca614e9ce95d3f8056602bf Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Tue, 7 Feb 2012 11:23:04 -0500 Subject: 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. --- doc/src/sgml/ref/explain.sgml | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml index 8a9c9defcac..419b72cad34 100644 --- a/doc/src/sgml/ref/explain.sgml +++ b/doc/src/sgml/ref/explain.sgml @@ -40,6 +40,7 @@ EXPLAIN [ ANALYZE ] [ VERBOSE ] statementboolean ] COSTS [ boolean ] BUFFERS [ boolean ] + TIMING [ boolean ] FORMAT { TEXT | XML | JSON | YAML } @@ -171,6 +172,21 @@ ROLLBACK; + + TIMING + + + Include the actual startup time and time spent in the node in the output. + The overhead of repeatedly reading the system clock can slow down the + query significantly on some systems, so it may be useful to set this + parameter to FALSE when only actual row counts, and not + exact times, are needed. + This parameter may only be used when ANALYZE is also + enabled. It defaults to TRUE. + + + + FORMAT -- cgit v1.2.3