explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eXRo

Settings
# exclusive inclusive rows x rows loops node
1. 20,565.063 125,903.608 ↓ 0.0 0 1

ModifyTable (cost=25,099.83..2,386,878.47 rows=54,045,222 width=72) (actual time=125,903.608..125,903.608 rows=0 loops=1)

  • Buffers: shared hit=11118, local hit=21679596 read=736682 dirtied=414281 written=414281, temp read=55222 written=55222
2. 92,189.081 105,338.545 ↑ 5.0 10,787,922 1

Hash Join (cost=25,099.83..2,386,878.47 rows=54,045,222 width=72) (actual time=386.806..105,338.545 rows=10,787,922 loops=1)

  • Buffers: shared hit=11118, local read=494133 dirtied=169867 written=172049, temp read=55222 written=55222
3. 12,768.792 12,768.792 ↑ 5.0 10,787,952 1

Seq Scan on tmp_fact_claim_product_location tmp_fact_claim_product_location (cost=0..1,034,585.22 rows=54,045,222 width=62) (actual time=5.501..12,768.792 rows=10,787,952 loops=1)

  • Buffers: local read=494133 dirtied=169867 written=172049
4. 216.202 380.672 ↑ 1.0 446,837 1

Hash (cost=15,586.37..15,586.37 rows=446,837 width=47) (actual time=380.671..380.672 rows=446,837 loops=1)

  • Buffers: shared hit=11118, temp written=1823
5. 164.470 164.470 ↑ 1.0 446,837 1

Seq Scan on dim_location dl (cost=0..15,586.37 rows=446,837 width=47) (actual time=0.009..164.47 rows=446,837 loops=1)

  • Buffers: shared hit=11118