Cursor style pagination with timestamp + id with a filter on timestamp

Question

I have an events style table with enough data to be a problem, but nothing insane. I do need a bit of help the most appropriate index or query pattern for cursor based pagination, since I am finding myself a bit confused. I say "cursor style" here because all this is done in the API, and not actually PostgreSQL server side cursors.

The table is straightforward, but the id is not user visible (only uuid).

CREATE TABLE events (
    id              serial       primary key,
    uuid            uuid         not null default uuid_generate_v1(),
    location_id     int          not null,
    event_time      timestamp    not null,
    payload         jsonb        not null,
    ...
)

Queries against this table always use the following 3 critiera (rarely more). Due to the duplicates in the event_time field I have added the id to guarantee the order. The query itself has many joins for data, but not for filtering/ordering in this case.

WHERE
        location_id  = :building-id
    AND event_time  >= '2022-01-01...'::timestamptz
    AND event_time  <= '2022-12-31...'::timestamptz

I am working with an ORM so some of what is generated is outside of my control, and what is below reflects that.

I have come up with the following indexes and queries and want to ensure that I don't accidentally create some limit offset style issue as the cursor advances further through the records:

CREATE INDEX ix_loc_event_id ON events (
    location_id asc, 
    event_time desc, 
    id desc
)

SELECT * FROM events 
WHERE
        location_id  = 1
    AND event_time  >= {min date} 
    AND event_time  <= {max date}
    AND event_time  <  {cursor position} -- i hope the optimizer collapses these 2!
ORDER BY
    event_time DESC, id DESC

The second idea is to use only the ID as the ordering, since that is a guaranteed order, and also as the cursor position. This has some advantages, but I uncertain how this will affect the indexes since the event_time will always be part of the query.

WHERE
        location_id  = 1
    AND event_time  >= {min date} 
    AND event_time  <= {max date}
    AND id          <  {cursor position, decreasing}
ORDER BY
    id DESC