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. > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
