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
