Re: Getting statistics for each sql statement?

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: Getting statistics for each sql statement?
Дата
Msg-id 078E95C6-CF2D-4849-B2D1-26E7A39B3F4D@silentmedia.com
обсуждение исходный текст
Ответ на Getting statistics for each sql statement?  (Stefan-Michael Guenther <s.guenther@in-put.de>)
Список 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 по дате отправления: