baptisteArno
06/28/2022, 9:47 AMsql
begin;
explain (analyze,buffers,timing)
SELECT "public"."Typebot"."id",
"public"."Typebot"."workspaceId"
FROM "public"."Typebot"
WHERE ("public"."Typebot"."id") NOT IN (
SELECT "t0"."id"
FROM "public"."Typebot" AS "t0"
INNER JOIN "public"."Result" AS "j0" ON ("j0"."typebotId") = ("t0"."id")
WHERE (
(
NOT (
"j0"."createdAt" >= '2022-05-31 22:00:00 UTC'
AND "j0"."createdAt" <= '2022-06-29 22:00:00 UTC'
)
)
AND "t0"."id" IS NOT NULL
)
)
ORDER BY "public"."Typebot"."id" ASC
LIMIT 100 OFFSET 0;
rollback;
Here is the output: https://gist.github.com/baptisteArno/19f3939a428ec0ee25a64611345a6002
I'm not sure how to interpret this? 😦