쿼리 계획 및 실행 통계 검색 방법

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: 'mark' },
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.209279,
37
                      invocationCounts: {
38
                        createWeight: Long('2'),
39
                        createScorer: Long('18')
40
                      }
41
                    },
42
                    match: {
43
                      millisElapsed: 0.028079,
44
                      invocationCounts: { nextDoc: Long('22') }
45
                    },
46
                    score: {
47
                      millisElapsed: 0.01706,
48
                      invocationCounts: { score: Long('16') }
49
                    }
50
                  }
51
                },
52
                {
53
                  type: 'BoostQuery',
54
                  args: {
55
                    query: {
56
                      type: 'TermQuery',
57
                      args: { path: 'title', value: 'yard' },
58
                      stats: {
59
                        context: { millisElapsed: 0 },
60
                        match: { millisElapsed: 0 },
61
                        score: { millisElapsed: 0 }
62
                      }
63
                    },
64
                    boost: 0.75
65
                  },
66
                  stats: {
67
                    context: {
68
                      millisElapsed: 0.136254,
69
                      invocationCounts: {
70
                        createWeight: Long('2'),
71
                        createScorer: Long('14')
72
                      }
73
                    },
74
                    match: {
75
                      millisElapsed: 0.008556,
76
                      invocationCounts: { nextDoc: Long('10') }
77
                    },
78
                    score: {
79
                      millisElapsed: 0.006096,
80
                      invocationCounts: { score: Long('6') }
81
                    }
82
                  }
83
                },
84
                {
85
                  type: 'BoostQuery',
86
                  args: {
87
                    query: {
88
                      type: 'TermQuery',
89
                      args: { path: 'title', value: 'york' },
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.303568,
101
                      invocationCounts: {
102
                        createWeight: Long('2'),
103
                        createScorer: Long('18')
104
                      }
105
                    },
106
                    match: {
107
                      millisElapsed: 0.374856,
108
                      invocationCounts: { nextDoc: Long('62') }
109
                    },
110
                    score: {
111
                      millisElapsed: 0.892383,
112
                      invocationCounts: { score: Long('56') }
113
                    }
114
                  }
115
                },
116
                {
117
                  type: 'BoostQuery',
118
                  args: {
119
                    query: {
120
                      type: 'TermQuery',
121
                      args: { path: 'title', value: 'ark' },
122
                      stats: {
123
                        context: { millisElapsed: 0 },
124
                        match: { millisElapsed: 0 },
125
                        score: { millisElapsed: 0 }
126
                      }
127
                    },
128
                    boost: 0.6666666269302368
129
                  },
130
                  stats: {
131
                    context: {
132
                      millisElapsed: 8.379562,
133
                      invocationCounts: {
134
                        createWeight: Long('2'),
135
                        createScorer: Long('10')
136
                      }
137
                    },
138
                    match: {
139
                      millisElapsed: 2.073272,
140
                      invocationCounts: { nextDoc: Long('6') }
141
                    },
142
                    score: {
143
                      millisElapsed: 0.004063,
144
                      invocationCounts: { score: Long('4') }
145
                    }
146
                  }
147
                },
148
                {
149
                  type: 'BoostQuery',
150
                  args: {
151
                    query: {
152
                      type: 'TermQuery',
153
                      args: { path: 'title', value: 'dark' },
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.679029,
165
                      invocationCounts: {
166
                        createWeight: Long('2'),
167
                        createScorer: Long('18')
168
                      }
169
                    },
170
                    match: {
171
                      millisElapsed: 5.500198,
172
                      invocationCounts: { nextDoc: Long('172') }
173
                    },
174
                    score: {
175
                      millisElapsed: 2.465502,
176
                      invocationCounts: { score: Long('166') }
177
                    }
178
                  }
179
                },
180
                {
181
                  type: 'BoostQuery',
182
                  args: {
183
                    query: {
184
                      type: 'TermQuery',
185
                      args: { path: 'title', value: 'park' },
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.221919,
197
                      invocationCounts: {
198
                        createWeight: Long('2'),
199
                        createScorer: Long('18')
200
                      }
201
                    },
202
                    match: {
203
                      millisElapsed: 0.116139,
204
                      invocationCounts: { nextDoc: Long('60') }
205
                    },
206
                    score: {
207
                      millisElapsed: 0.056817,
208
                      invocationCounts: { score: Long('54') }
209
                    }
210
                  }
211
                }
