search

TaiBIF / camera-trap-api

RESTful API
6 stars 3 forks source link

Use collection scan. #138

Open kelp404 opened 5 years ago

kelp404 commented 5 years ago

記錄目前哪些 API 缺少索引。

kelp404 commented 5 years ago 
Mongoose:     117ms Users.find({ permission: 'administrator' }, {})
[ { queryPlanner:
     { plannerVersion: 1,
       namespace: 'cameraTrap.Users',
       indexFilterSet: false,
       parsedQuery: { permission: { '$eq': 'administrator' } },
       winningPlan:
        { stage: 'COLLSCAN',
          filter: { permission: { '$eq': 'administrator' } },
          direction: 'forward' },
       rejectedPlans: [] },
    executionStats:
     { executionSuccess: true,
       nReturned: 4,
       executionTimeMillis: 0,
       totalKeysExamined: 0,
       totalDocsExamined: 5,
       executionStages:
        { stage: 'COLLSCAN',
          filter: { permission: { '$eq': 'administrator' } },
          nReturned: 4,
          executionTimeMillisEstimate: 0,
          works: 7,
          advanced: 4,
          needTime: 2,
          needYield: 0,
          saveState: 0,
          restoreState: 0,
          isEOF: 1,
          invalidates: 0,
          direction: 'forward',
          docsExamined: 5 },
       allPlansExecution: [] },
    serverInfo:
     { host: 'ip-10-0-30-53',
       port: 27017,
       version: '4.0.2',
       gitVersion: 'fc1573ba18aee42f97a3bb13b67af7d837826b47' },
    ok: 1 } ]
[200]     497ms POST   /api/v1/data-fields