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
