Question about pg_stat_activity

Поиск
Список
Период
Сортировка
От Tony Caduto
Тема Question about pg_stat_activity
Дата
Msg-id 41E60DBE.1030008@amsoftwaredesign.com
обсуждение исходный текст
Ответы Re: Question about pg_stat_activity  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
Hi,
When I run the following on my server:
SELECT * FROM pg_stat_activity

I get back <command string not enabled> for the field current_query.

I have stats enabled in my config file, is there some other setting that
I missed so I can see the current query?

I also thought that in 7.x it would say idle if the connection was just
sitting there.

Thanks,

Tony


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

Предыдущее
От: John DeSoi
Дата:
Сообщение: pgEdit 1.0b6
Следующее
От: Tony Caduto
Дата:
Сообщение: Working on a new Postgres Admin tool and was wondering...