Mongdb slow query analysis, what went wrong? - Codes Helper - Programming Question Answer

Mongdb slow query analysis, what went wrong?

{
  "op": "query",
  "ns": "fund_statistic.fund_minute_statistic_collection1588",
  "command": {
    "find": "fund_minute_statistic_collection1588",
    "filter": {
      "time": {
        "$gte": 1531868400,
        "$lt": 1531887084
      }
    },
    "$db": "fund_statistic",
    "$readPreference": {
      "mode": "primaryPreferred"
    },
    "lsid": {
      "id": UUID(
      "f0a2ea9e-f8a4-484f-86cc-d01d04ebea3e"
      )
    }
  },
  "cursorid": NumberLong(
  "119871802965176"
  ),
  "keysExamined": 101,
  "docsExamined": 101,
  "numYield": 1,
  "locks": {
    "Global": {
      "acquireCount": {
        "r": NumberLong(4)
      }
    },
    "Database": {
      "acquireCount": {
        "r": NumberLong(2)
      }
    },
    "Collection": {
      "acquireCount": {
        "r": NumberLong(2)
      }
    }
  },
  "nreturned": 101,
  "responseLength": 7185,
  "protocol": "op_msg",
  "millis": 8960,
  "planSummary": "IXSCAN { time: 1 }",
  "execStats": {
    "stage": "FETCH",
    "nReturned": 101,
    "executionTimeMillisEstimate": 119,
    "works": 101,
    "advanced": 101,
    "needTime": 0,
    "needYield": 0,
    "saveState": 2,
    "restoreState": 1,
    "isEOF": 0,
    "invalidates": 0,
    "docsExamined": 101,
    "alreadyHasObj": 0,
    "inputStage": {
      "stage": "IXSCAN",
      "nReturned": 101,
      "executionTimeMillisEstimate": 119,
      "works": 101,
      "advanced": 101,
      "needTime": 0,
      "needYield": 0,
      "saveState": 2,
      "restoreState": 1,
      "isEOF": 0,
      "invalidates": 0,
      "keyPattern": {
        "time": NumberLong(1)
      },
      "indexName": "time_1",
      "isMultiKey": false,
      "multiKeyPaths": {
        "time": []
      },
      "isUnique": false,
      "isSparse": false,
      "isPartial": false,
      "indexVersion": 2,
      "direction": "forward",
      "indexBounds": {
        "time": [
          "[1531868400, 1531887084)"
        ]
      },
      "keysExamined": 101,
      "seeks": 1,
      "dupsTested": 0,
      "dupsDropped": 0,
      "seenInvalidated": 0
    }
  },
  "ts": ISODate(
  "2018-07-18T04:11:33.487Z"
  ),
  "client": "192.168.10.81",
  "allUsers": [],
  "user": ""
}

Mar.28,2021

you may not have indexed the time field. Without indexing, the query is linear. It takes a long time to traverse the entries in the database.
see if db.collection.getIndexes () can get your current cache list.
if not, and this business scenario is more common, you can index the time field db.collection.createIndex ({time: 1})

Previous: On the problem that the output of self-executing function definition function declaration result is undefined

Next: Set up multiple git accounts on the same client

