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)