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@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.
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
