explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YXEs

Settings
# exclusive inclusive rows x rows loops node
1. 4,584.343 4,584.343 ↑ 7.1 510,522 1

Seq Scan on sale sale (cost=0..216,317.62 rows=3,642,327 width=16) (actual time=0.012..4,584.343 rows=510,522 loops=1)

  • Filter: (NOT upper_inf(sale.active_range))
  • Buffers: shared hit=7505 read=140519