View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000110 | Pgpool-II | Bug | public | 2014-08-09 21:43 | 2014-08-12 17:54 |
| Reporter | ramkumar | Assigned To | t-ishii | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | open | ||
| Platform | postgres | OS | linux | OS Version | cent |
| Summary | 0000110: Postgres unwanted query execute | ||||
| Description | Hi 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 | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
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 |
| 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 | |
| 2014-08-10 00:05 | t-ishii | Note Added: 0000461 | |
| 2014-08-10 00:05 | t-ishii | Steps to Reproduce Updated | |
| 2014-08-12 17:54 | t-ishii | Status | assigned => resolved |
