From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
Subject: | Need feedback on possible new feature |
Date: | 2001-07-14 10:12:36 |
Message-ID: | 20010714201236.D11863@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)svana(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua Jore | 2001-07-14 10:41:56 | RE: autoincrement??? |
Previous Message | markMLl.pgsql-general | 2001-07-14 08:53:30 | Re: Postgres User and Password |