Whether it's useful for anyone else is a question, but anyway, it makes an
explain type output like:
Aggregate (cost=183599.26..185497.00 rows=18977 width=116) actual (time=114.01..117.69 rows=61 loops=1)
-> Group (cost=183599.26..185022.57 rows=189774 width=116) actual (time=1.86..1.93 rows=3528 loops=61)
-> Sort (cost=183599.26..183599.26 rows=189774 width=116) actual (time=113.41..117.69 rows=215210 loops=1)
-> Merge Join (cost=134957.25..138521.82 rows=189774 width=116) actual (time=83.79..96.92 rows=215210
loops=1)
etc..
It shows the actual time taken to execute various parts of the query. Does anyone think this
is useful? Needs some tweaking still.
How should you invoke it? The ideas I have are:
EXPLAIN TRUTHFULLY [query]
ANALYZE [query]
SELECT WITH STATISTICS
Ideas?
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> It would be nice if someone came up with a certification system that
> actually separated those who can barely regurgitate what they crammed over
> the last few weeks from those who command secret ninja networking powers.