| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Israel Brewster <ijbrewster(at)alaska(dot)edu> |
| Cc: | Ruben Morais <ruben(dot)gmorais(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 15-->18 slowdown? |
| Date: | 2026-06-26 18:44:25 |
| Message-ID: | 1207571.1782499465@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Israel Brewster <ijbrewster(at)alaska(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Israel Brewster | 2026-06-26 18:55:00 | Re: PostgreSQL 15-->18 slowdown? |
| Previous Message | Adrian Klaver | 2026-06-26 18:40:09 | Re: PostgreSQL 15-->18 slowdown? |