[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