EXPLAIN ANALYZE feature to measure and show actual runtimes and tuple
Tom Lane <tgl@sss.pgh.pa.us>
EXPLAIN ANALYZE feature to measure and show actual runtimes and tuple counts alongside the planner's estimates. By Martijn van Oosterhout, with some further work by Tom Lane.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/perform.sgml | modified | +63 −12 |
| doc/src/sgml/ref/explain.sgml | modified | +37 −7 |
| src/backend/commands/explain.c | modified | +63 −19 |
| src/backend/executor/execAmi.c | modified | +4 −1 |
| src/backend/executor/execMain.c | modified | +9 −10 |
| src/backend/executor/execProcnode.c | modified | +23 −11 |
| src/backend/executor/instrument.c | added | +122 −0 |
| src/backend/executor/Makefile | modified | +2 −2 |
| src/backend/executor/nodeSubplan.c | modified | +11 −11 |
| src/backend/executor/nodeSubqueryscan.c | modified | +5 −5 |
| src/backend/nodes/copyfuncs.c | modified | +2 −1 |
| src/backend/nodes/equalfuncs.c | modified | +3 −1 |
| src/backend/parser/gram.y | modified | +11 −1 |
| src/backend/tcop/utility.c | modified | +2 −2 |
| src/include/commands/explain.h | modified | +2 −2 |
| src/include/executor/instrument.h | added | +39 −0 |
| src/include/nodes/parsenodes.h | modified | +2 −1 |
| src/include/nodes/plannodes.h | modified | +13 −1 |