Arvados

\pset format unaligned

EXPLAIN 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 ('project', 'filter') 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 50 OFFSET 0;

EXPLAIN SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = 'zzzzz-tpzed-000000000000000' LIMIT 1;

EXPLAIN SELECT "links".* FROM "links" WHERE "links"."head_uuid" = 'zzzzz-j7d0g-publicfavorites' AND "links"."link_class" = 'permission';

EXPLAIN SELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ('zzzzz-j7d0g-publicfavorites', 'zzzzz-tpzed-000000000000000') LIMIT 1;

EXPLAIN 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 ('project', 'filter') 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));

EXPLAIN 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 31 OFFSET 0;

EXPLAIN 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 31 OFFSET 0;

EXPLAIN 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));

EXPLAIN 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 12 OFFSET 0;

EXPLAIN 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 12 OFFSET 0;

EXPLAIN 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));

EXPLAIN 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 9 OFFSET 0;

EXPLAIN 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));