On 3/15/23 08:17, Arthur Ramsey wrote: > I've upgraded from 12.11 to 15.2 and I'm seeing this query now use a > sequential scan which is taking 500ms instead of < 2ms. If I disable > sequential scans then it performs as well as 12.11.
Did you run ANALYZE on the database/table in the new 15.2 instance?