explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x5Y6

Settings
# exclusive inclusive rows x rows loops node
1. 40,193.396 40,193.396 ↑ 7.2 558,732 1

Seq Scan on sale s (cost=0..481,463.55 rows=4,046,094 width=273) (actual time=0.953..40,193.396 rows=558,732 loops=1)

  • Filter: upper_inf(s.active_range)
  • Buffers: shared hit=179434 read=150301
Planning time : 12.628 ms
Execution time : 40,283.829 ms