datid | datCOL2 | pid | usesysid | useCOL2 | application_COL2 | client_addr | client_hostCOL2 | client_port | backend_start | xact_start | query_start | state_change | waiting | state | query -------+-----------------+-------+----------+-----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+---------+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 16385 | mydatabase | 15218 | 16384 | pguser | | 127.0.0.1 | | 56856 | 2015-06-25 07:27:25.810661+00 | | 2015-06-25 07:27:25.853777+00 | 2015-06-25 07:27:25.85392+00 | f | idle | SELECT NULL AS TABLE_CAT, n.nspCOL2 AS TABLE_SCHEM, c.relCOL2 AS TABLE_COL2, CASE n.nspCOL2 ~ '^pg_' OR n.nspCOL2 = 'information_schema' WHEN true THEN CASE WHEN n.nspCOL2 = 'pg_catalog' OR n.nspCOL2 = '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.nspCOL2 = '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 'TEMPORARY 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 'TABLE' 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_COL2space n, pg_catalog.pg_class c L 16385 | mydatabase | 15265 | 16384 | pguser | | 127.0.0.1 | | 56857 | 2015-06-25 07:27:25.872901+00 | | 2015-06-25 07:27:25.87695+00 | 2015-06-25 07:27:25.876965+00 | f | idle | select * from table85 where 1=2 16385 | mydatabase | 23805 | 16384 | pguser | | 127.0.0.1 | | 55914 | 2015-06-25 08:19:05.857882+00 | | 2015-07-01 21:55:20.127854+00 | 2015-07-01 21:55:20.127868+00 | f | idle | COMMIT 16385 | mydatabase | 17781 | 16384 | pguser | | 127.0.0.1 | | 55515 | 2015-06-25 08:18:11.767437+00 | | 2015-07-02 07:15:48.236259+00 | 2015-07-02 07:15:48.236272+00 | f | idle | COMMIT 16385 | mydatabase | 6384 | 16384 | pguser | | 127.0.0.1 | | 56898 | 2015-06-25 08:21:22.250527+00 | | 2015-07-01 12:11:40.71051+00 | 2015-07-01 12:11:40.710518+00 | f | idle | COMMIT 16385 | mydatabase | 1684 | 16384 | pguser | | 127.0.0.1 | | 56586 | 2015-06-25 08:20:39.277048+00 | | 2015-07-01 12:11:40.870593+00 | 2015-07-01 12:11:40.870607+00 | f | idle | COMMIT 16385 | mydatabase | 4038 | 16384 | pguser | | 127.0.0.1 | | 56743 | 2015-06-25 08:21:00.79642+00 | | 2015-07-02 07:15:58.116473+00 | 2015-07-02 07:15:58.116486+00 | f | idle | COMMIT 16385 | mydatabase | 10755 | 16384 | pguser | | 127.0.0.1 | | 55063 | 2015-06-25 08:17:10.20958+00 | 2015-07-02 07:15:58.138205+00 | 2015-07-02 07:15:58.138479+00 | 2015-07-02 07:15:58.138482+00 | f | active | select this_.COL1 as COL10_0_, this_.COL2 as COL20_0_, this_.COL3 as COL30_0_, this_.COL4 as COL40_0_0_, this_.COL5 as COL50_0_0_, this_.COL6 as COL60_0_0_, this_.COL7 as COL70_0_0_, this_.COL8 as COL680_0_, this_.COL9 as COL90_0_, this_.COL10 as COL100_0_, this_.COL11 as COL110_0_0_, this_.COL12 as COL120_0_, this_.COL13 as COL130_0_0_, this_.COL14 as COL140_0_0_, this_.COL15 as COL150_0_0_, this_.COL16 as COL160_0_, this_.COL17 as COL170_0_, this_.COL18 as COL180_0_, this_.COL19 as COL190_0_, this_.COL20 as COL200_0_, this_.COL21 as COL210_0_0_, this_.COL22 as COL220_0_0_, this_.COL23 as COL230_0_0_, this_.COL24 as COL240_0_0_, this_.COL25 as COL250_0_, this_.COL26 as COL260_0_0_, this_.COL27 as COL270_0_0_, this_.COL28 16385 | mydatabase | 5719 | 16384 | pguser | | 127.0.0.1 | | 56854 | 2015-06-25 08:21:16.246919+00 | | 2015-07-02 07:15:40.774325+00 | 2015-07-02 07:15:40.774339+00 | f | idle | COMMIT 16385 | mydatabase | 11883 | 16384 | pguser | | 127.0.0.1 | | 57257 | 2015-06-25 08:22:12.343203+00 | | 2015-07-02 05:55:23.842746+00 | 2015-07-02 05:55:23.84276+00 | f | idle | COMMIT 16385 | mydatabase | 15374 | 16384 | pguser | | 127.0.0.1 | | 56867 | 2015-06-25 07:27:27.140094+00 | | 2015-07-02 07:15:58.062046+00 | 2015-07-02 07:15:58.062828+00 | f | idle | select COL2 from table57,table84 where table57.COL1 = table84.COL1 and COL2 = $1 AND COL3 = $2 16385 | mydatabase | 32439 | 16384 | pguser | | 127.0.0.1 | | 54357 | 2015-06-25 08:15:37.480387+00 | | 2015-07-02 07:03:40.743647+00 | 2015-07-02 07:03:40.743661+00 | f | idle | COMMIT 16385 | mydatabase | 6800 | 16384 | pguser | | 127.0.0.1 | | 52689 | 2015-06-25 08:12:02.274653+00 | | 2015-07-01 12:11:40.711511+00 | 2015-07-01 12:11:40.711525+00 | f | idle | COMMIT 16385 | mydatabase | 21495 | 10 | pgsql | psql | | | -1 | 2015-07-02 07:15:58.13481+00 | 2015-07-02 07:15:58.136463+00 | 2015-07-02 07:15:58.136463+00 | 2015-07-02 07:15:58.136465+00 | f | active | select * from pg_stat_activity; 16385 | mydatabase | 15378 | 16384 | pguser | | 127.0.0.1 | | 56871 | 2015-06-25 07:27:27.146007+00 | | 2015-07-02 07:15:58.087992+00 | 2015-07-02 07:15:58.088782+00 | f | idle | select COL2 from table57,table84 where table57.COL1 = table84.COL1 and COL2 = $1 AND COL3 = $2 16385 | mydatabase | 10011 | 16384 | pguser | | 127.0.0.1 | | 57134 | 2015-06-25 08:21:55.223786+00 | | 2015-07-02 07:03:40.744361+00 | 2015-07-02 07:03:40.744375+00 | f | idle | COMMIT 16385 | mydatabase | 15375 | 16384 | pguser | | 127.0.0.1 | | 56868 | 2015-06-25 07:27:27.14889+00 | | 2015-07-02 07:15:58.114198+00 | 2015-07-02 07:15:58.115063+00 | f | idle | select COL2 from table57,table84 where table57.COL1 = table84.COL1 and COL2 = $1 AND COL3 = $2 16385 | mydatabase | 15526 | 16384 | pguser | | 127.0.0.1 | | 56881 | 2015-06-25 07:27:30.868762+00 | | 2015-07-02 07:12:49.90291+00 | 2015-07-02 07:12:49.902937+00 | f | idle | select col1 from table133 where 1=2 16385 | mydatabase | 16505 | 16384 | pguser | | 127.0.0.1 | | 56892 | 2015-06-25 07:27:52.184584+00 | | 2015-06-25 07:27:52.212348+00 | 2015-06-25 07:27:52.212373+00 | f | idle | SELECT * FROM table134 16385 | mydatabase | 15410 | 16384 | pguser | | 127.0.0.1 | | 56879 | 2015-06-25 07:27:29.878956+00 | | 2015-06-25 08:22:56.531901+00 | 2015-06-25 08:22:56.531985+00 | f | idle | UPDATE table134 SET COL1 = '0', COL2 = '0', COL3 = '0', COL4 = '0', COL5 = '0' WHERE COL6 = 'MyFunnyString' 16385 | mydatabase | 16506 | 16384 | pguser | | 127.0.0.1 | | 56893 | 2015-06-25 07:27:52.199076+00 | | 2015-06-25 08:22:56.535016+00 | 2015-06-25 08:22:56.535066+00 | f | idle | SELECT * FROM table134 WHERE COL6 = 'MyFunnyString' 16385 | mydatabase | 17128 | 16384 | pguser | | 127.0.0.1 | | 56902 | 2015-06-25 07:28:05.055152+00 | | 2015-06-25 07:28:05.096018+00 | 2015-06-25 07:28:05.096039+00 | f | idle | SELECT * FROM table134 WHERE COL6 = 'MyFunnyString' 16385 | mydatabase | 17130 | 16384 | pguser | | 127.0.0.1 | | 56903 | 2015-06-25 07:28:05.077238+00 | | 2015-06-25 07:28:05.093452+00 | 2015-06-25 07:28:05.093462+00 | f | idle | SELECT * FROM table8 16385 | mydatabase | 3942 | 16384 | pguser | | 127.0.0.1 | | 56735 | 2015-06-25 08:20:59.679311+00 | | 2015-07-01 12:11:40.711336+00 | 2015-07-01 12:11:40.711344+00 | f | idle | COMMIT (24 rows)