explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sc6h

Settings
# exclusive inclusive rows x rows loops node
1. 0.435 84.492 ↓ 0.0 0 1

Update on trn_source_1810_det src (cost=2,150.77..3,928.34 rows=1 width=31,937) (actual time=84.492..84.492 rows=0 loops=1)

2.          

Initplan (forUpdate)

3. 0.024 0.024 ↑ 1.0 1 1

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

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

Hash Join (cost=2,148.81..3,926.38 rows=1 width=31,937) (actual time=27.464..84.033 rows=2 loops=1)

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

Seq Scan on trn_source_1810_det src (cost=0.00..1,215.03 rows=50,003 width=31,915) (actual time=0.030..44.026 rows=50,003 loops=1)

  • Filter: (status_id IS NULL)
6. 14.082 27.116 ↑ 1.0 50,102 1

Hash (cost=1,272.02..1,272.02 rows=50,102 width=23) (actual time=27.116..27.116 rows=50,102 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3348kB
7. 13.034 13.034 ↑ 1.0 50,102 1

Seq Scan on trn_source_1811_det dest (cost=0.00..1,272.02 rows=50,102 width=23) (actual time=0.013..13.034 rows=50,102 loops=1)