212
              ],
213
              filter: [],
214
              minimumShouldMatch: 0
215
            },
216
            stats: {
217
              context: {
218
                millisElapsed: 25.303419,
219
                invocationCounts: { createWeight: Long('2'), createScorer: Long('12') }
220
              },
221
              match: {
222
                millisElapsed: 10.533183,
223
                invocationCounts: { nextDoc: Long('308') }
224
              },
225
              score: {
226
                millisElapsed: 5.501189,
227
                invocationCounts: { score: Long('302') }
228
              }
229
            }
230
          },
231
          collectStats: {
232
            allCollectorStats: {
233
              millisElapsed: 6.735626,
234
              invocationCounts: {
235
                collect: Long('302'),
236
                competitiveIterator: Long('6'),
237
                setScorer: Long('6')
238
              }
239
            },
240
            facet: { collectorStats: { millisElapsed: 0 } }
241
          },
242
          resultMaterialization: {
243
            stats: {
244
              millisElapsed: 176.613905,
245
              invocationCounts: { retrieveAndSerialize: Long('2') }
246
            }
247
          },
248
          metadata: {
249
            <hostname>.mongodb.netmongotVersion: '1.42.0',
250
            mongotHostName: '<hostname>.mongodb.net',
251
            indexName: 'default',
252
            cursorOptions: { batchSize: 108, requiresSearchSequenceToken: false },
253
            totalLuceneDocs: 21349
254
          },
255
          resourceUsage: {
256
            majorFaults: Long('99'),
257
            minorFaults: Long('192'),
258
            userTimeMs: Long('80'),
259
            systemTimeMs: Long('10'),
260
            maxReportingThreads: 1,
261
            numBatches: 2
262
          }
263
        },
264
        requiresSearchMetaCursor: false,
265
        internalMongotBatchSizeHistory: [ Long('108'), Long('162') ]
266
      },
267
      nReturned: Long('151'),
268
      executionTimeMillisEstimate: Long('83')
269
    },
270
    {
271
      '$_internalSearchIdLookup': {
272
        subPipeline: [
273
          { '$match': { _id: { '$eq': '_id placeholder' } } }
274
        ],
275
        totalDocsExamined: Long('151'),
276
        totalKeysExamined: Long('151'),
277
        numDocsFilteredByIdLookup: Long('0')
278
      },
279
      nReturned: Long('151'),
280
      executionTimeMillisEstimate: Long('88')
281
    }
282
  ],
283
  queryShapeHash: '6FD3791F785FA329D4ECD1171E0E5AF6772C18F5F0A7A50FC416D080A93C8CB7',
284
  serverInfo: {
285
    host: '<hostname>.mongodb.net',
286
    port: 27017,
287
    version: '8.2.0',
288
    gitVersion: '13e629eeccd63f00d17568fc4c12b7530fa34b54'
289
  },
290
  serverParameters: {
291
    ...
292
  },
293
  command: {
294
    aggregate: 'movies',
295
    pipeline: [
296
      {
297
        '$search': {
298
          text: {
299
            path: 'title',
300
            query: 'yark',
301
            fuzzy: { maxEdits: 1, maxExpansions: 100 }
302
          }
303
        }
304
      }
305
    ],
306
    cursor: {},
307
    '$db': 'sample_mflix'
308
  },
309
  ok: 1,
310
  '$clusterTime': {
311
    clusterTime: Timestamp({ t: 1758295936, i: 19 }),
312
    signature: {
313
      hash: Binary.createFromBase64('+CanjrL9jdXPTLa2sUaNPtImkBc=', 0),
314
      keyId: Long('7551379485140975621')
315
    }
316
  },
317
  operationTime: Timestamp({ t: 1758295936, i: 19 })
318
}

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: 9.880819,
17
                invocationCounts: { createWeight: Long('1'), createScorer: Long('6') }
18
              },
19
              match: {
20
                millisElapsed: 3.566358,
21
                invocationCounts: { nextDoc: Long('28') }
22
              },
