Horton
Menu

Re: PostgreSQL 15-->18 slowdown?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Israel Brewster <ijbrewster@alaska.edu>
Cc: Ruben Morais <ruben.gmorais@gmail.com>, PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2026-06-26T18:44:25Z
Lists: pgsql-general 
Israel Brewster <ijbrewster@alaska.edu> 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