explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cTyT : Optimization for: plan #SZCU

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.479 2,321,717.724 ↓ 0.0 0 1

Update on trn_source_1804_det src (cost=2.71..18.76 rows=1 width=32,464) (actual time=2,321,717.724..2,321,717.724 rows=0 loops=1)

2.          

Initplan (forUpdate)

3. 0.021 0.021 ↑ 1.0 1 1

Seq Scan on status (cost=0.00..1.96 rows=1 width=8) (actual time=0.016..0.021 rows=1 loops=1)

  • Filter: (((status_name)::text = 'Matched'::text) AND ((status_type)::text = 'Transaction'::text))
  • Rows Removed by Filter: 63
4. 416,656.680 2,321,717.224 ↓ 2.0 2 1

Nested Loop (cost=0.75..16.80 rows=1 width=32,464) (actual time=0.075..2,321,717.224 rows=2 loops=1)

  • Join Filter: ((src.col_11 = dest.col_11) AND ((src.txn_description)::text = (dest.txn_description)::text) AND (src.txn_amt = dest.txn_amt))
  • Rows Removed by Join Filter: 7551353052
5. 146.256 146.256 ↓ 50,003.0 50,003 1

Index Scan using trn_source_1804_det_116 on trn_source_1804_det src (cost=0.38..8.39 rows=1 width=32,442) (actual time=0.025..146.256 rows=50,003 loops=1)

  • Filter: (status_id IS NULL)
6. 1,904,914.288 1,904,914.288 ↓ 151,018.0 151,018 50,003

Index Scan using trn_source_1805_det_583 on trn_source_1805_det dest (cost=0.38..8.39 rows=1 width=550) (actual time=0.006..38.096 rows=151,018 loops=50,003)

Planning time : 3.142 ms
Execution time : 2,321,719.984 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint fkrwjkke2pagji1y67r4ornupvg 1.242 ms 2 0.621 ms
for constraint fkt99ipmy0fqb89gwet0055xgoq 0.812 ms 2 0.406 ms