pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedTrace for postgreSQL
2+ messages / 2 participants
[nested] [flat]
* Trace for postgreSQL
@ 2004-02-10 12:04 beyaNet Consultancy <beyanet@ntlworld.com>
0 siblings, 1 reply; 2+ messages in thread
From: beyaNet Consultancy @ 2004-02-10 12:04 UTC (permalink / raw)
To: pgsql-sql
Hi,
can anyone tell me whether there is a trace facility (application)
available for postgreSQL version 7.4.1 which will enable me to see all
incoming requests being made to the database (ala SQL Server)?
many thanks in advance.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Trace for postgreSQL
@ 2004-02-17 13:35 Andrew Sullivan <ajs@crankycanuck.ca>
parent: beyaNet Consultancy <beyanet@ntlworld.com>
0 siblings, 0 replies; 2+ messages in thread
From: Andrew Sullivan @ 2004-02-17 13:35 UTC (permalink / raw)
To: pgsql-sql
On Tue, Feb 10, 2004 at 12:04:42PM +0000, beyaNet Consultancy wrote:
> Hi,
> can anyone tell me whether there is a trace facility (application)
> available for postgreSQL version 7.4.1 which will enable me to see all
> incoming requests being made to the database (ala SQL Server)?
Sure. Alter your configuration to echo queries, and then watch your
log file. Alternatively, you can enable the command string
statistics function, and then you get the queries in near to real
time in pg_stat_activity.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The plural of anecdote is not data.
--Roger Brinner
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-02-17 13:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-10 12:04 Trace for postgreSQL beyaNet Consultancy <beyanet@ntlworld.com>
2004-02-17 13:35 ` Andrew Sullivan <ajs@crankycanuck.ca>
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