[openstreetmap/openstreetmap-website] Give the changesets_count in changeset metadata (#2224)
mmd
notifications at github.com
Wed May 15 18:03:26 UTC 2019
Now with 100k table entries, explain result look a bit more like announced before:
```
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))
```
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/2224#issuecomment-492760855
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20190515/1406fc0f/attachment.html>
More information about the rails-dev
mailing list