ANALYZE pg_class; doesn't help also, query is from "Hasura", so I don't have much room to maneuver
On Tue, 21 May 2024 at 16:18, Tom Lane <t...@sss.pgh.pa.us> wrote: > =?UTF-8?B?U2HFoW8gR2FudGFy?= <saso...@gmail.com> writes: > > thanks for the info, but is there any solution, given that it's system > > tables? > > Given the complexity of the query, I wonder if you're running into > problems with join_collapse_limit/from_collapse_limit preventing > the planner from considering all options. > > Also, as David already mentioned, ANALYZE on pg_class might help. > > regards, tom lane >
