explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h5cp3

Settings
# exclusive inclusive rows x rows loops node
1. 1.274 8.765 ↓ 979.0 979 1

GroupAggregate (cost=2,778.56..2,778.61 rows=1 width=87) (actual time=7.414..8.765 rows=979 loops=1)

  • 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. 2.122 7.491 ↓ 979.0 979 1

Sort (cost=2,778.56..2,778.57 rows=1 width=43) (actual time=7.402..7.491 rows=979 loops=1)

  • Sort Key: stats_adrevenue.date, stats_adrevenue.country, core_app.customer_id, stats_adrevenue.ad_unit_map_id
  • Sort Method: quicksort Memory: 137kB
3. 1.841 5.369 ↓ 979.0 979 1

Nested Loop (cost=112.09..2,778.55 rows=1 width=43) (actual time=4.555..5.369 rows=979 loops=1)

  • Join Filter: (stats_adrevenue.connected_channel_id = core_connectedchannel.id)
  • Rows Removed by Join Filter: 6,853
4. 0.014 0.032 ↓ 2.0 8 1

Bitmap Heap Scan on core_connectedchannel (cost=4.32..18.86 rows=4 width=8) (actual time=0.024..0.032 rows=8 loops=1)

  • Recheck Cond: (channel_id = 259)
  • Heap Blocks: exact=4
5. 0.018 0.018 ↓ 2.2 9 1

Bitmap Index Scan on core_connectedchannel_72eb6c85 (cost=0.00..4.32 rows=4 width=0) (actual time=0.018..0.018 rows=9 loops=1)

  • Index Cond: (channel_id = 259)
6. 1.108 3.496 ↓ 5.5 979 8

Materialize (cost=107.78..2,749.40 rows=179 width=43) (actual time=0.023..0.437 rows=979 loops=8)

7. 0.547 2.388 ↓ 5.5 979 1

Hash Left Join (cost=107.78..2,748.51 rows=179 width=43) (actual time=0.176..2.388 rows=979 loops=1)

  • Hash Cond: ((core_app.id = sq0.app_id) AND (stats_adrevenue.date = sq0.date) AND ((stats_adrevenue.country)::text = (sq0.country)::text))
8. 0.360 1.738 ↓ 5.5 979 1

Nested Loop (cost=0.98..2,640.31 rows=179 width=43) (actual time=0.058..1.738 rows=979 loops=1)

9. 0.005 0.030 ↑ 2.0 2 1

Nested Loop (cost=0.56..25.98 rows=4 width=16) (actual time=0.026..0.030 rows=2 loops=1)

10. 0.011 0.011 ↑ 1.0 1 1

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

  • Index Cond: (id = 5,287)
11. 0.014 0.014 ↑ 2.0 2 1

Index Scan using core_adrevenue_app_map_app_id_a0995552 on core_adrevenue_app_map (cost=0.28..17.65 rows=4 width=8) (actual time=0.012..0.014 rows=2 loops=1)

  • Index Cond: (app_id = 5,287)
12. 1.348 1.348 ↓ 1.0 490 2

Index Scan using stats_adrevenue_app_map_id_54a34d1e on stats_adrevenue (cost=0.42..648.86 rows=472 width=35) (actual time=0.309..0.674 rows=490 loops=2)

  • Index Cond: (app_map_id = core_adrevenue_app_map.id)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
  • Rows Removed by Filter: 676
13. 0.000 0.103 ↓ 0.0 0 1

Hash (cost=106.58..106.58 rows=12 width=23) (actual time=0.103..0.103 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
14. 0.001 0.103 ↓ 0.0 0 1

Subquery Scan on sq0 (cost=106.16..106.58 rows=12 width=23) (actual time=0.103..0.103 rows=0 loops=1)

15. 0.000 0.102 ↓ 0.0 0 1

GroupAggregate (cost=106.16..106.46 rows=12 width=23) (actual time=0.102..0.102 rows=0 loops=1)

  • Group Key: stats_general_regular.date, stats_general_regular.app_id, stats_general_regular.country
16. 0.006 0.102 ↓ 0.0 0 1

Sort (cost=106.16..106.19 rows=12 width=27) (actual time=0.102..0.102 rows=0 loops=1)

  • Sort Key: stats_general_regular.date, stats_general_regular.country
  • Sort Method: quicksort Memory: 25kB
17. 0.000 0.096 ↓ 0.0 0 1

Append (cost=0.29..105.94 rows=12 width=27) (actual time=0.096..0.096 rows=0 loops=1)

18. 0.018 0.018 ↓ 0.0 0 1

Index Scan using stats_general_regular_app_idx on stats_general_regular (cost=0.29..16.12 rows=1 width=19) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
  • Rows Removed by Filter: 14
19. 0.007 0.007 ↓ 0.0 0 1

Index Scan using stats_general_important_smartnews_app_idx on stats_general_important_smartnews (cost=0.14..8.16 rows=1 width=28) (actual time=0.006..0.007 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
20. 0.006 0.006 ↓ 0.0 0 1

Index Scan using stats_general_important_hutch_app_idx on stats_general_important_hutchgames (cost=0.14..8.16 rows=1 width=28) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
21. 0.010 0.010 ↓ 0.0 0 1

Index Scan using stats_general_important_zepto_app_idx on stats_general_important_zeptolab (cost=0.14..8.16 rows=1 width=28) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
22. 0.006 0.006 ↓ 0.0 0 1

Index Scan using stats_general_important_slc_app_idx on stats_general_important_super_lucky_casino (cost=0.14..8.16 rows=1 width=28) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
23. 0.005 0.005 ↓ 0.0 0 1

Index Scan using stats_general_important_zynga_app_idx on stats_general_important_zynga (cost=0.14..8.16 rows=1 width=28) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
24. 0.006 0.006 ↓ 0.0 0 1

Index Scan using stats_general_important_playtika_app_idx on stats_general_important_playtika (cost=0.14..8.16 rows=1 width=28) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
25. 0.005 0.005 ↓ 0.0 0 1

Index Scan using stats_general_important_voodoo_app_idx on stats_general_important_voodoo (cost=0.14..8.16 rows=1 width=28) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
26. 0.006 0.006 ↓ 0.0 0 1

Index Scan using stats_general_important_dataduck_app_idx on stats_general_important_dataduck (cost=0.14..8.16 rows=1 width=28) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
27. 0.009 0.009 ↓ 0.0 0 1

Index Scan using stats_general_important_pixonic_app_idx on stats_general_important_pixonic (cost=0.14..8.16 rows=1 width=28) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
28. 0.012 0.012 ↓ 0.0 0 1

Index Scan using stats_general_important_moburst_app_idx on stats_general_important_moburst (cost=0.14..8.16 rows=1 width=28) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
29. 0.006 0.006 ↓ 0.0 0 1

Index Scan using stats_general_important_melsoft_app_idx on stats_general_important_melsoft (cost=0.14..8.16 rows=1 width=28) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (app_id = 5,287)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
Planning time : 6.057 ms
Execution time : 9.232 ms