explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mxoX

Settings
# exclusive inclusive rows x rows loops node
1. 2,407.312 2,672.707 ↓ 0.0 0 1

Insert on public.mjv_accounts_branches mv (cost=45.43..38,704.43 rows=500,000 width=16) (actual time=2,672.707..2,672.707 rows=0 loops=1)

  • Conflict Resolution: UPDATE
  • Conflict Arbiter Indexes: cnstr_mjv_accounts_branches_keys
  • Tuples Inserted: 101002
  • Conflicting Tuples: 0
  • Buffers: shared hit=844069, local hit=1
2. 265.367 265.395 ↑ 5.0 101,002 1

Hash Join (cost=45.43..38,704.43 rows=500,000 width=16) (actual time=0.041..265.395 rows=101,002 loops=1)

  • Output: acc.aid, acc.abalance, br.bid, br.bbalance
  • Hash Cond: (acc.bid = br.bid)
  • Buffers: shared hit=19915, local hit=1
  • -> Seq Scan on public.pgbench_accounts acc (cost=0.00..29909.00 rows=1000000 width=12) (actual time=0.006..132.327 rows=1000000
  • Output: acc.aid, acc.bid, acc.abalance, acc.filler
  • Buffers: shared hit=19909
3. 0.002 0.028 ↑ 5.0 1 1

Hash (cost=45.36..45.36 rows=5 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Output: br.bid, br.bbalance, view_t_mjv_accounts_branches.bid
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=6, local hit=1
4. 0.005 0.026 ↑ 5.0 1 1

Hash Join (cost=41.73..45.36 rows=5 width=16) (actual time=0.025..0.026 rows=1 loops=1)

  • Output: br.bid, br.bbalance, view_t_mjv_accounts_branches.bid
  • Inner Unique: true
  • Hash Cond: (view_t_mjv_accounts_branches.bid = br.bid)
  • Buffers: shared hit=6, local hit=1
5. 0.008 0.008 ↑ 200.0 1 1

HashAggregate (cost=35.50..37.50 rows=200 width=8) (actual time=0.008..0.008 rows=1 loops=1)

  • Output: view_t_mjv_accounts_branches.bid
  • Group Key: view_t_mjv_accounts_branches.bid
  • Buffers: local hit=1
  • -> Seq Scan on pg_temp_7.view_t_mjv_accounts_branches (cost=0.00..30.40 rows=2040 width=8) (actual time=0.004.
  • Output: view_t_mjv_accounts_branches.bid, view_t_mjv_accounts_branches.bbalance
  • Buffers: local hit=1
6. 0.013 0.013 ↑ 1.0 10 1

Hash (cost=6.10..6.10 rows=10 width=8) (actual time=0.012..0.013 rows=10 loops=1)

  • Output: br.bid, br.bbalance
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=6
  • -> Seq Scan on public.pgbench_branches br (cost=0.00..6.10 rows=10 width=8) (actual time=0.003..0.009 rows=10
  • Output: br.bid, br.bbalance
  • Buffers: shared hit=6
Planning time : 0.333 ms
Execution time : 2,672.766 ms