Re: [PERFORM] SELECT 'DBD::Pg ping test'

sathiya psql wrote:
> Hi All,
>
> This query is being executed nearly a million times....
> SELECT 'DBD::Pg ping test'
>
> Why this is being executed ? What is the use ?

A client is sending a query to the server solely to see if the server responds.

DBD::Pg is the Perl database driver for PostgreSQL. Presumably the application using that driver has some sort of keepalive or database connectivity check enabled, so it's periodically issuing these queries.

--
Craig Ringer

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance