which commands under PostgreSQL do the similar func provided by "show processlist" under mysql

From: Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: which commands under PostgreSQL do the similar func provided by "show processlist" under mysql
Date: 2005-06-06 15:22:23
Message-ID: 42A46A2F.5030404@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2005-06-06 16:00:36 Re: numeric precision when raising one numeric to another.
Previous Message Chris Browne 2005-06-06 15:17:24 Re: postgresql books