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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Ying Lu
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



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org
Reply | Threaded
Open this post in threaded view
|

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

David Fetter
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 [hidden email] http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Reply | Threaded
Open this post in threaded view
|

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

Chris Browne
In reply to this post by Ying Lu
[hidden email] (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/>

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Reply | Threaded
Open this post in threaded view
|

Re: which commands under PostgreSQL do the similar func

Ying Lu
In reply to this post by David Fetter

>>"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