[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