Thread: what selects

Hi
    how to discover what selects are issued to the database and how often?
Is there something like in Oracle v$sql, v$sqltext?

Thanks in advance. Charlee

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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

This program might help you.
http://www.samse.fr/GPL/pg_analyzer/README.html

David Blood
Matraex, Inc


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Edward
Sent: Monday, October 28, 2002 9:40 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] what selects

Hi
    how to discover what selects are issued to the database and how
often?
Is there something like in Oracle v$sql, v$sqltext?

Thanks in advance. Charlee



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org