Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group