explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ugx4

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

GroupAggregate (cost=2,888,793.18..2,888,793.22 rows=1 width=87) (actual rows= loops=)

  • Group Key: stats_adrevenue.date, stats_adrevenue.country, core_adrevenue_app_map.app_id, core_app.customer_id, core_connectedchannel.channel_id, stats_adrevenue.ad_unit_map_id
2. 0.000 0.000 ↓ 0.0

Sort (cost=2,888,793.18..2,888,793.18 rows=1 width=43) (actual rows= loops=)

  • Sort Key: stats_adrevenue.date, stats_adrevenue.country, core_app.customer_id, stats_adrevenue.ad_unit_map_id
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2,760,229.37..2,888,793.17 rows=1 width=43) (actual rows= loops=)

  • Join Filter: ((core_app.id = stats_general_regular.app_id) AND (stats_adrevenue.date = stats_general_regular.date) AND ((stats_adrevenue.country)::text = (stats_general_regular.country)::text))
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,001.13..128,443.71 rows=1 width=43) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.85..128,439.40 rows=1 width=35) (actual rows= loops=)

  • Workers Planned: 1
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..127,439.30 rows=1 width=35) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..127,402.31 rows=122 width=35) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on core_connectedchannel (cost=0.00..2,391.76 rows=2 width=8) (actual rows= loops=)

  • Filter: (channel_id = 259)
9. 0.000 0.000 ↓ 0.0

Index Scan using stats_adrevenue_date_app_map_id_connecte_6b5281f1_uniq on stats_adrevenue (cost=0.57..62,277.33 rows=22,795 width=35) (actual rows= loops=)

  • Index Cond: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date) AND (connected_channel_id = core_connectedchannel.id))
10. 0.000 0.000 ↓ 0.0

Index Scan using core_adrevenue_app_map_pkey on core_adrevenue_app_map (cost=0.28..0.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = stats_adrevenue.app_map_id)
  • Filter: (app_id = 4,169)
11. 0.000 0.000 ↓ 0.0

Index Scan using core_app_pkey on core_app (cost=0.28..4.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = 4,169)
12. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=2,759,228.23..2,760,297.87 rows=1,876 width=14) (actual rows= loops=)

  • Group Key: stats_general_regular.date, stats_general_regular.app_id, stats_general_regular.country
13. 0.000 0.000 ↓ 0.0

Gather Merge (cost=2,759,228.23..2,760,199.38 rows=7,504 width=18) (actual rows= loops=)

  • Workers Planned: 4
14. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=2,758,228.18..2,758,305.52 rows=1,876 width=18) (actual rows= loops=)

  • Group Key: stats_general_regular.date, stats_general_regular.app_id, stats_general_regular.country
15. 0.000 0.000 ↓ 0.0

Sort (cost=2,758,228.18..2,758,239.89 rows=4,687 width=18) (actual rows= loops=)

  • Sort Key: stats_general_regular.date, stats_general_regular.country
16. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.56..2,757,942.40 rows=4,687 width=18) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on stats_general_regular (cost=31,328.61..2,748,871.30 rows=4,684 width=18) (actual rows= loops=)

  • Recheck Cond: (app_id = 4,169)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
18. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on stats_general_regular_app_idx (cost=0.00..31,323.93 rows=1,617,248 width=0) (actual rows= loops=)

  • Index Cond: (app_id = 4,169)
19. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on stats_general_important_zeptolab (cost=217.01..219.02 rows=1 width=18) (actual rows= loops=)

  • Recheck Cond: ((app_id = 4,169) AND (date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
20. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=217.01..217.01 rows=1 width=0) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on stats_general_important_zepto_app_idx (cost=0.00..23.95 rows=1,269 width=0) (actual rows= loops=)

  • Index Cond: (app_id = 4,169)
22. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on stats_general_important_zepto_unique (cost=0.00..192.81 rows=9,625 width=0) (actual rows= loops=)

  • Index Cond: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
23. 0.000 0.000 ↓ 0.0

Parallel Index Scan using stats_general_important_smartnews_app_idx on stats_general_important_smartnews (cost=0.56..4.30 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (app_id = 4,169)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
24. 0.000 0.000 ↓ 0.0

Parallel Index Scan using stats_general_important_slc_app_idx on stats_general_important_super_lucky_casino (cost=0.56..7,700.57 rows=5 width=18) (actual rows= loops=)

  • Index Cond: (app_id = 4,169)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
25. 0.000 0.000 ↓ 0.0

Parallel Index Scan using stats_general_important_melsoft_app_idx on stats_general_important_melsoft (cost=0.56..4.14 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (app_id = 4,169)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
26. 0.000 0.000 ↓ 0.0

Parallel Index Scan using stats_general_important_hutch_app_idx on stats_general_important_hutchgames (cost=0.56..1,100.15 rows=2 width=18) (actual rows= loops=)

  • Index Cond: (app_id = 4,169)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
27. 0.000 0.000 ↓ 0.0

Parallel Index Scan using stats_general_important_zynga_app_idx on stats_general_important_zynga (cost=0.14..4.15 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (app_id = 4,169)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
28. 0.000 0.000 ↓ 0.0

Parallel Index Scan using stats_general_important_playtika_app_idx on stats_general_important_playtika (cost=0.14..4.15 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (app_id = 4,169)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
29. 0.000 0.000 ↓ 0.0

Parallel Index Scan using stats_general_important_pixonic_unique on stats_general_important_pixonic (cost=0.12..4.14 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
  • Filter: (app_id = 4,169)
30. 0.000 0.000 ↓ 0.0

Parallel Index Scan using stats_general_important_moburst_app_idx on stats_general_important_moburst (cost=0.12..4.14 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (app_id = 4,169)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
31. 0.000 0.000 ↓ 0.0

Parallel Index Scan using stats_general_important_dataduck_app_idx on stats_general_important_dataduck (cost=0.12..2.90 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (app_id = 4,169)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))