Skip site navigation (1) Skip section navigation (2)

Re: how to view running sessions ?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Patrick Hsieh(?????????)" <pahudnet(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to view running sessions ?
Date: 2005-02-18 01:51:29
Message-ID: 20050218015128.GA28345@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, Feb 18, 2005 at 08:57:00AM +0800, Patrick Hsieh(?????????) wrote:

> Is there any why to see/view the running query sessions in the database?
> Something like "SHOW PROCESSLIST" in MySQL. 

SELECT * FROM pg_stat_activity;

If the current_query column says "<command string not enabled>"
then edit postgresql.conf, set "stats_command_string = true" (and
make sure it's uncommented), and restart or reload the backend.

For more information, see the "Monitoring Database Activity" and
"Server Run-time Environment" chapters in the documentation.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

pgsql-admin by date

Next:From: Spiegelberg, GregDate: 2005-02-18 14:29:52
Subject: OID assistance
Previous:From: Patrick Hsieh (謝洪恩)Date: 2005-02-18 00:57:00
Subject: how to view running sessions ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group