View Issue Details

IDProjectCategoryView StatusLast Update
0000110Pgpool-IIBugpublic2014-08-12 17:54
ReporterramkumarAssigned Tot-ishii 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionopen 
PlatformpostgresOSlinuxOS Versioncent
Product Version 
Target VersionFixed in Version 
Summary0000110: Postgres unwanted query execute
DescriptionHi
I am running postgresql 9.2 i will get the below query in pg_stat_activity and it will take more session in my project like total 300 session the query will take 271 and remaning query's only my table so i will get memory probelm how to stop or avoid that query. the query is

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 WHEN n.nspn
ame = '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' ELS
E 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.relki
nd WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN fa
lse THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE'
ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description
TagsNo tags attached.

Activities

ramkumar

2014-08-09 21:43

reporter  

parameteraudit.txt (1,036 bytes)

 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  WHEN n.nspn
ame = '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'   ELS
E 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.relki
nd   WHEN 'r' THEN 'TEMPORARY TABLE'   WHEN 'i' THEN 'TEMPORARY INDEX'   WHEN 'S' THEN 'TEMPORARY SEQUENCE'   WHEN 'v' THEN 'TEMPORARY VIEW'   ELSE NULL   END  END  WHEN fa
lse THEN CASE c.relkind  WHEN 'r' THEN 'TABLE'  WHEN 'i' THEN 'INDEX'  WHEN 'S' THEN 'SEQUENCE'  WHEN 'v' THEN 'VIEW'  WHEN 'c' THEN 'TYPE'  WHEN 'f' THEN 'FOREIGN TABLE'
ELSE NULL  END  ELSE NULL  END  AS TABLE_TYPE, d.description AS REMARKS  FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c  LEFT JOIN pg_catalog.pg_description 
parameteraudit.txt (1,036 bytes)

t-ishii

2014-08-10 00:05

developer   ~0000461

I think the query is issued by JDBC driver. Nothing related to pgpool-II.

http://stackoverflow.com/questions/5453992/a-very-strange-sql-of-postgresql

Issue History

Date Modified Username Field Change
2014-08-09 21:43 ramkumar New Issue
2014-08-09 21:43 ramkumar File Added: parameteraudit.txt
2014-08-10 00:04 t-ishii Assigned To => t-ishii
2014-08-10 00:04 t-ishii Status new => assigned
2014-08-10 00:04 t-ishii Steps to Reproduce Updated View Revisions
2014-08-10 00:05 t-ishii Note Added: 0000461
2014-08-10 00:05 t-ishii Steps to Reproduce Updated View Revisions
2014-08-12 17:54 t-ishii Status assigned => resolved