explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DeIQ

Settings
# exclusive inclusive rows x rows loops node
1. 1,461.002 1,723.043 ↓ 0.0 0 1

Update on trn_source_1808_det (cost=2,092.04..9,340.24 rows=1 width=31,943) (actual time=1,723.043..1,723.043 rows=0 loops=1)

2.          

Initplan (forUpdate)

3. 0.017 0.017 ↑ 1.0 1 1

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

  • Filter: (((status_name)::text = 'Matched'::text) AND ((status_type)::text = 'Transaction'::text))
  • Rows Removed by Filter: 63
4. 65.584 262.024 ↓ 100,006.0 100,006 1

Nested Loop (cost=2,090.08..9,338.28 rows=1 width=31,943) (actual time=29.133..262.024 rows=100,006 loops=1)

5. 33.725 100.100 ↓ 2.0 2 1

Hash Join (cost=2,090.08..7,623.23 rows=1 width=12) (actual time=29.089..100.100 rows=2 loops=1)

  • Hash Cond: ((dest.col_11 = src.col_11) AND ((dest.txn_description)::text = (src.txn_description)::text) AND (dest.txn_amt = src.txn_amt))
6. 37.677 37.677 ↑ 1.0 151,018 1

Seq Scan on trn_source_1809_det dest (cost=0.00..3,834.18 rows=151,018 width=24) (actual time=0.017..37.677 rows=151,018 loops=1)

7. 14.709 28.698 ↑ 1.0 50,003 1

Hash (cost=1,215.03..1,215.03 rows=50,003 width=23) (actual time=28.697..28.698 rows=50,003 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3296kB
8. 13.989 13.989 ↑ 1.0 50,003 1

Seq Scan on trn_source_1808_det src (cost=0.00..1,215.03 rows=50,003 width=23) (actual time=0.017..13.989 rows=50,003 loops=1)

  • Filter: (status_id IS NULL)
9. 96.340 96.340 ↑ 1.0 50,003 2

Seq Scan on trn_source_1808_det (cost=0.00..1,215.03 rows=50,003 width=31,915) (actual time=0.013..48.170 rows=50,003 loops=2)

Planning time : 2.625 ms
Execution time : 3,107.431 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint fkrwjkke2pagji1y67r4ornupvg 683.784 ms 50003 0.014 ms
for constraint fkt99ipmy0fqb89gwet0055xgoq 690.449 ms 50003 0.014 ms