SQL Monitoring

From: "Campbell, Lance" <lance(at)uiuc(dot)edu>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: SQL Monitoring
Date: 2007-10-09 14:11:43
Message-ID: B10E6810AC2A2F4EA7550D072CDE8760197DA7@SAB-FENWICK.sab.uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

PGSQL 8.2.4

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?

Thanks for any help,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marcin Stępnicki 2007-10-09 14:36:31 Re: SQL Monitoring
Previous Message Magnus Hagander 2007-10-08 17:12:23 Re: Apache2 PostgreSQL http authentication