| From: | "Martin Dillard" <martin(at)edusoftinc(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | PostgreSQL profiling tools |
| Date: | 2002-03-02 00:10:47 |
| Message-ID: | 0d5e01c1c17e$c66df6e0$0301a8c0@market |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----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(at)edusoftinc(dot)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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2002-03-02 00:13:41 | Re: Shared buffers vs large files |
| Previous Message | Glen Parker | 2002-03-01 23:57:25 | Re: Shared buffers vs large files |