Re: Timing a query

-----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@turnstep.com
PGP Key: 0x14964AC8 200111271003


-----BEGIN PGP SIGNATURE-----
Comment: http://www.gtsm.com/pgp.html

iQA/AwUBPAOrcrybkGcUlkrIEQLjZQCfepfTDzVHkY3kO6j/po1FFRi4qVEAn1Ye
Ih8pBO7jXx1lOTnp8ZoTD0oc
=AU0N
-----END PGP SIGNATURE-----