explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6PUG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 739.247 ↑ 1.0 1 1

Aggregate (cost=352,232.43..352,232.44 rows=1 width=8) (actual time=739.247..739.247 rows=1 loops=1)

  • Buffers: shared hit=4564 read=325171
2. 12.728 741.565 ↓ 1.5 3 1

Gather (cost=352,232.22..352,232.43 rows=2 width=8) (actual time=739.167..741.565 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=4564 read=325171
3. 18.763 728.837 ↑ 1.0 1 3 / 3

Aggregate (cost=351,232.22..351,232.23 rows=1 width=8) (actual time=728.837..728.837 rows=1 loops=3)

  • Buffers: shared hit=4564 read=325171
4. 710.074 710.074 ↑ 2.9 186,244 3 / 3

Seq Scan on sale sale (cost=0..349,888.64 rows=537,430 width=16) (actual time=41.798..710.074 rows=186,244 loops=3)

  • Filter: upper_inf(sale.active_range)
  • Buffers: shared hit=4564 read=325171
Planning time : 0.537 ms
Execution time : 741.665 ms