explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZReM

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2,283.132 ↓ 0.0 0 1

ModifyTable (cost=4,119.32..226,884.17 rows=84,818 width=251) (actual time=2,283.132..2,283.132 rows=0 loops=1)

  • Buffers: shared hit=109 read=147915, local read=2448
2. 191.651 2,283.129 ↓ 0.0 0 1

Hash Join (cost=4,119.32..226,884.17 rows=84,818 width=251) (actual time=2,283.129..2,283.129 rows=0 loops=1)

  • Buffers: shared hit=109 read=147915, local read=2448
3. 2,068.898 2,068.898 ↑ 2.2 810,528 1

Seq Scan on sale sale (cost=0..216,398.88 rows=1,823,330 width=233) (actual time=30.047..2,068.898 rows=810,528 loops=1)

  • Filter: upper_inf(sale.active_range)
  • Buffers: shared hit=109 read=147915
4. 7.146 22.580 ↑ 3.4 21,908 1

Hash (cost=3,190.81..3,190.81 rows=74,281 width=30) (actual time=22.58..22.58 rows=21,908 loops=1)

  • Buffers: local read=2448
5. 15.434 15.434 ↑ 3.4 21,908 1

Seq Scan on _import_sale _import_sale (cost=0..3,190.81 rows=74,281 width=30) (actual time=3.388..15.434 rows=21,908 loops=1)

  • Buffers: local read=2448