explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7yOG

Settings
# exclusive inclusive rows x rows loops node
1. 6.881 34.766 ↑ 1.2 16,716 1

Hash Join (cost=1,152.34..2,792.63 rows=19,303 width=116) (actual time=10.743..34.766 rows=16,716 loops=1)

  • Hash Cond: (COALESCE(i.aim__investment_by_account__c, i.investment_by_contact__c) = inv.investor_aim_id)
2. 5.496 24.556 ↑ 1.2 16,717 1

Hash Join (cost=838.39..2,213.27 rows=19,303 width=135) (actual time=7.384..24.556 rows=16,717 loops=1)

  • Hash Cond: (i.aim__investment_in_account__c = co.company_id)
3. 8.728 17.738 ↑ 1.0 19,303 1

Hash Join (cost=500.92..1,610.38 rows=19,303 width=135) (actual time=6.045..17.738 rows=19,303 loops=1)

  • Hash Cond: (i.aim__investment_in_deal__c = d.aim__aim_deal_id__c)
4. 2.993 2.993 ↑ 1.0 19,304 1

Seq Scan on aim_external_investment i (cost=0.00..844.04 rows=19,304 width=101) (actual time=0.005..2.993 rows=19,304 loops=1)

5. 1.928 6.017 ↑ 1.0 6,352 1

Hash (cost=421.52..421.52 rows=6,352 width=72) (actual time=6.016..6.017 rows=6,352 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 714kB
6. 4.089 4.089 ↑ 1.0 6,352 1

Seq Scan on aim_deal d (cost=0.00..421.52 rows=6,352 width=72) (actual time=0.006..4.089 rows=6,352 loops=1)

7. 0.333 1.322 ↑ 1.0 1,619 1

Hash (cost=317.24..317.24 rows=1,619 width=19) (actual time=1.322..1.322 rows=1,619 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 97kB
8. 0.989 0.989 ↑ 1.0 1,619 1

Seq Scan on company_dim_v3 co (cost=0.00..317.24 rows=1,619 width=19) (actual time=0.008..0.989 rows=1,619 loops=1)

  • Filter: ((company_type)::text = 'Graduate'::text)
9. 1.723 3.329 ↑ 1.0 9,153 1

Hash (cost=199.53..199.53 rows=9,153 width=19) (actual time=3.329..3.329 rows=9,153 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 584kB
10. 1.606 1.606 ↑ 1.0 9,153 1

Seq Scan on tmp_investor_dim inv (cost=0.00..199.53 rows=9,153 width=19) (actual time=0.011..1.606 rows=9,153 loops=1)