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

[Tatsuo Ishii]

>> What do you mean by "active" exactly?
>>
> 
> When I query [pg_stat_activity], the 'state' column is set to 'active'

Sounds like one of FAQ items.

http://pgpool.net/mediawiki/index.php/FAQ#When_I_check_pg_stat_activity_view.2C_I_see_a_query_like_.22SELECT_count.28.2A.29_FROM_pg_catalog.pg_class_AS_c_WHERE_c.oid_.3D_pgpool_regclass.28.27pgbench_accounts.27.29_AND_c.relpersistence_.3D_.27u.27.22_in_active_state_for_very_long_time._Why.3F

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp