쿼리 계획 및 실행 통계 조회

1
{
2
  explainVersion: '1',
3
  stages: [
4
    {
5
      '$_internalSearchMongotRemote': {
6
        mongotQuery: {
7
          text: {
8
            path: 'title',
9
            query: 'yark',
10
            fuzzy: { maxEdits: 1, maxExpansions: 100 }
11
          }
12
        },
13
        explain: {
14
          query: {
15
            type: 'BooleanQuery',
16
            args: {
17
              must: [],
18
              mustNot: [],
19
              should: [
20
                {
21
                  type: 'BoostQuery',
22
                  args: {
23
                    query: {
24
                      type: 'TermQuery',
25
                      args: { path: 'title', value: 'dark' },
26
                      stats: {
27
                        context: { millisElapsed: 0 },
28
                        match: { millisElapsed: 0 },
29
                        score: { millisElapsed: 0 }
30
                      }
31
                    },
32
                    boost: 0.75
33
                  },
34
                  stats: {
35
                    context: {
36
                      millisElapsed: 0.403983,
37
                      invocationCounts: {
38
                        createWeight: Long('1'),
39
                        createScorer: Long('18')
40
                      }
41
                    },
42
                    match: {
43
                      millisElapsed: 0.094254,
44
                      invocationCounts: { nextDoc: Long('89') }
45
                    },
46
                    score: {
47
                      millisElapsed: 0.077043,
48
                      invocationCounts: { score: Long('83') }
49
                    }
50
                  }
51
                },
52
                {
53
                  type: 'BoostQuery',
54
                  args: {
55
                    query: {
56
                      type: 'TermQuery',
57
                      args: { path: 'title', value: 'ark' },
58
                      stats: {
59
                        context: { millisElapsed: 0 },
60
                        match: { millisElapsed: 0 },
61
                        score: { millisElapsed: 0 }
62
                      }
63
                    },
64
                    boost: 0.6666666269302368
65
                  },
66
                  stats: {
67
                    context: {
68
                      millisElapsed: 0.248528,
69
                      invocationCounts: {
70
                        createWeight: Long('1'),
71
                        createScorer: Long('8')
72
                      }
73
                    },
74
                    match: {
75
                      millisElapsed: 0.067561,
76
                      invocationCounts: { nextDoc: Long('3') }
77
                    },
78
                    score: {
79
                      millisElapsed: 0.001649,
80
                      invocationCounts: { score: Long('2') }
81
                    }
82
                  }
83
                },
84
                {
85
                  type: 'BoostQuery',
86
                  args: {
87
                    query: {
88
                      type: 'TermQuery',
89
                      args: { path: 'title', value: 'mark' },
90
                      stats: {
91
                        context: { millisElapsed: 0 },
92
                        match: { millisElapsed: 0 },
93
                        score: { millisElapsed: 0 }
94
                      }
95
                    },
96
                    boost: 0.75
97
                  },
98
                  stats: {
99
                    context: {
100
                      millisElapsed: 0.337083,
101
                      invocationCounts: {
102
                        createWeight: Long('1'),
103
                        createScorer: Long('12')
104
                      }
105
                    },
106
                    match: {
107
                      millisElapsed: 0.006489,
108
                      invocationCounts: { nextDoc: Long('11') }
109
                    },
110
                    score: {
111
                      millisElapsed: 0.013741,
112
                      invocationCounts: { score: Long('8') }
113
                    }
114
                  }
115
                },
116
                {
117
                  type: 'BoostQuery',
118
                  args: {
119
                    query: {
120
                      type: 'TermQuery',
121
                      args: { path: 'title', value: 'park' },
122
                      stats: {
123
                        context: { millisElapsed: 0 },
124
                        match: { millisElapsed: 0 },
125
                        score: { millisElapsed: 0 }
126
                      }
127
                    },
128
                    boost: 0.75
129
                  },
130
                  stats: {
131
                    context: {
132
                      millisElapsed: 0.395528,
133
                      invocationCounts: {
134
                        createWeight: Long('1'),
135
                        createScorer: Long('16')
136
                      }
137
                    },
138
                    match: {
139
                      millisElapsed: 0.091681,
140
                      invocationCounts: { nextDoc: Long('32') }
141
                    },
142
                    score: {
143
                      millisElapsed: 0.137827,
144
                      invocationCounts: { score: Long('27') }
145
                    }
146
                  }
147
                },
148
                {
149
                  type: 'BoostQuery',
150
                  args: {
151
                    query: {
152
                      type: 'TermQuery',
153
                      args: { path: 'title', value: 'york' },
154
                      stats: {
155
                        context: { millisElapsed: 0 },
156
                        match: { millisElapsed: 0 },
157
                        score: { millisElapsed: 0 }
158
                      }
159
                    },
160
                    boost: 0.75
161
                  },
162
                  stats: {
163
                    context: {
164
                      millisElapsed: 0.150681,
165
                      invocationCounts: {
166
                        createWeight: Long('1'),
167
                        createScorer: Long('16')
168
                      }
169
                    },
170
                    match: {
171
                      millisElapsed: 0.067298,
172
                      invocationCounts: { nextDoc: Long('33') }
173
                    },
174
                    score: {
175
                      millisElapsed: 0.038636,
176
                      invocationCounts: { score: Long('28') }
177
                    }
178
                  }
179
                },
180
                {
181
                  type: 'BoostQuery',
182
                  args: {
183
                    query: {
184
                      type: 'TermQuery',
185
                      args: { path: 'title', value: 'yard' },
186
                      stats: {
187
                        context: { millisElapsed: 0 },
188
                        match: { millisElapsed: 0 },
189
                        score: { millisElapsed: 0 }
190
                      }
191
                    },
192
                    boost: 0.75
193
                  },
194
                  stats: {
195
                    context: {
196
                      millisElapsed: 0.104308,
197
                      invocationCounts: {
198
                        createWeight: Long('1'),
199
                        createScorer: Long('8')
200
                      }
201
                    },
202
                    match: {
203
                      millisElapsed: 0.002445,
204
                      invocationCounts: { nextDoc: Long('4') }
205
                    },
206
                    score: {
207
                      millisElapsed: 0.00233,
208
                      invocationCounts: { score: Long('3') }
209
                    }
210
                  }
211
                }
212
              ],
213
              filter: [],
214
              minimumShouldMatch: 0
215
            },
216
            stats: {
217
              context: {
218
                millisElapsed: 12.8127,
219
                invocationCounts: { createWeight: Long('1'), createScorer: Long('12') }
220
              },
221
              match: {
222
                millisElapsed: 0.761076,
223
                invocationCounts: { nextDoc: Long('157') }
224
              },
225
              score: {
226
                millisElapsed: 0.857125,
227
                invocationCounts: { score: Long('151') }
228
              }
229
            }
230
          },
231
          collectors: {
232
            allCollectorStats: {
233
              millisElapsed: 2.061296,
234
              invocationCounts: {
235
                collect: Long('151'),
236
                competitiveIterator: Long('6'),
237
                setScorer: Long('6')
238
              }
239
            },
240
            facet: { collectorStats: { millisElapsed: 0 } }
241
          },
242
          resultMaterialization: {
243
            stats: {
244
              millisElapsed: 17.759502,
245
              invocationCounts: { retrieveAndSerialize: Long('1') }
246
            }
247
          },
248
          metadata: {
249
            mongotVersion: '1.43.1',
250
            mongotHostName: '<hostname>.mogodb.net',
251
            indexName: 'default',
252
            totalLuceneDocs: 21349
253
          },
254
          resourceUsage: {
255
            majorFaults: Long('0'),
256
            minorFaults: Long('98'),
257
            userTimeMs: Long('30'),
258
            systemTimeMs: Long('0'),
259
            maxReportingThreads: 1,
260
            numBatches: 1
261
          }
262
        },
263
        requiresSearchMetaCursor: true
264
      },
265
      nReturned: Long('0'),
266
      executionTimeMillisEstimate: Long('108')
267
    },
268
    {
269
      '$_internalSearchIdLookup': {},
270
      nReturned: Long('0'),
271
      executionTimeMillisEstimate: Long('108')
272
    }
273
  ],
274
  queryShapeHash: '6FD3791F785FA329D4ECD1171E0E5AF6772C18F5F0A7A50FC416D080A93C8CB7',
275
  serverInfo: {
276
    host: '<hostname>.mogodb.net',
277
    port: 27017,
278
    version: '8.0.4',
279
    gitVersion: 'bc35ab4305d9920d9d0491c1c9ef9b72383d31f9'
280
  },
281
  serverParameters: {
282
    ...
283
  },
284
  command: {
285
    aggregate: 'movies',
286
    pipeline: [
287
      {
288
        '$search': {
289
          text: {
290
            path: 'title',
291
            query: 'yark',
292
            fuzzy: { maxEdits: 1, maxExpansions: 100 }
293
          }
294
        }
295
      }
296
    ],
297
    cursor: {},
298
    '$db': 'sample_mflix'
299
  },
300
  ok: 1,
301
  '$clusterTime': {
302
    clusterTime: Timestamp({ t: 1738081279, i: 12 }),
303
    signature: {
304
      hash: Binary.createFromBase64('DM3imkEw1qT23M2n/b/JibqB1Fg=', 0),
305
      keyId: Long('7462787091647168517')
306
    }
307
  },
308
  operationTime: Timestamp({ t: 1738081279, i: 12 })
309
}

1
{
2
  explainVersion: '1',
3
  stages: [
4
    {
5
      '$_internalSearchMongotRemote': {
6
        mongotQuery: {
7
          text: { path: 'title', query: 'prince' },
8
          highlight: { path: 'title', maxNumPassages: 1, maxCharsToExamine: 40 }
9
        },
10
        explain: {
11
          query: {
12
            type: 'TermQuery',
13
            args: { path: 'title', value: 'prince' },
14
            stats: {
15
              context: {
16
                millisElapsed: 1.034149,
17
                invocationCounts: { createWeight: Long('1'), createScorer: Long('10') }
18
              },
19
              match: {
20
                millisElapsed: 0.050591,
21
                invocationCounts: { nextDoc: Long('29') }
22
              },
23
              score: {
24
                millisElapsed: 0.027259,
25
                invocationCounts: { score: Long('25') }
26
              }
27
            }
28
          },
29
          collectors: {
30
            allCollectorStats: {
31
              millisElapsed: 0.112751,
32
              invocationCounts: {
33
                collect: Long('25'),
34
                competitiveIterator: Long('4'),
35
                setScorer: Long('4')
36
              }
37
            },
38
            facet: { collectorStats: { millisElapsed: 0 } }
39
          },
40
          highlight: {
41
            resolvedHighlightPaths: [ '$type:string/title' ],
42
            stats: {
43
              millisElapsed: 10.665238,
44
              invocationCounts: {
45
                executeHighlight: Long('1'),
46
                setupHighlight: Long('1')
47
              }
48
            }
49
          },
50
          resultMaterialization: {
51
            stats: {
52
              millisElapsed: 3.548075,
53
              invocationCounts: { retrieveAndSerialize: Long('1') }
54
            }
55
          },
56
          metadata: {
57
            mongotVersion: '1.43.1',
58
            mongotHostName: '<hostname>.mongodb.net',
59
            indexName: 'default',
60
            totalLuceneDocs: 21349
61
          },
62
          resourceUsage: {
63
            majorFaults: Long('0'),
64
            minorFaults: Long('0'),
65
            userTimeMs: Long('10'),
66
            systemTimeMs: Long('0'),
67
            maxReportingThreads: 1,
68
            numBatches: 1
69
          }
70
        },
71
        requiresSearchMetaCursor: true
72
      },
73
      nReturned: Long('0'),
74
      executionTimeMillisEstimate: Long('31')
75
    },
76
    {
77
      '$_internalSearchIdLookup': {},
78
      nReturned: Long('0'),
79
      executionTimeMillisEstimate: Long('31')
80
    },
81
    {
82
      '$project': {
83
        description: true,
84
        highlights: { '$meta': 'searchHighlights' },
85
        _id: false
86
      },
87
      nReturned: Long('0'),
88
      executionTimeMillisEstimate: Long('31')
89
    }
90
  ],
91
  queryShapeHash: 'D08444272924C1E04A6E99D0CD4BF82FD929893862B3356F79EC18BBD1F0EF0C',
92
  serverInfo: {
93
    host: '<hostname>.mogodb.net',
94
    port: 27017,
95
    version: '8.0.4',
96
    gitVersion: 'bc35ab4305d9920d9d0491c1c9ef9b72383d31f9'
97
  },
98
  serverParameters: {
99
    internalQueryFacetBufferSizeBytes: 104857600,
100
    internalQueryFacetMaxOutputDocSizeBytes: 104857600,
101
    internalLookupStageIntermediateDocumentMaxSizeBytes: 104857600,
102
    internalDocumentSourceGroupMaxMemoryBytes: 104857600,
103
    internalQueryMaxBlockingSortMemoryUsageBytes: 104857600,
104
    internalQueryProhibitBlockingMergeOnMongoS: 0,
105
    internalQueryMaxAddToSetBytes: 104857600,
106
    internalDocumentSourceSetWindowFieldsMaxMemoryBytes: 104857600,
107
    internalQueryFrameworkControl: 'trySbeRestricted',
108
    internalQueryPlannerIgnoreIndexWithCollationForRegex: 1
109
  },
110
  command: {
111
    aggregate: 'movies',
112
    pipeline: [
113
      {
114
        '$search': {
115
          text: { path: 'title', query: 'prince' },
116
          highlight: { path: 'title', maxNumPassages: 1, maxCharsToExamine: 40 }
117
        }
118
      },
119
      {
120
        '$project': {
121
          description: 1,
122
          _id: 0,
123
          highlights: { '$meta': 'searchHighlights' }
124
        }
125
      }
126
    ],
127
    cursor: {},
128
    '$db': 'sample_mflix'
129
  },
130
  ok: 1,
131
  '$clusterTime': {
132
    clusterTime: Timestamp({ t: 1738081637, i: 1 }),
133
    signature: {
134
      hash: Binary.createFromBase64('TnFwebZsmrjLunk7/TN+9rfJ/8Y=', 0),
135
      keyId: Long('7462787091647168517')
136
    }
137
  },
138
  operationTime: Timestamp({ t: 1738081637, i: 1 })
139
}

