Re: empty,query_id, pg_stat_activity

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: empty,query_id, pg_stat_activity
Дата
Msg-id CAKAnmmKn9Q0Kw6qiQu1dvW1hkq0twOCsX4AO9=Xbk56cOh1aJw@mail.gmail.com
обсуждение исходный текст
Ответ на empty,query_id, pg_stat_activity  ("zhouenbing" <zhouenbing@sunwoda-evb.com>)
Ответы 答复: empty,query_id, pg_stat_activity
Список pgsql-bugs
If the query_id* is null, it is not actually running yet. This is a good thing as far as your stated tracking requirements. You can do a WHERE query_id IS NOT NULL to exclude statements where the query has appeared, but has not been parsed and executed yet. I daresay you also want to be looking at wait_event and now()-state_change as well.

Cheers,
Greg


* Actually, query_id some places, queryid in others. So annoying.

--
Enterprise Postgres Software Products & Tech Support

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