Postgres Pro
Downloads
Home   >   mailing lists

SQL Monitoring - Mailing list pgsql-performance

From Campbell, Lance
Subject SQL Monitoring
Date
Msg-id B10E6810AC2A2F4EA7550D072CDE8760197DA7@SAB-FENWICK.sab.uiuc.edu
Whole thread Raw
Responses Re: SQL Monitoring
Re: SQL Monitoring
List pgsql-performance
Tree view

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

 

pgsql-performance by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Apache2 PostgreSQL http authentication
Next
From: "Marcin Stępnicki"
Date:
Subject: Re: SQL Monitoring