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>
Subject: Re: PostgreSQL 15-->18 slowdown?
In-reply-to: <7F4F161B-CD44-4686-A49B-C1C466A66951@alaska.edu>
References: <4A6D9280-1409-42A8-9A1F-99E2A558E2BB@alaska.edu>
 <CAG8sLzuG6wwUR3XmMDQtvUWk3DCQNL2Zq-OLCx_PnOarskbUdg@mail.gmail.com>
 <7F4F161B-CD44-4686-A49B-C1C466A66951@alaska.edu>
Comments: In-reply-to Israel Brewster <ijbrewster@alaska.edu>
	message dated "Fri, 26 Jun 2026 10:16:14 -0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1207570.1782499465.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 26 Jun 2026 14:44:25 -0400
Message-ID: <1207571.1782499465@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1207571.1782499465%40sss.pgh.pa.us>
Precedence: bulk

Israel Brewster <ijbrewster@alaska.edu> writes:

>          SubPlan 1
>            ->  Limit  (cost=3D0.00..0.48 rows=3D1 width=3D1)
>                  ->  Nested Loop  (cost=3D0.00..13833793.79 rows=3D29105=
774 width=3D1)
>                        ->  Seq Scan on tilt_data  (cost=3D0.00..13469970=
.40 rows=3D29105774 width=3D16)
>                              Filter: (station =3D stations.id)
>                        ->  Materialize  (cost=3D0.00..1.22 rows=3D1 widt=
h=3D16)
>                              ->  Seq Scan on tilt_orientation  (cost=3D0=
.00..1.21 rows=3D1 width=3D16)
>                                    Filter: (station =3D stations.id)

Can you show us the EXPLAIN output for this part of the plan in v15?

			regards, tom lane