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