Re: 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@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance