Arvados

[req-ppwd88zexdci21xzrvsh] Group Load (0.6ms) SELECT "groups".* FROM "groups" WHERE (NOT (((groups.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())) OR groups.trash_at <= statement_timestamp() IS TRUE))) AND (groups.uuid is NULL) ORDER BY "groups"."id" ASC LIMIT $1 OFFSET $2 [["LIMIT", 1], ["OFFSET", 0]]

[req-ppwd88zexdci21xzrvsh] Group Load (1.5ms) SELECT "groups".* FROM "groups" WHERE (NOT (((groups.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())) OR groups.trash_at <= statement_timestamp() IS TRUE))) AND "groups"."group_class" IN ($1, $2) AND (groups.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=groups.owner_uuid and gp.group_class != 'project')) AND ((1=1 OR 1=0 OR 1=0 OR 1=0) AND (groups.name ilike '%%') AND (groups.uuid <> 'jutro-j7d0g-publicfavorites' OR groups.uuid IS NULL)) ORDER BY groups.modified_at desc LIMIT $3 OFFSET $4 [["group_class", "project"], ["group_class", "filter"], ["LIMIT", 50], ["OFFSET", 0]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.4ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-000000000000000"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.5ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-publicfavorites"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.3ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-publicfavorites"], ["uuid", "zzzzz-tpzed-000000000000000"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.2ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-rew6elm53kancon"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-rew6elm53kancon"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.2ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-fusefiltertest1"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-fusefiltertest1"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.2ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-9otoxmrksam74q6"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-9otoxmrksam74q6"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.3ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-filtergroupthre"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-filtergroupthre"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.2ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-filtergroupfour"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-filtergroupfour"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.2ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-filtergroupfive"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-filtergroupfive"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.1ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-0010collections"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-0010collections"], ["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.3ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-0201collections"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.4ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-0201collections"], ["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.3ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-000010pipelines"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-000010pipelines"], ["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.2ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-nnncrspipelines"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-nnncrspipelines"], ["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.1ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-000025pipelines"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.1ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-000025pipelines"], ["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.1ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-0fusedrivertest"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.2ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-0000ownedbyfuse"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-0000ownedbyfuse"], ["uuid", "zzzzz-tpzed-0fusedrivertest"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.1ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-starredshared01"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-starredshared01"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.1ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-v955i6s2oi1cbso"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-v955i6s2oi1cbso"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.1ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-thisfiltergroup"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-thisfiltergroup"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.1ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-afiltergrouptwo"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-afiltergrouptwo"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.1ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-81hsbo6mk8nl05c"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.1ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-lsjm0ibr0ydwpzx"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-lsjm0ibr0ydwpzx"], ["uuid", "zzzzz-tpzed-81hsbo6mk8nl05c"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] CACHE FrozenGroup Exists? (0.0ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2 [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Link Load (0.3ms) SELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2 [["head_uuid", "zzzzz-j7d0g-subprojsamenam1"], ["link_class", "permission"]]

[req-ppwd88zexdci21xzrvsh] FrozenGroup Exists? (0.2ms) SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3 [["uuid", "zzzzz-j7d0g-subprojsamenam1"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]

[req-ppwd88zexdci21xzrvsh] Group Count (0.5ms) SELECT COUNT(*) FROM "groups" WHERE (NOT (((groups.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())) OR groups.trash_at <= statement_timestamp() IS TRUE))) AND "groups"."group_class" IN ($1, $2) AND (groups.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=groups.owner_uuid and gp.group_class != 'project')) AND ((1=1 OR 1=0 OR 1=0 OR 1=0) AND (groups.name ilike '%%') AND (groups.uuid <> 'jutro-j7d0g-publicfavorites' OR groups.uuid IS NULL)) [["group_class", "project"], ["group_class", "filter"]]

[req-ppwd88zexdci21xzrvsh] TRANSACTION (0.1ms) BEGIN

[req-ppwd88zexdci21xzrvsh] ContainerRequest Load (1.0ms) SELECT (octet_length(container_requests.mounts)) as read_length FROM "container_requests" WHERE (NOT ((container_requests.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (container_requests.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=container_requests.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=0 OR 1=1) AND (container_requests.requesting_container_uuid is null) AND (container_requests.name ilike '%%') AND (container_requests.uuid <> 'jutro-j7d0g-publicfavorites' OR container_requests.uuid IS NULL)) ORDER BY container_requests.modified_at desc LIMIT $1 OFFSET $2 [["LIMIT", 31], ["OFFSET", 0]]

[req-ppwd88zexdci21xzrvsh] ContainerRequest Load (0.9ms) SELECT "container_requests".* FROM "container_requests" WHERE (NOT ((container_requests.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (container_requests.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=container_requests.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=0 OR 1=1) AND (container_requests.requesting_container_uuid is null) AND (container_requests.name ilike '%%') AND (container_requests.uuid <> 'jutro-j7d0g-publicfavorites' OR container_requests.uuid IS NULL)) ORDER BY container_requests.modified_at desc LIMIT $1 OFFSET $2 [["LIMIT", 31], ["OFFSET", 0]]

[req-ppwd88zexdci21xzrvsh] TRANSACTION (0.3ms) COMMIT

[req-ppwd88zexdci21xzrvsh] ContainerRequest Count (0.9ms) SELECT COUNT(*) FROM "container_requests" WHERE (NOT ((container_requests.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (container_requests.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=container_requests.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=0 OR 1=1) AND (container_requests.requesting_container_uuid is null) AND (container_requests.name ilike '%%') AND (container_requests.uuid <> 'jutro-j7d0g-publicfavorites' OR container_requests.uuid IS NULL))

[req-ppwd88zexdci21xzrvsh] TRANSACTION (0.2ms) BEGIN

[req-ppwd88zexdci21xzrvsh] Workflow Load (0.4ms) SELECT (octet_length(workflows.definition)) as read_length FROM "workflows" WHERE (NOT ((workflows.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (workflows.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=workflows.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=1 OR 1=0) AND (workflows.uuid <> 'jutro-j7d0g-publicfavorites' OR workflows.uuid IS NULL)) ORDER BY workflows.modified_at desc, workflows.uuid desc LIMIT $1 OFFSET $2 [["LIMIT", 12], ["OFFSET", 0]]

[req-ppwd88zexdci21xzrvsh] Workflow Load (0.6ms) SELECT "workflows".* FROM "workflows" WHERE (NOT ((workflows.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (workflows.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=workflows.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=1 OR 1=0) AND (workflows.uuid <> 'jutro-j7d0g-publicfavorites' OR workflows.uuid IS NULL)) ORDER BY workflows.modified_at desc, workflows.uuid desc LIMIT $1 OFFSET $2 [["LIMIT", 12], ["OFFSET", 0]]

[req-ppwd88zexdci21xzrvsh] TRANSACTION (0.2ms) COMMIT

[req-ppwd88zexdci21xzrvsh] Workflow Count (0.5ms) SELECT COUNT(*) FROM "workflows" WHERE (NOT ((workflows.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (workflows.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=workflows.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=1 OR 1=0) AND (workflows.uuid <> 'jutro-j7d0g-publicfavorites' OR workflows.uuid IS NULL))

[req-ppwd88zexdci21xzrvsh] Collection Load (1.5ms) SELECT collections."uuid", collections."owner_uuid", collections."created_at", collections."modified_by_client_uuid", collections."modified_by_user_uuid", collections."modified_at", collections."name", collections."description", collections."properties", collections."portable_data_hash", collections."replication_desired", collections."replication_confirmed", collections."replication_confirmed_at", collections."storage_classes_desired", collections."storage_classes_confirmed", collections."storage_classes_confirmed_at", collections."delete_at", collections."trash_at", collections."is_trashed", collections."version", collections."current_version_uuid", collections."preserve_version", collections."file_count", collections."file_size_total" FROM "collections" WHERE (NOT (((collections.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())) OR collections.trash_at <= statement_timestamp() IS TRUE)) AND collections.uuid = collections.current_version_uuid) AND (collections.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=collections.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=1 OR 1=0 OR 1=0) AND (collections.properties->>'type' NOT IN ('log','intermediate') OR collections.properties->>'type' IS NULL) AND (collections.name ilike '%%') AND (collections.uuid <> 'jutro-j7d0g-publicfavorites' OR collections.uuid IS NULL)) ORDER BY collections.modified_at desc LIMIT $1 OFFSET $2 [["LIMIT", 9], ["OFFSET", 0]]

[req-ppwd88zexdci21xzrvsh] Collection Count (1.0ms) SELECT COUNT(*) FROM "collections" WHERE (NOT (((collections.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())) OR collections.trash_at <= statement_timestamp() IS TRUE)) AND collections.uuid = collections.current_version_uuid) AND (collections.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=collections.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=1 OR 1=0 OR 1=0) AND (collections.properties->>'type' NOT IN ('log','intermediate') OR collections.properties->>'type' IS NULL) AND (collections.name ilike '%%') AND (collections.uuid <> 'jutro-j7d0g-publicfavorites' OR collections.uuid IS NULL))

{"method":"GET","path":"/arvados/v1/groups/contents","format":"html","controller":"Arvados::V1::GroupsController","action":"contents","status":200,"allocations":68272,"duration":92.47,"view":0.55,"db":21.84,"ClusterID":"zzzzz","request_id":"req-ppwd88zexdci21xzrvsh","client_ipaddr":"127.0.0.1","client_auth":"zzzzz-gj3su-027z32aux8dg2s1","params":{"cluster_id":"","count":"","exclude_home_project":"true","filters":"[[\"uuid\",\"is_a\",[\"arvados#group\",\"arvados#collection\",\"arvados#workflow\",\"arvados#containerRequest\"]],[\"collections.properties.type\",\"not in\",[\"log\",\"intermediate\"]],[\"container_requests.requesting_container_uuid\",\"=\",null],[\"collections.name\",\"ilike\",\"%%\"],[\"container_requests.name\",\"ilike\",\"%%\"],[\"groups.name\",\"ilike\",\"%%\"],[\"uuid\",\"!=\",\"jutro-j7d0g-publicfavorites\"]]","limit":"50","offset":"0","order":"[\"collections.modified_at desc\",\"container_requests.modified_at desc\",\"groups.modified_at desc\",\"container_requests.created_at desc\"]"},"@timestamp":"2024-06-03T16:01:34.266552700Z","@version":"1","message":"[200] GET /arvados/v1/groups/contents (Arvados::V1::GroupsController#contents)"}