23
              score: {
24
                millisElapsed: 2.762687,
25
                invocationCounts: { score: Long('25') }
26
              }
27
            }
28
          },
29
          collectStats: {
30
            allCollectorStats: {
31
              millisElapsed: 3.238152,
32
              invocationCounts: {
33
                collect: Long('25'),
34
                competitiveIterator: Long('3'),
35
                setScorer: Long('3')
36
              }
37
            },
38
            facet: { collectorStats: { millisElapsed: 0 } }
39
          },
40
          highlight: {
41
            resolvedHighlightPaths: [ '$type:string/title' ],
42
            stats: {
43
              millisElapsed: 157.543967,
44
              invocationCounts: {
45
                executeHighlight: Long('1'),
46
                setupHighlight: Long('1')
47
              }
48
            }
49
          },
50
          resultMaterialization: {
51
            stats: {
52
              millisElapsed: 3.781115,
53
              invocationCounts: { retrieveAndSerialize: Long('1') }
54
            }
55
          },
56
          metadata: {
57
            <hostname>.mongodb.netmongotVersion: '1.42.0',
58
            mongotHostName: '<hostname>.mongodb.net',
59
            indexName: 'default',
60
            cursorOptions: { batchSize: 108, requiresSearchSequenceToken: false },
61
            totalLuceneDocs: 21349
62
          },
63
          resourceUsage: {
64
            majorFaults: Long('42'),
65
            minorFaults: Long('167'),
66
            userTimeMs: Long('50'),
67
            systemTimeMs: Long('0'),
68
            maxReportingThreads: 1,
69
            numBatches: 1
70
          }
71
        },
72
        requiresSearchMetaCursor: false,
73
        internalMongotBatchSizeHistory: [ Long('108') ]
74
      },
75
      nReturned: Long('25'),
76
      executionTimeMillisEstimate: Long('0')
77
    },
78
    {
79
      '$_internalSearchIdLookup': {
80
        subPipeline: [
81
          { '$match': { _id: { '$eq': '_id placeholder' } } }
82
        ],
83
        totalDocsExamined: Long('25'),
84
        totalKeysExamined: Long('25'),
85
        numDocsFilteredByIdLookup: Long('0')
86
      },
87
      nReturned: Long('25'),
88
      executionTimeMillisEstimate: Long('1')
89
    },
90
    {
91
      '$project': {
92
        description: true,
93
        highlights: { '$meta': 'searchHighlights' },
94
        _id: false
95
      },
96
      nReturned: Long('25'),
97
      executionTimeMillisEstimate: Long('1')
98
    }
99
  ],
100
  queryShapeHash: 'D08444272924C1E04A6E99D0CD4BF82FD929893862B3356F79EC18BBD1F0EF0C',
101
  serverInfo: {
102
    host: '<hostname>.mongodb.net',
103
    port: 27017,
104
    version: '8.2.0',
105
    gitVersion: '13e629eeccd63f00d17568fc4c12b7530fa34b54'
106
  },
107
  serverParameters: {
108
    internalQueryFacetBufferSizeBytes: 104857600,
109
    internalQueryFacetMaxOutputDocSizeBytes: 104857600,
110
    internalLookupStageIntermediateDocumentMaxSizeBytes: 104857600,
111
    internalDocumentSourceGroupMaxMemoryBytes: 104857600,
112
    internalQueryMaxBlockingSortMemoryUsageBytes: 104857600,
113
    internalQueryProhibitBlockingMergeOnMongoS: 0,
114
    internalQueryMaxAddToSetBytes: 104857600,
115
    internalDocumentSourceSetWindowFieldsMaxMemoryBytes: 104857600,
116
    internalQueryFrameworkControl: 'trySbeRestricted',
117
    internalQueryPlannerIgnoreIndexWithCollationForRegex: 1
118
  },
119
  command: {
120
    aggregate: 'movies',
121
    pipeline: [
122
      {
123
        '$search': {
124
          text: { path: 'title', query: 'prince' },
125
          highlight: { path: 'title', maxNumPassages: 1, maxCharsToExamine: 40 }
126
        }
127
      },
128
      {
129
        '$project': {
130
          description: 1,
131
          _id: 0,
132
          highlights: { '$meta': 'searchHighlights' }
133
        }
134
      }
135
    ],
136
    cursor: {},
137
    '$db': 'sample_mflix'
138
  },
