explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DTjp

Settings
# exclusive inclusive rows x rows loops node
1. 1,943.255 1,943.255 ↓ 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.019..1,943.255 rows=3,841,730 loops=1)

  • Filter: (NOT upper_inf(sale.active_range))
  • Buffers: shared hit=128648 read=19376