[openstreetmap/openstreetmap-website] Serve only trackable and identifiable points and add cursor pagination to the trackpoints API (PR #7322)

[Ruben L. Mendoza]

Rub21 left a comment (openstreetmap/openstreetmap-website#7322)

> I ran [one of the explains on prod](https://explain.depesz.com/s/DdUe) but I'm it looks like it needs a suitable gpx_id from prod as well. A backward index scan probably makes little sense in most cases. Could you provide a query to run EXPLAIN ANALYZE on?

You are right, Postgres picks a different plan on each environment, and my test database is small enough that it picks a different one than prod. I rewrote the queries so they do not depend on any id from my database, the cursor is read from prod itself. I tested them locally, so you can check if they work on prod: https://gist.github.com/Rub21/9a7de2ea8d5e3d26ea4a4093f2e57911 is the explained one, page 1 and page 2, and https://gist.github.com/Rub21/9d806cc5944eb1d1a6911382028a0fb7 goes up to page 10.



-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/7322#issuecomment-5398592260
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/7322/c5398592260 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20260824/d30dc9b7/attachment.htm>