139
  ok: 1,
140
  '$clusterTime': {
141
    clusterTime: Timestamp({ t: 1758302099, i: 1 }),
142
    signature: {
143
      hash: Binary.createFromBase64('pUGxwCVnDOBIObmhURJQ1a1UwC8=', 0),
144
      keyId: Long('7551379485140975621')
145
    }
146
  },
147
  operationTime: Timestamp({ t: 1758302099, i: 1 })
148
}

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: 4.141763,
32
                invocationCounts: { createWeight: Long('1'), createScorer: Long('6') }
33
              },
34
              match: {
35
                millisElapsed: 24.986327,
36
                invocationCounts: { nextDoc: Long('20881') }
37
              },
38
              score: {
39
                millisElapsed: 33.324657,
40
                invocationCounts: { score: Long('20878') }
41
              }
42
            }
43
          },
44
          collectStats: {
45
            allCollectorStats: {
46
              millisElapsed: 72.243101,
47
              invocationCounts: {
48
                collect: Long('20878'),
49
                competitiveIterator: Long('3'),
50
                setScorer: Long('3')
51
              }
52
            },
53
            facet: {
54
              collectorStats: {
55
                millisElapsed: 10.424621,
56
                invocationCounts: { collect: Long('20878'), setScorer: Long('3') }
57
              },
58
              createCountsStats: {
59
                millisElapsed: 60.095261,
60
                invocationCounts: { generateFacetCounts: Long('2') }
61
              },
62
              stringFacetCardinalities: { genresFacet: { queried: 10, total: 25 } }
63
            }
64
          },
65
          resultMaterialization: {
66
            stats: {
67
              millisElapsed: 13.764287,
68
              invocationCounts: { retrieveAndSerialize: Long('1') }
69
            }
70
          },
71
          metadata: {
72
            <hostname>.mongodb.netmongotVersion: '1.42.0',
73
            mongotHostName: '<hostname>.mongodb.net',
74
            indexName: 'default',
75
            totalLuceneDocs: 21349
76
          },
77
          resourceUsage: {
78
            majorFaults: Long('10'),
79
            minorFaults: Long('13'),
80
            userTimeMs: Long('20'),
81
            systemTimeMs: Long('0'),
82
            maxReportingThreads: 1,
83
            numBatches: 1
84
          }
85
        },
86
        requiresSearchMetaCursor: true
87
      },
88
      nReturned: Long('1'),
89
      executionTimeMillisEstimate: Long('336')
90
    }
91
  ],
92
  queryShapeHash: '582DB864C9BCFB96896CF1A3079CF70FAC10A9A1E19E8D66DF20A2BB40424FB5',
93
  serverInfo: {
94
    host: '<hostname>.mongodb.net',
95
    port: 27017,
96
    version: '8.2.0',
97
    gitVersion: '13e629eeccd63f00d17568fc4c12b7530fa34b54'
98
  },
99
  serverParameters: {
100
    ...
101
  },
102
  command: {
103
    aggregate: 'movies',
104
    pipeline: [
105
      {
106
        '$searchMeta': {
107
          facet: {
108
            operator: {
109
              near: {
110
                path: 'released',
111
                origin: ISODate('1921-11-01T00:00:00.000Z'),
112
                pivot: 7776000000
113
              }
114
            },
115
            facets: {
116
              genresFacet: { type: 'string', path: 'genres' },
117
              yearFacet: {
118
                type: 'number',
119
                path: 'year',
120
                boundaries: [ 1910, 1920, 1930, 1940 ]
121
              }
122
            }
123
          }
124
        }
125
      }
126
    ],
127
    cursor: {},
128
    '$db': 'sample_mflix'
129
  },
130
  ok: 1,
131
  '$clusterTime': {
132
    clusterTime: Timestamp({ t: 1758304279, i: 1 }),
133
    signature: {
134
      hash: Binary.createFromBase64('DI9+ZTogU1QxHCWId6QLcA4R4tQ=', 0),
135
      keyId: Long('7551379485140975621')
136
    }
137
  },
138
  operationTime: Timestamp({ t: 1758304279, i: 1 })
139
}