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

Pablo Sanchez pablo at blueoakdb.com
Thu Sep 10 10:14:49 JST 2015


[ Comments below, in-line ]


On 09/09/2015 09:07 PM, Tatsuo Ishii wrote:
> 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

Hi Tatsuo,

As always, I'm very grateful for your quick help.  Thank you.

--
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