pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Displaying 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>
  2002-09-09 17:52 ` Re: Displaying current queries on the database? mallah@trade-india.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:34 Displaying current queries on the database? Sloan Bowman <smileyq@nashlinux.com>
@ 2002-09-09 17:52 ` mallah@trade-india.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