From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: EXPLAIN ANALYSE patch |
Date: | 2001-09-04 15:01:40 |
Message-ID: | 200109041501.f84F1eM08249@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
> Here is the latest version of the EXPLAIN ANALYZE patch. I hope I correct
> most of the issues that people had with the previous version. The impact
> should be negligable when nothing is being measured. The precision is pretty
> darn good considering its use of gettimeofday().
>
> The effect is to create a new command EXPLAIN ANALYZE which actually
> executes the query and then returns statistics on how the query ran. It
> counts the number of rows, the time till the first tuple is returned, time
> forall the tuples and the number of times the tuple was restarted.
>
> If the node is part of a subplan, the statistics will be the total of all
> executions of that subplan. I do beleive this is the right way of doing it.
> Group nodes look slightly strange but I beleive it's fine that way.
>
> Anyway, test away. If there is enough interest I can even write some docs.
> It adds two files.
>
> http://svana.org/kleptog/pgsql/timing-explain.patch
> --
> 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.
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-09-04 15:21:06 | Re: to_char(interval) |
Previous Message | Bruce Momjian | 2001-09-04 14:55:08 | Re: pgcrypto/px.c fix |