Project

General

Profile

Defect #37268 » explain_without_visible_condition.csv

Marius BĂLTEANU, 2022-06-27 20:52

 
1
"QUERY PLAN"
2
"[
3
  {
4
    ""Plan"": {
5
      ""Node Type"": ""Sort"",
6
      ""Parallel Aware"": false,
7
      ""Async Capable"": false,
8
      ""Actual Rows"": 0,
9
      ""Actual Loops"": 1,
10
      ""Sort Key"": [""issues.id""],
11
      ""Sort Method"": ""quicksort"",
12
      ""Sort Space Used"": 25,
13
      ""Sort Space Type"": ""Memory"",
14
      ""Plans"": [
15
        {
16
          ""Node Type"": ""Seq Scan"",
17
          ""Parent Relationship"": ""InitPlan"",
18
          ""Subplan Name"": ""InitPlan 1 (returns $0)"",
19
          ""Parallel Aware"": false,
20
          ""Async Capable"": false,
21
          ""Relation Name"": ""custom_fields"",
22
          ""Alias"": ""ifa"",
23
          ""Actual Rows"": 0,
24
          ""Actual Loops"": 0,
25
          ""Filter"": ""(is_for_all AND (id = 13))"",
26
          ""Rows Removed by Filter"": 0
27
        },
28
        {
29
          ""Node Type"": ""Nested Loop"",
30
          ""Parent Relationship"": ""Outer"",
31
          ""Parallel Aware"": false,
32
          ""Async Capable"": false,
33
          ""Join Type"": ""Semi"",
34
          ""Actual Rows"": 0,
35
          ""Actual Loops"": 1,
36
          ""Inner Unique"": false,
37
          ""Join Filter"": ""(projects.id = em.project_id)"",
38
          ""Rows Removed by Join Filter"": 0,
39
          ""Plans"": [
40
            {
41
              ""Node Type"": ""Nested Loop"",
42
              ""Parent Relationship"": ""Outer"",
43
              ""Parallel Aware"": false,
44
              ""Async Capable"": false,
45
              ""Join Type"": ""Inner"",
46
              ""Actual Rows"": 0,
47
              ""Actual Loops"": 1,
48
              ""Inner Unique"": true,
49
              ""Plans"": [
50
                {
51
                  ""Node Type"": ""Nested Loop"",
52
                  ""Parent Relationship"": ""Outer"",
53
                  ""Parallel Aware"": false,
54
                  ""Async Capable"": false,
55
                  ""Join Type"": ""Inner"",
56
                  ""Actual Rows"": 0,
57
                  ""Actual Loops"": 1,
58
                  ""Inner Unique"": true,
59
                  ""Plans"": [
60
                    {
61
                      ""Node Type"": ""Merge Join"",
62
                      ""Parent Relationship"": ""Outer"",
63
                      ""Parallel Aware"": false,
64
                      ""Async Capable"": false,
65
                      ""Join Type"": ""Inner"",
66
                      ""Actual Rows"": 0,
67
                      ""Actual Loops"": 1,
68
                      ""Inner Unique"": true,
69
                      ""Merge Cond"": ""(issues.status_id = issue_statuses_1.id)"",
70
                      ""Plans"": [
71
                        {
72
                          ""Node Type"": ""Sort"",
73
                          ""Parent Relationship"": ""Outer"",
74
                          ""Parallel Aware"": false,
75
                          ""Async Capable"": false,
76
                          ""Actual Rows"": 0,
77
                          ""Actual Loops"": 1,
78
                          ""Sort Key"": [""issues.status_id""],
79
                          ""Sort Method"": ""quicksort"",
80
                          ""Sort Space Used"": 25,
81
                          ""Sort Space Type"": ""Memory"",
82
                          ""Plans"": [
83
                            {
84
                              ""Node Type"": ""Nested Loop"",
85
                              ""Parent Relationship"": ""Outer"",
86
                              ""Parallel Aware"": false,
87
                              ""Async Capable"": false,
88
                              ""Join Type"": ""Inner"",
89
                              ""Actual Rows"": 0,
90
                              ""Actual Loops"": 1,
91
                              ""Inner Unique"": true,
92
                              ""Join Filter"": ""(issues.id = custom_values.customized_id)"",
93
                              ""Rows Removed by Join Filter"": 0,
94
                              ""Plans"": [
95
                                {
96
                                  ""Node Type"": ""Aggregate"",
97
                                  ""Strategy"": ""Hashed"",
98
                                  ""Partial Mode"": ""Simple"",
99
                                  ""Parent Relationship"": ""Outer"",
100
                                  ""Parallel Aware"": false,
101
                                  ""Async Capable"": false,
102
                                  ""Actual Rows"": 0,
103
                                  ""Actual Loops"": 1,
104
                                  ""Group Key"": [""issues_1.id""],
105
                                  ""HashAgg Batches"": 1,
106
                                  ""Peak Memory Usage"": 24,
107
                                  ""Disk Usage"": 0,
108
                                  ""Plans"": [
109
                                    {
110
                                      ""Node Type"": ""Nested Loop"",
111
                                      ""Parent Relationship"": ""Outer"",
112
                                      ""Parallel Aware"": false,
113
                                      ""Async Capable"": false,
114
                                      ""Join Type"": ""Inner"",
115
                                      ""Actual Rows"": 0,
116
                                      ""Actual Loops"": 1,
117
                                      ""Inner Unique"": true,
118
                                      ""Plans"": [
119
                                        {
120
                                          ""Node Type"": ""Nested Loop"",
121
                                          ""Parent Relationship"": ""Outer"",
122
                                          ""Parallel Aware"": false,
123
                                          ""Async Capable"": false,
124
                                          ""Join Type"": ""Inner"",
125
                                          ""Actual Rows"": 0,
126
                                          ""Actual Loops"": 1,
127
                                          ""Inner Unique"": true,
128
                                          ""Plans"": [
129
                                            {
130
                                              ""Node Type"": ""Bitmap Heap Scan"",
131
                                              ""Parent Relationship"": ""Outer"",
132
                                              ""Parallel Aware"": false,
133
                                              ""Async Capable"": false,
134
                                              ""Relation Name"": ""custom_values"",
135
                                              ""Alias"": ""custom_values"",
136
                                              ""Actual Rows"": 0,
137
                                              ""Actual Loops"": 1,
138
                                              ""Recheck Cond"": ""(custom_field_id = 13)"",
139
                                              ""Rows Removed by Index Recheck"": 0,
140
                                              ""Filter"": ""((value ~~* '%text%'::text) AND ((customized_type)::text = 'Issue'::text))"",
141
                                              ""Rows Removed by Filter"": 5001,
142
                                              ""Exact Heap Blocks"": 1764,
143
                                              ""Lossy Heap Blocks"": 0,
144
                                              ""Plans"": [
145
                                                {
146
                                                  ""Node Type"": ""Bitmap Index Scan"",
147
                                                  ""Parent Relationship"": ""Outer"",
148
                                                  ""Parallel Aware"": false,
149
                                                  ""Async Capable"": false,
150
                                                  ""Index Name"": ""index_custom_values_on_custom_field_id"",
151
                                                  ""Actual Rows"": 5001,
152
                                                  ""Actual Loops"": 1,
153
                                                  ""Index Cond"": ""(custom_field_id = 13)""
154
                                                }
155
                                              ]
156
                                            },
157
                                            {
158
                                              ""Node Type"": ""Index Scan"",
159
                                              ""Parent Relationship"": ""Inner"",
160
                                              ""Parallel Aware"": false,
161
                                              ""Async Capable"": false,
162
                                              ""Scan Direction"": ""Forward"",
163
                                              ""Index Name"": ""issues_pkey"",
164
                                              ""Relation Name"": ""issues"",
165
                                              ""Alias"": ""issues_1"",
166
                                              ""Actual Rows"": 0,
167
                                              ""Actual Loops"": 0,
168
                                              ""Index Cond"": ""(id = custom_values.customized_id)"",
169
                                              ""Rows Removed by Index Recheck"": 0,
170
                                              ""Filter"": ""($0 OR (hashed SubPlan 2))"",
171
                                              ""Rows Removed by Filter"": 0,
172
                                              ""Plans"": [
173
                                                {
174
                                                  ""Node Type"": ""Bitmap Heap Scan"",
175
                                                  ""Parent Relationship"": ""SubPlan"",
176
                                                  ""Subplan Name"": ""SubPlan 2"",
177
                                                  ""Parallel Aware"": false,
178
                                                  ""Async Capable"": false,
179
                                                  ""Relation Name"": ""custom_fields_projects"",
180
                                                  ""Alias"": ""custom_fields_projects"",
181
                                                  ""Actual Rows"": 0,
182
                                                  ""Actual Loops"": 0,
183
                                                  ""Recheck Cond"": ""(custom_field_id = 13)"",
184
                                                  ""Rows Removed by Index Recheck"": 0,
185
                                                  ""Exact Heap Blocks"": 0,
186
                                                  ""Lossy Heap Blocks"": 0,
187
                                                  ""Plans"": [
188
                                                    {
189
                                                      ""Node Type"": ""Bitmap Index Scan"",
190
                                                      ""Parent Relationship"": ""Outer"",
191
                                                      ""Parallel Aware"": false,
192
                                                      ""Async Capable"": false,
193
                                                      ""Index Name"": ""index_custom_fields_projects_on_custom_field_id_and_project_id"",
194
                                                      ""Actual Rows"": 0,
195
                                                      ""Actual Loops"": 0,
196
                                                      ""Index Cond"": ""(custom_field_id = 13)""
197
                                                    }
198
                                                  ]
199
                                                }
200
                                              ]
201
                                            }
202
                                          ]
203
                                        },
204
                                        {
205
                                          ""Node Type"": ""Index Only Scan"",
206
                                          ""Parent Relationship"": ""Inner"",
207
                                          ""Parallel Aware"": false,
208
                                          ""Async Capable"": false,
209
                                          ""Scan Direction"": ""Forward"",
210
                                          ""Index Name"": ""index_custom_fields_trackers_on_custom_field_id_and_tracker_id"",
211
                                          ""Relation Name"": ""custom_fields_trackers"",
212
                                          ""Alias"": ""custom_fields_trackers"",
213
                                          ""Actual Rows"": 0,
214
                                          ""Actual Loops"": 0,
215
                                          ""Index Cond"": ""((custom_field_id = 13) AND (tracker_id = issues_1.tracker_id))"",
216
                                          ""Rows Removed by Index Recheck"": 0,
217
                                          ""Heap Fetches"": 0
218
                                        }
219
                                      ]
220
                                    }
221
                                  ]
222
                                },
223
                                {
224
                                  ""Node Type"": ""Index Scan"",
225
                                  ""Parent Relationship"": ""Inner"",
226
                                  ""Parallel Aware"": false,
227
                                  ""Async Capable"": false,
228
                                  ""Scan Direction"": ""Forward"",
229
                                  ""Index Name"": ""issues_pkey"",
230
                                  ""Relation Name"": ""issues"",
231
                                  ""Alias"": ""issues"",
232
                                  ""Actual Rows"": 0,
233
                                  ""Actual Loops"": 0,
234
                                  ""Index Cond"": ""(id = issues_1.id)"",
235
                                  ""Rows Removed by Index Recheck"": 0
236
                                }
237
                              ]
238
                            }
239
                          ]
240
                        },
241
                        {
242
                          ""Node Type"": ""Sort"",
243
                          ""Parent Relationship"": ""Inner"",
244
                          ""Parallel Aware"": false,
245
                          ""Async Capable"": false,
246
                          ""Actual Rows"": 0,
247
                          ""Actual Loops"": 0,
248
                          ""Sort Key"": [""issue_statuses_1.id""],
249
                          ""Plans"": [
250
                            {
251
                              ""Node Type"": ""Seq Scan"",
252
                              ""Parent Relationship"": ""Outer"",
253
                              ""Parallel Aware"": false,
254
                              ""Async Capable"": false,
255
                              ""Relation Name"": ""issue_statuses"",
256
                              ""Alias"": ""issue_statuses_1"",
257
                              ""Actual Rows"": 0,
258
                              ""Actual Loops"": 0,
259
                              ""Filter"": ""(NOT is_closed)"",
260
                              ""Rows Removed by Filter"": 0
261
                            }
262
                          ]
263
                        }
264
                      ]
265
                    },
266
                    {
267
                      ""Node Type"": ""Index Scan"",
268
                      ""Parent Relationship"": ""Inner"",
269
                      ""Parallel Aware"": false,
270
                      ""Async Capable"": false,
271
                      ""Scan Direction"": ""Forward"",
272
                      ""Index Name"": ""projects_pkey"",
273
                      ""Relation Name"": ""projects"",
274
                      ""Alias"": ""projects"",
275
                      ""Actual Rows"": 0,
276
                      ""Actual Loops"": 0,
277
                      ""Index Cond"": ""(id = issues.project_id)"",
278
                      ""Rows Removed by Index Recheck"": 0,
279
                      ""Filter"": ""((status <> 9) AND (status <> 10))"",
280
                      ""Rows Removed by Filter"": 0
281
                    }
282
                  ]
283
                },
284
                {
285
                  ""Node Type"": ""Index Scan"",
286
                  ""Parent Relationship"": ""Inner"",
287
                  ""Parallel Aware"": false,
288
                  ""Async Capable"": false,
289
                  ""Scan Direction"": ""Forward"",
290
                  ""Index Name"": ""issue_statuses_pkey"",
291
                  ""Relation Name"": ""issue_statuses"",
292
                  ""Alias"": ""issue_statuses"",
293
                  ""Actual Rows"": 0,
294
                  ""Actual Loops"": 0,
295
                  ""Index Cond"": ""(id = issues.status_id)"",
296
                  ""Rows Removed by Index Recheck"": 0
297
                }
298
              ]
299
            },
300
            {
301
              ""Node Type"": ""Index Scan"",
302
              ""Parent Relationship"": ""Inner"",
303
              ""Parallel Aware"": false,
304
              ""Async Capable"": false,
305
              ""Scan Direction"": ""Forward"",
306
              ""Index Name"": ""enabled_modules_project_id"",
307
              ""Relation Name"": ""enabled_modules"",
308
              ""Alias"": ""em"",
309
              ""Actual Rows"": 0,
310
              ""Actual Loops"": 0,
311
              ""Index Cond"": ""(project_id = issues.project_id)"",
312
              ""Rows Removed by Index Recheck"": 0,
313
              ""Filter"": ""((name)::text = 'issue_tracking'::text)"",
314
              ""Rows Removed by Filter"": 0
315
            }
316
          ]
317
        }
318
      ]
319
    },
320
    ""Triggers"": [
321
    ]
322
  }
323
]"
(8-8/10)