PostgreSQL profiling tools
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I have been told there are some very helpful profiling tools out
there that will give me information such as which queries happen the
most, and which queries take the longest. I would like to develop
such information from our database to subsequently optimize using
EXPLAIN.
After searching the mailing list archives and the online
documentation, I can only find reference to enabling OS level
profiling in the binaries by compiling with "gmake PROFILE=-pg all".
I am looking for something that outputs information in a way that is
more DBA-friendly.
Can anyone point me to something that would help me with this? I
__________________________
Martin Dillard
Senior Engineer
Edusoft
http://www.edusoftinc.com
Direct: (415) 341-8562
Main: (415) 863-6315
E-mail: martin@edusoftinc.com
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
iQA/AwUBPIAYhhiVliUcvJG9EQLRBgCfUZdqtA/duwFKGp5iEemLE1KMzy0An3Ic
mDflclMlIHH6sPeKyX/9mFoq
=pqNM
-----END PGP SIGNATURE-----