{"t":{"$date":"2023-02-13T13:59:02.962+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn26098","msg":"Slow query","attr":{"type":"command","ns":"evin2.txn_count_log_details","command":{"getMore":412611100320334542,"collection":"txn_count_log_details","lsid":{"id":{"$uuid":"c0e591a8-c82c-4e92-9fa6-9da08c9d41c1"},"uid":{"$binary":{"base64":"O0CMtIVItQN4IsEOsJdrPL8s7jv5xwh5a/A5Qfvs2A8=","subType":"0"}}},"$clusterTime":{"clusterTime":{"$timestamp":{"t":1676296707,"i":1}},"signature":{"hash":{"$binary":{"base64":"rqjFRgJZjGS5rFYoSf65qqbYCjE=","subType":"0"}},"keyId":7170969717723627522}},"$audit":{"$impersonatedUsers":[{"user":"admin","db":"admin"}],"$impersonatedRoles":[{"role":"userAdminAnyDatabase","db":"admin"},{"role":"root","db":"admin"}]},"$client":{"driver":{"name":"mongo-java-driver|sync|spring-boot","version":"4.1.1"},"os":{"type":"Linux","name":"Linux","architecture":"amd64","version":"3.10.0-1160.36.2.el7.x86_64"},"platform":"Java/Oracle Corporation/11.0.16+8","mongos":{"host":,"version":"4.4.2"}},"$configServerState":{"opTime":{"ts":{"$timestamp":{"t":1676296703,"i":1}},"t":25}},"$db":"evin2"},"originatingCommand":{"aggregate":"txn_count_log_details","pipeline":[{"$match":{"$and":[{"productBadgeId":{"$in":[284,1,252,3,2,12]}},{"storeBadgeId":{"$in":[155,53,130,50,18,57,279,51,52]}},{"pranthId":{"$in":[1343774,1345036,1344349,1343773,1345192,1345023,1345016,1344996,1344958,1344939,1344748,1344711,1344693,1344676,1344542,1344522,1344520,1344422,1344391,1344313,1344289,1344275,1344241,1344147,1344114,1344088,1344047,1343945,1343776,1343775,1345196,1345186,1345158,1345153,1344983,1344745,1344630,1344629,1345060,1345109,1345108,1345075,1345107,1345106,1345105,1345104,1345074,1345059,1345058,1345037,1344366,1344361,1344362,1344360,1344359,1344365,1344364,1344363,1343894,1343767,1344343,1343772,1343771,1343770,1343769,1343768,1343766,1343765,1345194,1345195,1345193,1345191,1345027,1345024,1345199,1345182,1345121,1345184,1345181,1345179,1345177,1345175,1345173,1345171,1345169,1345167,1345151,1345149,1345141,1345139,1345137,1345135,1345119,1345110,1345084,1345078,1345067,1345048,1345042,1345040,1345034,1345021,1345017,1345009,1344997,1344976,1344962,1344959,1344941,1344940,1344833,1344933,1344831,1344764,1344762,1344759,1344757,1344755,1344753,1344751,1344749,1344717,1344714,1344713,1344712,1344726,1344707,1344706,1344698,1344696,1344682,1344684,1344683,1344681,1344680,1344679,1344678,1344677,1344581,1344549,1344547,1344545,1344544,1344543,1344548,1344546,1344541,1344527,1344526,1344525,1344524,1344523,1344518,1344506,1344489,1344480,1344473,1344461,1344453,1344436,1344427,1344423,1344416,1344388,1344387,1344340,1344316,1344315,1344314,1344322,1344320,1344318,1344301,1345217,1345218,1345219,1345220,1345221,1344300,1344299,1344298,1344297,1344296,1344295,1344294,1344293,1344291,1344290,1344292,1344287,1344286,1344285,1344284,1344283,1344282,1344281,1344280,1344278,1344277,1344276,1344279,1344274,1344246,1344245,1344244,1344243,1344242,1344195,1344692,1344156,1344155,1344154,1344153,1344152,1344151,1344150,1344149,1344148,1344146,1344138,1344128,1344127,1344126,1344125,1344124,1344123,1344122,1344121,1344120,1344119,1344344,1344118,1344117,1343944,1345223,1344108,1344107,1344106,1344105,1344104,1344103,1344102,1344095,1344094,1344093,1344092,1344091,1344383,1344090,1345254,1344087,1344053,1344054,1344052,1344051,1344055,1344050,1344049,1344048,1344240,1344196,1344116,1344115,1344089,1344198,1344197,1343895,1343790,1343789,1343788,1343786,1343896,1343942,1343941,1343802,1343798,1343797,1343796,1343795,1345198,1345197,1345189,1345187,1345069,1344984,1344772,1344771,1344770,1344632,1344631,1344386,1344385,1344612,1344611,1344610,1344609,1344608,1344607,1344606,1344605,1344604,1344358,1344357,1344356,1344355,1344354,1344353,1344352,1344351,1344350,1343759,1343892,1343890,1343886,1343891,1343764,1343763,1343762,1343889,1343888,1343887,1343761,1343821,1343760,1343893,1343758,1343885,1343757,1345083,1345082,1345081,1345080,1345051,1345050,1345029,1345026,1345025,1345183,1345122,1345185,1345180,1345178,1345176,1345174,1345172,1345170,1345168,1345152,1345150,1345142,1345140,1345138,1345136,1345120,1345111,1345085,1345079,1345068,1345049,1345043,1345041,1345035,1345022,1345018,1345148,1345147,1345145,1345144,1345102,1345101,1345100,1345057,1345056,1345055,1345008,1345103,1345099,1345098,1345097,1345096,1345054,1345053,1345052,1345007,1345000,1344999,1344998,1345146,1345143,1345118,1345159,1345155,1345131,1345114,1345094,1345066,1344981,1344979,1344977,1345163,1345161,1345133,1345092,1345065,1345030,1344974,1345165,1345154,1345116,1345076,1344971,1344969,1345005,1345004,1345039,1345006,1344988,1344948,1344951,1344950,1344947,1344946,1344945,1344963,1344953,1344934,1345002,1344965,1344964,1344952,1344830,1344957,1344936,1344935,1344828,1344824,1344765,1344954,1344937,1344832,1344821,1344763,1344826,1344827,1344818,1344769,1344760,1344956,1344944,1344829,1344825,1344768,1344758,1345222,1345003,1344966,1344756,1345028,1344955,1344943,1344754,1345207,1344823,1344822,1344767,1344752,1344750,1344820,1344766,1344747,1344737,1344733,1344718,1344716,1344817,1344816,1344746,1344742,1344741,1344736,1344732,1344725,1344715,1344993,1344738,1344728,1344719,1344709,1344704,1344743,1344722,1344720,1344710,1344702,1344761,1344739,1344735,1344727,1344699,1344734,1344723,1344705,1344697,1344695,1344694,1344580,1344579,1344578,1344577,1344572,1344571,1344570,1344564,1344563,1344562,1344561,1344560,1344559,1344558,1344557,1344556,1344555,1344554,1344553,1344552,1344551,1344550,1344576,1344575,1344574,1344573,1344569,1344568,1344567,1344566,1344565,1345235,1345250,1345246,1344540,1344539,1344538,1345245,1345238,1345244,1344537,1344536,1344535,1345248,1345243,1344534,1344533,1345249,1345237,1344532,1344531,1344530,1345251,1345241,1345240,1344529,1344528,1344512,1344510,1344507,1344519,1344517,1344516,1344515,1344514,1344513,1344509,1344500,1344498,1344495,1344492,1344490,1344499,1344497,1344496,1344493,1344491,1344487,1344484,1344483,1344481,1344482,1344479,1344477,1344475,1344474,1344478,1344476,1344471,1344469,1344468,1344467,1344463,1344462,1344470,1344466,1344460,1344458,1344456,1344454,1344459,1344455,1344446,1344445,1344442,1344440,1344437,1344441,1344439,1344464,1344452,1344444,1344505,1344504,1344503,1344502,1344501,1344494,1344485,1344472,1344457,1344451,1344450,1344449,1344448,1344447,1344443,1344438,1344435,1344434,1344433,1344432,1344429,1344431,1344428,1344426,1344430,1344425,1344424,1344414,1344411,1344408,1344402,1344399,1344398,1344395,1344394,1344393,1344740,1344412,1344410,1344407,1344406,1344405,1344404,1344403,1344400,1344397,1344392,1344938,1344421,1344420,1344419,1344418,1344417,1344415,1344413,1344409,1344401,1344396,1344390,1344389,1344317,1344338,1344336,1344334,1344332,1344330,1344328,1344326,1344324,1344323,1344321,1344319,1344273,1344272,1344271,1344270,1345211,1344269,1344268,1344267,1344266,1345208,1344265,1344264,1344263,1344262,1344261,1344252,1345212,1345209,1344260,1344259,1344258,1344257,1344256,1345213,1345210,1344255,1344254,1344253,1344251,1344250,1344249,1344248,1344247,1344176,1344175,1344174,1344173,1344172,1344194,1344193,1344192,1344191,1344190,1344189,1344188,1344187,1344186,1344185,1344184,1344183,1344182,1344181,1344180,1344179,1344178,1344177,1344171,1344170,1344169,1344168,1344167,1344166,1344165,1344164,1344163,1344162,1344161,1344160,1344159,1344158,1344157,1345216,1344133,1344132,1344131,1344130,1344129,1344145,1344144,1344143,1344142,1344141,1344140,1344139,1344137,1344136,1344135,1344134,1344101,1344099,1344100,1344098,1344097,1344096,1344113,1344112,1344111,1344110,1344109,1343951,1344064,1344063,1344065,1344061,1344062,1344078,1344081,1344080,1344079,1344084,1344083,1344082,1344077,1344076,1344075,1344074,1344675,1344086,1344085,1344073,1344072,1344071,1344070,1344069,1344068,1344067,1344066,1344060,1344059,1344058,1344057,1344056,1344223,1344222,1344221,1344220,1344219,1344224,1344209,1344208,1344207,1344206,1344210,1344204,1344203,1344202,1344201,1344200,1344199,1344205,1344217,1344216,1344215,1344214,1344213,1344212,1344211,1344218,1344237,1344236,1344235,1344234,1344233,1344239,1344238,1344229,1344230,1344228,1344227,1344226,1344225,1344232,1344231,1343940,1343939,1343915,1343783,1343938,1343937,1343936,1343935,1343934,1343933,1343932,1343931,1343930,1343929,1343928,1343782,1343785,1343903,1343902,1343901,1343900,1343899,1343898,1343897,1343781,1343787,1343927,1343926,1343925,1343924,1343923,1343922,1343921,1343779,1343784,1343949,1343948,1343947,1343871,1343960,1343959,1343958,1343956,1343957,1343946,1343943,1343869,1343866,1343801,1343971,1343970,1343969,1343962,1343961,1343794,1343968,1343967,1343966,1343793,1343965,1343964,1343963,1343792,1343955,1343952,1343840,1343834,1343833,1343791,1345190,1345188,1345129,1345127,1345125,1345123,1345112,1345090,1345088,1345086,1345072,1345070,1345046,1345044,1345032,1345014,1345012,1345010,1344994,1344991,1344989,1344985,1344628,1344627,1344626,1344625,1344624,1344623,1344622,1344621,1344620,1344619,1344618,1344617,1344616,1344615,1344614,1343873,1343752,1343875,1343874,1343872,1343819,1343878,1343877,1343876,1343865,1343864,1343863,1343862,1343843,1343842,1343811,1343870,1343868,1343867,1343806,1343805,1343804,1343803,1343799,1343756,1343861,1343860,1343859,1343858,1343857,1343750,1343830,1343829,1343828,1343827,1343826,1343755,1343853,1343852,1343851,1343850,1343849,1343848,1343847,1343846,1343845,1343844,1343856,1343855,1343854,1343754,1343825,1343824,1343823,1343822,1343832,1343831,1343808,1343807,1343753,1343881,1343880,1343879,1343884,1343883,1343882,1343751,1343837,1343836,1343835,1343809,1343839,1343838,1343810,1343749,1345001,1345156,1345132,1345115,1345095,1345064,1344982,1344980,1344978,1345164,1345162,1345134,1345093,1345063,1345031,1344975,1345166,1345157,1345117,1345077,1344972,1344961,1344595,1344594,1345206,1345205,1345204,1345203,1345201,1344603,1344602,1344599,1344691,1344690,1344689,1344688,1344687,1344686,1344685,1344648,1344647,1344646,1344645,1344644,1344643,1344642,1344641,1344640,1344639,1344664,1344662,1344663,1344661,1344667,1344660,1344659,1344658,1344657,1344656,1344655,1344674,1344673,1344672,1344671,1344670,1344638,1344637,1344636,1344635,1344587,1344586,1344585,1344654,1344653,1344652,1344651,1344650,1344649,1344511,1344508,1344465,1344339,1344337,1344335,1344333,1344331,1344329,1344327,1344325,1343920,1343919,1343918,1343917,1343778,1343909,1343908,1343907,1343906,1343905,1343904,1343780,1343916,1343914,1343913,1343912,1343911,1343910,1343777,1345130,1345128,1345126,1345124,1345113,1345091,1345089,1345087,1345073,1345071,1345047,1345045,1345033,1345015,1345013,1345011,1344995,1344992,1344990,1344986]}},{"txnDate":{"$gte":{"$date":"2022-01-01T00:00:00.000Z"}}},{"txnDate":{"$lte":{"$date":"2022-03-31T00:00:00.000Z"}}}]}},{"$group":{"_id":"$txnTypeId","count":{"$sum":{"$const":1}}}}],"fromMongos":true,"needsMerge":true,"collation":{"locale":"simple"},"cursor":{"batchSize":0},"runtimeConstants":{"localNow":{"$date":"2023-02-13T13:58:27.803Z"},"clusterTime":{"$timestamp":{"t":1676296707,"i":1}}},"use44SortKeys":true,"useNewUpsert":true,"readConcern":{"provenance":"implicitDefault"},"writeConcern":{"w":1,"wtimeout":0,"provenance":"implicitDefault"},"shardVersion":[{"$timestamp":{"t":1148,"i":1}},{"$oid":"63e37a5d8ee4ac33c1be7e8d"}]},"planSummary":"IXSCAN { productBadgeId: 1, storeBadgeId: 1, pranthId: 1, txnDate: 1 }","cursorid":412611100320334542,"keysExamined":6725351,"docsExamined":6725295,"cursorExhausted":true,"numYields":6881,"nreturned":5,"reslen":550,"locks":{"ReplicationStateTransition":{"acquireCount":{"w":7067}},"Global":{"acquireCount":{"r":7067}},"Database":{"acquireCount":{"r":7067}},"Collection":{"acquireCount":{"r":7067}},"Mutex":{"acquireCount":{"r":186}}},"readConcern":{"provenance":"implicitDefault"},"writeConcern":{"w":1,"wtimeout":0,"provenance":"implicitDefault"},"storage":{},"protocol":"op_msg","durationMillis":35122},"truncated":{"originatingCommand":{"clientOperationKey":{"type":"binData","size":21}}},"size":{"originatingCommand":17001}}