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

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!