explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lMpk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.005 ↓ 0.0 0 1

Update on public.mjv_accounts_branches mv (cost=30.05..1,829,904.00 rows=402,738 width=54) (actual time=0.005..0.005 rows=0 loops=1)

2.          

CTE deleted_delta_t

3. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on pg_temp_7.delta_t (cost=0.00..29.62 rows=8 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: delta_t.bid
  • Filter: (delta_t.op = 'D'::bpchar)
4. 0.001 0.005 ↓ 0.0 0 1

Nested Loop (cost=0.42..1,829,874.37 rows=402,738 width=54) (actual time=0.004..0.005 rows=0 loops=1)

  • Output: mv.aid, mv.abalance, NULL::integer, NULL::integer, mv.ctid, deleted_delta_t.*
5. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on deleted_delta_t (cost=0.00..0.16 rows=8 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: deleted_delta_t.*, deleted_delta_t.bid
6. 0.000 0.000 ↓ 0.0 0

Index Scan using cnstr_mjv_accounts_branches_keys on public.mjv_accounts_branches mv (cost=0.42..228,230.86 rows=50,342 width=18) (never executed)

  • Output: mv.aid, mv.abalance, mv.ctid, mv.bid
  • Index Cond: (mv.bid = deleted_delta_t.bid)
  • Filter: (NOT (SubPlan 2))
7.          

SubPlan (forIndex Scan)

8. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pgbench_branches_pkey on public.pgbench_branches br (cost=0.14..4.15 rows=1 width=4) (never executed)

  • Output: br.bid
  • Index Cond: (br.bid = mv.bid)
  • Heap Fetches: 0
Planning time : 0.224 ms
Execution time : 0.057 ms