Postgres log statistics

From: Christian Bucanac <christian(dot)bucanac(at)mindark(dot)com>
To: "Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Postgres log statistics
Date: 2002-12-16 14:56:19
Message-ID: AE39D66BA4D2D5119DBE000103D74BFA11BB1F@mingbgnts02.mindark.intranet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

In Postgres you can log a lot of stuff and statistics by modifying some of
the following flags:
debug_print_query
show_parser_stats
show_planner_stats
show_executor_stats
show_query_stats

What I wonder is, if there are any tools, perl scripts or similar, to
analyze / data mine the output in the postmaster log that these flags
produce?

I am interested in knowing for example how often every SQL statement is
executed how long time it took to execute it. It would also be good to have
the output presented with the most frequently executed statements and the
longest execution time at the "top" of the report. This way you could fast
and easy identify where to focus your improvement effort.

I have been looking at "PostgreSQL Log Analyzer v1.1". It is not good enough
because it does not do enough analyzing. In some cases, it considers two
same SQL statements different because they use different data and it does
not sort the SQL statements by frequency.

Thanks for your help!

/Buckis

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-12-16 15:11:20 Re: Total crash of my db-server
Previous Message Greg Kelley 2002-12-16 14:32:48 Login Failures After Upgrade