explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Di

Settings
# exclusive inclusive rows x rows loops node
1. 12.531 13.677 ↓ 0.0 0 1

ModifyTable (cost=0..98.06 rows=2,106 width=117) (actual time=13.677..13.677 rows=0 loops=1)

  • Buffers: shared hit=9587
2. 1.146 1.146 ↑ 1.0 2,106 1

Seq Scan on dim_account dim_account_1 (cost=0..98.06 rows=2,106 width=117) (actual time=0.011..1.146 rows=2,106 loops=1)

  • Buffers: shared hit=77