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?
regards, tom lane
