git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 1631598) | patch
Add TIMING option to EXPLAIN, to allow eliminating of timing overhead.
Tue, 7 Feb 2012 16:23:04 +0000 (11:23 -0500)
Tue, 7 Feb 2012 16:23:04 +0000 (11:23 -0500)
commit af7914c6627bcf0b0ca614e9ce95d3f8056602bf
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 diff | blob | blame | history
doc/src/sgml/ref/explain.sgml diff | blob | blame | history
src/backend/commands/explain.c diff | blob | blame | history
src/backend/executor/instrument.c diff | blob | blame | history
src/include/commands/explain.h diff | blob | blame | history
src/include/executor/instrument.h diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /