datid datname pid usesysid usename application_name client_addr client_hostname client_port backend_start xact_start query_start state_change waiting state query
41167 billing 9692 16396 srmdcache   192.33.123.24 t3se01.psi.ch 44463 2013-06-10 15:38:33.836947+02   2013-06-11 11:12:09.077133+02 2013-06-11 11:12:09.077155+02 f idle COMMIT
41167 billing 9562 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49524 2013-05-16 09:28:10.923477+02   2013-06-11 09:30:20.836383+02 2013-06-11 09:30:20.836582+02 f 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 WHEN 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 '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' 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 d ON (c.oid = d.objoid AND d.ob
41167 billing 9691 16396 srmdcache   192.33.123.24 t3se01.psi.ch 44462 2013-06-10 15:38:33.827307+02   2013-06-11 11:12:08.355739+02 2013-06-11 11:12:08.355764+02 f idle COMMIT
41167 billing 31263 16396 srmdcache   192.33.123.24 t3se01.psi.ch 36238 2013-06-10 06:17:04.170293+02   2013-06-11 11:18:08.27666+02 2013-06-11 11:18:08.277561+02 f idle COMMIT
41167 billing 365 16396 srmdcache   192.33.123.24 t3se01.psi.ch 33332 2013-06-11 11:11:08.064766+02   2013-06-11 11:16:58.24366+02 2013-06-11 11:16:58.244266+02 f idle COMMIT
41167 billing 23712 16396 srmdcache   192.33.123.24 t3se01.psi.ch 54619 2013-06-11 03:17:09.289724+02   2013-06-11 11:17:08.250989+02 2013-06-11 11:17:08.25168+02 f idle COMMIT
41167 billing 7760 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42825 2013-06-10 13:42:36.237146+02   2013-06-11 11:17:58.267219+02 2013-06-11 11:17:58.268747+02 f idle COMMIT
41167 billing 24703 16396 srmdcache   192.33.123.24 t3se01.psi.ch 55463 2013-06-11 04:10:49.535955+02   2013-06-11 11:12:09.477774+02 2013-06-11 11:12:09.477807+02 f idle COMMIT
41167 billing 25637 16396 srmdcache   192.33.123.24 t3se01.psi.ch 60152 2013-06-10 01:13:03.15042+02   2013-06-11 11:16:08.230971+02 2013-06-11 11:16:08.231563+02 f idle COMMIT
41167 billing 24702 16396 srmdcache   192.33.123.24 t3se01.psi.ch 55462 2013-06-11 04:10:49.532292+02   2013-06-11 11:12:07.786475+02 2013-06-11 11:12:07.7865+02 f idle COMMIT
41167 billing 14358 16396 srmdcache   192.33.123.24 t3se01.psi.ch 47682 2013-06-10 19:18:09.023201+02   2013-06-11 11:14:03.163017+02 2013-06-11 11:14:03.164102+02 f idle COMMIT
41167 billing 9597 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49559 2013-05-16 09:28:14.996625+02   2013-06-11 09:30:07.383063+02 2013-06-11 09:30:07.383271+02 f 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 WHEN 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 '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' 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 d ON (c.oid = d.objoid AND d.ob
41167 billing 9593 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49555 2013-05-16 09:28:14.97519+02   2013-06-11 09:30:06.390639+02 2013-06-11 09:30:06.390727+02 f 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 WHEN 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 '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' 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 d ON (c.oid = d.objoid AND d.ob
41167 billing 9590 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49552 2013-05-16 09:28:14.961548+02   2013-06-11 09:30:09.706293+02 2013-06-11 09:30:09.70652+02 f 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 WHEN 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 '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' 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 d ON (c.oid = d.objoid AND d.ob
41167 billing 21425 16396 srmdcache   192.33.123.24 t3se01.psi.ch 52875 2013-06-11 01:12:17.488252+02   2013-06-11 11:17:13.257463+02 2013-06-11 11:17:13.257968+02 f idle COMMIT
41167 billing 9049 16396 srmdcache   192.33.123.24 t3se01.psi.ch 53135 2013-06-08 08:58:55.372105+02   2013-06-11 11:12:08.903038+02 2013-06-11 11:12:08.903057+02 f idle COMMIT
41167 billing 366 16396 srmdcache   192.33.123.24 t3se01.psi.ch 33333 2013-06-11 11:11:08.071521+02   2013-06-11 11:15:03.196362+02 2013-06-11 11:15:03.197134+02 f idle COMMIT
41167 billing 24877 16396 srmdcache   192.33.123.24 t3se01.psi.ch 36763 2013-06-08 22:31:14.541462+02   2013-06-11 11:12:07.611117+02 2013-06-11 11:12:07.611136+02 f idle COMMIT
41167 billing 4268 16396 srmdcache   192.33.123.24 t3se01.psi.ch 35796 2013-06-05 02:14:23.8172+02   2013-06-11 11:12:08.540175+02 2013-06-11 11:12:08.540201+02 f idle COMMIT
41167 billing 16177 16396 srmdcache   192.33.123.24 t3se01.psi.ch 58397 2013-06-08 14:59:58.560087+02   2013-06-11 11:12:08.907301+02 2013-06-11 11:12:08.907317+02 f idle COMMIT
41167 billing 9554 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49516 2013-05-16 09:28:10.494404+02   2013-06-11 09:30:22.737711+02 2013-06-11 09:30:22.738+02 f 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 WHEN 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 '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' 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 d ON (c.oid = d.objoid AND d.ob
41167 billing 9561 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49523 2013-05-16 09:28:10.914821+02   2013-06-11 09:30:18.452535+02 2013-06-11 09:30:18.45276+02 f 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 WHEN 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 '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' 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 d ON (c.oid = d.objoid AND d.ob
41167 billing 24876 16396 srmdcache   192.33.123.24 t3se01.psi.ch 36762 2013-06-08 22:31:14.535446+02   2013-06-11 11:12:08.734846+02 2013-06-11 11:12:08.73486+02 f idle COMMIT
41168 chimera 11229 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42233 2013-05-16 09:33:28.27618+02   2013-06-11 11:18:31.602057+02 2013-06-11 11:18:33.405764+02 f idle SELECT t_inodes.ipnfsid, t_dirs.iname, t_inodes.isize,t_inodes.inlink,t_inodes.imode,t_inodes.itype,t_inodes.iuid,t_inodes.igid,t_inodes.iatime,t_inodes.ictime,t_inodes.imtime FROM t_inodes, t_dirs WHERE iparent=$1 AND t_inodes.ipnfsid = t_dirs.ipnfsid
41168 chimera 11230 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42234 2013-05-16 09:33:28.277909+02   2013-06-11 11:18:10.69248+02 2013-06-11 11:18:10.692635+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11231 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42235 2013-05-16 09:33:28.27918+02   2013-06-11 11:18:45.332593+02 2013-06-11 11:18:45.332702+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11232 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42236 2013-05-16 09:33:28.280771+02   2013-06-11 11:18:06.561727+02 2013-06-11 11:18:06.56181+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11238 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42237 2013-05-16 09:33:28.283581+02   2013-06-11 11:18:10.696776+02 2013-06-11 11:18:10.696943+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11239 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42238 2013-05-16 09:33:28.284219+02   2013-06-11 11:18:31.591017+02 2013-06-11 11:18:31.591078+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 11240 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42239 2013-05-16 09:33:28.286471+02   2013-06-11 11:18:10.691424+02 2013-06-11 11:18:10.691605+02 f idle SELECT ipnfsid FROM t_dirs WHERE iname=$1 AND iparent=$2
41168 chimera 11241 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42240 2013-05-16 09:33:28.28814+02   2013-06-11 11:18:31.543864+02 2013-06-11 11:18:31.544009+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11242 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42241 2013-05-16 09:33:28.289932+02   2013-06-11 11:18:07.154278+02 2013-06-11 11:18:07.154374+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11243 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42242 2013-05-16 09:33:28.29211+02   2013-06-11 11:18:31.544367+02 2013-06-11 11:18:31.544515+02 f idle SELECT iparent FROM t_dirs WHERE ipnfsid=$1 AND iname!='..' AND iname !='.'
41168 chimera 11244 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42243 2013-05-16 09:33:28.292858+02   2013-06-11 11:18:10.848801+02 2013-06-11 11:18:10.849004+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11245 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42244 2013-05-16 09:33:28.294918+02   2013-06-11 11:18:31.586467+02 2013-06-11 11:18:31.586616+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11246 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42245 2013-05-16 09:33:28.295725+02   2013-06-11 11:18:10.692001+02 2013-06-11 11:18:10.692169+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11247 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42246 2013-05-16 09:33:28.297799+02   2013-06-11 11:18:31.58603+02 2013-06-11 11:18:31.586163+02 f idle SELECT ilocation,ipriority,ictime,iatime FROM t_locationinfo WHERE itype=$1 AND ipnfsid=$2 AND istate=1 ORDER BY ipriority DESC
41168 chimera 11248 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42247 2013-05-16 09:33:28.300649+02   2013-06-11 11:18:31.588569+02 2013-06-11 11:18:31.588637+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 11254 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42248 2013-05-16 09:33:28.30329+02   2013-06-11 11:18:03.606176+02 2013-06-11 11:18:03.756042+02 f idle SELECT t_inodes.ipnfsid, t_dirs.iname, t_inodes.isize,t_inodes.inlink,t_inodes.imode,t_inodes.itype,t_inodes.iuid,t_inodes.igid,t_inodes.iatime,t_inodes.ictime,t_inodes.imtime FROM t_inodes, t_dirs WHERE iparent=$1 AND t_inodes.ipnfsid = t_dirs.ipnfsid
41168 chimera 12433 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42314 2013-05-16 10:32:00.434547+02   2013-06-11 11:18:50.304972+02 2013-06-11 11:18:50.30509+02 f idle SELECT ilocation,ipriority,ictime,iatime FROM t_locationinfo WHERE itype=$1 AND ipnfsid=$2 AND istate=1 ORDER BY ipriority DESC
41168 chimera 12435 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42316 2013-05-16 10:32:00.481417+02   2013-06-11 11:18:50.309476+02 2013-06-11 11:18:50.309552+02 f idle SELECT iparent FROM t_dirs WHERE ipnfsid=$1 AND iname != '.' and iname != '..'
41168 chimera 5484 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 50194 2013-05-24 02:54:18.819444+02   2013-06-11 09:00:57.859158+02 2013-06-11 09:00:57.860086+02 f idle DELETE FROM t_locationinfo_trash WHERE ilocation=$1 AND ipnfsid=$2 AND itype=1
41168 chimera 11198 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42210 2013-05-16 09:33:28.20825+02   2013-06-11 11:18:50.307515+02 2013-06-11 11:18:50.307584+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11200 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42213 2013-05-16 09:33:28.21334+02   2013-06-11 11:18:50.309255+02 2013-06-11 11:18:50.309325+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11208 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42221 2013-05-16 09:33:28.240414+02   2013-06-11 11:18:50.308092+02 2013-06-11 11:18:50.308161+02 f idle SELECT iaccessLatency FROM t_access_latency WHERE ipnfsid=$1
41168 chimera 11201 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42214 2013-05-16 09:33:28.217835+02   2013-06-11 11:18:50.309697+02 2013-06-11 11:18:50.309794+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11202 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42215 2013-05-16 09:33:28.220813+02   2013-06-11 11:18:50.304734+02 2013-06-11 11:18:50.304805+02 f idle SELECT isum FROM t_inodes_checksum WHERE ipnfsid=$1 AND itype=$2
41168 chimera 11203 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42216 2013-05-16 09:33:28.223684+02   2013-06-11 11:18:30.668931+02 2013-06-11 11:18:30.669102+02 f idle SELECT t_inodes.ipnfsid, t_dirs.iname, t_inodes.isize,t_inodes.inlink,t_inodes.imode,t_inodes.itype,t_inodes.iuid,t_inodes.igid,t_inodes.iatime,t_inodes.ictime,t_inodes.imtime FROM t_inodes, t_dirs WHERE iparent=$1 AND t_inodes.ipnfsid = t_dirs.ipnfsid
41168 chimera 11204 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42217 2013-05-16 09:33:28.226532+02   2013-06-11 11:18:50.304216+02 2013-06-11 11:18:50.304293+02 f idle SELECT isum FROM t_inodes_checksum WHERE ipnfsid=$1 AND itype=$2
41168 chimera 11205 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42218 2013-05-16 09:33:28.22937+02   2013-06-11 11:18:50.30398+02 2013-06-11 11:18:50.304059+02 f idle SELECT iaccessLatency FROM t_access_latency WHERE ipnfsid=$1
41168 chimera 11206 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42219 2013-05-16 09:33:28.232279+02   2013-06-11 11:18:50.303328+02 2013-06-11 11:18:50.303408+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11207 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42220 2013-05-16 09:33:28.235125+02   2013-06-11 11:18:50.306149+02 2013-06-11 11:18:50.30618+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 11217 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42222 2013-05-16 09:33:28.24752+02   2013-06-11 11:18:45.350773+02 2013-06-11 11:18:45.350868+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 11219 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42223 2013-05-16 09:33:28.2511+02   2013-06-11 11:18:45.350099+02 2013-06-11 11:18:45.35021+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11220 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42224 2013-05-16 09:33:28.25699+02   2013-06-11 11:18:45.349686+02 2013-06-11 11:18:45.349769+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 11221 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42225 2013-05-16 09:33:28.260247+02   2013-06-11 11:18:45.281926+02 2013-06-11 11:18:45.306625+02 f idle SELECT iaccessLatency FROM t_access_latency WHERE ipnfsid=$1
41168 chimera 11222 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42226 2013-05-16 09:33:28.263839+02   2013-06-11 11:18:45.365784+02 2013-06-11 11:18:45.365928+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11223 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42227 2013-05-16 09:33:28.265378+02   2013-06-11 11:18:10.847831+02 2013-06-11 11:18:10.847987+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11224 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42228 2013-05-16 09:33:28.266856+02   2013-06-11 11:18:45.331755+02 2013-06-11 11:18:45.331889+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11225 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42229 2013-05-16 09:33:28.26978+02   2013-06-11 11:18:45.333074+02 2013-06-11 11:18:45.337775+02 f idle SELECT isum FROM t_inodes_checksum WHERE ipnfsid=$1 AND itype=$2
41168 chimera 11226 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42230 2013-05-16 09:33:28.272132+02   2013-06-11 11:18:10.690406+02 2013-06-11 11:18:10.690568+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11227 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42231 2013-05-16 09:33:28.27297+02   2013-06-11 11:18:45.352269+02 2013-06-11 11:18:45.352377+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11228 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42232 2013-05-16 09:33:28.275067+02   2013-06-11 11:18:40.80138+02 2013-06-11 11:18:40.801546+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11264 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42256 2013-05-16 09:33:28.317339+02   2013-06-11 11:18:10.693638+02 2013-06-11 11:18:10.693859+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11265 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42257 2013-05-16 09:33:28.320116+02   2013-06-11 11:18:12.182271+02 2013-06-11 11:18:12.182424+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11266 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42258 2013-05-16 09:33:28.323076+02   2013-06-11 11:18:10.849928+02 2013-06-11 11:18:10.850107+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 13435 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42344 2013-05-16 11:30:07.251403+02   2013-06-11 11:18:45.332188+02 2013-06-11 11:18:45.33234+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 13436 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42345 2013-05-16 11:30:07.25474+02   2013-06-11 11:18:45.338877+02 2013-06-11 11:18:45.347955+02 f idle SELECT ilocation,ipriority,ictime,iatime FROM t_locationinfo WHERE itype=$1 AND ipnfsid=$2 AND istate=1 ORDER BY ipriority DESC
41168 chimera 13437 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42346 2013-05-16 11:30:07.55217+02   2013-06-11 11:18:50.307326+02 2013-06-11 11:18:50.307356+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 11267 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42259 2013-05-16 09:33:28.326003+02   2013-06-11 11:18:04.445404+02 2013-06-11 11:18:04.445554+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 13438 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42347 2013-05-16 11:30:08.097222+02   2013-06-11 11:18:50.307912+02 2013-06-11 11:18:50.307942+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 13439 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42348 2013-05-16 11:30:08.102131+02   2013-06-11 11:18:50.308301+02 2013-06-11 11:18:50.308371+02 f idle SELECT iretentionPolicy FROM t_retention_policy WHERE ipnfsid=$1
41168 chimera 13440 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42349 2013-05-16 11:30:08.231611+02   2013-06-11 11:18:50.303081+02 2013-06-11 11:18:50.303181+02 f idle SELECT iparent FROM t_dirs WHERE ipnfsid=$1 AND iname != '.' and iname != '..'
41168 chimera 13442 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42350 2013-05-16 11:30:08.238866+02   2013-06-11 11:18:30.871552+02 2013-06-11 11:18:30.871712+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11268 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42260 2013-05-16 09:33:28.328897+02   2013-06-11 11:18:10.697774+02 2013-06-11 11:18:10.746773+02 f idle SELECT ipnfsid FROM t_dirs WHERE iname=$1 AND iparent=$2
41168 chimera 17110 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 54970 2013-05-29 02:04:59.579417+02   2013-06-11 08:44:57.734333+02 2013-06-11 08:44:57.735562+02 f idle DELETE FROM t_locationinfo_trash WHERE ilocation=$1 AND ipnfsid=$2 AND itype=1
41168 chimera 5488 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 50198 2013-05-24 02:54:18.850754+02   2013-06-11 10:22:58.156112+02 2013-06-11 10:22:58.156772+02 f idle DELETE FROM t_locationinfo_trash WHERE ilocation=$1 AND ipnfsid=$2 AND itype=1
41168 chimera 17111 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 54971 2013-05-29 02:04:59.581946+02   2013-06-11 09:22:57.951238+02 2013-06-11 09:22:57.951939+02 f idle DELETE FROM t_locationinfo_trash WHERE ilocation=$1 AND ipnfsid=$2 AND itype=1
41168 chimera 14570 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42373 2013-05-16 12:17:23.482938+02   2013-06-11 11:18:31.538923+02 2013-06-11 11:18:31.538988+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 14571 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42374 2013-05-16 12:17:23.486061+02   2013-06-11 11:18:31.587721+02 2013-06-11 11:18:31.587897+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 14572 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42375 2013-05-16 12:17:23.489077+02   2013-06-11 11:18:31.540635+02 2013-06-11 11:18:31.540806+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 14573 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42376 2013-05-16 12:17:23.491651+02   2013-06-11 11:18:31.542713+02 2013-06-11 11:18:31.542797+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 14574 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42377 2013-05-16 12:17:23.533672+02   2013-06-11 11:18:31.587354+02 2013-06-11 11:18:31.587417+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 14810 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42387 2013-05-16 12:31:36.810171+02   2013-06-11 11:18:50.309044+02 2013-06-11 11:18:50.309117+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11269 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42261 2013-05-16 09:33:28.331733+02   2013-06-11 11:18:10.85063+02 2013-06-11 11:18:10.966158+02 f idle SELECT t_inodes.ipnfsid, t_dirs.iname, t_inodes.isize,t_inodes.inlink,t_inodes.imode,t_inodes.itype,t_inodes.iuid,t_inodes.igid,t_inodes.iatime,t_inodes.ictime,t_inodes.imtime FROM t_inodes, t_dirs WHERE iparent=$1 AND t_inodes.ipnfsid = t_dirs.ipnfsid
41168 chimera 11275 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42262 2013-05-16 09:33:28.339424+02   2013-06-11 11:18:04.574251+02 2013-06-11 11:18:04.575024+02 f idle SELECT t_inodes.ipnfsid, t_dirs.iname, t_inodes.isize,t_inodes.inlink,t_inodes.imode,t_inodes.itype,t_inodes.iuid,t_inodes.igid,t_inodes.iatime,t_inodes.ictime,t_inodes.imtime FROM t_inodes, t_dirs WHERE iparent=$1 AND t_inodes.ipnfsid = t_dirs.ipnfsid
41168 chimera 14577 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42378 2013-05-16 12:17:46.131581+02   2013-06-11 11:18:45.351951+02 2013-06-11 11:18:45.352012+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 11276 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42263 2013-05-16 09:33:28.342377+02   2013-06-11 11:18:10.68899+02 2013-06-11 11:18:10.689238+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 14578 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42379 2013-05-16 12:17:46.134872+02   2013-06-11 11:18:45.366253+02 2013-06-11 11:18:45.36636+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 14579 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42380 2013-05-16 12:17:46.137564+02   2013-06-11 11:18:45.248543+02 2013-06-11 11:18:45.248692+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 17112 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 54972 2013-05-29 02:04:59.584619+02   2013-06-11 08:22:57.528186+02 2013-06-11 08:22:57.52924+02 f idle DELETE FROM t_locationinfo_trash WHERE ilocation=$1 AND ipnfsid=$2 AND itype=1
41168 chimera 11277 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42264 2013-05-16 09:33:28.345188+02   2013-06-11 11:18:11.866332+02 2013-06-11 11:18:11.866572+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11278 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42265 2013-05-16 09:33:28.348109+02   2013-06-11 11:18:10.695727+02 2013-06-11 11:18:10.69589+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11279 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42266 2013-05-16 09:33:28.351087+02   2013-06-11 11:18:10.694755+02 2013-06-11 11:18:10.694952+02 f idle SELECT ipnfsid FROM t_dirs WHERE iname=$1 AND iparent=$2
41168 chimera 11280 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42267 2013-05-16 09:33:28.354099+02   2013-06-11 11:18:16.797664+02 2013-06-11 11:18:16.79789+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 14580 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42381 2013-05-16 12:17:46.372747+02   2013-06-11 11:18:45.338091+02 2013-06-11 11:18:45.338233+02 f idle SELECT isum FROM t_inodes_checksum WHERE ipnfsid=$1 AND itype=$2
41168 chimera 11281 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42268 2013-05-16 09:33:28.356995+02   2013-06-11 11:18:10.683174+02 2013-06-11 11:18:10.683427+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11282 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42269 2013-05-16 09:33:28.35989+02   2013-06-11 11:18:04.57334+02 2013-06-11 11:18:04.573502+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 14581 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42382 2013-05-16 12:17:46.427011+02   2013-06-11 11:18:45.351124+02 2013-06-11 11:18:45.35124+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 14811 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42388 2013-05-16 12:31:36.877787+02   2013-06-11 11:18:50.305281+02 2013-06-11 11:18:50.305361+02 f idle SELECT ilocation,ipriority,ictime,iatime FROM t_locationinfo WHERE itype=$1 AND ipnfsid=$2 AND istate=1 ORDER BY ipriority DESC
41168 chimera 11283 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42270 2013-05-16 09:33:28.362742+02   2013-06-11 11:18:10.823328+02 2013-06-11 11:18:10.846278+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11284 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42271 2013-05-16 09:33:28.365536+02   2013-06-11 11:18:06.560788+02 2013-06-11 11:18:06.560902+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11392 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42274 2013-05-16 09:35:28.671796+02   2013-06-11 11:02:58.2844+02 2013-06-11 11:02:58.28452+02 f idle SELECT DISTINCT ilocation FROM t_locationinfo_trash WHERE itype=1
41168 chimera 11396 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42275 2013-05-16 09:35:28.672842+02   2013-06-11 10:58:58.184567+02 2013-06-11 10:58:58.184732+02 f idle SELECT DISTINCT ilocation FROM t_locationinfo_trash WHERE itype=1
41168 chimera 11400 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42276 2013-05-16 09:35:28.675403+02   2013-06-11 11:04:58.285802+02 2013-06-11 11:04:58.285873+02 f idle SELECT DISTINCT ilocation FROM t_locationinfo_trash WHERE itype=1
41168 chimera 11402 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42278 2013-05-16 09:35:28.677731+02   2013-06-11 11:14:58.293238+02 2013-06-11 11:14:58.293363+02 f idle SELECT DISTINCT ilocation FROM t_locationinfo_trash WHERE itype=1
41168 chimera 11403 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42279 2013-05-16 09:35:28.681934+02   2013-06-11 11:08:58.28979+02 2013-06-11 11:08:58.289862+02 f idle SELECT DISTINCT ilocation FROM t_locationinfo_trash WHERE itype=1
41168 chimera 32408 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 47773 2013-05-21 15:14:55.709425+02   2013-06-11 11:18:12.184914+02 2013-06-11 11:18:12.28532+02 f idle SELECT t_inodes.ipnfsid, t_dirs.iname, t_inodes.isize,t_inodes.inlink,t_inodes.imode,t_inodes.itype,t_inodes.iuid,t_inodes.igid,t_inodes.iatime,t_inodes.ictime,t_inodes.imtime FROM t_inodes, t_dirs WHERE iparent=$1 AND t_inodes.ipnfsid = t_dirs.ipnfsid
41168 chimera 11404 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42280 2013-05-16 09:35:28.685317+02   2013-06-11 11:06:58.288238+02 2013-06-11 11:06:58.288533+02 f idle SELECT DISTINCT ilocation FROM t_locationinfo_trash WHERE itype=1
41168 chimera 11405 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42281 2013-05-16 09:35:28.685582+02   2013-06-11 11:04:58.185316+02 2013-06-11 11:04:58.185415+02 f 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 WHEN 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 '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' 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 d ON (c.oid = d.objoid AND d.ob
41168 chimera 14812 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42389 2013-05-16 12:31:36.970007+02   2013-06-11 11:18:50.305742+02 2013-06-11 11:18:50.305818+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11407 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42283 2013-05-16 09:35:28.688717+02   2013-06-11 11:16:58.294884+02 2013-06-11 11:16:58.294973+02 f idle SELECT DISTINCT ilocation FROM t_locationinfo_trash WHERE itype=1
41168 chimera 11408 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42284 2013-05-16 09:35:28.689024+02   2013-06-11 11:10:58.290833+02 2013-06-11 11:10:58.290908+02 f idle SELECT DISTINCT ilocation FROM t_locationinfo_trash WHERE itype=1
41168 chimera 11410 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42286 2013-05-16 09:35:28.691932+02   2013-06-11 11:00:58.18548+02 2013-06-11 11:00:58.185677+02 f idle SELECT DISTINCT ilocation FROM t_locationinfo_trash WHERE itype=1
41168 chimera 24457 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43866 2013-05-18 00:20:58.471895+02   2013-06-11 11:18:06.857475+02 2013-06-11 11:18:07.151596+02 f idle SELECT t_inodes.ipnfsid, t_dirs.iname, t_inodes.isize,t_inodes.inlink,t_inodes.imode,t_inodes.itype,t_inodes.iuid,t_inodes.igid,t_inodes.iatime,t_inodes.ictime,t_inodes.imtime FROM t_inodes, t_dirs WHERE iparent=$1 AND t_inodes.ipnfsid = t_dirs.ipnfsid
41168 chimera 24458 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43867 2013-05-18 00:20:59.934832+02   2013-06-11 11:18:12.179639+02 2013-06-11 11:18:12.179933+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 32409 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 47774 2013-05-21 15:14:55.757723+02   2013-06-11 11:18:05.05208+02 2013-06-11 11:18:05.052248+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 32410 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 47775 2013-05-21 15:14:55.762661+02   2013-06-11 11:18:10.78578+02 2013-06-11 11:18:10.785947+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11553 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42292 2013-05-16 09:43:00.805215+02   2013-06-11 11:18:31.541487+02 2013-06-11 11:18:31.541575+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 11554 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42293 2013-05-16 09:43:00.808368+02   2013-06-11 11:18:31.592354+02 2013-06-11 11:18:31.592472+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11555 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42294 2013-05-16 09:43:00.81113+02   2013-06-11 11:18:31.543444+02 2013-06-11 11:18:31.543594+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11556 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42295 2013-05-16 09:43:00.814782+02   2013-06-11 11:18:31.539321+02 2013-06-11 11:18:31.539466+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11557 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42296 2013-05-16 09:43:00.81771+02   2013-06-11 11:18:31.589844+02 2013-06-11 11:18:31.589945+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 14813 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42390 2013-05-16 12:31:37.246712+02   2013-06-11 11:18:50.306404+02 2013-06-11 11:18:50.306485+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 14814 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42391 2013-05-16 12:31:37.270035+02   2013-06-11 11:18:50.308532+02 2013-06-11 11:18:50.308618+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 24459 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43868 2013-05-18 00:20:59.938815+02   2013-06-11 11:18:06.85675+02 2013-06-11 11:18:06.856913+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 32411 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 47776 2013-05-21 15:14:55.767184+02   2013-06-11 11:16:58.254431+02 2013-06-11 11:16:58.254519+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 32412 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 47777 2013-05-21 15:14:55.792368+02   2013-06-11 11:18:04.572134+02 2013-06-11 11:18:04.572334+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 24460 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43869 2013-05-18 00:20:59.941715+02   2013-06-11 11:18:10.685278+02 2013-06-11 11:18:10.685452+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 24461 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43870 2013-05-18 00:20:59.944605+02   2013-06-11 11:18:28.799579+02 2013-06-11 11:18:28.799809+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 10188 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43378 2013-05-17 12:16:40.918494+02   2013-06-11 11:18:45.199836+02 2013-06-11 11:18:45.199894+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 10189 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43379 2013-05-17 12:16:40.927185+02   2013-06-11 11:18:45.36536+02 2013-06-11 11:18:45.36549+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 10190 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43380 2013-05-17 12:16:40.929872+02   2013-06-11 11:18:45.366636+02 2013-06-11 11:18:45.366762+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 10191 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43381 2013-05-17 12:16:40.932484+02   2013-06-11 11:18:45.279223+02 2013-06-11 11:18:45.27931+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 10192 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43382 2013-05-17 12:16:40.935014+02   2013-06-11 11:18:45.331224+02 2013-06-11 11:18:45.331391+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 10260 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43383 2013-05-17 12:18:19.390556+02   2013-06-11 11:18:31.588988+02 2013-06-11 11:18:31.58913+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 10261 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43384 2013-05-17 12:18:19.695619+02   2013-06-11 11:18:31.541875+02 2013-06-11 11:18:31.542065+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 10262 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43385 2013-05-17 12:18:19.698885+02   2013-06-11 11:18:31.585049+02 2013-06-11 11:18:31.585169+02 f idle SELECT isum FROM t_inodes_checksum WHERE ipnfsid=$1 AND itype=$2
41168 chimera 10263 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43386 2013-05-17 12:18:19.723558+02   2013-06-11 11:18:31.543026+02 2013-06-11 11:18:31.543184+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 10264 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43387 2013-05-17 12:18:19.766388+02   2013-06-11 11:18:31.591405+02 2013-06-11 11:18:31.591532+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 24462 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43871 2013-05-18 00:21:00.55915+02   2013-06-11 11:18:06.546853+02 2013-06-11 11:18:06.547118+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 24463 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43872 2013-05-18 00:21:00.577054+02   2013-06-11 11:18:06.855519+02 2013-06-11 11:18:06.855748+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 24464 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43873 2013-05-18 00:21:00.623386+02   2013-06-11 11:18:10.786818+02 2013-06-11 11:18:10.822965+02 f idle SELECT ipnfsid FROM t_dirs WHERE iname=$1 AND iparent=$2
41168 chimera 24465 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43874 2013-05-18 00:21:00.626507+02   2013-06-11 11:18:10.846623+02 2013-06-11 11:18:10.846824+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 24466 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 43875 2013-05-18 00:21:00.629969+02   2013-06-11 11:18:10.695257+02 2013-06-11 11:18:10.695443+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 10522 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 48088 2013-05-22 00:16:41.224258+02   2013-06-11 11:18:31.581516+02 2013-06-11 11:18:31.583588+02 f idle SELECT path2inode($1, $2)
41168 chimera 10523 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 48089 2013-05-22 00:16:42.282493+02   2013-06-11 11:18:31.584564+02 2013-06-11 11:18:31.584706+02 f idle SELECT isum FROM t_inodes_checksum WHERE ipnfsid=$1 AND itype=$2
41168 chimera 10524 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 48090 2013-05-22 00:16:42.285276+02   2013-06-11 11:18:31.585496+02 2013-06-11 11:18:31.585616+02 f idle SELECT isum FROM t_inodes_checksum WHERE ipnfsid=$1 AND itype=$2
41168 chimera 10525 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 48091 2013-05-22 00:16:42.28796+02   2013-06-11 11:18:31.584018+02 2013-06-11 11:18:31.584248+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 10526 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 48092 2013-05-22 00:16:42.290544+02   2013-06-11 11:18:31.590224+02 2013-06-11 11:18:31.590337+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 10538 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 48093 2013-05-22 00:17:33.0742+02   2013-06-11 11:18:45.348323+02 2013-06-11 11:18:45.348484+02 f idle SELECT ilocation,ipriority,ictime,iatime FROM t_locationinfo WHERE itype=$1 AND ipnfsid=$2 AND istate=1 ORDER BY ipriority DESC
41168 chimera 10539 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 48094 2013-05-22 00:17:33.347109+02   2013-06-11 11:18:45.358402+02 2013-06-11 11:18:45.365025+02 f idle SELECT iretentionPolicy FROM t_retention_policy WHERE ipnfsid=$1
41168 chimera 10540 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 48095 2013-05-22 00:17:33.491948+02   2013-06-11 11:18:45.35301+02 2013-06-11 11:18:45.35307+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 10541 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 48096 2013-05-22 00:17:33.625519+02   2013-06-11 11:18:45.338476+02 2013-06-11 11:18:45.338582+02 f idle SELECT isum FROM t_inodes_checksum WHERE ipnfsid=$1 AND itype=$2
41168 chimera 10542 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 48097 2013-05-22 00:17:33.681127+02   2013-06-11 11:18:45.307038+02 2013-06-11 11:18:45.330822+02 f idle SELECT iretentionPolicy FROM t_retention_policy WHERE ipnfsid=$1
41168 chimera 11031 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 52569 2013-05-26 13:48:58.699608+02   2013-06-11 11:18:50.303692+02 2013-06-11 11:18:50.303798+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11035 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 52570 2013-05-26 13:48:58.70437+02   2013-06-11 11:18:50.3055+02 2013-06-11 11:18:50.305585+02 f idle SELECT iparent FROM t_dirs WHERE ipnfsid=$1 AND iname != '.' and iname != '..'
41168 chimera 11036 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 52571 2013-05-26 13:48:58.710304+02   2013-06-11 11:18:50.306938+02 2013-06-11 11:18:50.30701+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11038 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 52572 2013-05-26 13:48:58.850967+02   2013-06-11 11:18:50.301814+02 2013-06-11 11:18:50.302552+02 f idle SELECT ipnfsid,isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime from path2inodes($1, $2)
41168 chimera 11039 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 52573 2013-05-26 13:48:58.853862+02   2013-06-11 11:18:50.306771+02 2013-06-11 11:18:50.306801+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 12434 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42315 2013-05-16 10:32:00.478611+02   2013-06-11 11:18:50.30878+02 2013-06-11 11:18:50.308851+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 12436 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42317 2013-05-16 10:32:00.48383+02   2013-06-11 11:18:50.304508+02 2013-06-11 11:18:50.304587+02 f idle SELECT isum FROM t_inodes_checksum WHERE ipnfsid=$1 AND itype=$2
41168 chimera 12437 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42318 2013-05-16 10:32:00.486262+02   2013-06-11 11:18:50.302798+02 2013-06-11 11:18:50.302892+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 32269 16395 nagios psql     -1 2013-06-11 10:43:50.904606+02     2013-06-11 10:43:50.908753+02 f idle  
41168 chimera 11255 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42249 2013-05-16 09:33:28.303581+02   2013-06-11 11:18:31.544848+02 2013-06-11 11:18:31.545004+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11256 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42250 2013-05-16 09:33:28.306281+02   2013-06-11 11:18:12.181098+02 2013-06-11 11:18:12.181266+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 13432 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42341 2013-05-16 11:30:07.060092+02   2013-06-11 11:18:45.353317+02 2013-06-11 11:18:45.358144+02 f idle SELECT iaccessLatency FROM t_access_latency WHERE ipnfsid=$1
41168 chimera 13433 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42342 2013-05-16 11:30:07.064819+02   2013-06-11 11:18:45.348822+02 2013-06-11 11:18:45.348972+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 13434 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42343 2013-05-16 11:30:07.246702+02   2013-06-11 11:18:45.200971+02 2013-06-11 11:18:45.201074+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41168 chimera 10093 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 52549 2013-05-26 12:59:31.534708+02   2013-06-11 10:00:58.059521+02 2013-06-11 10:00:58.060627+02 f idle DELETE FROM t_locationinfo_trash WHERE ilocation=$1 AND ipnfsid=$2 AND itype=1
41168 chimera 17108 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 54968 2013-05-29 02:04:59.574145+02   2013-06-11 11:00:58.281599+02 2013-06-11 11:00:58.282389+02 f idle DELETE FROM t_locationinfo_trash WHERE ilocation=$1 AND ipnfsid=$2 AND itype=1
41168 chimera 17109 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 54969 2013-05-29 02:04:59.576853+02   2013-06-11 08:36:57.624618+02 2013-06-11 08:36:57.625575+02 f idle DELETE FROM t_locationinfo_trash WHERE ilocation=$1 AND ipnfsid=$2 AND itype=1
41168 chimera 11257 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42251 2013-05-16 09:33:28.307684+02   2013-06-11 11:18:31.591875+02 2013-06-11 11:18:31.591983+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11259 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42253 2013-05-16 09:33:28.31092+02   2013-06-11 11:18:04.44656+02 2013-06-11 11:18:04.446745+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11258 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42252 2013-05-16 09:33:28.310722+02   2013-06-11 11:18:31.537835+02 2013-06-11 11:18:31.538011+02 f idle SELECT itagname FROM t_tags where ipnfsid=$1
41168 chimera 11260 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42254 2013-05-16 09:33:28.314123+02   2013-06-11 11:18:10.294315+02 2013-06-11 11:18:10.294555+02 f idle SELECT isize,inlink,itype,imode,iuid,igid,iatime,ictime,imtime FROM t_inodes WHERE ipnfsid=$1
41168 chimera 11261 16394 chimera   192.33.123.26 t3dcachedb03.psi.ch 42255 2013-05-16 09:33:28.31431+02   2013-06-11 11:18:31.540229+02 2013-06-11 11:18:31.540293+02 f idle SELECT ivalue,isize FROM t_tags_inodes WHERE itagid=$1
41169 dcache 1063 16396 srmdcache   192.33.123.24 t3se01.psi.ch 48286 2013-05-21 16:08:56.722174+02   2013-06-11 11:16:32.552414+02 2013-06-11 11:16:32.553011+02 f idle COMMIT
41169 dcache 13412 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42679 2013-06-05 08:27:21.886643+02   2013-06-11 11:18:46.013196+02 2013-06-11 11:18:46.013263+02 f idle COMMIT
41169 dcache 27286 16396 srmdcache   192.33.123.24 t3se01.psi.ch 56356 2013-06-04 17:51:24.438117+02   2013-06-11 11:14:53.031401+02 2013-06-11 11:14:53.03184+02 f idle COMMIT
41169 dcache 13414 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42681 2013-06-05 08:27:21.887668+02   2013-06-11 11:18:46.085523+02 2013-06-11 11:18:46.085559+02 f idle COMMIT
41169 dcache 13415 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42682 2013-06-05 08:27:21.891325+02   2013-06-11 11:18:46.055673+02 2013-06-11 11:18:46.055691+02 f idle COMMIT
41169 dcache 13397 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42664 2013-06-05 08:27:19.479199+02   2013-06-11 11:18:30.459027+02 2013-06-11 11:18:30.4858+02 f idle SELECT id, ATTRIBUTE, authrecord_id FROM AUTHGROUPLIST WHERE (authrecord_id = $1) ORDER BY id ASC
41169 dcache 420 16396 srmdcache   192.33.123.24 t3se01.psi.ch 33362 2013-06-11 11:15:52.892362+02     2013-06-11 11:15:52.894316+02 f idle  
41169 dcache 1067 16396 srmdcache   192.33.123.24 t3se01.psi.ch 48290 2013-05-21 16:08:56.843448+02   2013-06-11 11:12:32.398471+02 2013-06-11 11:12:32.398914+02 f idle COMMIT
41169 dcache 31666 16396 srmdcache   192.33.123.24 t3se01.psi.ch 60704 2013-06-11 10:10:58.755292+02   2013-06-11 10:59:59.765204+02 2013-06-11 10:59:59.767884+02 f idle COMMIT
41169 dcache 13416 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42683 2013-06-05 08:27:21.892429+02   2013-06-11 11:18:45.990197+02 2013-06-11 11:18:45.990245+02 f idle COMMIT
41169 dcache 13417 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42684 2013-06-05 08:27:21.89338+02   2013-06-11 11:18:46.091689+02 2013-06-11 11:18:46.091733+02 f idle COMMIT
41169 dcache 30801 16396 srmdcache   192.33.123.24 t3se01.psi.ch 59968 2013-06-11 09:21:09.525095+02   2013-06-11 11:15:52.894403+02 2013-06-11 11:15:52.894941+02 f idle COMMIT
41169 dcache 13418 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42685 2013-06-05 08:27:21.894752+02   2013-06-11 11:18:46.043824+02 2013-06-11 11:18:46.043847+02 f idle COMMIT
41169 dcache 13419 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42686 2013-06-05 08:27:21.896479+02   2013-06-11 11:18:46.055876+02 2013-06-11 11:18:46.055931+02 f idle COMMIT
41169 dcache 13420 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42687 2013-06-05 08:27:21.897435+02   2013-06-11 11:18:46.101394+02 2013-06-11 11:18:46.101429+02 f idle COMMIT
41169 dcache 10385 16396 srmdcache   192.33.123.24 t3se01.psi.ch 54271 2013-06-08 10:16:03.747458+02   2013-06-11 11:12:51.015824+02 2013-06-11 11:12:51.016386+02 f idle COMMIT
41169 dcache 13413 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42680 2013-06-05 08:27:21.887401+02   2013-06-11 11:18:46.084971+02 2013-06-11 11:18:46.08501+02 f idle COMMIT
41169 dcache 10386 16396 srmdcache   192.33.123.24 t3se01.psi.ch 54268 2013-06-08 10:16:03.751561+02   2013-06-08 10:16:04.016944+02 2013-06-08 10:16:04.117367+02 f idle COMMIT
41169 dcache 28553 16396 srmdcache   192.33.123.24 t3se01.psi.ch 58256 2013-06-11 07:21:14.419392+02   2013-06-11 11:12:01.131971+02 2013-06-11 11:12:01.132474+02 f idle COMMIT
41169 dcache 10388 16396 srmdcache   192.33.123.24 t3se01.psi.ch 54272 2013-06-08 10:16:03.754318+02   2013-06-10 13:59:29.402036+02 2013-06-10 13:59:29.405071+02 f idle COMMIT
41169 dcache 13411 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42678 2013-06-05 08:27:21.882454+02   2013-06-11 11:18:46.096983+02 2013-06-11 11:18:46.097019+02 f idle COMMIT
41169 dcache 13410 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42677 2013-06-05 08:27:21.882+02   2013-06-11 11:18:46.097012+02 2013-06-11 11:18:46.097122+02 f idle COMMIT
41169 dcache 21820 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45196 2013-06-06 19:23:25.553601+02   2013-06-11 11:18:50.315933+02 2013-06-11 11:18:50.316449+02 f idle COMMIT
41169 dcache 16633 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45374 2013-06-05 11:34:22.921945+02   2013-06-11 11:18:46.05477+02 2013-06-11 11:18:46.054788+02 f idle COMMIT
41169 dcache 13409 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42676 2013-06-05 08:27:21.881523+02   2013-06-11 11:18:46.056275+02 2013-06-11 11:18:46.056292+02 f idle COMMIT
41169 dcache 13448 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42695 2013-06-05 08:27:55.469325+02   2013-06-08 10:16:03.996597+02 2013-06-08 10:16:03.997104+02 f idle COMMIT
41169 dcache 13449 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42696 2013-06-05 08:27:55.469762+02   2013-06-08 10:27:05.096735+02 2013-06-08 10:27:05.332781+02 f idle COMMIT
41169 dcache 13450 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42697 2013-06-05 08:27:55.470125+02   2013-06-11 11:18:50.297114+02 2013-06-11 11:18:50.29787+02 f idle COMMIT
41169 dcache 13740 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42949 2013-06-05 08:46:20.579397+02   2013-06-08 10:27:05.084234+02 2013-06-08 10:27:05.084298+02 f idle COMMIT
41169 dcache 16634 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45373 2013-06-05 11:34:22.923996+02   2013-06-11 11:18:46.085495+02 2013-06-11 11:18:46.085543+02 f idle COMMIT
41169 dcache 13408 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42675 2013-06-05 08:27:21.873449+02   2013-06-11 11:18:46.086132+02 2013-06-11 11:18:46.086183+02 f idle COMMIT
41169 dcache 13407 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42674 2013-06-05 08:27:21.872963+02   2013-06-11 11:18:46.056375+02 2013-06-11 11:18:46.056406+02 f idle COMMIT
41169 dcache 13406 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42673 2013-06-05 08:27:21.872601+02   2013-06-11 11:18:46.01284+02 2013-06-11 11:18:46.012878+02 f idle COMMIT
41169 dcache 16635 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45375 2013-06-05 11:34:22.928249+02   2013-06-11 11:18:45.990295+02 2013-06-11 11:18:45.990311+02 f idle COMMIT
41169 dcache 10468 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49690 2013-05-16 09:30:28.875133+02   2013-06-11 11:17:32.563316+02 2013-06-11 11:17:32.563349+02 f idle COMMIT
41169 dcache 10469 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49691 2013-05-16 09:30:28.880401+02   2013-06-11 11:11:32.378337+02 2013-06-11 11:11:32.378987+02 f idle COMMIT
41169 dcache 13404 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42671 2013-06-05 08:27:20.118583+02   2013-06-08 10:55:05.800747+02 2013-06-08 10:55:05.878768+02 f idle COMMIT
41169 dcache 16636 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45376 2013-06-05 11:34:22.933679+02   2013-06-11 11:18:46.085077+02 2013-06-11 11:18:46.085114+02 f idle COMMIT
41169 dcache 383 16396 srmdcache   192.33.123.24 t3se01.psi.ch 33334 2013-06-11 11:12:01.131596+02     2013-06-11 11:12:01.133596+02 f idle  
41169 dcache 10473 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49695 2013-05-16 09:30:28.89409+02   2013-06-11 11:17:52.540508+02 2013-06-11 11:17:52.540993+02 f idle COMMIT
41169 dcache 16637 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45377 2013-06-05 11:34:22.935965+02   2013-06-11 11:18:46.107214+02 2013-06-11 11:18:46.107248+02 f idle COMMIT
41169 dcache 16638 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45379 2013-06-05 11:34:22.949427+02   2013-06-11 11:18:46.055747+02 2013-06-11 11:18:46.055765+02 f idle COMMIT
41169 dcache 16640 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45380 2013-06-05 11:34:22.951689+02   2013-06-11 11:18:46.08579+02 2013-06-11 11:18:46.085841+02 f idle COMMIT
41169 dcache 384 16396 srmdcache   192.33.123.24 t3se01.psi.ch 33335 2013-06-11 11:12:01.135344+02     2013-06-11 11:12:01.137108+02 f idle  
41169 dcache 16639 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45378 2013-06-05 11:34:22.949704+02   2013-06-11 11:18:46.146133+02 2013-06-11 11:18:46.146206+02 f idle COMMIT
41169 dcache 16641 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45381 2013-06-05 11:34:22.95472+02   2013-06-11 11:18:46.01362+02 2013-06-11 11:18:46.013654+02 f idle COMMIT
41169 dcache 16643 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45383 2013-06-05 11:34:22.955727+02   2013-06-11 11:18:46.184364+02 2013-06-11 11:18:46.184401+02 f idle COMMIT
41169 dcache 16642 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45382 2013-06-05 11:34:22.955484+02   2013-06-11 11:18:46.055736+02 2013-06-11 11:18:46.055757+02 f idle COMMIT
41169 dcache 10476 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49698 2013-05-16 09:30:28.908233+02   2013-06-11 11:18:50.326087+02 2013-06-11 11:18:50.326537+02 f idle COMMIT
41169 dcache 16644 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45384 2013-06-05 11:34:22.959777+02   2013-06-11 11:18:46.05584+02 2013-06-11 11:18:46.055858+02 f idle COMMIT
41169 dcache 21821 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45197 2013-06-06 19:23:25.559718+02   2013-06-11 11:18:32.596666+02 2013-06-11 11:18:32.596778+02 f idle COMMIT
41169 dcache 21822 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45198 2013-06-06 19:23:25.566344+02   2013-06-11 11:17:59.233449+02 2013-06-11 11:17:59.234418+02 f idle COMMIT
41169 dcache 13403 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42670 2013-06-05 08:27:19.512086+02     2013-06-05 08:27:19.514545+02 f idle  
41169 dcache 16645 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45385 2013-06-05 11:34:22.9605+02   2013-06-11 11:18:46.056271+02 2013-06-11 11:18:46.056288+02 f idle COMMIT
41169 dcache 16646 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45386 2013-06-05 11:34:22.965996+02   2013-06-11 11:18:46.146249+02 2013-06-11 11:18:46.146268+02 f idle COMMIT
41169 dcache 16647 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45387 2013-06-05 11:34:22.966273+02   2013-06-11 11:18:46.054991+02 2013-06-11 11:18:46.055014+02 f idle COMMIT
41169 dcache 13402 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42669 2013-06-05 08:27:19.506249+02     2013-06-05 08:27:19.508676+02 f idle  
41169 dcache 19461 16396 srmdcache   192.33.123.24 t3se01.psi.ch 47338 2013-06-05 13:43:52.460766+02   2013-06-08 10:27:05.095687+02 2013-06-08 10:27:05.332867+02 f idle COMMIT
41169 dcache 21810 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45186 2013-06-06 19:23:24.279795+02   2013-06-11 11:17:52.592214+02 2013-06-11 11:17:52.592717+02 f idle COMMIT
41169 dcache 21811 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45187 2013-06-06 19:23:24.294282+02   2013-06-11 11:17:32.564509+02 2013-06-11 11:17:32.565366+02 f idle COMMIT
41169 dcache 13401 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42668 2013-06-05 08:27:19.501642+02     2013-06-05 08:27:19.503542+02 f idle  
41169 dcache 21812 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45188 2013-06-06 19:23:24.297943+02   2013-06-11 11:18:32.625004+02 2013-06-11 11:18:32.625459+02 f idle COMMIT
41169 dcache 13400 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42667 2013-06-05 08:27:19.497544+02   2013-06-05 16:16:26.85072+02 2013-06-05 16:16:26.852172+02 f idle COMMIT
41169 dcache 17288 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45914 2013-06-05 12:10:05.415556+02   2013-06-11 11:16:32.520325+02 2013-06-11 11:16:32.520968+02 f idle COMMIT
41169 dcache 17289 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45915 2013-06-05 12:10:05.42133+02   2013-06-11 11:18:07.298003+02 2013-06-11 11:18:07.299316+02 f idle COMMIT
41169 dcache 17290 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45916 2013-06-05 12:10:05.425739+02   2013-06-11 11:17:01.551593+02 2013-06-11 11:17:01.552037+02 f idle COMMIT
41169 dcache 17291 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45917 2013-06-05 12:10:05.429324+02   2013-06-11 11:12:59.563635+02 2013-06-11 11:12:59.564102+02 f idle COMMIT
41169 dcache 27280 16396 srmdcache   192.33.123.24 t3se01.psi.ch 56350 2013-06-04 17:51:23.939726+02   2013-06-11 11:18:01.233712+02 2013-06-11 11:18:01.234307+02 f idle COMMIT
41169 dcache 19465 16396 srmdcache   192.33.123.24 t3se01.psi.ch 47353 2013-06-05 13:45:45.588869+02   2013-06-08 10:16:03.621997+02 2013-06-08 10:16:03.622073+02 f idle COMMIT
41169 dcache 17348 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45970 2013-06-05 12:13:21.6223+02   2013-06-08 10:16:03.621183+02 2013-06-08 10:16:03.621238+02 f idle COMMIT
41169 dcache 11442 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49842 2013-05-16 09:36:43.201494+02   2013-06-11 11:16:58.882859+02 2013-06-11 11:16:58.883322+02 f idle COMMIT
41169 dcache 21814 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45190 2013-06-06 19:23:24.899645+02   2013-06-11 11:18:50.319645+02 2013-06-11 11:18:50.320095+02 f idle COMMIT
41169 dcache 21815 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45191 2013-06-06 19:23:25.534968+02   2013-06-11 11:17:52.967714+02 2013-06-11 11:17:52.96818+02 f idle COMMIT
41169 dcache 21816 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45192 2013-06-06 19:23:25.538132+02   2013-06-11 11:18:02.318761+02 2013-06-11 11:18:02.318779+02 f idle COMMIT
41169 dcache 21817 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45193 2013-06-06 19:23:25.543113+02   2013-06-11 11:17:32.589035+02 2013-06-11 11:17:32.589688+02 f idle COMMIT
41169 dcache 21818 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45194 2013-06-06 19:23:25.546244+02   2013-06-11 11:15:52.258516+02 2013-06-11 11:15:52.258945+02 f idle COMMIT
41169 dcache 21819 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45195 2013-06-06 19:23:25.549151+02   2013-06-11 11:15:58.396801+02 2013-06-11 11:15:58.398424+02 f idle COMMIT
41169 dcache 27281 16396 srmdcache   192.33.123.24 t3se01.psi.ch 56351 2013-06-04 17:51:23.948798+02   2013-06-11 11:12:51.056037+02 2013-06-11 11:12:51.056479+02 f idle COMMIT
41169 dcache 13399 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42666 2013-06-05 08:27:19.492562+02   2013-06-05 16:16:26.761192+02 2013-06-05 16:16:26.762483+02 f idle COMMIT
41169 dcache 11560 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49930 2013-05-16 09:43:08.381737+02   2013-06-11 11:17:52.95855+02 2013-06-11 11:17:52.959+02 f idle COMMIT
41169 dcache 11573 16396 srmdcache   192.33.123.24 t3se01.psi.ch 49944 2013-05-16 09:44:43.421843+02   2013-06-11 11:17:52.951201+02 2013-06-11 11:17:52.952837+02 f idle COMMIT
41169 dcache 13398 16396 srmdcache   192.33.123.24 t3se01.psi.ch 42665 2013-06-05 08:27:19.486062+02   2013-06-11 11:18:30.48775+02 2013-06-11 11:18:30.495555+02 f idle SELECT id, gid, name, grouplist_id FROM AUTHGROUP WHERE (grouplist_id = $1) ORDER BY id ASC
41169 dcache 32581 16396 srmdcache   192.33.123.24 t3se01.psi.ch 33128 2013-06-11 10:59:59.763187+02     2013-06-11 10:59:59.765091+02 f idle  
41169 dcache 1058 16396 srmdcache   192.33.123.24 t3se01.psi.ch 48281 2013-05-21 16:08:56.493078+02   2013-06-11 11:18:32.601373+02 2013-06-11 11:18:32.611165+02 f idle COMMIT
41169 dcache 17347 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45969 2013-06-05 12:13:21.622592+02   2013-06-11 11:18:50.335727+02 2013-06-11 11:18:50.336164+02 f idle COMMIT
41169 dcache 17349 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45971 2013-06-05 12:13:24.251604+02   2013-06-11 11:18:50.293267+02 2013-06-11 11:18:50.294154+02 f idle COMMIT
41169 dcache 1059 16396 srmdcache   192.33.123.24 t3se01.psi.ch 48282 2013-05-21 16:08:56.497125+02   2013-06-11 11:17:59.230068+02 2013-06-11 11:17:59.230997+02 f idle COMMIT
41169 dcache 10382 16396 srmdcache   192.33.123.24 t3se01.psi.ch 54269 2013-06-08 10:16:03.652858+02   2013-06-11 11:18:50.332525+02 2013-06-11 11:18:50.33295+02 f idle COMMIT
41169 dcache 27283 16396 srmdcache   192.33.123.24 t3se01.psi.ch 56353 2013-06-04 17:51:24.10158+02   2013-06-11 11:12:59.88288+02 2013-06-11 11:12:59.883404+02 f idle COMMIT
41169 dcache 13538 16396 srmdcache   192.33.123.24 t3se01.psi.ch 51551 2013-05-16 11:32:14.160376+02   2013-06-11 11:18:01.22869+02 2013-06-11 11:18:01.229197+02 f idle COMMIT
41169 dcache 19466 16396 srmdcache   192.33.123.24 t3se01.psi.ch 47354 2013-06-05 13:45:45.617452+02   2013-06-08 10:16:03.759902+02 2013-06-08 10:16:03.760605+02 f idle COMMIT
41169 dcache 10387 16396 srmdcache   192.33.123.24 t3se01.psi.ch 54270 2013-06-08 10:16:03.749646+02   2013-06-08 10:16:04.117826+02 2013-06-08 10:16:04.118312+02 f idle COMMIT
41169 dcache 1060 16396 srmdcache   192.33.123.24 t3se01.psi.ch 48283 2013-05-21 16:08:56.501306+02   2013-06-11 11:18:32.670099+02 2013-06-11 11:18:32.670707+02 f idle COMMIT
41169 dcache 421 16396 srmdcache   192.33.123.24 t3se01.psi.ch 33363 2013-06-11 11:15:52.895648+02     2013-06-11 11:15:52.897679+02 f idle  
41169 dcache 32582 16396 srmdcache   192.33.123.24 t3se01.psi.ch 33129 2013-06-11 10:59:59.766215+02     2013-06-11 10:59:59.768125+02 f idle  
41169 dcache 17340 16396 srmdcache   192.33.123.24 t3se01.psi.ch 45955 2013-06-05 12:11:21.474606+02   2013-06-08 10:16:03.747647+02 2013-06-08 10:16:03.748215+02 f idle COMMIT
12870 postgres 456 10 postgres psql     -1 2013-06-11 11:18:50.401724+02 2013-06-11 11:18:50.406322+02 2013-06-11 11:18:50.406322+02 2013-06-11 11:18:50.406326+02 f active SELECT * FROM pg_stat_activity order by datname;

(274 rows)