explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O6Ir

Settings
# exclusive inclusive rows x rows loops node
1. 1.946 36,308.433 ↑ 3.4 474 1

GroupAggregate (cost=2,805,081.20..2,805,303.26 rows=1,615 width=14) (actual time=36,305.606..36,308.433 rows=474 loops=1)

  • Group Key: stats_general_regular.date, stats_general_regular.app_id, stats_general_regular.country
2. 11.501 36,306.487 ↑ 1.2 13,451 1

Sort (cost=2,805,081.20..2,805,121.57 rows=16,150 width=18) (actual time=36,305.592..36,306.487 rows=13,451 loops=1)

  • Sort Key: stats_general_regular.date, stats_general_regular.country
  • Sort Method: quicksort Memory: 1,435kB
3. 0.844 36,294.986 ↑ 1.2 13,451 1

Append (cost=2,762,666.36..2,803,952.38 rows=16,150 width=18) (actual time=36,222.180..36,294.986 rows=13,451 loops=1)

4. 110.680 36,291.655 ↑ 1.2 13,451 1

Bitmap Heap Scan on stats_general_regular (cost=2,762,666.36..2,794,764.54 rows=16,129 width=18) (actual time=36,222.179..36,291.655 rows=13,451 loops=1)

  • Recheck Cond: ((app_id = 4,169) AND (date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
  • Heap Blocks: exact=6,552
5. 60.130 36,180.975 ↓ 0.0 0 1

BitmapAnd (cost=2,762,666.36..2,762,666.36 rows=16,129 width=0) (actual time=36,180.975..36,180.975 rows=0 loops=1)

6. 1,216.050 1,216.050 ↑ 1.0 1,641,453 1

Bitmap Index Scan on stats_general_regular_app_idx (cost=0.00..32,639.47 rows=1,685,987 width=0) (actual time=1,216.050..1,216.050 rows=1,641,453 loops=1)

  • Index Cond: (app_id = 4,169)
7. 34,904.795 34,904.795 ↓ 1.8 2,497,660 1

Bitmap Index Scan on stats_general_regular_customer_date_idx (cost=0.00..2,730,018.57 rows=1,382,510 width=0) (actual time=34,904.795..34,904.795 rows=2,497,660 loops=1)

  • Index Cond: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
8. 0.485 0.485 ↓ 0.0 0 1

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

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

Index Scan using stats_general_important_hutch_app_idx on stats_general_important_hutchgames (cost=0.56..1,103.53 rows=3 width=18) (actual time=0.457..0.457 rows=0 loops=1)

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

Bitmap Heap Scan on stats_general_important_zeptolab (cost=239.94..243.97 rows=2 width=18) (actual time=0.350..0.350 rows=0 loops=1)

  • Recheck Cond: ((app_id = 4,169) AND (date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
11. 0.001 0.349 ↓ 0.0 0 1

BitmapAnd (cost=239.94..239.94 rows=2 width=0) (actual time=0.349..0.349 rows=0 loops=1)

12. 0.348 0.348 ↓ 0.0 0 1

Bitmap Index Scan on stats_general_important_zepto_app_idx (cost=0.00..50.37 rows=2,658 width=0) (actual time=0.348..0.348 rows=0 loops=1)

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

Bitmap Index Scan on stats_general_important_zepto_unique (cost=0.00..189.32 rows=9,476 width=0) (never executed)

  • Index Cond: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
14. 0.476 0.476 ↓ 0.0 0 1

Index Scan using stats_general_important_slc_app_idx on stats_general_important_super_lucky_casino (cost=0.56..7,731.62 rows=9 width=18) (actual time=0.476..0.476 rows=0 loops=1)

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

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

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

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

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

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

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

Index Scan using stats_general_important_pixonic_unique on stats_general_important_pixonic (cost=0.12..4.15 rows=1 width=18) (actual time=0.120..0.120 rows=0 loops=1)

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

Index Scan using stats_general_important_moburst_app_idx on stats_general_important_moburst (cost=0.12..4.15 rows=1 width=18) (actual time=0.120..0.120 rows=0 loops=1)

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

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

  • Index Cond: (app_id = 4,169)
  • Filter: ((date >= '2020-07-26'::date) AND (date <= '2020-07-27'::date))
Planning time : 1.546 ms
Execution time : 36,314.914 ms