Arvind K

Arvind K

  • NA
  • 43
  • 5.7k

how to optimize the query

Sep 25 2022 8:43 AM

I just tested it myself:

WITH arr AS (
  SELECT array_agg((random()*18000000)::bigint) AS id FROM generate_series(0, 10000)
  ) SELECT * FROM arr
    JOIN foxo.file ON file.id = ANY(arr.id)

Query complete 00:01:13.853


Answers (1)