Need feedback on possible new feature

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.

Responses

Browse pgsql-general by date

  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