Thread: PostgreSQL profiling tools
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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.
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.
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
__________________________
Martin Dillard
Senior Engineer
Edusoft
http://www.edusoftinc.com
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
iQA/AwUBPIAYhhiVliUcvJG9EQLRBgCfUZdqtA/duwFKGp5iEemLE1KMzy0An3Ic
mDflclMlIHH6sPeKyX/9mFoq
=pqNM
-----END PGP SIGNATURE-----
mDflclMlIHH6sPeKyX/9mFoq
=pqNM
-----END PGP SIGNATURE-----