pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDisplaying current queries on the database?
2+ messages / 2 participants
[nested] [flat]
* Displaying current queries on the database?
@ 2002-09-09 17:34 Sloan Bowman <smileyq@nashlinux.com>
0 siblings, 1 reply; 2+ messages in thread
From: Sloan Bowman @ 2002-09-09 17:34 UTC (permalink / raw)
To: pgsql-sql
I was wondering if there is a way to display all of the current queries
that are being submitted to the database. Thanks in advance.
-Sloan Bowman
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Displaying current queries on the database?
@ 2002-09-09 17:52 mallah@trade-india.com
parent: Sloan Bowman <smileyq@nashlinux.com>
0 siblings, 0 replies; 2+ messages in thread
From: mallah@trade-india.com @ 2002-09-09 17:52 UTC (permalink / raw)
To: smileyq@nashlinux.com; +Cc: pgsql-sql
its possible,
select * from pg_stat_activity after
AS connect as postgres.
THOUGH NEEd to configure postgresql.conf accordigly
regds
mallaH
> I was wondering if there is a way to display all of the current queries that are being
> submitted to the database. Thanks in advance.
>
> -Sloan Bowman
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9'
> the postmaster
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-09-09 17:52 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-09-09 17:34 Displaying current queries on the database? Sloan Bowman <smileyq@nashlinux.com>
2002-09-09 17:52 ` mallah@trade-india.com
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