explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kmmY

Settings
# exclusive inclusive rows x rows loops node
1. 55,765.474 55,765.474 ↑ 7.3 558,732 1

Seq Scan on sale s (cost=0..482,504.84 rows=4,073,862 width=16) (actual time=0.254..55,765.474 rows=558,732 loops=1)

  • Filter: upper_inf(s.active_range)
  • Buffers: shared hit=2445 read=327290 dirtied=4426 written=3119
Planning time : 1.041 ms
Execution time : 55,857.979 ms