explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7nSJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=61,990.02..779,167.13 rows=236 width=26) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=61,989.46..778,213.82 rows=208 width=24) (actual rows= loops=)

  • Join Filter: (d.offer_id = b.f_offer_id)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=61,989.02..332,428.38 rows=128,293 width=12) (actual rows= loops=)

  • Hash Cond: (d.advertiser_fund_id = e.id)
  • Join Filter: ((e.total_inflow - e.burn) >= c.f_default_revenue)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=61,467.51..324,683.06 rows=386,837 width=21) (actual rows= loops=)

  • Hash Cond: (c.f_offer_id = d.offer_id)
  • Join Filter: ((d.monthly_budget - d.monthly_expenditure) >= c.f_default_revenue)
5. 0.000 0.000 ↓ 0.0

Seq Scan on t_offer_info c (cost=0.00..222,813.02 rows=1,198,102 width=9) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=40,161.13..40,161.13 rows=1,160,510 width=20) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on t_offer_fund d (cost=0.00..40,161.13 rows=1,160,510 width=20) (actual rows= loops=)

  • Filter: ((monthly_budget - monthly_expenditure) <> '0'::numeric)
8. 0.000 0.000 ↓ 0.0

Hash (cost=506.77..506.77 rows=1,179 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on t_advertiser_fund e (cost=0.00..506.77 rows=1,179 width=16) (actual rows= loops=)

  • Filter: ((total_inflow - burn) <> '0'::numeric)
10. 0.000 0.000 ↓ 0.0

Index Scan using t_affiliate_offer_offerid_idx on t_affiliate_offer b (cost=0.44..3.46 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (f_offer_id = c.f_offer_id)
  • Filter: f_is_cap_reached
11. 0.000 0.000 ↓ 0.0

Index Scan using t_aff_offer_fund_offer_id_aff_id_key on t_aff_offer_fund a (cost=0.56..4.57 rows=1 width=22) (actual rows= loops=)

  • Index Cond: ((offer_id = b.f_offer_id) AND (aff_id = b.f_aff_id))