Message-ID: <40A8CCEA.3000906@ca.afilias.info>
Date: Mon, 17 May 2004 10:32:10 -0400
From: Andrew Hammond <ahammond@ca.afilias.info>
User-Agent: Mozilla Thunderbird 0.6 (X11/20040509)
MIME-Version: 1.0
To: postgres SQL <pgsql-sql@postgresql.org>
Cc: Eric Anderson Vianet SAO <eric@vianet-express.com.br>
Subject: Re: view running query
References: <20040512175750.12624.qmail@web41006.mail.yahoo.com>
	<069701c439d7$4cae4de0$0701a8c0@netterm>
In-Reply-To: <069701c439d7$4cae4de0$0701a8c0@netterm>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

There are two ways to do it. The server-side approach is to increase
logging levels in the config file and then "pg_ctl reload". See

http://www.postgresql.org/docs/7.4/interactive/runtime-config.html#RUNTIME-CONFIG-LOGGING

for the stuff involved.

The other way to do it is client side. In this case, you have to
increase the logging level of your database connection. For example, if
you have a perl DBD application, find the initilization of the database
handle (by convention named $dbh) and then add

$dbh->trace(2);

After it.

Drew


Eric Anderson Vianet SAO wrote:
|     I run an application which connects to my pgsql DB.
|
|     How could I see which query is sent to DB when, an example, i push
some
| application button (such ´find´).
|
|     sds
|
|     Eric Anderson
|     CPD Via Net SAO
|     11-66432800
|
|
| ---------------------------(end of broadcast)---------------------------
| TIP 4: Don't 'kill -9' the postmaster

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFAqMzogfzn5SevSpoRAnDwAJ4+y6xBwD9hXQ2k7V4mJbUf26rKLQCeP74Q
HdgdLOV8bpqh5z4hgcUX52M=
=dVN9
-----END PGP SIGNATURE-----