MongoDB shell version v4.0.5 : Very Slow Query












0















MongoDB shell version v4.0.5 : Very Slow Query | Taking time in fetching | Data Size : 2-3 Million documents in a collection and there are around 13-15 such collections.



System Conf:



Architecture:          x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 6
On-line CPU(s) list: 0-5
Thread(s) per core: 1
Core(s) per socket: 6
Socket(s): 1
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 79
Stepping: 1
CPU MHz: 2097.570
BogoMIPS: 4195.14
Hypervisor vendor: VMware
Virtualization type: full
L1d cache: 32K
L1i cache: 32K
L2 cache: 256K
L3 cache: 20480K
NUMA node0 CPU(s): 0-5

MemTotal: 16432268 kB


I have done indexing on the tables and that is working fine but still, the system is taking a lot of time:



Below is the query planner:



db.vnms_vccells_5.find({auid:"<1e000097>",hub_ip:"10.252.0.105",sector_ip:"<1e000046>", last_updated_time:{$gt:"2016-12-24 05:49:00"}}).explain("executionStats")
{
"queryPlanner" : {
"plannerVersion" : 1,
"namespace" : "opennms.vnms_vccells_5",
"indexFilterSet" : false,
"parsedQuery" : {
"$and" : [
{
"auid" : {
"$eq" : "<1e000097>"
}
},
{
"hub_ip" : {
"$eq" : "10.252.0.105"
}
},
{
"sector_ip" : {
"$eq" : "<1e000046>"
}
},
{
"last_updated_time" : {
"$gt" : "2016-12-24 05:49:00"
}
}
]
},
"winningPlan" : {
"stage" : "FETCH",
"inputStage" : {
"stage" : "IXSCAN",
"keyPattern" : {
"auid" : 1,
"hub_ip" : 1,
"sector_ip" : 1,
"last_updated_time" : -1
},
"indexName" : "auid_1_hub_ip_1_sector_ip_1_last_updated_time_-1",
"isMultiKey" : false,
"multiKeyPaths" : {
"auid" : [ ],
"hub_ip" : [ ],
"sector_ip" : [ ],
"last_updated_time" : [ ]
},
"isUnique" : false,
"isSparse" : false,
"isPartial" : false,
"indexVersion" : 2,
"direction" : "forward",
"indexBounds" : {
"auid" : [
"["<1e000097>", "<1e000097>"]"
],
"hub_ip" : [
"["10.252.0.105", "10.252.0.105"]"
],
"sector_ip" : [
"["<1e000046>", "<1e000046>"]"
],
"last_updated_time" : [
"({}, "2016-12-24 05:49:00")"
]
}
}
},
"rejectedPlans" : [ ]
},
"executionStats" : {
"executionSuccess" : true,
"nReturned" : 28788,
"executionTimeMillis" : 34989,
"totalKeysExamined" : 28788,
"totalDocsExamined" : 28788,
"executionStages" : {
"stage" : "FETCH",
"nReturned" : 28788,
"executionTimeMillisEstimate" : 34475,
"works" : 28789,
"advanced" : 28788,
"needTime" : 0,
"needYield" : 0,
"saveState" : 1039,
"restoreState" : 1039,
"isEOF" : 1,
"invalidates" : 0,
"docsExamined" : 28788,
"alreadyHasObj" : 0,
"inputStage" : {
"stage" : "IXSCAN",
"nReturned" : 28788,
"executionTimeMillisEstimate" : 7730,
"works" : 28789,
"advanced" : 28788,
"needTime" : 0,
"needYield" : 0,
"saveState" : 1039,
"restoreState" : 1039,
"isEOF" : 1,
"invalidates" : 0,
"keyPattern" : {
"auid" : 1,
"hub_ip" : 1,
"sector_ip" : 1,
"last_updated_time" : -1
},
"indexName" : "auid_1_hub_ip_1_sector_ip_1_last_updated_time_-1",
"isMultiKey" : false,
"multiKeyPaths" : {
"auid" : [ ],
"hub_ip" : [ ],
"sector_ip" : [ ],
"last_updated_time" : [ ]
},
"isUnique" : false,
"isSparse" : false,
"isPartial" : false,
"indexVersion" : 2,
"direction" : "forward",
"indexBounds" : {
"auid" : [
"["<1e000097>", "<1e000097>"]"
],
"hub_ip" : [
"["10.252.0.105", "10.252.0.105"]"
],
"sector_ip" : [
"["<1e000046>", "<1e000046>"]"
],
"last_updated_time" : [
"({}, "2016-12-24 05:49:00")"
]
},
"keysExamined" : 28788,
"seeks" : 1,
"dupsTested" : 0,
"dupsDropped" : 0,
"seenInvalidated" : 0
}
}
},
"serverInfo" : {
"host" : "vnms",
"port" : 27017,
"version" : "4.0.5",
"gitVersion" : "3739429dd92b92d1b0ab120911a23d50bf03c412"
},
"ok" : 1
}


