explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MB3W

Settings
# exclusive inclusive rows x rows loops node
1. 67.306 67.558 ↑ 2.0 1 1

Nested Loop Left Join (cost=8.72..17,655.24 rows=2 width=1,064) (actual time=24.277..67.558 rows=1 loops=1)

  • Join Filter: (cmbu.ext_branch_id = ibm.jde_branch_number)
  • Rows Removed by Join Filter: 1,116
2. 0.005 0.252 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.72..33.84 rows=1 width=594) (actual time=0.075..0.252 rows=1 loops=1)

3. 0.014 0.014 ↑ 1.0 1 1

Index Scan using pk_customer_master on customer_master (cost=0.42..8.44 rows=1 width=470) (actual time=0.012..0.014 rows=1 loops=1)

  • Index Cond: (id = 182,357)
4. 0.102 0.233 ↑ 1.0 1 1

Hash Right Join (cost=8.30..25.40 rows=1 width=124) (actual time=0.058..0.233 rows=1 loops=1)

  • Hash Cond: (ibm.av_sales_branch_id = sbm.av_branch_id)
5. 0.121 0.121 ↑ 1.0 340 1

Seq Scan on branch_mapping ibm (cost=0.00..15.81 rows=340 width=66) (actual time=0.002..0.121 rows=340 loops=1)

  • Filter: active
  • Rows Removed by Filter: 41
6. 0.005 0.010 ↑ 1.0 1 1

Hash (cost=8.29..8.29 rows=1 width=62) (actual time=0.010..0.010 rows=1 loops=1)

7. 0.005 0.005 ↑ 1.0 1 1

Buckets: 1024 Batches: 1 Memory Usage: 9kB" -> Index Scan using ext_branch_id_idx on branch_mapping sbm (cost=0.27..8.29 rows=1 width=62) (actual time=0.004..0.005 rows=1 loops=1)