Обсуждение: which commands under PostgreSQL do the similar func provided by "show processlist" under mysql
Greetings, I have a question about how to see current processes running under postgreSQL. "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? Thanks a lot! Emi
On Mon, Jun 06, 2005 at 11:22:23AM -0400, Ying Lu wrote: > Greetings, > > I have a question about how to see current processes running under > postgreSQL. > > "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; Cheers, D -- David Fetter david@fetter.org http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote!
ying_lu@cs.concordia.ca (Ying Lu) writes: > Greetings, > > I have a question about how to see current processes running under > postgreSQL. > > "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? The nearest rough equivalent would be the contents of the system table pg_catalog.pg_stat_activity. This will only contain actual query information if the database is configured to collect statistics on queries, so it's possible for the field current_query to be left blank... -- (format nil "~S@~S" "cbbrowne" "acm.org") http://www.ntlug.org/~cbbrowne/sap.html Rules of the Evil Overlord #78. "I will not tell my Legions of Terror "And he must be taken alive!" The command will be: ``And try to take him alive if it is reasonably practical.''" <http://www.eviloverlord.com/>
>>"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