Below is the mongostat data:



insert query update delete getmore command dirty  used flushes vsize   res qrw arw  net_in    net_out conn                time
*0 *0 *0 *0 0 3|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 254b 101k 7 Jan 23 10:20:41.082
*0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 134b 53.0k 7 Jan 23 10:20:42.261
*0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 147b 58.4k 7 Jan 23 10:20:43.329
*0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 138b 54.8k 7 Jan 23 10:20:44.469
*0 *0 *0 *0 0 3|0 0.0% 79.9% 0 5.26G 3.52G 0|0 3|0 277b 81.9k 7 Jan 23 10:20:45.232
*0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 138b 54.8k 7 Jan 23 10:20:46.371









share|improve this question





























    0















    MongoDB shell version v4.0.5 : Very Slow Query | Taking time in fetching | Data Size : 2-3 Million documents in a collection and there are around 13-15 such collections.



    System Conf:



    Architecture:          x86_64
    CPU op-mode(s): 32-bit, 64-bit
    Byte Order: Little Endian
    CPU(s): 6
    On-line CPU(s) list: 0-5
    Thread(s) per core: 1
    Core(s) per socket: 6
    Socket(s): 1
    NUMA node(s): 1
    Vendor ID: GenuineIntel
    CPU family: 6
    Model: 79
    Stepping: 1
    CPU MHz: 2097.570
    BogoMIPS: 4195.14
    Hypervisor vendor: VMware
    Virtualization type: full
    L1d cache: 32K
    L1i cache: 32K
    L2 cache: 256K
    L3 cache: 20480K
    NUMA node0 CPU(s): 0-5

    MemTotal: 16432268 kB


    I have done indexing on the tables and that is working fine but still, the system is taking a lot of time:



    Below is the query planner:



    db.vnms_vccells_5.find({auid:"<1e000097>",hub_ip:"10.252.0.105",sector_ip:"<1e000046>", last_updated_time:{$gt:"2016-12-24 05:49:00"}}).explain("executionStats")
    {
    "queryPlanner" : {
    "plannerVersion" : 1,
    "namespace" : "opennms.vnms_vccells_5",
    "indexFilterSet" : false,
    "parsedQuery" : {
    "$and" : [
    {
    "auid" : {
    "$eq" : "<1e000097>"
    }
    },
    {
    "hub_ip" : {
    "$eq" : "10.252.0.105"
    }
    },
    {
    "sector_ip" : {
    "$eq" : "<1e000046>"
    }
    },
    {
    "last_updated_time" : {
    "$gt" : "2016-12-24 05:49:00"
    }
    }
    ]
    },
    "winningPlan" : {
    "stage" : "FETCH",
    "inputStage" : {
    "stage" : "IXSCAN",
    "keyPattern" : {
    "auid" : 1,
    "hub_ip" : 1,
    "sector_ip" : 1,
    "last_updated_time" : -1
    },
    "indexName" : "auid_1_hub_ip_1_sector_ip_1_last_updated_time_-1",
    "isMultiKey" : false,
    "multiKeyPaths" : {
    "auid" : [ ],
    "hub_ip" : [ ],
    "sector_ip" : [ ],
    "last_updated_time" : [ ]
    },
    "isUnique" : false,
    "isSparse" : false,
    "isPartial" : false,
    "indexVersion" : 2,
    "direction" : "forward",
    "indexBounds" : {
    "auid" : [
    "["<1e000097>", "<1e000097>"]"
    ],
    "hub_ip" : [
    "["10.252.0.105", "10.252.0.105"]"
    ],
    "sector_ip" : [
    "["<1e000046>", "<1e000046>"]"
    ],
    "last_updated_time" : [
    "({}, "2016-12-24 05:49:00")"
    ]
    }
    }
    },
    "rejectedPlans" : [ ]
    },
    "executionStats" : {
    "executionSuccess" : true,
    "nReturned" : 28788,
    "executionTimeMillis" : 34989,
    "totalKeysExamined" : 28788,
    "totalDocsExamined" : 28788,
    "executionStages" : {
    "stage" : "FETCH",
    "nReturned" : 28788,
    "executionTimeMillisEstimate" : 34475,
    "works" : 28789,
    "advanced" : 28788,
    "needTime" : 0,
    "needYield" : 0,
    "saveState" : 1039,
    "restoreState" : 1039,
    "isEOF" : 1,
    "invalidates" : 0,
    "docsExamined" : 28788,
    "alreadyHasObj" : 0,
    "inputStage" : {
    "stage" : "IXSCAN",
    "nReturned" : 28788,
    "executionTimeMillisEstimate" : 7730,
    "works" : 28789,
    "advanced" : 28788,
    "needTime" : 0,
    "needYield" : 0,
    "saveState" : 1039,
    "restoreState" : 1039,
    "isEOF" : 1,
    "invalidates" : 0,
    "keyPattern" : {
    "auid" : 1,
    "hub_ip" : 1,
    "sector_ip" : 1,
    "last_updated_time" : -1
    },
    "indexName" : "auid_1_hub_ip_1_sector_ip_1_last_updated_time_-1",
    "isMultiKey" : false,
    "multiKeyPaths" : {
    "auid" : [ ],
    "hub_ip" : [ ],
    "sector_ip" : [ ],
    "last_updated_time" : [ ]
    },
    "isUnique" : false,
    "isSparse" : false,
    "isPartial" : false,
    "indexVersion" : 2,
    "direction" : "forward",
    "indexBounds" : {
    "auid" : [
    "["<1e000097>", "<1e000097>"]"
    ],
    "hub_ip" : [
    "["10.252.0.105", "10.252.0.105"]"
    ],
    "sector_ip" : [
    "["<1e000046>", "<1e000046>"]"
    ],
    "last_updated_time" : [
    "({}, "2016-12-24 05:49:00")"
    ]
    },
    "keysExamined" : 28788,
    "seeks" : 1,
    "dupsTested" : 0,
    "dupsDropped" : 0,
    "seenInvalidated" : 0
    }
    }
    },
    "serverInfo" : {
    "host" : "vnms",
    "port" : 27017,
    "version" : "4.0.5",
    "gitVersion" : "3739429dd92b92d1b0ab120911a23d50bf03c412"
    },
    "ok" : 1
    }


    Below is the mongostat data:



    insert query update delete getmore command dirty  used flushes vsize   res qrw arw  net_in    net_out conn                time
    *0 *0 *0 *0 0 3|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 254b 101k 7 Jan 23 10:20:41.082
    *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 134b 53.0k 7 Jan 23 10:20:42.261
    *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 147b 58.4k 7 Jan 23 10:20:43.329
    *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 138b 54.8k 7 Jan 23 10:20:44.469
    *0 *0 *0 *0 0 3|0 0.0% 79.9% 0 5.26G 3.52G 0|0 3|0 277b 81.9k 7 Jan 23 10:20:45.232
    *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 138b 54.8k 7 Jan 23 10:20:46.371









    share|improve this question



























      0












      0








      0








      MongoDB shell version v4.0.5 : Very Slow Query | Taking time in fetching | Data Size : 2-3 Million documents in a collection and there are around 13-15 such collections.



      System Conf:



      Architecture:          x86_64
      CPU op-mode(s): 32-bit, 64-bit
      Byte Order: Little Endian
      CPU(s): 6
      On-line CPU(s) list: 0-5
      Thread(s) per core: 1
      Core(s) per socket: 6
      Socket(s): 1
      NUMA node(s): 1
      Vendor ID: GenuineIntel
      CPU family: 6
      Model: 79
      Stepping: 1
      CPU MHz: 2097.570
      BogoMIPS: 4195.14
      Hypervisor vendor: VMware
      Virtualization type: full
      L1d cache: 32K
      L1i cache: 32K
      L2 cache: 256K
      L3 cache: 20480K
      NUMA node0 CPU(s): 0-5

      MemTotal: 16432268 kB


      I have done indexing on the tables and that is working fine but still, the system is taking a lot of time:



      Below is the query planner:



      db.vnms_vccells_5.find({auid:"<1e000097>",hub_ip:"10.252.0.105",sector_ip:"<1e000046>", last_updated_time:{$gt:"2016-12-24 05:49:00"}}).explain("executionStats")
      {
      "queryPlanner" : {
      "plannerVersion" : 1,
      "namespace" : "opennms.vnms_vccells_5",
      "indexFilterSet" : false,
      "parsedQuery" : {
      "$and" : [
      {
      "auid" : {
      "$eq" : "<1e000097>"
      }
      },
      {
      "hub_ip" : {
      "$eq" : "10.252.0.105"
      }
      },
      {
      "sector_ip" : {
      "$eq" : "<1e000046>"
      }
      },
      {
      "last_updated_time" : {
      "$gt" : "2016-12-24 05:49:00"
      }
      }
      ]
      },
      "winningPlan" : {
      "stage" : "FETCH",
      "inputStage" : {
      "stage" : "IXSCAN",
      "keyPattern" : {
      "auid" : 1,
      "hub_ip" : 1,
      "sector_ip" : 1,
      "last_updated_time" : -1
      },
      "indexName" : "auid_1_hub_ip_1_sector_ip_1_last_updated_time_-1",
      "isMultiKey" : false,
      "multiKeyPaths" : {
      "auid" : [ ],
      "hub_ip" : [ ],
      "sector_ip" : [ ],
      "last_updated_time" : [ ]
      },
      "isUnique" : false,
      "isSparse" : false,
      "isPartial" : false,
      "indexVersion" : 2,
      "direction" : "forward",
      "indexBounds" : {
      "auid" : [
      "["<1e000097>", "<1e000097>"]"
      ],
      "hub_ip" : [
      "["10.252.0.105", "10.252.0.105"]"
      ],
      "sector_ip" : [
      "["<1e000046>", "<1e000046>"]"
      ],
      "last_updated_time" : [
      "({}, "2016-12-24 05:49:00")"
      ]
      }
      }
      },
      "rejectedPlans" : [ ]
      },
      "executionStats" : {
      "executionSuccess" : true,
      "nReturned" : 28788,
      "executionTimeMillis" : 34989,
      "totalKeysExamined" : 28788,
      "totalDocsExamined" : 28788,
      "executionStages" : {
      "stage" : "FETCH",
      "nReturned" : 28788,
      "executionTimeMillisEstimate" : 34475,
      "works" : 28789,
      "advanced" : 28788,
      "needTime" : 0,
      "needYield" : 0,
      "saveState" : 1039,
      "restoreState" : 1039,
      "isEOF" : 1,
      "invalidates" : 0,
      "docsExamined" : 28788,
      "alreadyHasObj" : 0,
      "inputStage" : {
      "stage" : "IXSCAN",
      "nReturned" : 28788,
      "executionTimeMillisEstimate" : 7730,
      "works" : 28789,
      "advanced" : 28788,
      "needTime" : 0,
      "needYield" : 0,
      "saveState" : 1039,
      "restoreState" : 1039,
      "isEOF" : 1,
      "invalidates" : 0,
      "keyPattern" : {
      "auid" : 1,
      "hub_ip" : 1,
      "sector_ip" : 1,
      "last_updated_time" : -1
      },
      "indexName" : "auid_1_hub_ip_1_sector_ip_1_last_updated_time_-1",
      "isMultiKey" : false,
      "multiKeyPaths" : {
      "auid" : [ ],
      "hub_ip" : [ ],
      "sector_ip" : [ ],
      "last_updated_time" : [ ]
      },
      "isUnique" : false,
      "isSparse" : false,
      "isPartial" : false,
      "indexVersion" : 2,
      "direction" : "forward",
      "indexBounds" : {
      "auid" : [
      "["<1e000097>", "<1e000097>"]"
      ],
      "hub_ip" : [
      "["10.252.0.105", "10.252.0.105"]"
      ],
      "sector_ip" : [
      "["<1e000046>", "<1e000046>"]"
      ],
      "last_updated_time" : [
      "({}, "2016-12-24 05:49:00")"
      ]
      },
      "keysExamined" : 28788,
      "seeks" : 1,
      "dupsTested" : 0,
      "dupsDropped" : 0,
      "seenInvalidated" : 0
      }
      }
      },
      "serverInfo" : {
      "host" : "vnms",
      "port" : 27017,
      "version" : "4.0.5",
      "gitVersion" : "3739429dd92b92d1b0ab120911a23d50bf03c412"
      },
      "ok" : 1
      }


      Below is the mongostat data:



      insert query update delete getmore command dirty  used flushes vsize   res qrw arw  net_in    net_out conn                time
      *0 *0 *0 *0 0 3|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 254b 101k 7 Jan 23 10:20:41.082
      *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 134b 53.0k 7 Jan 23 10:20:42.261
      *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 147b 58.4k 7 Jan 23 10:20:43.329
      *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 138b 54.8k 7 Jan 23 10:20:44.469
      *0 *0 *0 *0 0 3|0 0.0% 79.9% 0 5.26G 3.52G 0|0 3|0 277b 81.9k 7 Jan 23 10:20:45.232
      *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 138b 54.8k 7 Jan 23 10:20:46.371









      share|improve this question
















      MongoDB shell version v4.0.5 : Very Slow Query | Taking time in fetching | Data Size : 2-3 Million documents in a collection and there are around 13-15 such collections.



      System Conf:



      Architecture:          x86_64
      CPU op-mode(s): 32-bit, 64-bit
      Byte Order: Little Endian
      CPU(s): 6
      On-line CPU(s) list: 0-5
      Thread(s) per core: 1
      Core(s) per socket: 6
      Socket(s): 1
      NUMA node(s): 1
      Vendor ID: GenuineIntel
      CPU family: 6
      Model: 79
      Stepping: 1
      CPU MHz: 2097.570
      BogoMIPS: 4195.14
      Hypervisor vendor: VMware
      Virtualization type: full
      L1d cache: 32K
      L1i cache: 32K
      L2 cache: 256K
      L3 cache: 20480K
      NUMA node0 CPU(s): 0-5

      MemTotal: 16432268 kB


      I have done indexing on the tables and that is working fine but still, the system is taking a lot of time:



      Below is the query planner:



      db.vnms_vccells_5.find({auid:"<1e000097>",hub_ip:"10.252.0.105",sector_ip:"<1e000046>", last_updated_time:{$gt:"2016-12-24 05:49:00"}}).explain("executionStats")
      {
      "queryPlanner" : {
      "plannerVersion" : 1,
      "namespace" : "opennms.vnms_vccells_5",
      "indexFilterSet" : false,
      "parsedQuery" : {
      "$and" : [
      {
      "auid" : {
      "$eq" : "<1e000097>"
      }
      },
      {
      "hub_ip" : {
      "$eq" : "10.252.0.105"
      }
      },
      {
      "sector_ip" : {
      "$eq" : "<1e000046>"
      }
      },
      {
      "last_updated_time" : {
      "$gt" : "2016-12-24 05:49:00"
      }
      }
      ]
      },
      "winningPlan" : {
      "stage" : "FETCH",
      "inputStage" : {
      "stage" : "IXSCAN",
      "keyPattern" : {
      "auid" : 1,
      "hub_ip" : 1,
      "sector_ip" : 1,
      "last_updated_time" : -1
      },
      "indexName" : "auid_1_hub_ip_1_sector_ip_1_last_updated_time_-1",
      "isMultiKey" : false,
      "multiKeyPaths" : {
      "auid" : [ ],
      "hub_ip" : [ ],
      "sector_ip" : [ ],
      "last_updated_time" : [ ]
      },
      "isUnique" : false,
      "isSparse" : false,
      "isPartial" : false,
      "indexVersion" : 2,
      "direction" : "forward",
      "indexBounds" : {
      "auid" : [
      "["<1e000097>", "<1e000097>"]"
      ],
      "hub_ip" : [
      "["10.252.0.105", "10.252.0.105"]"
      ],
      "sector_ip" : [
      "["<1e000046>", "<1e000046>"]"
      ],
      "last_updated_time" : [
      "({}, "2016-12-24 05:49:00")"
      ]
      }
      }
      },
      "rejectedPlans" : [ ]
      },
      "executionStats" : {
      "executionSuccess" : true,
      "nReturned" : 28788,
      "executionTimeMillis" : 34989,
      "totalKeysExamined" : 28788,
      "totalDocsExamined" : 28788,
      "executionStages" : {
      "stage" : "FETCH",
      "nReturned" : 28788,
      "executionTimeMillisEstimate" : 34475,
      "works" : 28789,
      "advanced" : 28788,
      "needTime" : 0,
      "needYield" : 0,
      "saveState" : 1039,
      "restoreState" : 1039,
      "isEOF" : 1,
      "invalidates" : 0,
      "docsExamined" : 28788,
      "alreadyHasObj" : 0,
      "inputStage" : {
      "stage" : "IXSCAN",
      "nReturned" : 28788,
      "executionTimeMillisEstimate" : 7730,
      "works" : 28789,
      "advanced" : 28788,
      "needTime" : 0,
      "needYield" : 0,
      "saveState" : 1039,
      "restoreState" : 1039,
      "isEOF" : 1,
      "invalidates" : 0,
      "keyPattern" : {
      "auid" : 1,
      "hub_ip" : 1,
      "sector_ip" : 1,
      "last_updated_time" : -1
      },
      "indexName" : "auid_1_hub_ip_1_sector_ip_1_last_updated_time_-1",
      "isMultiKey" : false,
      "multiKeyPaths" : {
      "auid" : [ ],
      "hub_ip" : [ ],
      "sector_ip" : [ ],
      "last_updated_time" : [ ]
      },
      "isUnique" : false,
      "isSparse" : false,
      "isPartial" : false,
      "indexVersion" : 2,
      "direction" : "forward",
      "indexBounds" : {
      "auid" : [
      "["<1e000097>", "<1e000097>"]"
      ],
      "hub_ip" : [
      "["10.252.0.105", "10.252.0.105"]"
      ],
      "sector_ip" : [
      "["<1e000046>", "<1e000046>"]"
      ],
      "last_updated_time" : [
      "({}, "2016-12-24 05:49:00")"
      ]
      },
      "keysExamined" : 28788,
      "seeks" : 1,
      "dupsTested" : 0,
      "dupsDropped" : 0,
      "seenInvalidated" : 0
      }
      }
      },
      "serverInfo" : {
      "host" : "vnms",
      "port" : 27017,
      "version" : "4.0.5",
      "gitVersion" : "3739429dd92b92d1b0ab120911a23d50bf03c412"
      },
      "ok" : 1
      }


      Below is the mongostat data:



      insert query update delete getmore command dirty  used flushes vsize   res qrw arw  net_in    net_out conn                time
      *0 *0 *0 *0 0 3|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 254b 101k 7 Jan 23 10:20:41.082
      *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 134b 53.0k 7 Jan 23 10:20:42.261
      *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 147b 58.4k 7 Jan 23 10:20:43.329
      *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 138b 54.8k 7 Jan 23 10:20:44.469
      *0 *0 *0 *0 0 3|0 0.0% 79.9% 0 5.26G 3.52G 0|0 3|0 277b 81.9k 7 Jan 23 10:20:45.232
      *0 *0 *0 *0 0 1|0 0.0% 80.0% 0 5.26G 3.52G 0|0 3|0 138b 54.8k 7 Jan 23 10:20:46.371






      query mongodb






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jan 23 at 11:20









      harrymc

      258k14270573




      258k14270573










      asked Jan 23 at 10:45









      Harshit JainHarshit Jain

      11




      11






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "3"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1397401%2fmongodb-shell-version-v4-0-5-very-slow-query%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Super User!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1397401%2fmongodb-shell-version-v4-0-5-very-slow-query%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Probability when a professor distributes a quiz and homework assignment to a class of n students.

          Aardman Animations

          Are they similar matrix