what is pg_stat_activity.query for idle connections ?

Поиск
Список
Период
Сортировка
От David Gauthier
Тема what is pg_stat_activity.query for idle connections ?
Дата
Msg-id CAMBRECB8ieWna_+vhkKCJ+2cC6NkQ5po44iHBu4HWFk1KkW=yw@mail.gmail.com
обсуждение исходный текст
Ответы Re: what is pg_stat_activity.query for idle connections ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
11.3 on linux

I have a DB with a worrisome number of connections with pg_stat_activity.query = '/* DBD::Pg ping test v3.5.3 */', all of them with state='idle'.  I have code that uses perl's ping method to ping the DB and I suspect this is the source.  Is '/* DBD::Pg ping test v3.5.3 */' the last thing it did, but because it's idle now, it's actually doing nothing ?  

 

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

Предыдущее
От: Israel Brewster
Дата:
Сообщение: Re: Fastest option to transfer db?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: what is pg_stat_activity.query for idle connections ?