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

[Tatsuo Ishii]

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

What do you mean by "active" exactly?

> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general