<p>Now with 100k table entries, explain result look a bit more like announced before:</p>
<pre><code>explain verbose select count(user_id) from changesets where user_id = 1220430 and created_at < '2019-04-08 16:56:26.117157';
                                                                  QUERY PLAN                                                                  
----------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=4.44..4.45 rows=1 width=8)
   Output: count(user_id)
   ->  Index Only Scan using changesets_user_id_created_at_idx on public.changesets  (cost=0.42..4.44 rows=1 width=8)
         Output: user_id, created_at
         Index Cond: ((changesets.user_id = 1220430) AND (changesets.created_at < '2019-04-08 16:56:26.117157'::timestamp without time zone))

</code></pre>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/issues/2224?email_source=notifications&email_token=AAK2OLJUZEVXDNQPDIVUZP3PVRF65A5CNFSM4HMPOK62YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVPO6FY#issuecomment-492760855">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLOINGBZZX2PSZFUR6DPVRF65ANCNFSM4HMPOK6Q">mute the thread</a>.<img src="https://github.com/notifications/beacon/AAK2OLOAKTCGSJZJHJHY6OTPVRF65A5CNFSM4HMPOK62YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVPO6FY.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/openstreetmap-website/issues/2224?email_source=notifications\u0026email_token=AAK2OLJUZEVXDNQPDIVUZP3PVRF65A5CNFSM4HMPOK62YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVPO6FY#issuecomment-492760855",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/2224?email_source=notifications\u0026email_token=AAK2OLJUZEVXDNQPDIVUZP3PVRF65A5CNFSM4HMPOK62YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVPO6FY#issuecomment-492760855",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>