|
Output format is unaligned.
|
|
QUERY PLAN
|
|
Limit (cost=161.67..161.69 rows=11 width=277)
|
|
-> Sort (cost=161.67..161.69 rows=11 width=277)
|
|
Sort Key: groups.modified_at DESC
|
|
-> Bitmap Heap Scan on groups (cost=40.96..161.48 rows=11 width=277)
|
|
Recheck Cond: ((group_class)::text = ANY ('{project,filter}'::text[]))
|
|
Filter: ((NOT (hashed SubPlan 1)) AND ((name)::text ~~* '%%'::text) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((trash_at <= statement_timestamp()) IS NOT TRUE) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
-> Bitmap Index Scan on index_groups_on_group_class (cost=0.00..8.52 rows=32 width=0)
|
|
Index Cond: ((group_class)::text = ANY ('{project,filter}'::text[]))
|
|
SubPlan 1
|
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
Filter: (trash_at <= statement_timestamp())
|
|
SubPlan 2
|
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
SubPlan 4
|
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
Filter: ((group_class)::text <> 'project'::text)
|
|
(17 rows)
|
|
QUERY PLAN
|
|
Limit (cost=0.15..8.17 rows=1 width=4)
|
|
-> Index Only Scan using index_frozen_groups_on_uuid on frozen_groups (cost=0.15..8.17 rows=1 width=4)
|
|
Index Cond: (uuid = 'zzzzz-tpzed-000000000000000'::text)
|
|
(3 rows)
|
|
QUERY PLAN
|
|
Seq Scan on links (cost=0.00..6.05 rows=1 width=241)
|
|
Filter: (((head_uuid)::text = 'zzzzz-j7d0g-publicfavorites'::text) AND ((link_class)::text = 'permission'::text))
|
|
(2 rows)
|
|
QUERY PLAN
|
|
Limit (cost=0.15..6.25 rows=1 width=4)
|
|
-> Index Only Scan using index_frozen_groups_on_uuid on frozen_groups (cost=0.15..12.34 rows=2 width=4)
|
|
Index Cond: (uuid = ANY ('{zzzzz-j7d0g-publicfavorites,zzzzz-tpzed-000000000000000}'::text[]))
|
|
(3 rows)
|
|
QUERY PLAN
|
|
Aggregate (cost=161.50..161.51 rows=1 width=8)
|
|
-> Bitmap Heap Scan on groups (cost=40.96..161.48 rows=11 width=0)
|
|
Recheck Cond: ((group_class)::text = ANY ('{project,filter}'::text[]))
|
|
Filter: ((NOT (hashed SubPlan 1)) AND ((name)::text ~~* '%%'::text) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((trash_at <= statement_timestamp()) IS NOT TRUE) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
-> Bitmap Index Scan on index_groups_on_group_class (cost=0.00..8.52 rows=32 width=0)
|
|
Index Cond: ((group_class)::text = ANY ('{project,filter}'::text[]))
|
|
SubPlan 1
|
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
Filter: (trash_at <= statement_timestamp())
|
|
SubPlan 2
|
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
SubPlan 4
|
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
Filter: ((group_class)::text <> 'project'::text)
|
|
(15 rows)
|
|
QUERY PLAN
|
|
Limit (cost=354.21..354.29 rows=30 width=12)
|
|
-> Sort (cost=354.21..354.29 rows=30 width=12)
|
|
Sort Key: container_requests.modified_at DESC
|
|
-> Bitmap Heap Scan on container_requests (cost=41.20..353.47 rows=30 width=12)
|
|
Recheck Cond: (requesting_container_uuid IS NULL)
|
|
Filter: ((NOT (hashed SubPlan 1)) AND ((name)::text ~~* '%%'::text) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
-> Bitmap Index Scan on index_container_requests_on_requesting_container_uuid (cost=0.00..8.77 rows=83 width=0)
|
|
Index Cond: (requesting_container_uuid IS NULL)
|
|
SubPlan 1
|
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
Filter: (trash_at <= statement_timestamp())
|
|
SubPlan 2
|
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
SubPlan 4
|
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
Filter: ((group_class)::text <> 'project'::text)
|
|
(17 rows)
|
|
QUERY PLAN
|
|
Limit (cost=354.14..354.21 rows=30 width=1239)
|
|
-> Sort (cost=354.14..354.21 rows=30 width=1239)
|
|
Sort Key: container_requests.modified_at DESC
|
|
-> Bitmap Heap Scan on container_requests (cost=41.20..353.40 rows=30 width=1239)
|
|
Recheck Cond: (requesting_container_uuid IS NULL)
|
|
Filter: ((NOT (hashed SubPlan 1)) AND ((name)::text ~~* '%%'::text) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
-> Bitmap Index Scan on index_container_requests_on_requesting_container_uuid (cost=0.00..8.77 rows=83 width=0)
|
|
Index Cond: (requesting_container_uuid IS NULL)
|
|
SubPlan 1
|
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
Filter: (trash_at <= statement_timestamp())
|
|
SubPlan 2
|
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
SubPlan 4
|
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
Filter: ((group_class)::text <> 'project'::text)
|
|
(17 rows)
|
|
QUERY PLAN
|
|
Aggregate (cost=353.66..353.67 rows=1 width=8)
|
|
-> Index Only Scan using container_requests_search_index on container_requests (cost=32.70..353.58 rows=30 width=0)
|
|
Index Cond: (requesting_container_uuid IS NULL)
|
|
Filter: ((NOT (hashed SubPlan 1)) AND ((name)::text ~~* '%%'::text) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
SubPlan 1
|
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
Filter: (trash_at <= statement_timestamp())
|
|
SubPlan 2
|
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
SubPlan 4
|
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
Filter: ((group_class)::text <> 'project'::text)
|
|
(13 rows)
|
|
QUERY PLAN
|
|
Limit (cost=152.53..152.55 rows=11 width=528)
|
|
-> Sort (cost=152.53..152.55 rows=11 width=528)
|
|
Sort Key: workflows.modified_at DESC, workflows.uuid DESC
|
|
-> Seq Scan on workflows (cost=32.43..152.33 rows=11 width=528)
|
|
Filter: ((NOT (hashed SubPlan 1)) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
SubPlan 1
|
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
Filter: (trash_at <= statement_timestamp())
|
|
SubPlan 2
|
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
SubPlan 4
|
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
Filter: ((group_class)::text <> 'project'::text)
|
|
(14 rows)
|
|
QUERY PLAN
|
|
Limit (cost=152.50..152.53 rows=11 width=2676)
|
|
-> Sort (cost=152.50..152.53 rows=11 width=2676)
|
|
Sort Key: workflows.modified_at DESC, workflows.uuid DESC
|
|
-> Seq Scan on workflows (cost=32.43..152.31 rows=11 width=2676)
|
|
Filter: ((NOT (hashed SubPlan 1)) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
SubPlan 1
|
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
Filter: (trash_at <= statement_timestamp())
|
|
SubPlan 2
|
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
SubPlan 4
|
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
Filter: ((group_class)::text <> 'project'::text)
|
|
(14 rows)
|
|
QUERY PLAN
|
|
Aggregate (cost=152.33..152.34 rows=1 width=8)
|
|
-> Seq Scan on workflows (cost=32.43..152.31 rows=11 width=0)
|
|
Filter: ((NOT (hashed SubPlan 1)) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
SubPlan 1
|
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
Filter: (trash_at <= statement_timestamp())
|
|
SubPlan 2
|
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
SubPlan 4
|
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
Filter: ((group_class)::text <> 'project'::text)
|
|
(12 rows)
|
|
QUERY PLAN
|
|
Limit (cost=1146.72..1146.73 rows=1 width=367)
|
|
-> Sort (cost=1146.72..1146.73 rows=1 width=367)
|
|
Sort Key: collections.modified_at DESC
|
|
-> Seq Scan on collections (cost=32.43..1146.71 rows=1 width=367)
|
|
Filter: ((NOT (hashed SubPlan 1)) AND ((name)::text ~~* '%%'::text) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((uuid)::text = (current_version_uuid)::text) AND ((trash_at <= statement_timestamp()) IS NOT TRUE) AND (((properties ->> 'type'::text) <> ALL ('{log,intermediate}'::text[])) OR ((properties ->> 'type'::text) IS NULL)) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
SubPlan 1
|
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
Filter: (trash_at <= statement_timestamp())
|
|
SubPlan 2
|
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
SubPlan 4
|
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
Filter: ((group_class)::text <> 'project'::text)
|
|
(14 rows)
|
|
QUERY PLAN
|
|
Aggregate (cost=1146.71..1146.72 rows=1 width=8)
|
|
-> Seq Scan on collections (cost=32.43..1146.71 rows=1 width=0)
|
|
Filter: ((NOT (hashed SubPlan 1)) AND ((name)::text ~~* '%%'::text) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((uuid)::text = (current_version_uuid)::text) AND ((trash_at <= statement_timestamp()) IS NOT TRUE) AND (((properties ->> 'type'::text) <> ALL ('{log,intermediate}'::text[])) OR ((properties ->> 'type'::text) IS NULL)) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
SubPlan 1
|
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
Filter: (trash_at <= statement_timestamp())
|
|
SubPlan 2
|
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
SubPlan 4
|
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
Filter: ((group_class)::text <> 'project'::text)
|
|
(12 rows)
|