explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EkMI

Settings
# exclusive inclusive rows x rows loops node
1. 19,210.524 125,601.198 ↓ 0.0 0 1

ModifyTable (cost=26,652.92..1,689,113.24 rows=1 width=72) (actual time=125,601.197..125,601.198 rows=0 loops=1)

  • Buffers: shared hit=11118, local hit=21748750 read=506524 dirtied=407719 written=407719, temp read=53809 written=53809
2. 92,901.416 106,390.674 ↓ 10,787,922.0 10,787,922 1

Hash Join (cost=26,652.92..1,689,113.24 rows=1 width=72) (actual time=456.545..106,390.674 rows=10,787,922 loops=1)

  • Buffers: shared hit=11118, local read=327765 dirtied=228961 written=228960, temp read=53809 written=53809
3. 13,038.710 13,038.710 ↑ 3.3 10,787,952 1

Seq Scan on tmp_fact_claim_product_location tmp_fact_claim_product_location (cost=0..686,254.16 rows=35,848,916 width=62) (actual time=5.237..13,038.71 rows=10,787,952 loops=1)

  • Buffers: local read=327765 dirtied=228961 written=228960
4. 257.533 450.548 ↑ 1.0 446,837 1

Hash (cost=15,586.37..15,586.37 rows=446,837 width=51) (actual time=450.547..450.548 rows=446,837 loops=1)

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

Seq Scan on dim_location dl (cost=0..15,586.37 rows=446,837 width=51) (actual time=0.032..193.015 rows=446,837 loops=1)

  • Buffers: shared hit=11118