By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
setseed |
---|
SELECT 1
CREATE TABLE
INSERT 0 200000
CREATE INDEX
CREATE INDEX
CREATE INDEX
VACUUM
QUERY PLAN |
---|
Limit (cost=6.41..1481.91 rows=426 width=59) (actual time=0.810..0.811 rows=0 loops=1) |
Output: products.id, products.created_at, products.name |
-> Nested Loop (cost=6.41..1481.91 rows=426 width=59) (actual time=0.809..0.810 rows=0 loops=1) |
Output: products.id, products.created_at, products.name |
-> HashAggregate (cost=6.41..8.41 rows=200 width=32) (actual time=0.200..0.251 rows=426 loops=1) |
Output: (unnest(ARRAY[(random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text])) |
Group Key: unnest(ARRAY[(random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text]) |
Batches: 1 Memory Usage: 77kB |
-> ProjectSet (cost=0.00..5.34 rows=426 width=32) (actual time=0.070..0.103 rows=426 loops=1) |
Output: unnest(ARRAY[(random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text]) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1) |
-> Index Scan using product_id_idx2 on public.products (cost=0.00..7.36 rows=1 width=59) (actual time=0.001..0.001 rows=0 loops=426) |
Output: products.id, products.created_at, products.name |
Index Cond: (products.id = (unnest(ARRAY[(random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text]))) |
Planning Time: 1.116 ms |
Execution Time: 0.986 ms |
EXPLAIN