Trying to _really_ understand the postgres query planner's `EXPLAIN` output. We have long-running embarrassingly parallel processes where the throughput will sometimes completely tank. Got worse when we upgraded to PG16.
Trying to compare good query plans with bad ones, and then work out what changes we need to make to the slow queries is ... interesting.
Trying to compare good query plans with bad ones, and then work out what changes we need to make to the slow queries is ... interesting.