-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
-
ALL
-
None
-
3
-
TBD
-
None
-
None
-
None
-
None
-
None
-
None
-
None
"Slow query","attr":{"type":"command","isFromUserConnection":true,"ns":"test.geo_bigpoly","collectionType":"normal","appName":"MongoDB Shell","command":{"count":"geo_bigpoly","query":{"geo":{"$geoWithin":{"$geometry":{"name":"25000 sided polygon centered on 0, 0","type":"Polygon","coordinates":[[[0,44.995],[0.8048628327358974,44.987800799999995],[1.1382023994342036,44.98060159999999],[1.3939517809719353,44.97340239999999],[1.6095324713439556,44.96620319999999],[1.7994400039970857,44.959003999999986],[1.9711088814923903,44.951804799999984],[2.128955720640998,44.94460559999998],[2.2758583086916477,44.93740639999998],[2.4138156443834013,44.93020719999998],[2.54428324522605,44.923007999999975],[2.6683599535753935,44.91580879999997],[2.786899494920874,44.90860959999997],[2.9005808195557137,44.90141039999997],[3.0099544398208864,44.894211199999965],[3.1154740749778576,44.88701199999996],[3.217518925656772,44.87981279999996],[3.316409761338092,44.87261359999996],[3.412420800000543,44.865414399999956],[3.505788651714877,44.858215199999954],[3.5967191672061656,44.85101599999995],[3.6853927617069635,44.84381679999995],[3.7719686095426184,44.83661759999995],[3.856587989109822,44.829418399999945],[3.939376979568766,44.82221919999994],[4.020448656506538,44.81501999999994],[4.099904895859514,44.80782079999994],[4.177837868278146,44.800621599999936],[4.254331286487231,44.79342239999993],[4.32946145378242,44.78622319999993],[4.4032981510942655,44.77902399999993],[4.475905391997385,44.771824799999926],[4.547342068926779,44.764625599999924],[4.617662509169522,44.75742639999992],[4.686916955567613,44.75022719999992],[4.755151984029879,44.74302799999992],[4.822410867719369,44.735828799999915],[4.88873389601146,44.72862959999991],[4.954158654904342,44.72143039999991],[5.018720274427985,44.71423119999991],[5.082451647677932,44.707031999999906],[5.145383625353182,44.6998327999999],[5.2075451890655415,44.6926335999999],[5.2689636061853165,44.6854343999999],[5.329664568571835,44.6782351999999],[5.38967231719268,44.671035999999894],[5.449009754347586,44.66383679999989],[5.507698544971019,44.65663759999989],[5.5657592082855425,44.64943839999989],[5.623211200905888,44.642239199999885],[5.680072992348802,44.63503999999988],[5.736362133780067,44.62784079999988],[5.792095320724619,44.62064159999988],[5.847288450375369,44.613442399999876],[5.901956674058597,44.606243199999874],[5.956114445347331,44.59904399999987],[6.009775564255657,44.59184479999987],[6.062953217897393,44.58464559999987],[6.115660017948922,44.577446399999864],[6.167908035217786,44.57024719999986],[6.219708831585943,44.56304799999986],[6.271073489567072,44.55584879999986],[6.322012639692569,44.548649599999855],[6.372536485917735,44.54145039999985],[6.42265482922067,44.53425119999985],[6.4723770895482735,44.52705199999985],[6.521712326248807,44.519852799999846],[6.570669257116873,44.512653599999844],[6.619256276163845,44.50545439999984],[6.667481470216998,44.49825519999984],[6.715352634439855,44.49105599999984],[6.7628772868586235,44.483856799999835],[6.810062681971211,44.47665759999983],[6.856915823508722,44.46945839999983],[6.903443476413084,44.46225919999983],[6.949652178088869,44.455059999999825],[6.995548248982265,44.44786079999982],[7.041137802535982,44.44066159999982],[7.0864267545641155,44.43346239999982],[7.1314208320882235,44.426263199999816],[7.176125581671518,44.419063999999814],[7.220546377285957,44.41186479999981],[7.2646884277437005,44.40466559999981],[7.308556783721929,44.39746639999981],[7.352156344408173,44.390267199999805],[7.3954918637906255,44.3830679999998],[7.438567956616652,44.3758687999998],[7.481389104040348,44.3686695999998],[7.52395965897889,44.361470399999796],[7.5662838511959585,44.35427119999979],[7.608365792128703,44.34707199999979],[7.650209479474313,44.33987279999979],[7.691818801550239,44.33267359999979],[7.733197541441934,44.325474399999784],[7.774349380950413,44.31827519999978],[7.815277904351405,44.31107599999978],[7.855986601976941,44.30387679999978],[7.896478873629564,44.296677599999775],[7.936758031838526,44.28947839999977],[7.97682730496703,44.28227919999977],[8.016689840178444,44.27507999999977],[8.056348706269604,44.267880799999766],[8.095806896378042,44.260681599999764],[8.13506733057023,44.25348239999976],[8.17413285831707,44.24628319999976],[8.213006260862414,44.23908399999976],[8.251690253490514,44.231884799999754],[8.290187487697393,44.22468559999975],[8.328500553271095,44.21748639999975],[8.366631980285625,44.21028719999975],[8.404584241012659,44.203087999999745],[8.44235975175525,44.19588879999974],[8.47996087460753,44.18868959999974],[8.517389919143701,44.18149039999974],[8.554649144040082,44.174291199999736],[8.591740758633222,44.167091999999734],[8.62866692441722,44.15989279999973],[8.6654297564831,44.15269359999973],[8.702031324902968,44.14549439999973],[8.738473656061506,44.138295199999725],[8.774758733937267,44.13109599999972],[8.810888501335956,44.12389679999972],[8.84686486107813,44.11669759999972],[8.882689677142967,44.109498399999715],[8.918364775770522,44.10229919999971],[8.953891946523884,44.09509999999971],[8.989272943313315,44.08790079999971],[9.02450948538385,44.080701599999706],[9.059603258267995,44.073502399999704],[9.094555914705003,44.0663031999997],[9.129369075528185,44.0591039999997],[9.16404433052151,44.0519047999997],[9.198583239246977,44.044705599999695],[9.23298733184368,44.03750639999969],[9.267258109800075,44.03030719999969],[9.301397046700208,44.02310799999969],[9.335405588945234,44.015908799999686],[9.369285156451127,44.00870959999968],[9.403037143323406,44.00151039999968],[9.436662918510043,43.99431119999968],[9.470163826433222,43.98711199999968],[9.503541187600788,43.979912799999674],[9.536796299198363,43.97271359999967],[9.569930435662608,43.96551439999967],[9.602944849236504,43.95831519999967],[9.635840770507428,43.951115999999665],[9.668619408928413,43.94391679999966],[9.701281953323486,43.93671759999966],[9.73382957237753,43.92951839999966],[9.766263415111302,43.922319199999656],[9.798584611342102,43.91511999999965],[9.8307942721307,43.90792079999965],[9.862893490214928,43.90072159999965],[9.894883340430503,43.89352239999965],[9.92676488011944,43.886323199999644],[9.958539149526665,43.87912399999964],[9.990207172184983,43.87192479999964],[10.021769955289146,43.86472559999964],[10.053228490059045,43.857526399999635],[10.084583752092705,43.85032719999963],[10.115836701709267,43.84312799999963],[10.146988284282333,43.83592879999963],[10.17803943056404,43.828729599999626],[10.208991057000123,43.821530399999624],[10.239844066036335,43.81433119999962],[10.270599346416406,43.80713199999962],[10.301257773472011,43.79993279999962],[10.331820209404754,43.792733599999615],[10.362287503560704,43.78553439999961],[10.392660492697473,43.77833519999961],[10.422940001244282,43.77113599999961],[10.453126841555118,43.763936799999605],[10.48322181415526,43.7567375999996],[10.513225707981356,43.7495383999996],[10.543139300615275,43.7423391999996],[10.572963358511894,43.735139999999596],[10.602698637221119,43.727940799999594],[10.63234588160416,43.72074159999959],[10.661905826044329,43.71354239999959],[10.691379194652557,43.70634319999959],[10.720766701467765,43.699143999999585],[10.750069050652149,43.69194479999958],[10.779286936681714,43.68474559999958],[10.808421044532066,43.67754639999958],[10.83747204985964,43.670347199999576],[10.866440619178531,43.66314799999957],[10.895327410032971,43.65594879999957],[10.924133071165755,43.64874959999957],[10.952858242682476,43.641550399999566],[10.981503556211983,43.634351199999564],[11.01006963506289,43.62715199999956],[11.038557094376525,43.61995279999956],[11.066966541276132,43.61275359999956],[11.095298575012714,43.605554399999555],[11.123553787107413,43.59835519999955],[11.151732761490605,43.59115599999955],[11.179836074637812,43.58395679999955],[11.207864295702441,43.576757599999546],[11.235817986645614,43.56955839999954],[11.263697702362892,43.56235919999954],[11.29150399080831,43.55515999999954],[11.319237393115465,43.54796079999954],[11.346898443716048,43.540761599999534],[11.374487670455611,43.53356239999953],[11.402005594706855,43.52636319999953],[11.429452731480403,43.51916399999953],[11.456829589533143,43.511964799999525],[11.484136671474177,43.50476559999952],[11.511374473868553,43.49756639999952],[11.538543487338682,43.49036719999952],[11.565644196663575,43.483167999999516],[11.592677080876042,43.475968799999514],[11.619642613357701,43.46876959999951],[11.646541261932068,43.46157039999951],[11.673373488955674,43.45437119999951],[11.700139751407193,43.447171999999505],[11.72684050097481,43.4399727999995],[11.7534761841417,43.4327735999995],[11.780047242269791,43.4255743999995],[11.80655411168172,43.418375199999495],[11.83299722374124,43.41117599999949],[11.859377004931824,43.40397679999949],[11.885693876933836,43.39677759999949],[11.911948256699981,43.389578399999486],[11.93814055652939,43.382379199999484],[11.964271184140081,43.37517999999948],[11.990340542740071,43.36798079999948],[12.016349031097029,43.36078159999948],[12.042297043606567,43.353582399999475],[12.068184970359185,43.34638319999947],[12.094013197205868,43.33918399999947],[12.119782105822487,43.33198479999947],[12.145492073772834,43.324785599999466],[12.171143474570554,43.31758639999946],[12.19673667773977,43.31038719999946],[12.222272048874654,43.30318799999946],[12.247749949697756,43.295988799999456],[12.273170738117305,43.288789599999454],[12.298534768283377,43.28159039999945],[12.323842390643021,43.27439119999945],[12.34909395199436,43.26719199999945],[12.37428979553962,43.259992799999445],[12.399430260937272,43.25279359999944],[12.424515684353127,43.24559439999944],[12.449546398510487,43.23839519999944],[12.474522732739418,43.231195999999436],[12.499445013025118,43.22399679999943],[12.524313562055335,43.21679759999943],[12.549128699266996,43.20959839999943],[12.573890740891965,43.20239919999943],[12.598600000001962,43.195199999999424],[12.623256786552707,43.18800079999942],[12.647861407427241,43.18080159999942],[12.672414166478472,43.17360239999942],[12.696915364571037,43.166403199999415],[12.721365299622299,43.15920399999941],[12.745764266642764,43.15200479999941],[12.770112557775656,43.14480559999941],[12.794410462335891,43.137606399999406],[12.818658266848345,43.130407199999404],[12.842856255085449,43.1232079999994],[12.867004708104142,43.1160087999994],[]]]}}}}},"planSummary":"COLLSCAN","planningTimeMicros":80920,"keysExamined":0,"docsExamined":13,"numYields":1,"nreturned":1,"planCacheShapeHash":"B2ACBBB0","queryHash":"B2ACBBB0","planCacheKey":"C5A9EA54","reslen":152,"locks":{"Global":{"acquireCount":{"r":2}}},"readConcern":{"level":"local","provenance":"implicitDefault"},"storage":{"timeWaitingMicros":{"storageExecutionMicros":78928}},"cpuNanos":187437250,"remote":"127.0.0.1:32928","protocol":"op_msg","delinquencyInfo":{"totalDelinquentAcquisitions":1,"totalAcquisitionDelinquencyMillis":180,"maxAcquisitionDelinquencyMillis":180},"queues":{"ingress":{"admissions":1},"execution":{"admissions":3}},"workingMillis":190,"durationMillis":190},"truncated":{"command":{"truncated":{"query":{"truncated":{"geo":{"truncated":{"$geoWithin":{"truncated":{"$geometry":{"truncated":{"coordinates":{"truncated":{"0":{"truncated":{"262":{"truncated":{"0":{"type":"double","size":8}},"omitted":2}},"omitted":24738}}}},"omitted":3}}}}}}}},"omitted":9}},"size":{"command":840034}
Please close this ticket as “Work as Design” or “Won’t Do” if this is expected or the testing issue.