---
# System prepended metadata

title: JR mongo slow query (超過三秒以上) 2022-02-23

---

# JR mongo slow query (超過三秒以上) 2022-02-23


- PMS0110041ChangeLog： 最長194.524
``"command": {
      "find": "PMS0110041ChangeLog",
      "filter": {
        "athena_id": 150,
        "ikey": {
          "$regex": ".*00019236.*"
        }
      },
      "sort": {
        "trans_dat": -1
      },
      "projection": {},
      "limit": 1000,
      "lsid": {
        "id": {
          "$binary": {
            "base64": "LH0R00f4RQqugiY2rl8sTQ==",
            "subType": "04"
          }
        }
      },
      "$db": "bacchus"
    }``
    
- bacchus.ScanInfo: 最長92.356
``"command": {
      "findAndModify": "ScanInfo",
      "query": {
        "gcust_cod": "HFD000000003065301",
        "pic_nam": "id_f"
      },
      "remove": true,
      "new": false,
      "upsert": false,
      "fields": {},
      "lsid": {
        "id": {
          "$binary": {
            "base64": "jvwfrlNaSnSYuGQ169lyyg==",
            "subType": "04"
          }
        }
      }``
- bacchus.AdminApiLog (op: remove): 最長72.962
   `` "command": {
      "q": {
        "$or": [
          {
            "ins_dat": {
              "$lte": "2022-01-23"
            }
          },
          {
            "time": {
              "$lte": "2022-01-23"
            }
          }
        ]
      },
      "limit": 0
      }``
      
      
- bacchus.LogsAPI (op: remove): 最長8.769
``    "command": {
      "q": {
        "ins_datetime": {
          "$lte": "2022/01/23"
        }
      },
      "limit": 0
    },
    "millis": 8769
  }``