pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedview running query
2+ messages / 2 participants
[nested] [flat]
* view running query
@ 2004-05-14 17:17 Eric Anderson Vianet SAO <eric@vianet-express.com.br>
2004-05-17 14:32 ` Re: view running query Andrew Hammond <ahammond@ca.afilias.info>
0 siblings, 1 reply; 2+ messages in thread
From: Eric Anderson Vianet SAO @ 2004-05-14 17:17 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: view running query
2004-05-14 17:17 view running query Eric Anderson Vianet SAO <eric@vianet-express.com.br>
@ 2004-05-17 14:32 ` Andrew Hammond <ahammond@ca.afilias.info>
0 siblings, 0 replies; 2+ messages in thread
From: Andrew Hammond @ 2004-05-17 14:32 UTC (permalink / raw)
To: pgsql-sql; +Cc: Eric Anderson Vianet SAO <eric@vianet-express.com.br>
-----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-----
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-05-17 14:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-14 17:17 view running query Eric Anderson Vianet SAO <eric@vianet-express.com.br>
2004-05-17 14:32 ` Andrew Hammond <ahammond@ca.afilias.info>
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