|
1
|
Output format is unaligned.
|
|
2
|
QUERY PLAN
|
|
3
|
Limit (cost=161.67..161.69 rows=11 width=277)
|
|
4
|
-> Sort (cost=161.67..161.69 rows=11 width=277)
|
|
5
|
Sort Key: groups.modified_at DESC
|
|
6
|
-> Bitmap Heap Scan on groups (cost=40.96..161.48 rows=11 width=277)
|
|
7
|
Recheck Cond: ((group_class)::text = ANY ('{project,filter}'::text[]))
|
|
8
|
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)))
|
|
9
|
-> Bitmap Index Scan on index_groups_on_group_class (cost=0.00..8.52 rows=32 width=0)
|
|
10
|
Index Cond: ((group_class)::text = ANY ('{project,filter}'::text[]))
|
|
11
|
SubPlan 1
|
|
12
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
13
|
Filter: (trash_at <= statement_timestamp())
|
|
14
|
SubPlan 2
|
|
15
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
16
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
17
|
SubPlan 4
|
|
18
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
19
|
Filter: ((group_class)::text <> 'project'::text)
|
|
20
|
(17 rows)
|
|
21
|
QUERY PLAN
|
|
22
|
Limit (cost=0.15..8.17 rows=1 width=4)
|
|
23
|
-> Index Only Scan using index_frozen_groups_on_uuid on frozen_groups (cost=0.15..8.17 rows=1 width=4)
|
|
24
|
Index Cond: (uuid = 'zzzzz-tpzed-000000000000000'::text)
|
|
25
|
(3 rows)
|
|
26
|
QUERY PLAN
|
|
27
|
Seq Scan on links (cost=0.00..6.05 rows=1 width=241)
|
|
28
|
Filter: (((head_uuid)::text = 'zzzzz-j7d0g-publicfavorites'::text) AND ((link_class)::text = 'permission'::text))
|
|
29
|
(2 rows)
|
|
30
|
QUERY PLAN
|
|
31
|
Limit (cost=0.15..6.25 rows=1 width=4)
|
|
32
|
-> Index Only Scan using index_frozen_groups_on_uuid on frozen_groups (cost=0.15..12.34 rows=2 width=4)
|
|
33
|
Index Cond: (uuid = ANY ('{zzzzz-j7d0g-publicfavorites,zzzzz-tpzed-000000000000000}'::text[]))
|
|
34
|
(3 rows)
|
|
35
|
QUERY PLAN
|
|
36
|
Aggregate (cost=161.50..161.51 rows=1 width=8)
|
|
37
|
-> Bitmap Heap Scan on groups (cost=40.96..161.48 rows=11 width=0)
|
|
38
|
Recheck Cond: ((group_class)::text = ANY ('{project,filter}'::text[]))
|
|
39
|
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)))
|
|
40
|
-> Bitmap Index Scan on index_groups_on_group_class (cost=0.00..8.52 rows=32 width=0)
|
|
41
|
Index Cond: ((group_class)::text = ANY ('{project,filter}'::text[]))
|
|
42
|
SubPlan 1
|
|
43
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
44
|
Filter: (trash_at <= statement_timestamp())
|
|
45
|
SubPlan 2
|
|
46
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
47
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
48
|
SubPlan 4
|
|
49
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
50
|
Filter: ((group_class)::text <> 'project'::text)
|
|
51
|
(15 rows)
|
|
52
|
QUERY PLAN
|
|
53
|
Limit (cost=354.21..354.29 rows=30 width=12)
|
|
54
|
-> Sort (cost=354.21..354.29 rows=30 width=12)
|
|
55
|
Sort Key: container_requests.modified_at DESC
|
|
56
|
-> Bitmap Heap Scan on container_requests (cost=41.20..353.47 rows=30 width=12)
|
|
57
|
Recheck Cond: (requesting_container_uuid IS NULL)
|
|
58
|
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)))
|
|
59
|
-> Bitmap Index Scan on index_container_requests_on_requesting_container_uuid (cost=0.00..8.77 rows=83 width=0)
|
|
60
|
Index Cond: (requesting_container_uuid IS NULL)
|
|
61
|
SubPlan 1
|
|
62
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
63
|
Filter: (trash_at <= statement_timestamp())
|
|
64
|
SubPlan 2
|
|
65
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
66
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
67
|
SubPlan 4
|
|
68
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
69
|
Filter: ((group_class)::text <> 'project'::text)
|
|
70
|
(17 rows)
|
|
71
|
QUERY PLAN
|
|
72
|
Limit (cost=354.14..354.21 rows=30 width=1239)
|
|
73
|
-> Sort (cost=354.14..354.21 rows=30 width=1239)
|
|
74
|
Sort Key: container_requests.modified_at DESC
|
|
75
|
-> Bitmap Heap Scan on container_requests (cost=41.20..353.40 rows=30 width=1239)
|
|
76
|
Recheck Cond: (requesting_container_uuid IS NULL)
|
|
77
|
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)))
|
|
78
|
-> Bitmap Index Scan on index_container_requests_on_requesting_container_uuid (cost=0.00..8.77 rows=83 width=0)
|
|
79
|
Index Cond: (requesting_container_uuid IS NULL)
|
|
80
|
SubPlan 1
|
|
81
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
82
|
Filter: (trash_at <= statement_timestamp())
|
|
83
|
SubPlan 2
|
|
84
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
85
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
86
|
SubPlan 4
|
|
87
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
88
|
Filter: ((group_class)::text <> 'project'::text)
|
|
89
|
(17 rows)
|
|
90
|
QUERY PLAN
|
|
91
|
Aggregate (cost=353.66..353.67 rows=1 width=8)
|
|
92
|
-> Index Only Scan using container_requests_search_index on container_requests (cost=32.70..353.58 rows=30 width=0)
|
|
93
|
Index Cond: (requesting_container_uuid IS NULL)
|
|
94
|
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)))
|
|
95
|
SubPlan 1
|
|
96
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
97
|
Filter: (trash_at <= statement_timestamp())
|
|
98
|
SubPlan 2
|
|
99
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
100
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
101
|
SubPlan 4
|
|
102
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
103
|
Filter: ((group_class)::text <> 'project'::text)
|
|
104
|
(13 rows)
|
|
105
|
QUERY PLAN
|
|
106
|
Limit (cost=152.53..152.55 rows=11 width=528)
|
|
107
|
-> Sort (cost=152.53..152.55 rows=11 width=528)
|
|
108
|
Sort Key: workflows.modified_at DESC, workflows.uuid DESC
|
|
109
|
-> Seq Scan on workflows (cost=32.43..152.33 rows=11 width=528)
|
|
110
|
Filter: ((NOT (hashed SubPlan 1)) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
111
|
SubPlan 1
|
|
112
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
113
|
Filter: (trash_at <= statement_timestamp())
|
|
114
|
SubPlan 2
|
|
115
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
116
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
117
|
SubPlan 4
|
|
118
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
119
|
Filter: ((group_class)::text <> 'project'::text)
|
|
120
|
(14 rows)
|
|
121
|
QUERY PLAN
|
|
122
|
Limit (cost=152.50..152.53 rows=11 width=2676)
|
|
123
|
-> Sort (cost=152.50..152.53 rows=11 width=2676)
|
|
124
|
Sort Key: workflows.modified_at DESC, workflows.uuid DESC
|
|
125
|
-> Seq Scan on workflows (cost=32.43..152.31 rows=11 width=2676)
|
|
126
|
Filter: ((NOT (hashed SubPlan 1)) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
127
|
SubPlan 1
|
|
128
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
129
|
Filter: (trash_at <= statement_timestamp())
|
|
130
|
SubPlan 2
|
|
131
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
132
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
133
|
SubPlan 4
|
|
134
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
135
|
Filter: ((group_class)::text <> 'project'::text)
|
|
136
|
(14 rows)
|
|
137
|
QUERY PLAN
|
|
138
|
Aggregate (cost=152.33..152.34 rows=1 width=8)
|
|
139
|
-> Seq Scan on workflows (cost=32.43..152.31 rows=11 width=0)
|
|
140
|
Filter: ((NOT (hashed SubPlan 1)) AND (((uuid)::text <> 'jutro-j7d0g-publicfavorites'::text) OR (uuid IS NULL)) AND ((hashed SubPlan 2) OR (hashed SubPlan 4)))
|
|
141
|
SubPlan 1
|
|
142
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
143
|
Filter: (trash_at <= statement_timestamp())
|
|
144
|
SubPlan 2
|
|
145
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
146
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
147
|
SubPlan 4
|
|
148
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
149
|
Filter: ((group_class)::text <> 'project'::text)
|
|
150
|
(12 rows)
|
|
151
|
QUERY PLAN
|
|
152
|
Limit (cost=1146.72..1146.73 rows=1 width=367)
|
|
153
|
-> Sort (cost=1146.72..1146.73 rows=1 width=367)
|
|
154
|
Sort Key: collections.modified_at DESC
|
|
155
|
-> Seq Scan on collections (cost=32.43..1146.71 rows=1 width=367)
|
|
156
|
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)))
|
|
157
|
SubPlan 1
|
|
158
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
159
|
Filter: (trash_at <= statement_timestamp())
|
|
160
|
SubPlan 2
|
|
161
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
162
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
163
|
SubPlan 4
|
|
164
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
165
|
Filter: ((group_class)::text <> 'project'::text)
|
|
166
|
(14 rows)
|
|
167
|
QUERY PLAN
|
|
168
|
Aggregate (cost=1146.71..1146.72 rows=1 width=8)
|
|
169
|
-> Seq Scan on collections (cost=32.43..1146.71 rows=1 width=0)
|
|
170
|
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)))
|
|
171
|
SubPlan 1
|
|
172
|
-> Seq Scan on trashed_groups (cost=0.00..28.00 rows=400 width=32)
|
|
173
|
Filter: (trash_at <= statement_timestamp())
|
|
174
|
SubPlan 2
|
|
175
|
-> Seq Scan on users (cost=0.00..3.36 rows=28 width=28)
|
|
176
|
Filter: ((uuid)::text <> 'zzzzz-tpzed-d9tiejq69daie8f'::text)
|
|
177
|
SubPlan 4
|
|
178
|
-> Seq Scan on groups gp (cost=0.00..3.54 rows=16 width=32)
|
|
179
|
Filter: ((group_class)::text <> 'project'::text)
|
|
180
|
(12 rows)
|