Re: SQL Monitoring

From: Marcin Stępnicki <mstepnicki(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: SQL Monitoring
Date: 2007-10-09 14:36:31
Message-ID: 179149fe0710090736l1a863d71yb04e2598d0faed4e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 10/9/07, Campbell, Lance <lance(at)uiuc(dot)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/.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2007-10-09 15:07:59 Re: SQL Monitoring
Previous Message Campbell, Lance 2007-10-09 14:11:43 SQL Monitoring