explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2SuN

Settings
# exclusive inclusive rows x rows loops node
1. 62,461.351 270,802.965 ↓ 0.0 0 1

ModifyTable (cost=2,429,558.2..3,568,381.09 rows=22,729,375 width=64) (actual time=270,802.965..270,802.965 rows=0 loops=1)

  • Buffers: shared read=1747759, local hit=19078618 read=3024341 dirtied=3024340 written=3024340, temp read=228990 written=228990
2. 106,139.572 208,341.614 ↑ 2.1 10,786,033 1

Hash Join (cost=2,429,558.2..3,568,381.09 rows=22,729,375 width=64) (actual time=81,497.509..208,341.614 rows=10,786,033 loops=1)

  • Buffers: shared read=1747759, local read=207890 dirtied=207890 written=207889, temp read=228990 written=228990
3. 20,727.270 20,727.270 ↑ 2.1 10,804,975 1

Seq Scan on tmp_fact_claim_product_location tmp_fact_claim_product_location (cost=0..435,183.75 rows=22,729,375 width=54) (actual time=1.763..20,727.27 rows=10,804,975 loops=1)

  • Buffers: local read=207890 dirtied=207890 written=207889
4. 11,178.627 81,474.772 ↑ 1.3 16,604,081 1

Hash (cost=1,965,662.2..1,965,662.2 rows=21,790,320 width=47) (actual time=81,474.771..81,474.772 rows=16,604,081 loops=1)

  • Buffers: shared read=1747759, temp written=131544
5. 70,296.145 70,296.145 ↑ 1.3 16,604,081 1

Seq Scan on fact_claim fc (cost=0..1,965,662.2 rows=21,790,320 width=47) (actual time=0.79..70,296.145 rows=16,604,081 loops=1)

  • Buffers: shared read=1747759