This was true for ES < 2.0. New indices created on 2.0 and onwards the second phase is linear to the amount of parent docs that match with the rest of the query. In your case that are documents that match with the term query on the instagram_post_id field. How many documents do match this term query? If that number is small then I do expect reasonable performance.