From: Andrew Hammond <ahammond@ca.afilias.info>
To: postgres SQL <pgsql-sql@postgresql.org>
Cc: Eric Anderson Vianet SAO <eric@vianet-express.com.br>
Subject: Re: view running query
Date: Mon, 17 May 2004 10:32:10 -0400
Message-ID: <40A8CCEA.3000906@ca.afilias.info> (raw)
In-Reply-To: <069701c439d7$4cae4de0$0701a8c0@netterm>
References: <20040512175750.12624.qmail@web41006.mail.yahoo.com>
<069701c439d7$4cae4de0$0701a8c0@netterm>
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ahammond@ca.afilias.info, eric@vianet-express.com.br
Subject: Re: view running query
In-Reply-To: <40A8CCEA.3000906@ca.afilias.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox