Skip site navigation (1) Skip section navigation (2)

Re: view running query

From: Andrew Hammond <ahammond(at)ca(dot)afilias(dot)info>
To: postgres SQL <pgsql-sql(at)postgresql(dot)org>
Cc: Eric Anderson Vianet SAO <eric(at)vianet-express(dot)com(dot)br>
Subject: Re: view running query
Date: 2004-05-17 14:32:10
Message-ID: 40A8CCEA.3000906@ca.afilias.info (view raw or flat)
Thread:
Lists: pgsql-sql
-----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-----

In response to

pgsql-sql by date

Next:From: KornelijeDate: 2004-05-17 14:58:13
Subject: Replace function ...
Previous:From: nahum castroDate: 2004-05-17 14:05:05
Subject: Re: [JDBC] problem with spanish characters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group