Re: Timing a query

this looks superb.

one small question though; how do i apply the patch ?

thanks,

Steve
""Greg Sabino Mullane"" <greg(at)turnstep(dot)com> wrote in message
news:E168jiH-0002Jj-00(at)mclean(dot)mail(dot)mindspring(dot)net(dot)(dot)(dot)
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> > Can someone tell me if there is a way of getting the time a
> > query has taken to run to display after the query results (
> > where in gives the row count).
>
> If you have a recent version of Postgresql, you can do an
> EXPLAIN ANALYZE before the actual query:
>
> EXPLAIN ANALYZE SELECT (*) FROM mytable WHERE foo=12;
>
> Alteratively, I wrote a small patch for psql that tells
> you how long every query you run takes. It may not work
> on your version: please always state which version you
> are running when posting a question. If you want to use my
> patch and it does not work with your version, let me know
> and I'll tweak it so it does.
>
> http://www.gtsm.com/postgres/microtiming.patch
>
>
> Greg Sabino Mullane
> greg(at)turnstep(dot)com
> PGP Key: 0x14964AC8 200111271003
>
>
> -----BEGIN PGP SIGNATURE-----
> Comment: http://www.gtsm.com/pgp.html
>
> iQA/AwUBPAOrcrybkGcUlkrIEQLjZQCfepfTDzVHkY3kO6j/po1FFRi4qVEAn1Ye
> Ih8pBO7jXx1lOTnp8ZoTD0oc
> =AU0N
> -----END PGP SIGNATURE-----
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly