> On Jun 26, 2026, at 10:44 AM, Tom Lane <[email protected]> wrote: > > Israel Brewster <[email protected]> writes: > >> SubPlan 1 >> -> Limit (cost=0.00..0.48 rows=1 width=1) >> -> Nested Loop (cost=0.00..13833793.79 rows=29105774 >> width=1) >> -> Seq Scan on tilt_data (cost=0.00..13469970.40 >> rows=29105774 width=16) >> Filter: (station = stations.id) >> -> Materialize (cost=0.00..1.22 rows=1 width=16) >> -> Seq Scan on tilt_orientation >> (cost=0.00..1.21 rows=1 width=16) >> Filter: (station = stations.id) > > Can you show us the EXPLAIN output for this part of the plan in v15?
I wish I could - I was wanting to see that myself. Unfortunately, I upgraded to 18 using —link, so by the time I discovered this issue, I had no way to go back to 15 (other than restoring from backups or the like), at least to the best of my knowledge. --- Israel Brewster Software Engineer Alaska Volcano Observatory Geophysical Institute - UAF 2156 Koyukuk Drive Fairbanks AK 99775-7320 Work: 907-474-5172 cell: 907-328-9145 > > regards, tom lane
