Postgres Pro
Downloads
Home   >   mailing lists

which commands under PostgreSQL do the similar func provided by "show processlist" under mysql - Mailing list pgsql-general

From Ying Lu
Subject which commands under PostgreSQL do the similar func provided by "show processlist" under mysql
Date
Msg-id 42A46A2F.5030404@cs.concordia.ca
Whole thread Raw
Responses Re: which commands under PostgreSQL do the similar func provided by "show processlist" under mysql
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Phil Endecott
Date:
Subject: Re: CPU-intensive autovacuuming
Next
From: Jan Wieck
Date:
Subject: Re: numeric precision when raising one numeric to another.