explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xhxH

Settings
# exclusive inclusive rows x rows loops node
1. 0.072 8.045 ↓ 0.0 0 1

ModifyTable (cost=0.28..3.31 rows=1 width=124) (actual time=8.045..8.045 rows=0 loops=1)

  • Buffers: shared hit=31 read=6 dirtied=1
2. 7.973 7.973 ↑ 1.0 1 1

Index Scan using dim_account_pkey on dim_account dim_account_1 (cost=0.28..3.31 rows=1 width=124) (actual time=7.97..7.973 rows=1 loops=1)

  • Index Cond: (dim_account_1.account_sk = '-1'::integer)
  • Buffers: shared hit=25 read=6 dirtied=1