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

[Pablo Sanchez]

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'

Is it because we don't appear to have pgpool_regclass() installed?

Cheers,
-pablo

ps:  I've obfuscated some of the objects

:::: Queries :::


  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 't_xxxxxxxxxxx' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 't_region' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 't_yyyyyyyyyyyyyyyyyassociation' AND c.relnamespace = n.oid AND 
n.nspname ~ '^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 'v_zzzzzzzzzzinfo' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 't_wwwwwwww' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 't_yyyyyyyyyyyyyyyyyion' AND c.relnamespace = n.oid AND n.nspname ~ 
'^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 't_region' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 'summary' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 't_1234444333333333' AND c.relnamespace = n.oid AND n.nspname ~ 
'^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 't_kdkdkdkdkkdkdkdkdd' AND c.relnamespace = n.oid AND n.nspname ~ 
'^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 't_region' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 't_xxxxxxxxffff' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
  SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname 
= 't_hhh' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'

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