[pgpool-general: 4049] Re: Many queries of "SELECT count(*) FROM pg_class

Pablo Sanchez pablo at blueoakdb.com
Thu Sep 10 09:50:16 JST 2015


[ Comments below, in-line ]


On 09/09/2015 08:20 PM, Tatsuo Ishii wrote:
>> Hi everyone,
>> >
>> >I'm see several 'active' connections of the sort below .... Googling
>> >around, they appear to be PGPool related.
>> >
>> >I'm wondering why they're just hanging around and marked 'active'
> What do you mean by "active" exactly?
>

When I query [pg_stat_activity], the 'state' column is set to 'active'

Cheers,

--
Pablo Sanchez - Blueoak Database Engineering, Inc
Ph:    819.459.1926         Blog:  http://pablo-blog.blueoakdb.com
iNum:  883.5100.0990.1054



More information about the pgpool-general mailing list