<blockquote>
<p>nb: changeset metadata call is currently in CGImap land (e.g. <a href="https://api.openstreetmap.org/api/0.6/changeset/12" rel="nofollow">https://api.openstreetmap.org/api/0.6/changeset/12</a>). If there's some consensus here, can you please also open up an issue in the cgimap repo?</p>
<p>What about changeset replication on <a href="https://planet.openstreetmap.org/replication/changesets" rel="nofollow">https://planet.openstreetmap.org/replication/changesets</a>?</p>
</blockquote>
<p>Yep, when we nail down the details here, we'll roll it out to the other things that read directly from the database (like cgimap and replication).</p>
<blockquote>
<p>We already have a secondary index on fields user_id and created_at for the changesets table.</p>
</blockquote>
<p>I'm not sure why your example used the <code>changesets_created_at_idx</code> instead of the <code>changesets_user_id_created_at_idx</code>? Maybe it's just postgres not caring because there's not enough data in that db?</p>
<p>A challenge will be figuring out a nice way to make this available in the rails models as an attribute for the changeset.</p>

<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=AAK2OLLHY42RF2ULJUBI5T3PVJZKVA5CNFSM4HMPOK62YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVKVBZY#issuecomment-492130535">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLPXZM5ANCVOFBVKTWDPVJZKVANCNFSM4HMPOK6Q">mute the thread</a>.<img src="https://github.com/notifications/beacon/AAK2OLMM45L4Z7V3TO2PWGLPVJZKVA5CNFSM4HMPOK62YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVKVBZY.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=AAK2OLLHY42RF2ULJUBI5T3PVJZKVA5CNFSM4HMPOK62YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVKVBZY#issuecomment-492130535",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/2224?email_source=notifications\u0026email_token=AAK2OLLHY42RF2ULJUBI5T3PVJZKVA5CNFSM4HMPOK62YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVKVBZY#issuecomment-492130535",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>