explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kg5o

Settings
# exclusive inclusive rows x rows loops node
1. 2,626.387 2,626.387 ↑ 1.5 2,432,481 1

Seq Scan on sale sale (cost=0..216,357.89 rows=3,644,474 width=16) (actual time=0.105..2,626.387 rows=2,432,481 loops=1)

  • Filter: (NOT upper_inf(sale.active_range))
  • Buffers: shared hit=16029 read=131995 dirtied=15081 written=13895