explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yPvg

Settings
# exclusive inclusive rows x rows loops node
1. 0.540 89.027 ↓ 0.0 0 1

Update on trn_source_1800_det src (cost=2.87..7,683.44 rows=1 width=31,937) (actual time=89.026..89.027 rows=0 loops=1)

2.          

Initplan (for Update)

3. 0.028 0.028 ↑ 1.0 1 1

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

  • Filter: (((status_name)::text = 'Matched'::text) AND ((status_type)::text = 'Transaction'::text))
  • Rows Removed by Filter: 63
4. 18.241 88.459 ↓ 2.0 2 1

Merge Join (cost=0.91..7,681.48 rows=1 width=31,937) (actual time=0.060..88.459 rows=2 loops=1)

  • Merge Cond: ((src.col_11 = dest.col_11) AND ((src.txn_description)::text = (dest.txn_description)::text) AND (src.txn_amt = dest.txn_amt))
5. 51.939 51.939 ↑ 1.0 50,003 1

Index Scan using trn_source_1800_det_840 on trn_source_1800_det src (cost=0.41..3,409.59 rows=50,003 width=31,915) (actual time=0.010..51.939 rows=50,003 loops=1)

  • Filter: (status_id IS NULL)
6. 18.279 18.279 ↑ 3.0 50,003 1

Index Scan using trn_source_1801_det_333 on trn_source_1801_det dest (cost=0.42..10,645.63 rows=151,018 width=24) (actual time=0.010..18.279 rows=50,003 loops=1)