1
{
2
  explainVersion: '1',
3
  stages: [
4
    {
5
      '$searchMeta': {
6
        mongotQuery: {
7
          facet: {
8
            operator: {
9
              near: {
10
                path: 'released',
11
                origin: ISODate('1921-11-01T00:00:00.000Z'),
12
                pivot: 7776000000
13
              }
14
            },
15
            facets: {
16
              genresFacet: { type: 'string', path: 'genres' },
17
              yearFacet: {
18
                type: 'number',
19
                path: 'year',
20
                boundaries: [ 1910, 1920, 1930, 1940 ]
21
              }
22
            }
23
          }
24
        },
25
        explain: {
26
          query: {
27
            type: 'LongDistanceFeatureQuery',
28
            args: {},
29
            stats: {
30
              context: {
31
                millisElapsed: 0.684076,
32
                invocationCounts: { createWeight: Long('1'), createScorer: Long('12') }
33
              },
34
              match: {
35
                millisElapsed: 1.285512,
36
                invocationCounts: { nextDoc: Long('20884') }
37
              },
38
              score: {
39
                millisElapsed: 1.321738,
40
                invocationCounts: { score: Long('20878') }
41
              }
42
            }
43
          },
44
          collectors: {
45
            allCollectorStats: {
46
              millisElapsed: 10.536043,
47
              invocationCounts: {
48
                collect: Long('20878'),
49
                competitiveIterator: Long('6'),
50
                setScorer: Long('6')
51
              }
52
            },
53
            facet: {
54
              collectorStats: {
55
                millisElapsed: 3.730834,
56
                invocationCounts: { collect: Long('20878'), setScorer: Long('6') }
57
              },
58
              createCountsStats: {
59
                millisElapsed: 10.350302,
60
                invocationCounts: { generateFacetCounts: Long('2') }
61
              },
62
              stringFacetCardinalities: { genresFacet: { queried: 10, total: 25 } }
63
            }
64
          },
65
          resultMaterialization: {
66
            stats: {
67
              millisElapsed: 10.645713,
68
              invocationCounts: { retrieveAndSerialize: Long('1') }
69
            }
70
          },
71
          metadata: {
72
            mongotVersion: '1.43.1',
73
            mongotHostName: '<hostname>.mogodb.net',
74
            indexName: 'default',
75
            totalLuceneDocs: 21349
76
          },
77
          resourceUsage: {
78
            majorFaults: Long('0'),
79
            minorFaults: Long('0'),
80
            userTimeMs: Long('10'),
81
            systemTimeMs: Long('0'),
82
            maxReportingThreads: 1,
83
            numBatches: 1
84
          }
85
        },
86
        requiresSearchMetaCursor: true
87
      },
88
      nReturned: Long('0'),
89
      executionTimeMillisEstimate: Long('57')
90
    }
91
  ],
92
  queryShapeHash: '582DB864C9BCFB96896CF1A3079CF70FAC10A9A1E19E8D66DF20A2BB40424FB5',
93
  serverInfo: {
94
    host: '<hostname>.mogodb.net',
95
    port: 27017,
96
    version: '8.0.4',
97
    gitVersion: 'bc35ab4305d9920d9d0491c1c9ef9b72383d31f9'
98
  },
99
  serverParameters: {
100
    internalQueryFacetBufferSizeBytes: 104857600,
101
    internalQueryFacetMaxOutputDocSizeBytes: 104857600,
102
    internalLookupStageIntermediateDocumentMaxSizeBytes: 104857600,
103
    internalDocumentSourceGroupMaxMemoryBytes: 104857600,
104
    internalQueryMaxBlockingSortMemoryUsageBytes: 104857600,
105
    internalQueryProhibitBlockingMergeOnMongoS: 0,
106
    internalQueryMaxAddToSetBytes: 104857600,
107
    internalDocumentSourceSetWindowFieldsMaxMemoryBytes: 104857600,
108
    internalQueryFrameworkControl: 'trySbeRestricted',
109
    internalQueryPlannerIgnoreIndexWithCollationForRegex: 1
110
  },
111
  command: {
112
    aggregate: 'movies',
113
    pipeline: [
114
      {
115
        '$searchMeta': {
116
          facet: {
117
            operator: {
118
              near: {
119
                path: 'released',
120
                origin: ISODate('1921-11-01T00:00:00.000Z'),
121
                pivot: 7776000000
122
              }
123
            },
124
            facets: {
125
              genresFacet: { type: 'string', path: 'genres' },
126
              yearFacet: {
127
                type: 'number',
128
                path: 'year',
129
                boundaries: [ 1910, 1920, 1930, 1940 ]
130
              }
131
            }
132
          }
133
        }
134
      }
135
    ],
136
    cursor: {},
137
    '$db': 'sample_mflix'
138
  },
139
  ok: 1,
140
  '$clusterTime': {
141
    clusterTime: Timestamp({ t: 1738081767, i: 1 }),
142
    signature: {
143
      hash: Binary.createFromBase64('ieRjqe84DdOnmlCcP3XBelo8vyM=', 0),
144
      keyId: Long('7462787091647168517')
145
    }
146
  },
147
  operationTime: Timestamp({ t: 1738081767, i: 1 })
148
}