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