explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sZr0

Settings
# exclusive inclusive rows x rows loops node
1. 16.407 16.407 ↓ 5.6 39,465 1

Seq Scan on seqpk (cost=0.00..2,560.85 rows=6,998 width=8) (actual time=0.011..16.407 rows=39,465 loops=1)

  • Filter: (((col2)::double precision >= (random() * '500'::double precision)) AND ((col2)::double precision <= ('500'::double precision + (random() * '1000'::double precision))))