I've search the list but there's no hint on this question.
Is there any why to see/view the running query sessions in the database?
Something like "SHOW PROCESSLIST" in MySQL.

thx
--
"Unthinkably good things can happen, even late in the game." -- Under
the Tuscan Sun

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)