Re: SQL Monitoring

Поиск
Список
Период
Сортировка
От Marcin Stępnicki
Тема Re: SQL Monitoring
Дата
Msg-id 179149fe0710090736l1a863d71yb04e2598d0faed4e@mail.gmail.com
обсуждение исходный текст
Ответ на SQL Monitoring  ("Campbell, Lance" <lance@uiuc.edu>)
Ответы Re: SQL Monitoring  (Tomáš Vondra <tv@fuzzy.cz>)
Список pgsql-performance
On 10/9/07, Campbell, Lance <lance@uiuc.edu> wrote:
> I have noticed a slight spike in the amount of CPU usage in the last few
> weeks.  I am sure it has to do with a change or two that was made to some
> queries.  What is the best way to log the SQL that is being executed?  I
> would prefer to limit the size of the log file to 2 G.  Is there a way to do
> this?
>

Use http://pgfouine.projects.postgresql.org/.

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Campbell, Lance"
Дата:
Сообщение: SQL Monitoring
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: SQL Monitoring