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(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
