Re: EXISTS by itself vs SELECT EXISTS much slower in query.

Jimmy A writes: > I have two equivalent queries, one with an EXISTS clause by itself and one > wrapped in a (SELECT EXISTS) and the "naked" exists is much slower. > I would expect both to be the same speed / have same execution plan. That is a dangerous assumption. In general, wrapping (SELECT .

Re: EXISTS by itself vs SELECT EXISTS much slower in query.

postgresql 14, linux with: CREATE TABLE child(child_id bigint generated always as identity PRIMARY KEY, parent_id bigint references parent(parent_id), name text); CREATE TABLE child(child_id bigint generated always as identity PRIMARY KEY, parent_id bigint references parent(parent_id), name text);

EXISTS by itself vs SELECT EXISTS much slower in query.

A description of what you are trying to achieve and what results you expect.: I have two equivalent queries, one with an EXISTS clause by itself and one wrapped in a (SELECT EXISTS) and the "naked" exists is much slower. I would expect both to be the same speed / have same execution plan. -- slow