From: mallah@trade-india.com
To: smileyq@nashlinux.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Displaying current queries on the database?
Date: Mon, 9 Sep 2002 23:22:41 +0530 (IST)
Message-ID: <44589.203.145.129.36.1031593961.squirrel@mail.trade-india.com> (raw)
In-Reply-To: <5.1.1.6.2.20020909123226.00affae0@mail.nashlinux.com>
References: <5.1.1.6.2.20020909123226.00affae0@mail.nashlinux.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, smileyq@nashlinux.com
Subject: Re: Displaying current queries on the database?
In-Reply-To: <44589.203.145.129.36.1031593961.squirrel@mail.trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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