explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yZhB

Settings
# exclusive inclusive rows x rows loops node
1. 6,330.331 6,330.331 ↓ 1.1 3,836,518 1

Seq Scan on sale sale (cost=0..216,398.88 rows=3,646,660 width=16) (actual time=0.013..6,330.331 rows=3,836,518 loops=1)

  • Filter: (NOT upper_inf(sale.active_range))
  • Buffers: shared hit=171 read=147853 dirtied=2