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 по дате отправления:

Предыдущее
От: Matthew Wilson
Дата:
Сообщение: How to improve performance in reporting database?
Следующее
От: "Andrus"
Дата:
Сообщение: Re: How to distribute quantity if same product is in multiple rows