Re: Getting statistics for each sql statement? - Mailing list pgsql-general

From Ben Chobot
Subject Re: Getting statistics for each sql statement?
Date
Msg-id 078E95C6-CF2D-4849-B2D1-26E7A39B3F4D@silentmedia.com
Whole thread Raw
In response to Getting statistics for each sql statement?  (Stefan-Michael Guenther <s.guenther@in-put.de>)
List pgsql-general
On Jul 22, 2010, at 4:50 AM, Stefan-Michael Guenther wrote:

> Hello,
>
> is it possible to get statistics on the usage of different sql statements, e.g. how many INSERT or UPDATE statements
perday? 
>
> log_statement_stats doesn't seem to be the right parameter or I haven't found the output statistic for this command.
>
> Any ideas or suggestions?

The usual approach is to make a log file that holds all your queries and then let something like pgFouine grovel
throughit. 

pgsql-general by date:

Previous
From: Matthew Wilson
Date:
Subject: How to improve performance in reporting database?
Next
From: "Andrus"
Date:
Subject: Re: How to distribute quantity if same product is in multiple rows