Query perf when getting items within a time range along with further n items beyond the range

Hello @ianf

It would be worth you sharing the EXPLAIN for the slow queries, you can format it nicely at https://explain.depesz.com/ There’s a discussion on query filtering here, too, for you to just check through SQL query filtering best practices

Once we have an EXPLAIN then I’ll see if I can get someone else to cast :eyes:

1 Like