Postgres Pro
Downloads
Home   >   mailing lists

what is pg_stat_activity.query for idle connections ? - Mailing list pgsql-general

From David Gauthier
Subject what is pg_stat_activity.query for idle connections ?
Date
Msg-id CAMBRECB8ieWna_+vhkKCJ+2cC6NkQ5po44iHBu4HWFk1KkW=yw@mail.gmail.com
Whole thread Raw
Responses Re: what is pg_stat_activity.query for idle connections ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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 by date:

Previous
From: Israel Brewster
Date:
Subject: Re: Fastest option to transfer db?
Next
From: Tom Lane
Date:
Subject: Re: what is pg_stat_activity.query for idle connections ?