Re: Application hangs

El vie, 22-01-2016 a las 09:17 +0530, Ankur Kaushik escribió:
>
> Hi ,
>
> We are facing problem in our Live server , Applications hangs after
> some time
>
> Please Let me know Is this database related or Application ?
>
> Process list shows as below
>
> postgres=# select count(*) from pg_stat_activity ;
> count
> -------
> 37
> (1 row)
>
>
> "SELECT NULL AS TABLE_CAT" and "SHOW TRANSACTION ISOLATION LEVEL",
> Type query increases as
>
>
>
> 16384 | 15011 | idle | SELECT NULL AS TABLE_CAT, n.nspname AS
> TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR
> n.nspname = 'information_schema' WHEN true THEN CASE WHE
> N n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN
> CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM
> VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL
> END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN
> 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL
> END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPOR
> ARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN
> 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL
> END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TAB
> LE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN
> 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm'
> THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL
> END AS TABLE_TYPE, d.description AS REMARKS FROM
> pg_catalog.pg_namespace n, pg_catalog.pg_class c L
> 16384 | 15012 | idle | SELECT NULL AS TABLE_CAT, n.nspname AS
> TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR
> n.nspname = 'information_schema' WHEN true THEN CASE WHE
> N n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN
> CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM
> VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL
> END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN
> 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL
> END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPOR
> ARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN
> 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL
> END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TAB
> LE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN
> 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm'
> THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL
> END AS TABLE_TYPE, d.description AS REMARKS FROM
> pg_catalog.pg_namespace n, pg_catalog.pg_class c L
> 16384 | 15013 | idle | SELECT NULL AS TABLE_CAT, n.nspname AS
> TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR
> n.nspname = 'information_schema' WHEN true THEN CASE WHE
> N n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN
> CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM
> VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL
> END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN
> 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL
> END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPOR
> ARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN
> 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL
> END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TAB
> LE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN
> 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm'
> THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL
> END AS TABLE_TYPE, d.description AS REMARKS FROM
> pg_catalog.pg_namespace n, pg_catalog.pg_class c L
> 16384 | 15014 | idle | SELECT NULL AS TABLE_CAT, n.nspname AS
> TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR
> n.nspname = 'information_schema' WHEN true THEN CASE WHE
> N n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN
> CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM
> VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL
> END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN
> 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL
> END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPOR
> ARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN
> 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL
> END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TAB
> LE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN
> 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm'
> THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL
> END AS TABLE_TYPE, d.description AS REMARKS FROM
> pg_catalog.pg_namespace n, pg_catalog.pg_class c L

Please look that all activity on database server are select on postgres
catalog and their state are idle, so it looks like there is no problem
related to dataserver.

>