Re: Displaying current queries on the database?

From: <mallah(at)trade-india(dot)com>
To: <smileyq(at)nashlinux(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Displaying current queries on the database?
Date: 2002-09-09 17:52:41
Message-ID: 44589.203.145.129.36.1031593961.squirrel@mail.trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Charles Hauser 2002-09-09 18:15:53 stored procedures: sybase -> postgreSQL ?
Previous Message Sloan Bowman 2002-09-09 17:34:07 Displaying current queries on the database?