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: (view raw, whole thread or download thread mbox)
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




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-2017 The PostgreSQL Global Development Group