| datid | datname | procpid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | waiting | current_query |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1284719 | SpartaCI | 23525 | 10 | postgres | 192.168.96.91 | 50122 | 2015-03-17 14:37:50.697947+01 | 2015-03-17 14:37:51.530389+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 19356 | 10 | postgres | pgAdmin III- Abfragewerkzeug | 192.168.96.91 | 63427 | 2015-03-17 08:57:03.219893+01 | 2015-03-17 14:39:12.892938+01 | 2015-03-17 14:39:12.892938+01 | f | select * from pg_stat_activity WHERE datname = 'SpartaCI' | |
| 1284719 | SpartaCI | 19029 | 10 | postgres | pgAdmin III- Browser | 192.168.96.91 | 63175 | 2015-03-17 08:46:23.305957+01 | 2015-03-17 08:46:23.47564+01 | f | <IDLE> | ||
| 1284719 | SpartaCI | 23510 | 10 | postgres | 192.168.96.91 | 50109 | 2015-03-17 14:37:36.023761+01 | 2015-03-17 14:37:37.204956+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23511 | 10 | postgres | 192.168.96.91 | 50110 | 2015-03-17 14:37:37.506643+01 | 2015-03-17 14:37:38.445361+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23512 | 10 | postgres | 192.168.96.91 | 50111 | 2015-03-17 14:37:38.508863+01 | 2015-03-17 14:37:39.379263+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23513 | 10 | postgres | 192.168.96.91 | 50112 | 2015-03-17 14:37:39.43448+01 | 2015-03-17 14:37:40.542339+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23515 | 10 | postgres | 192.168.96.91 | 50113 | 2015-03-17 14:37:40.591369+01 | 2015-03-17 14:37:41.470425+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23516 | 10 | postgres | 192.168.96.91 | 50114 | 2015-03-17 14:37:41.523822+01 | 2015-03-17 14:37:42.335431+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23517 | 10 | postgres | 192.168.96.91 | 50115 | 2015-03-17 14:37:42.383143+01 | 2015-03-17 14:37:43.221479+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23518 | 10 | postgres | 192.168.96.91 | 50116 | 2015-03-17 14:37:43.274698+01 | 2015-03-17 14:37:44.179312+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23519 | 10 | postgres | 192.168.96.91 | 50117 | 2015-03-17 14:37:44.310896+01 | 2015-03-17 14:37:45.174244+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23520 | 10 | postgres | 192.168.96.91 | 50118 | 2015-03-17 14:37:45.255963+01 | 2015-03-17 14:37:47.106016+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23521 | 10 | postgres | 192.168.96.91 | 50119 | 2015-03-17 14:37:47.143532+01 | 2015-03-17 14:37:48.950519+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23523 | 10 | postgres | 192.168.96.91 | 50120 | 2015-03-17 14:37:48.995873+01 | 2015-03-17 14:37:49.799136+01 | 2015-03-17 14:37:49.799656+01 | f | <IDLE> in transaction | ||
| 1284719 | SpartaCI | 23524 | 10 | postgres | 192.168.96.91 | 50121 | 2015-03-17 14:37:49.853087+01 | 2015-03-17 14:37:50.659202+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23526 | 10 | postgres | 192.168.96.91 | 50123 | 2015-03-17 14:37:51.577305+01 | 2015-03-17 14:37:52.454648+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23527 | 10 | postgres | 192.168.96.91 | 50124 | 2015-03-17 14:37:52.515145+01 | 2015-03-17 14:37:53.342579+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23528 | 10 | postgres | 192.168.96.91 | 50125 | 2015-03-17 14:37:53.380692+01 | 2015-03-17 14:37:54.217285+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23529 | 10 | postgres | 192.168.96.91 | 50126 | 2015-03-17 14:37:54.25008+01 | 2015-03-17 14:37:55.048882+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23530 | 10 | postgres | 192.168.96.91 | 50127 | 2015-03-17 14:37:55.097344+01 | 2015-03-17 14:37:56.935666+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23531 | 10 | postgres | 192.168.96.91 | 50128 | 2015-03-17 14:37:56.982398+01 | 2015-03-17 14:37:57.814655+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23533 | 10 | postgres | 192.168.96.91 | 50129 | 2015-03-17 14:37:57.84156+01 | 2015-03-17 14:37:58.690847+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23534 | 10 | postgres | 192.168.96.91 | 50130 | 2015-03-17 14:37:58.728218+01 | 2015-03-17 14:38:00.576286+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23535 | 10 | postgres | 192.168.96.91 | 50131 | 2015-03-17 14:38:00.629015+01 | 2015-03-17 14:38:01.479137+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23536 | 10 | postgres | 192.168.96.91 | 50132 | 2015-03-17 14:38:01.523098+01 | 2015-03-17 14:38:02.335194+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23539 | 10 | postgres | 192.168.96.91 | 50133 | 2015-03-17 14:38:02.369065+01 | 2015-03-17 14:38:03.153606+01 | 2015-03-17 14:38:03.154141+01 | f | <IDLE> in transaction | ||
| 1284719 | SpartaCI | 23540 | 10 | postgres | 192.168.96.91 | 50134 | 2015-03-17 14:38:03.190512+01 | 2015-03-17 14:38:04.041647+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23541 | 10 | postgres | 192.168.96.91 | 50135 | 2015-03-17 14:38:04.101648+01 | 2015-03-17 14:38:06.509825+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23543 | 10 | postgres | 192.168.96.91 | 50136 | 2015-03-17 14:38:06.54553+01 | 2015-03-17 14:38:07.401324+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23544 | 10 | postgres | 192.168.96.91 | 50137 | 2015-03-17 14:38:07.450591+01 | 2015-03-17 14:38:08.289933+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23545 | 10 | postgres | 192.168.96.91 | 50138 | 2015-03-17 14:38:08.343672+01 | 2015-03-17 14:38:09.222233+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23546 | 10 | postgres | 192.168.96.91 | 50139 | 2015-03-17 14:38:09.26432+01 | 2015-03-17 14:38:10.054569+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23547 | 10 | postgres | 192.168.96.91 | 50140 | 2015-03-17 14:38:10.090091+01 | 2015-03-17 14:38:11.827345+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23548 | 10 | postgres | 192.168.96.91 | 50141 | 2015-03-17 14:38:11.873655+01 | 2015-03-17 14:38:12.682291+01 | 2015-03-17 14:38:12.682849+01 | f | <IDLE> in transaction | ||
| 1284719 | SpartaCI | 23549 | 10 | postgres | 192.168.96.91 | 50142 | 2015-03-17 14:38:12.726458+01 | 2015-03-17 14:38:13.582031+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23550 | 10 | postgres | 192.168.96.91 | 50143 | 2015-03-17 14:38:13.614459+01 | 2015-03-17 14:38:14.391881+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23551 | 10 | postgres | 192.168.96.91 | 50144 | 2015-03-17 14:38:14.435776+01 | 2015-03-17 14:38:15.30914+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23553 | 10 | postgres | 192.168.96.91 | 50145 | 2015-03-17 14:38:15.346727+01 | 2015-03-17 14:38:16.196879+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23554 | 10 | postgres | 192.168.96.91 | 50146 | 2015-03-17 14:38:16.240652+01 | 2015-03-17 14:38:17.039719+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23555 | 10 | postgres | 192.168.96.91 | 50147 | 2015-03-17 14:38:17.083112+01 | 2015-03-17 14:38:17.979638+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23556 | 10 | postgres | 192.168.96.91 | 50148 | 2015-03-17 14:38:18.01247+01 | 2015-03-17 14:38:20.049474+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23557 | 10 | postgres | 192.168.96.91 | 50149 | 2015-03-17 14:38:20.087959+01 | 2015-03-17 14:38:21.764317+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23558 | 10 | postgres | 192.168.96.91 | 50150 | 2015-03-17 14:38:21.811058+01 | 2015-03-17 14:38:22.583884+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23559 | 10 | postgres | 192.168.96.91 | 50151 | 2015-03-17 14:38:22.625853+01 | 2015-03-17 14:38:23.49378+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23561 | 10 | postgres | 192.168.96.91 | 50152 | 2015-03-17 14:38:23.544352+01 | 2015-03-17 14:38:24.346904+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23562 | 10 | postgres | 192.168.96.91 | 50153 | 2015-03-17 14:38:24.389565+01 | 2015-03-17 14:38:25.191725+01 | 2015-03-17 14:38:25.192331+01 | f | <IDLE> in transaction | ||
| 1284719 | SpartaCI | 23563 | 10 | postgres | 192.168.96.91 | 50154 | 2015-03-17 14:38:25.234346+01 | 2015-03-17 14:38:26.07756+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23564 | 10 | postgres | 192.168.96.91 | 50155 | 2015-03-17 14:38:26.116078+01 | 2015-03-17 14:38:27.023824+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23565 | 10 | postgres | 192.168.96.91 | 50156 | 2015-03-17 14:38:27.065851+01 | 2015-03-17 14:38:27.934119+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23566 | 10 | postgres | 192.168.96.91 | 50157 | 2015-03-17 14:38:28.012963+01 | 2015-03-17 14:38:28.840907+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23567 | 10 | postgres | 192.168.96.91 | 50158 | 2015-03-17 14:38:28.889787+01 | 2015-03-17 14:38:29.733597+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23568 | 10 | postgres | 192.168.96.91 | 50159 | 2015-03-17 14:38:29.780076+01 | 2015-03-17 14:38:30.648565+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23569 | 10 | postgres | 192.168.96.91 | 50160 | 2015-03-17 14:38:30.701722+01 | 2015-03-17 14:38:31.525954+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23570 | 10 | postgres | 192.168.96.91 | 50161 | 2015-03-17 14:38:31.557243+01 | 2015-03-17 14:38:33.637417+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23574 | 10 | postgres | 192.168.96.91 | 50162 | 2015-03-17 14:38:33.682788+01 | 2015-03-17 14:38:34.496145+01 | 2015-03-17 14:38:34.496954+01 | f | <IDLE> in transaction | ||
| 1284719 | SpartaCI | 23575 | 10 | postgres | 192.168.96.91 | 50163 | 2015-03-17 14:38:34.537878+01 | 2015-03-17 14:38:35.41712+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23576 | 10 | postgres | 192.168.96.91 | 50165 | 2015-03-17 14:38:35.465487+01 | 2015-03-17 14:38:36.315224+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23577 | 10 | postgres | 192.168.96.91 | 50166 | 2015-03-17 14:38:36.365878+01 | 2015-03-17 14:38:37.243998+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23578 | 10 | postgres | 192.168.96.91 | 50167 | 2015-03-17 14:38:37.285117+01 | 2015-03-17 14:38:38.066672+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23579 | 10 | postgres | 192.168.96.91 | 50168 | 2015-03-17 14:38:38.132603+01 | 2015-03-17 14:38:38.951769+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23580 | 10 | postgres | 192.168.96.91 | 50169 | 2015-03-17 14:38:39.001467+01 | 2015-03-17 14:38:39.844374+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23581 | 10 | postgres | 192.168.96.91 | 50170 | 2015-03-17 14:38:39.882642+01 | 2015-03-17 14:38:42.275919+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23583 | 10 | postgres | 192.168.96.91 | 50171 | 2015-03-17 14:38:42.325176+01 | 2015-03-17 14:38:43.197205+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23584 | 10 | postgres | 192.168.96.91 | 50172 | 2015-03-17 14:38:43.252535+01 | 2015-03-17 14:38:44.119238+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23585 | 10 | postgres | 192.168.96.91 | 50173 | 2015-03-17 14:38:44.154553+01 | 2015-03-17 14:38:44.965306+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23586 | 10 | postgres | 192.168.96.91 | 50174 | 2015-03-17 14:38:45.028025+01 | 2015-03-17 14:38:45.820354+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23587 | 10 | postgres | 192.168.96.91 | 50175 | 2015-03-17 14:38:45.848893+01 | 2015-03-17 14:38:46.804253+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23588 | 10 | postgres | 192.168.96.91 | 50176 | 2015-03-17 14:38:46.854731+01 | 2015-03-17 14:38:47.682246+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23589 | 10 | postgres | 192.168.96.91 | 50177 | 2015-03-17 14:38:47.715364+01 | 2015-03-17 14:38:49.566261+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23591 | 10 | postgres | 192.168.96.91 | 50178 | 2015-03-17 14:38:49.612838+01 | 2015-03-17 14:38:50.447113+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23592 | 10 | postgres | 192.168.96.91 | 50179 | 2015-03-17 14:38:50.488648+01 | 2015-03-17 14:38:52.479786+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23593 | 10 | postgres | 192.168.96.91 | 50180 | 2015-03-17 14:38:52.52537+01 | 2015-03-17 14:38:53.320824+01 | 2015-03-17 14:38:53.321463+01 | f | <IDLE> in transaction | ||
| 1284719 | SpartaCI | 23594 | 10 | postgres | 192.168.96.91 | 50181 | 2015-03-17 14:38:53.365382+01 | 2015-03-17 14:38:54.171776+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23595 | 10 | postgres | 192.168.96.91 | 50182 | 2015-03-17 14:38:54.206166+01 | 2015-03-17 14:38:55.042219+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23596 | 10 | postgres | 192.168.96.91 | 50183 | 2015-03-17 14:38:55.117806+01 | 2015-03-17 14:38:55.962615+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23597 | 10 | postgres | 192.168.96.91 | 50184 | 2015-03-17 14:38:56.002985+01 | 2015-03-17 14:38:56.842485+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23598 | 10 | postgres | 192.168.96.91 | 50185 | 2015-03-17 14:38:56.888894+01 | 2015-03-17 14:38:57.734866+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23600 | 10 | postgres | 192.168.96.91 | 50186 | 2015-03-17 14:38:57.777361+01 | 2015-03-17 14:38:58.580673+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23601 | 10 | postgres | 192.168.96.91 | 50187 | 2015-03-17 14:38:58.623838+01 | 2015-03-17 14:38:59.464456+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23602 | 10 | postgres | 192.168.96.91 | 50188 | 2015-03-17 14:38:59.512698+01 | 2015-03-17 14:39:00.387874+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23603 | 10 | postgres | 192.168.96.91 | 50189 | 2015-03-17 14:39:00.462182+01 | 2015-03-17 14:39:01.242668+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23604 | 10 | postgres | 192.168.96.91 | 50190 | 2015-03-17 14:39:01.287401+01 | 2015-03-17 14:39:02.073596+01 | 2015-03-17 14:39:02.074143+01 | f | <IDLE> in transaction | ||
| 1284719 | SpartaCI | 23607 | 10 | postgres | 192.168.96.91 | 50191 | 2015-03-17 14:39:02.095669+01 | 2015-03-17 14:39:03.935659+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23608 | 10 | postgres | 192.168.96.91 | 50192 | 2015-03-17 14:39:03.97491+01 | 2015-03-17 14:39:06.325714+01 | f | <IDLE> | |||
| 1284719 | SpartaCI | 23610 | 10 | postgres | 192.168.96.91 | 50193 | 2015-03-17 14:39:06.364469+01 | 2015-03-17 14:39:07.295309+01 | f | <IDLE> |
86 rows with 14 columns retrieved.
select * from pg_stat_activity WHERE datname = 'SpartaCI'