Re: what selects

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: what selects
Date: 2002-10-30 15:18:58
Message-ID: 20021030101858.B9431@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 28, 2002 at 05:39:44PM +0100, Edward wrote:
> Hi
> how to discover what selects are issued to the database and how often?

You can turn on query echoing in the logs. Also, in 7.2 and later,
there is a statistics level that allows you to watch _current_ query
activity; but I gather that's not what you want.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Blood 2002-10-30 15:29:57 Re: what selects
Previous Message Robert Treat 2002-10-30 15:18:47 Re: Database replication... - Mission Critical DBMS's --