explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vSmM

Settings
# exclusive inclusive rows x rows loops node
1. 46.856 114.667 ↓ 0.0 0 1

Delete on public.mjv_accounts_branches mv (cost=521.83..1,678.61 rows=138 width=38) (actual time=114.667..114.667 rows=0 loops=1)

  • Buffers: shared hit=74198, local hit=176
2.          

CTE deleted_delta_t

3. 4.956 4.956 ↓ 99.7 13,758 1

Seq Scan on pg_temp_7.delta_t (cost=0.00..521.40 rows=138 width=8) (actual time=0.010..4.956 rows=13,758 loops=1)

  • Output: delta_t.aid
  • Filter: (delta_t.op = 'D'::bpchar)
  • Rows Removed by Filter: 13758
  • Buffers: local hit=176
4. 57.052 67.811 ↓ 99.7 13,758 1

Nested Loop (cost=0.42..1,157.21 rows=138 width=38) (actual time=0.033..67.811 rows=13,758 loops=1)

  • Output: mv.ctid, deleted_delta_t.*
  • Buffers: shared hit=55156, local hit=176
  • -> Index Scan using cnstr_mjv_accounts_branches_keys on public.mjv_accounts_branches mv (cost=0.42..8.36 rows=1 width=10) (actua
5. 10.759 10.759 ↓ 99.7 13,758 1

CTE Scan on deleted_delta_t (cost=0.00..2.76 rows=138 width=40) (actual time=0.022..10.759 rows=13,758 loops=1)

  • Output: deleted_delta_t.*, deleted_delta_t.aid
  • Buffers: local hit=176
  • Output: mv.ctid, mv.aid
  • Index Cond: (mv.aid = deleted_delta_t.aid)
  • Buffers: shared hit=55156
Planning time : 0.189 ms
Execution time : 114.983 ms