2018-08-09T20:18:16.168+0000 D QUERY    [conn39699] Tagging the match expression according to cache data:
Filter:
$and
    feed_id $eq "abcdefg"
    timestamps.article_timestamps.first_article_published $lte new Date(1531754990084)
    timestamps.article_timestamps.first_article_published $gte new Date(1531668590084)
    score exists
    timestamps.cluster_timestamps.summary_last_updated exists
    $not
        deleted $eq true
Cache data:
(index-tagged expression tree: tree=Node
---Leaf feed_id.first_article_published.score-1.summary_last_updated.deleted, pos: 0, can combine? 1
---Leaf feed_id.first_article_published.score-1.summary_last_updated.deleted, pos: 1, can combine? 1
---Leaf feed_id.first_article_published.score-1.summary_last_updated.deleted, pos: 1, can combine? 1
---Leaf feed_id.first_article_published.score-1.summary_last_updated.deleted, pos: 2, can combine? 1
---Leaf feed_id.first_article_published.score-1.summary_last_updated.deleted, pos: 3, can combine? 1
---Node
------Leaf feed_id.first_article_published.score-1.summary_last_updated.deleted, pos: 4, can combine? 1
)
2018-08-09T20:18:16.168+0000 D QUERY    [conn39699] Index 0: feed_id_1_active_1__id_-1
2018-08-09T20:18:16.168+0000 D QUERY    [conn39699] Index 1: feed_id_1_score_1_last_updated_at_1_deleted_1
2018-08-09T20:18:16.168+0000 D QUERY    [conn39699] Index 2: _id_
2018-08-09T20:18:16.168+0000 D QUERY    [conn39699] Index 3: feed_id_1_timestamps.cluster_timestamps.created_1
2018-08-09T20:18:16.168+0000 D QUERY    [conn39699] Index 4: feed_id_1_score_-1_timestamps.article_timestamps.latest_article_published_1_deleted_1
2018-08-09T20:18:16.168+0000 D QUERY    [conn39699] Index 5: timestamps.article_timestamps.latest_article_published_-1_feed_id_1_deleted_1
2018-08-09T20:18:16.168+0000 D QUERY    [conn39699] Index 6: feed_id_1_timestamps.cluster_timestamps.summary_last_updated_-1
2018-08-09T20:18:16.168+0000 D QUERY    [conn39602] Using idhack: { _id: ObjectId('5b6ae31428c7eb00012c474c') }
2018-08-09T20:18:16.168+0000 D QUERY    [conn39699] Index 7: feed_id_1_score_-1_timestamps.cluster_timestamps.last_updated_-1_deleted_1
2018-08-09T20:18:16.169+0000 D QUERY    [conn39699] Index 8: feed_id_1_active_1
2018-08-09T20:18:16.169+0000 D QUERY    [conn39699] Index 9: feed_id_1
2018-08-09T20:18:16.169+0000 D QUERY    [conn39699] Index 10: feed_id.first_article_published.score-1.summary_last_updated.deleted
2018-08-09T20:18:16.169+0000 D QUERY    [conn39699] Tagged tree:
$and
    feed_id $eq "abcdefg"  || Selected Index #10 pos 0 combine 1
    $not
        deleted $eq true  || Selected Index #10 pos 4 combine 1
    timestamps.article_timestamps.first_article_published $lte new Date(1531754990084)  || Selected Index #10 pos 1 combine 1
    timestamps.article_timestamps.first_article_published $gte new Date(1531668590084)  || Selected Index #10 pos 1 combine 1
    score exists  || Selected Index #10 pos 2 combine 1
    timestamps.cluster_timestamps.summary_last_updated exists  || Selected Index #10 pos 3 combine 1
2018-08-09T20:18:16.169+0000 D QUERY    [conn39699] Planner: solution constructed from the cache:
FETCH
---filter:
        $and
            score exists  || Selected Index #10 pos 2 combine 1
            timestamps.cluster_timestamps.summary_last_updated exists  || Selected Index #10 pos 3 combine 1
---fetched = 1
---sortedByDiskLoc = 0
---getSort = [{ feed_id: 1 }, { feed_id: 1, timestamps.article_timestamps.first_article_published: 1 }, { feed_id: 1, timestamps.article_timestamps.first_article_published: 1, score: -1 }, { feed_id: 1, timestamps.article_timestamps.first_article_published: 1, score: -1, timestamps.cluster_timestamps.summary_last_updated: 1 }, { feed_id: 1, timestamps.article_timestamps.first_article_published: 1, score: -1, timestamps.cluster_timestamps.summary_last_updated: 1, deleted: 1 }, { timestamps.article_timestamps.first_article_published: 1 }, { timestamps.article_timestamps.first_article_published: 1, score: -1 }, { timestamps.article_timestamps.first_article_published: 1, score: -1, timestamps.cluster_timestamps.summary_last_updated: 1 }, { timestamps.article_timestamps.first_article_published: 1, score: -1, timestamps.cluster_timestamps.summary_last_updated: 1, deleted: 1 }, ]
---Child:
------IXSCAN
---------indexName = feed_id.first_article_published.score-1.summary_last_updated.deleted
keyPattern = { feed_id: 1.0, timestamps.article_timestamps.first_article_published: 1.0, score: -1.0, timestamps.cluster_timestamps.summary_last_updated: 1.0, deleted: 1.0 }
---------direction = 1
---------bounds = field #0['feed_id']: ["abcdefg", "abcdefg"], field #1['timestamps.article_timestamps.first_article_published']: [new Date(1531668590084), new Date(1531754990084)], field #2['score']: [MaxKey, MinKey], field #3['timestamps.cluster_timestamps.summary_last_updated']: [MinKey, MaxKey], field #4['deleted']: [MinKey, true), (true, MaxKey]
---------fetched = 0
---------sortedByDiskLoc = 0
---------getSort = [{ feed_id: 1 }, { feed_id: 1, timestamps.article_timestamps.first_article_published: 1 }, { feed_id: 1, timestamps.article_timestamps.first_article_published: 1, score: -1 }, { feed_id: 1, timestamps.article_timestamps.first_article_published: 1, score: -1, timestamps.cluster_timestamps.summary_last_updated: 1 }, { feed_id: 1, timestamps.article_timestamps.first_article_published: 1, score: -1, timestamps.cluster_timestamps.summary_last_updated: 1, deleted: 1 }, { timestamps.article_timestamps.first_article_published: 1 }, { timestamps.article_timestamps.first_article_published: 1, score: -1 }, { timestamps.article_timestamps.first_article_published: 1, score: -1, timestamps.cluster_timestamps.summary_last_updated: 1 }, { timestamps.article_timestamps.first_article_published: 1, score: -1, timestamps.cluster_timestamps.summary_last_updated: 1, deleted: 1 }, ]
2018-08-09T20:18:16.170+0000 D QUERY    [conn39714] Using idhack: { _id: ObjectId('5b69ae14abce6c0001d7884c') }
2018-08-09T20:18:16.170+0000 D QUERY    [conn39637] Using idhack: { _id: ObjectId('5b6c2caaabce6c0001d9ba48') }
2018-08-09T20:18:16.171+0000 D QUERY    [conn39538] Using idhack: query: { _id: { id: UUID("23829fed-8e1a-41cd-95ee-030f84ba07f7"), uid: BinData(0, 34C9C24E99D4CB0DB633877D77657AE38E3A5B245A4BA3BA06498398A7298241) } } sort: {} projection: {} ntoreturn=1