explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q7ec

Settings
# exclusive inclusive rows x rows loops node
1. 7,475.383 7,475.383 ↓ 1.1 3,841,730 1

Seq Scan on sale sale (cost=0..216,398.88 rows=3,646,660 width=16) (actual time=0.949..7,475.383 rows=3,841,730 loops=1)

  • Filter: (NOT upper_inf(sale.active_range))
  • Buffers: shared hit=2139 read=145885