Roger Hunwicks <roger@tonic-solutions.com> writes:
> ...
> However, even though we have similar performance for 12.4 for most
> test runs, it remains very variable.
> ...
> I think we have narrowed down the problem to a single, very complex,
> materialized view using CTEs; the unit tests create the test data and
> then refresh the materialized view before executing the actual test
> code.
In addition to others' nearby comments, I'd suggest that running all this
under auto_explain would be informative. You evidently are not getting a
stable plan for your troublesome query, so you need to see what the range
of plans is, not just probe it once with a manual EXPLAIN.
regards, tom lane