explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AoVl

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.072 ↓ 0.0 0 1

Limit (cost=65.82..90.55 rows=1 width=860) (actual time=0.072..0.072 rows=0 loops=1)

2. 0.000 0.058 ↓ 0.0 0 1

Nested Loop Left Join (cost=65.82..90.55 rows=1 width=860) (actual time=0.058..0.058 rows=0 loops=1)

  • Join Filter: (wrc.date = conso.date1)
3. 0.026 0.058 ↓ 0.0 0 1

Merge Left Join (cost=64.25..64.28 rows=1 width=260) (actual time=0.058..0.058 rows=0 loops=1)

  • Merge Cond: (conso.date1 = vu.date)
4. 0.012 0.032 ↓ 0.0 0 1

Sort (cost=47.46..47.46 rows=1 width=252) (actual time=0.032..0.032 rows=0 loops=1)

  • Sort Key: conso.date1 DESC
  • Sort Method: quicksort Memory: 25kB
5. 0.000 0.020 ↓ 0.0 0 1

Subquery Scan on conso (cost=2.41..47.45 rows=1 width=252) (actual time=0.020..0.020 rows=0 loops=1)

6. 0.001 0.020 ↓ 0.0 0 1

GroupAggregate (cost=2.41..47.44 rows=1 width=252) (actual time=0.020..0.020 rows=0 loops=1)

  • Group Key: cc.date
7. 0.000 0.019 ↓ 0.0 0 1

Nested Loop Semi Join (cost=2.41..47.35 rows=1 width=77) (actual time=0.019..0.019 rows=0 loops=1)

8. 0.002 0.019 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.13..43.77 rows=1 width=80) (actual time=0.019..0.019 rows=0 loops=1)

9. 0.000 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.84..40.20 rows=1 width=84) (actual time=0.017..0.017 rows=0 loops=1)

10. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=1.42..31.74 rows=1 width=78) (actual time=0.017..0.017 rows=0 loops=1)

11. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=1.15..25.22 rows=1 width=79) (actual time=0.017..0.017 rows=0 loops=1)

12. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.86..16.91 rows=1 width=75) (actual time=0.017..0.017 rows=0 loops=1)

13. 0.017 0.017 ↓ 0.0 0 1

Index Scan using conso_commission_global_uix on conso_commission cc (cost=0.57..8.59 rows=1 width=75) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((date >= '2019-03-07'::date) AND (date <= '2019-03-13'::date))
14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using campaign_pkey on campaign cam (cost=0.29..8.30 rows=1 width=4) (never executed)

  • Index Cond: (id = cc.campaign_id)
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0

Index Scan using zone_pkey on zone z (cost=0.29..8.30 rows=1 width=12) (never executed)

  • Index Cond: (id = cc.zone_id)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using website_pkey on media m (cost=0.28..6.51 rows=1 width=7) (never executed)

  • Index Cond: (id = z.media_id)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using conversion_rate_history_pkey on conversion_rate_history crh (cost=0.42..8.45 rows=1 width=10) (never executed)

  • Index Cond: ((cc.date = date) AND (date >= '2019-03-07'::date) AND (date <= '2019-03-13'::date) AND (iso = 'EUR'::bpchar))
18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using campaign_flag_pkey on campaign_flag cf (cost=0.29..3.57 rows=1 width=4) (never executed)

  • Index Cond: (campaign_id = cam.id)
  • Heap Fetches: 0
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using flex_user_countries_pk on flex_user_countries fuco (cost=0.29..3.56 rows=1 width=3) (never executed)

  • Index Cond: ((flex_user_id = '3493'::bigint) AND (country_ref = (m.country_ref)::text))
  • Heap Fetches: 0
20. 0.000 0.000 ↓ 0.0 0

Sort (cost=16.80..16.80 rows=1 width=12) (never executed)

  • Sort Key: vu.date DESC
21. 0.000 0.000 ↓ 0.0 0

Subquery Scan on vu (cost=0.71..16.79 rows=1 width=12) (never executed)

22. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.71..16.78 rows=1 width=12) (never executed)

  • Group Key: cvc.date
23. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.76 rows=1 width=8) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Index Scan using conso_vu_campaign_uix on conso_vu_campaign cvc (cost=0.42..8.45 rows=1 width=12) (never executed)

  • Index Cond: ((date >= '2019-03-07'::date) AND (date <= '2019-03-13'::date))
25. 0.000 0.000 ↓ 0.0 0

Index Only Scan using campaign_pkey on campaign cam_1 (cost=0.29..8.30 rows=1 width=4) (never executed)

  • Index Cond: (id = cvc.campaign_id)
  • Heap Fetches: 0
26. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=1.57..26.05 rows=1 width=28) (never executed)

  • Group Key: wrc.date
27. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=1.57..26.03 rows=1 width=16) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.29..25.40 rows=1 width=19) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.01..25.09 rows=1 width=20) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..16.77 rows=1 width=20) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Index Scan using rtb_zone_winrate_campaign_ix on rtb_zone_winrate_campaign wrc (cost=0.43..8.46 rows=1 width=24) (never executed)

  • Index Cond: ((date >= '2019-03-07'::date) AND (date <= '2019-03-13'::date))
32. 0.000 0.000 ↓ 0.0 0

Index Only Scan using campaign_pkey on campaign cam_2 (cost=0.29..8.30 rows=1 width=4) (never executed)

  • Index Cond: (id = wrc.campaign_id)
  • Heap Fetches: 0
33. 0.000 0.000 ↓ 0.0 0

Index Scan using zone_pkey on zone z_1 (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (id = wrc.zone_id)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using website_pkey on media m_1 (cost=0.28..0.30 rows=1 width=7) (never executed)

  • Index Cond: (id = z_1.media_id)
35. 0.000 0.000 ↓ 0.0 0

Index Only Scan using flex_user_countries_pk on flex_user_countries fuco_1 (cost=0.29..0.62 rows=1 width=3) (never executed)

  • Index Cond: ((flex_user_id = '3493'::bigint) AND (country_ref = (m_1.country_ref)::text))
  • Heap Fetches: 0