Re: which commands under PostgreSQL do the similar func

Поиск
Список
Период
Сортировка
От Ying Lu
Тема Re: which commands under PostgreSQL do the similar func
Дата
Msg-id 42A49188.2080003@cs.concordia.ca
обсуждение исходный текст
Ответ на Re: which commands under PostgreSQL do the similar func provided by "show processlist" under mysql  (David Fetter <david@fetter.org>)
Список pgsql-general
>>"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


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2
Следующее
От: Jochem van Dieten
Дата:
Сообщение: Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2