Re: Displaying current queries on the database? - Mailing list pgsql-sql

From
Subject Re: Displaying current queries on the database?
Date
Msg-id 44589.203.145.129.36.1031593961.squirrel@mail.trade-india.com
Whole thread Raw
In response to Displaying current queries on the database?  (Sloan Bowman <smileyq@nashlinux.com>)
List 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/




pgsql-sql by date:

Previous
From: Sloan Bowman
Date:
Subject: Displaying current queries on the database?
Next
From: Charles Hauser
Date:
Subject: stored procedures: sybase -> postgreSQL ?