Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: [GENERAL] How to know which queries are to be optimised?



Hi,

But is there a tool that could compile a summary out of the log? The log grows awefully big after a short time.

There's also pg_analyzer to check out.

http://www.samse.fr/GPL/pg_analyzer/

Some of it's features are: written in Perl and produces HTML output.

You might want to look at the "Practical Query Analyser" - haven't used it myself yet, but it seems a sensible idea.

http://pqa.projects.postgresql.org/


Cheers,
Rudi.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group