Thread: Getting statistics for each sql statement?

Hello,

is it possible to get statistics on the usage of different sql
statements, e.g. how many INSERT or UPDATE statements per day?

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?

Thanks,

Stefan

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.