explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IQAy

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 280.746 ↓ 0.0 0 1

Update on public.mjv_accounts_branches mv (cost=35.85..19,326.76 rows=1 width=60) (actual time=280.746..280.746 rows=0 loops=1)

  • Buffers: shared hit=5450
2.          

CTE deleted_delta_t

3. 0.000 0.000 ↓ 0.0 0

Seq Scan on pg_temp_7.delta_t (cost=0.00..29.62 rows=8 width=8) (never executed)

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

Nested Loop (cost=6.22..19,297.13 rows=1 width=60) (actual time=280.744..280.744 rows=0 loops=1)

  • Output: mv.aid, mv.abalance, NULL::integer, NULL::integer, mv.ctid, deleted_delta_t.*, br.ctid
  • Join Filter: (mv.bid = deleted_delta_t.bid)
  • Buffers: shared hit=5450
5. 123.119 280.743 ↓ 0.0 0 1

Hash Anti Join (cost=6.22..19,296.87 rows=1 width=24) (actual time=280.743..280.743 rows=0 loops=1)

  • Output: mv.aid, mv.abalance, mv.ctid, mv.bid, br.ctid
  • Hash Cond: (mv.bid = br.bid)
  • Buffers: shared hit=5450
6. 157.609 157.609 ↑ 1.0 1,000,000 1

Seq Scan on public.mjv_accounts_branches mv (cost=0.00..15,514.29 rows=1,007,029 width=18) (actual time=0.026..157.609 rows=1,000,000 loops=1)

  • Output: mv.aid, mv.abalance, mv.ctid, mv.bid
  • Buffers: shared hit=5444
7. 0.005 0.015 ↑ 1.0 10 1

Hash (cost=6.10..6.10 rows=10 width=10) (actual time=0.015..0.015 rows=10 loops=1)

  • Output: br.ctid, br.bid
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=6
8. 0.010 0.010 ↑ 1.0 10 1

Seq Scan on public.pgbench_branches br (cost=0.00..6.10 rows=10 width=10) (actual time=0.003..0.010 rows=10 loops=1)

  • Output: br.ctid, br.bid
  • Buffers: shared hit=6
9. 0.000 0.000 ↓ 0.0 0

CTE Scan on deleted_delta_t (cost=0.00..0.16 rows=8 width=40) (never executed)

  • Output: deleted_delta_t.*, deleted_delta_t.bid
Planning time : 0.311 ms
Execution time : 280.797 ms