In the 'not exists' cluster, you do not have to search table "Vacancy as v" again.I think it would be faster to use the outer Vacancy table as below.In your case, that do the same work. NOT EXISTS ( SELECT 1 FROM "CategoryOption_TableRow" "ct126" WHERE "Vacancy"."Template" AND "ct126"."CategoryOptionID" IN (34024,35254,35255,35256) AND "ct126"."Category_TableID" = 126 AND "ct126"."RowID" = "Vacancy"."ID" )If you reply to this email, your message will be added to the discussion below:http://postgresql.nabble.com/Slow-Query-tp5861835p5862008.html To unsubscribe from Slow Query, click here.NAML
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных