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.
In response to
pgsql-admin by date
|Next:||From: Spiegelberg, Greg||Date: 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 ?|