Hey guys, I struggle to understand why my query is...
# sql
b
Hey guys, I struggle to understand why my query is slow :
Copy code
sql
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? 😦