[GENERAL] Getting statistics for each sql statement?

2010-07-22 Thread Stefan-Michael Guenther 

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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Getting statistics for each sql statement?

2010-07-22 Thread Ben Chobot 
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 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?

The usual approach is to make a log file that holds all your queries and then 
let something like pgFouine grovel through it.
-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general