-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: 5.0.0-rc0
-
Component/s: None
-
Query Integration
-
Query Execution 2021-07-26, QE 2021-08-09, QE 2021-08-23, QE 2021-09-06, QE 2021-09-20, QE 2021-10-04, QE 2021-10-18, QE 2021-11-01, QE 2021-11-15, QE 2021-11-29, QE 2021-12-13, QE 2021-12-27, QE 2022-01-10, QE 2022-01-24
Description
In SERVER-50286, the `resolvedViews field was added to slow query log entries for views and time series collections.
The current issue is that the `resolvedViews` field is not present on all slow query logs including insert and create logs.
Example Time Series Insert Log
{"t":{"$date":"2021-06-28T16:56:57.528-04:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn4263","msg":"Slow query","attr":{"type":"command","ns":"timeDB.timeseriesCollection","appName":"MongoDB Shell","command":{"insert":"timeseriesCollection","ordered":true,"lsid":{"id":{"$uuid":"37b18558-878f-4403-8d50-375c4d4714f0"}},"$db":"timeDB"},"ninserted":1,"keysInserted":0,"numYields":0,"reslen":45,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":1}},"ReplicationStateTransition":{"acquireCount":{"w":1}},"Global":{"acquireCount":{"w":1}},"Database":{"acquireCount":{"w":1}},"Collection":{"acquireCount":{"w":1}},"Mutex":{"acquireCount":{"r":1}}},"flowControl":{"acquireCount":1,"timeAcquiringMicros":1},"storage":{},"remote":"127.0.0.1:63564","protocol":"op_msg","durationMillis":0}}
Example Time Series Create Log
{"t":{"$date":"2021-06-28T15:44:26.178-04:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn151","msg":"Slow query","attr":{"type":"command","ns":"timeDB.timeseriesCollection","appName":"MongoDB Shell","command":{"create":"timeseriesCollection","timeseries":{"timeField":"tf"},"lsid":{"id":{"$uuid":"a7ce46ff-77ba-41e3-b0c8-adb39b1a7356"}},"$db":"timeDB"},"keysInserted":1,"numYields":0,"reslen":38,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":4}},"ReplicationStateTransition":{"acquireCount":{"w":6}},"Global":{"acquireCount":{"r":4,"w":2}},"Database":{"acquireCount":{"r":4,"w":2}},"Collection":{"acquireCount":{"r":3,"w":2,"W":1}},"Mutex":{"acquireCount":{"r":7}}},"flowControl":{"acquireCount":2,"timeAcquiringMicros":6},"storage":{},"remote":"127.0.0.1:51958","protocol":"op_msg","durationMillis":183}}
Example View Create Log
{"t":{"$date":"2021-06-28T15:59:47.589-04:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn151","msg":"Slow query","attr":{"type":"command","ns":"smol.managementFeedback","appName":"MongoDB Shell","command":{"create":"managementFeedback","pipeline":[{"$project":{"management":"$feedback.management","department":1}}],"viewOn":"survey","lsid":{"id":{"$uuid":"a7ce46ff-77ba-41e3-b0c8-adb39b1a7356"}},"$db":"smol"},"keysInserted":1,"numYields":0,"reslen":38,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":2}},"ReplicationStateTransition":{"acquireCount":{"w":4}},"Global":{"acquireCount":{"r":3,"w":1}},"Database":{"acquireCount":{"r":3,"w":1}},"Collection":{"acquireCount":{"r":2,"w":1,"W":1}},"Mutex":{"acquireCount":{"r":4}}},"flowControl":{"acquireCount":1,"timeAcquiringMicros":1},"storage":{},"remote":"127.0.0.1:51958","protocol":"op_msg","durationMillis":133}}
- related to
-
-
- Closed
-