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

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!

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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


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

http://archives.postgresql.org