Re: SELECT 'DBD::Pg ping test' - Mailing list pgsql-performance

From Craig Ringer
Subject Re: SELECT 'DBD::Pg ping test'
Date
Msg-id 480EF315.3040605@postnewspapers.com.au
Whole thread Raw
In response to SELECT 'DBD::Pg ping test'  ("sathiya psql" <sathiya.psql@gmail.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "sathiya psql"
Date:
Subject: SELECT 'DBD::Pg ping test'
Next
From: Hans Ekbrand
Date:
Subject: mysterious difference in speed when combining two queries with OR