"show processlist" will display DB, command, time, State, etc under MySQL:
| Id | User | Host | db | Command | Time |
*State * | *Info*
| 21 | admin | server1:40898 | test | *Query* | 104 |
Copying to tmp table | INSERT INTO test (SELECT ... ...
May I know which commands to display similar current running
commands/states under PostgreSQL please?
You're looking for something like SELECT * FROM pg_stat_activity;
I tried this query. Under column "current_query", I always got: <command
string not enabled> but not the correct queries.
I searched the previous mailing list, it seems that I need also setup
stats_command_string = true in postgresql.conf to see the queries. May I
ask will if arise any performance issues please?
I'd love to get some info about setting up:
stats_block_level = true
stats_row_level = true
Thanks A LOT,
Emi
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
