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

Pablo Sanchez pablo at blueoakdb.com
Thu Sep 10 07:50:01 JST 2015


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


More information about the pgpool-general mailing list