Apologies for the sloppiness!
> Postgres version(s)?
x: Aurora PostgreSQL 11.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC)
4.9.3, 64-bit (RDS)
y: PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg19.10+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 9.2.1-9ubuntu2) 9.2.1 20191008, 64-bit (GCP)
>
> Without the actual query and EXPLAIN ANALYZE on it this will be
> difficult to answer with any detail.
>
> Also would be nice to have the table schema.
>
Here's the query, schema and the EXPLAIN ANALYZE
query: https://gist.github.com/mewwts/704663e19a21bc51864f3298f09a18c0
plan: https://explain.depesz.com/s/RQFQ
Best,
--
Mats
CTO @ Dune Analytics
We're hiring: https://careers.duneanalytics.com