Mongodb update level 3 or above cannot be deleted
Project.updateOne(r, { $pull: { thunder2: { files: { _id: "5ab362d446f15936bcea7dd3" } } } }, function(err, data) { if (err) { res.send("") } else { ...

Mongodb

Feb.26,2021
How to add mongodb service under Windows 10?
the previous command is as follows: mongod --logpath C: mydatabase logs.txt --logappend --dbpath C: mydatabase --serviceName MongoDB --install however, there is no prompt on the command line after entering the carriage enter, and the service has ...

Windows10 mongodb

Feb.26,2021
How does php MongoDB turn ObjectId into string
the query data is printed to see that _ id is objectID,. If it is directly converted to json,_id, it will be empty. Can you change objectID to string, and then to json? ...

Mongodb php

Feb.26,2021
What is the Virtual of mongoose?
Virtual properties are document properties that you can get and set but that do not get persisted to MongoDB. I don t quite understand this sentence. Please do not translate. I hope you can explain it in your own words. It is better to have examples. ...

Mongodb mongoose

Feb.26,2021
It is invalid for MongoDB, to use the configuration file to modify the database path?!
first of all, according to the description of the official document, the configuration file is created and the database path is modified. The content of the configuration file mongo.config is as follows: systemLog: destination: file path: I: ...

Mongodb

Feb.26,2021
Mongodb cannot be started under mac
suddenly became interested in mongodb, installed and started with brew according to the rookie tutorial, but showed "waiting for connections on port 27017 " for a long time, then as a front-end younger brother who still has a narrow range of knowle...

Node.js javascript mongodb

Feb.27,2021
What is the difference in the way mongodb starts?
Mode 1: mongod Command Mode 2: brew services start mongodb Command start what s the difference between the two ways of starting? why are there two ways? ...

Node.js mongodb

Feb.27,2021
About mongodb doing document management?
the company recently has a project, the main function is to manage documents, such as on the web page to view the contents of the document, and can be modified, you can also download the document to export in word format, the most important thing is to r...

Mongodb

Feb.27,2021
Mongdb 90,000,000 data query fetches
assume a single document type: { "_id" : ObjectId("5a19403b421aa92332bc2b32"), "id" : "95957f4a9eab11e787f1509a4c4be0cd" "incre" :1 "city" "" } data volume, 90 mill...

Mongodb

Feb.27,2021
Explain this custom mongoose schema method
var animalSchema = new Schema({ name: String, type: String }); animalSchema.methods.findSimilarTypes = function(cb) { return this.model( Animal ).find({ type: this.type }, cb); }; var Animal = mongoose.model( Animal , animalSchema); var dog = new A...

Mongodb mongoose

Feb.27,2021
MongoDB link failed mongo "exception: connect failed"
the computer is a WIN 10 system I follow this tutorial to install mongoDB, http: www.runoob.com mongodb. but as soon as you enter the mongo link. Just report this error has been reinstalled several times, but it has not been solved. also chan...

Mongod mongodb

Feb.27,2021
Can't connect to the server's mongdb database!
ip and port are OK on the server! bind_ip 0.0.0.0 ip ask the boss to have a look. No, no, no. It s okay to pay for an answer! ...

Linux mongodb node.js

Feb.28,2021
How to use mongodb for ifelse Operation in spring boot
data stores a field type (as an enumeration). When querying, it needs to be processed separately by using ifelse or switch, for example, 1 is converted to normal. I ve implemented it with the MongoDB statement, but how do I handle it in the springboot ...

Java mongodb spring

Feb.28,2021
How does mongodb use aggregate to count the total number of non-duplicated fields in a group?
there is data like this: I want to use aggregate to group group by p, and then count the sum of ac, cc in each province, which can be done. The question is: I want to count the total number of tc in each province (do not repeat)? For example, Fujia...

Mongodb

Feb.28,2021
Whether the mongodb replication set can be taken from the disk and taken out separately to make a new mongodb server.
I tried to do this, but could not copy set initialization. ...

Mongodb

Feb.28,2021
Python uses pymongo to connect to the local database prompt to actively reject?
the problem is like a question. I ll describe the details in detail. asked the same question on Zhihu when I was self-taught python crawler, I came into contact with MongoDB, to install according to the URL given by rookie tutorial . Visual obser...

Nosql python3.x mongodb

Feb.28,2021
A subset of a subset of mongoose queries
first of all, the models of my mongoose is as follows: var clubsSchema = new mongoose.Schema({ "clubCreatetime": String, "clubCreater": String, "clubName": String, "clubDescription": String, &...

Mongodb mongoose

Feb.28,2021
The loop of cursor in pyMongo is very slow, is there any effective way to solve it?
there are 200000 data in the data, and each data has a typical list of words of 5000 length [{aVl1}, {bju 2},.], and typical dictionaries of 5000 length {{aRom 1}, {bjr 2},.}, use pyMongo to find100 data, the traversal of cursor is particularly slow, is...

Python mongodb pymongo database database-performance-optimization

Feb.28,2021
What is mongoose streaming??
You can stream query results from MongoDB. You need to call the Query-sharpcursor () function to return an instance of QueryCursor. Please do not translate directly. I want to know what cursor is and what stream is, and why I use it, thank you! ...

Mongodb mongoose

Feb.28,2021
Ask mongodb this kind of nosql database design, are there any basic principles?
mongodb doesn t seem to have the join functionality of sql. Reducing the redundancy of individual tables does not seem to make sense and affects query efficiency. and mongodb also has storage formats such as lists, which can achieve different function...

Mongodb

Feb.28,2021

Menu