explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7RvG

Settings
# exclusive inclusive rows x rows loops node
1. 43,555.365 56,871.954 ↓ 0.0 0 1

ModifyTable (cost=0..114,612.21 rows=901,788 width=332) (actual time=56,871.954..56,871.954 rows=0 loops=1)

  • Buffers: shared hit=8966273 read=50121 dirtied=49785 written=44558, local read=17670 dirtied=8756 written=8756
2. 13,316.589 13,316.589 ↑ 2.0 446,862 1

Seq Scan on tmp_dim_location tmp_dim_location (cost=0..114,612.21 rows=901,788 width=332) (actual time=1.638..13,316.589 rows=446,862 loops=1)

  • Buffers: shared hit=446870 read=4 dirtied=1 written=4, local read=17670 dirtied=8756 written=8756