explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kDpC

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 3,333.035 ↓ 0.0 1 1

Aggregate (cost=0.00..0.00 rows=0 width=0) (actual time=3,333.035..3,333.035 rows=1 loops=1)

  • Output: (pg_catalog.sum(remote_scan." "))::bigint
  • Buffers: shared hit=3830
2. 1,361.903 3,333.002 ↓ 0.0 64 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=3,332.998..3,333.002 rows=64 loops=1)

  • Output: remote_scan."
  • Task Count: 64
  • Tasks Shown: All
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.134 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.81 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.82 port=5432 dbname=citus
  • Buffers: shared hit=3830
3. 4.240 38.264 ↑ 1.0 1 1

Aggregate (cost=37,839.82..37,839.83 rows=1 width=8) (actual time=38.264..38.264 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3866
4. 5.108 34.024 ↓ 1.0 55,928 1

Append (cost=0.42..37,702.92 rows=54,763 width=4) (actual time=0.060..34.024 rows=55,928 loops=1)

  • Buffers: shared hit=3866
5. 1.263 1.263 ↓ 1.0 3,450 1

Index Scan using fact_publishers_64_v4_2020_02_01_country_idx_264474 on public.fact_publishers_64_v4_2020_02_01_264474 fact_publishers_v4 (cost=0.42..2,396.78 rows=3,402 width=4) (actual time=0.059..1.263 rows=3,450 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=241
6. 2.344 2.344 ↓ 1.0 3,631 1

Index Scan using fact_publishers_64_v4_2020_02_02_country_idx_264538 on public.fact_publishers_64_v4_2020_02_02_264538 fact_publishers_v4_1 (cost=0.42..2,450.60 rows=3,566 width=4) (actual time=0.024..2.344 rows=3,631 loops=1)

  • Output: fact_publishers_v4_1.views
  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=245
7. 1.289 1.289 ↓ 1.0 3,699 1

Index Scan using fact_publishers_64_v4_2020_02_03_country_idx_264602 on public.fact_publishers_64_v4_2020_02_03_264602 fact_publishers_v4_2 (cost=0.42..2,243.99 rows=3,542 width=4) (actual time=0.032..1.289 rows=3,699 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=263
8. 1.332 1.332 ↓ 1.0 3,670 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264666 on public.fact_publishers_64_v4_2020_02_04_264666 fact_publishers_v4_3 (cost=0.42..2,442.98 rows=3,530 width=4) (actual time=0.023..1.332 rows=3,670 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=261
9. 1.520 1.520 ↓ 1.1 3,591 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264730 on public.fact_publishers_64_v4_2020_02_05_264730 fact_publishers_v4_4 (cost=0.42..2,290.79 rows=3,249 width=4) (actual time=0.035..1.520 rows=3,591 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=245
10. 1.490 1.490 ↑ 1.1 3,850 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264794 on public.fact_publishers_64_v4_2020_02_06_264794 fact_publishers_v4_5 (cost=0.42..2,525.79 rows=4,086 width=4) (actual time=0.033..1.490 rows=3,850 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=266
11. 1.337 1.337 ↓ 1.1 3,818 1

Index Scan using fact_publishers_64_v4_2020_02_07_country_idx_264858 on public.fact_publishers_64_v4_2020_02_07_264858 fact_publishers_v4_6 (cost=0.42..2,159.23 rows=3,477 width=4) (actual time=0.030..1.337 rows=3,818 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=270
12. 2.035 2.035 ↑ 1.0 3,653 1

Index Scan using fact_publishers_64_v4_2020_02_08_country_idx_264922 on public.fact_publishers_64_v4_2020_02_08_264922 fact_publishers_v4_7 (cost=0.42..2,416.08 rows=3,790 width=4) (actual time=0.032..2.035 rows=3,653 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=247
13. 6.773 6.773 ↓ 1.1 3,886 1

Index Scan using fact_publishers_64_v4_2020_02_09_country_idx_264986 on public.fact_publishers_64_v4_2020_02_09_264986 fact_publishers_v4_8 (cost=0.42..2,357.34 rows=3,689 width=4) (actual time=0.034..6.773 rows=3,886 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=259
14. 1.703 1.703 ↓ 1.1 3,939 1

Index Scan using fact_publishers_64_v4_2020_02_10_country_idx_265050 on public.fact_publishers_64_v4_2020_02_10_265050 fact_publishers_v4_9 (cost=0.42..2,156.51 rows=3,467 width=4) (actual time=0.029..1.703 rows=3,939 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=276
15. 1.657 1.657 ↑ 1.0 3,885 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265114 on public.fact_publishers_64_v4_2020_02_11_265114 fact_publishers_v4_10 (cost=0.42..2,580.43 rows=3,911 width=4) (actual time=0.029..1.657 rows=3,885 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=267
16. 1.585 1.585 ↑ 1.0 3,705 1

Index Scan using fact_publishers_64_v4_2020_02_12_country_idx_265178 on public.fact_publishers_64_v4_2020_02_12_265178 fact_publishers_v4_11 (cost=0.42..2,478.41 rows=3,735 width=4) (actual time=0.028..1.585 rows=3,705 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=257
17. 1.364 1.364 ↓ 1.1 3,666 1

Index Scan using fact_publishers_64_v4_2020_02_13_country_idx_265242 on public.fact_publishers_64_v4_2020_02_13_265242 fact_publishers_v4_12 (cost=0.42..2,465.10 rows=3,444 width=4) (actual time=0.042..1.364 rows=3,666 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=252
18. 1.755 1.755 ↑ 1.1 3,724 1

Index Scan using fact_publishers_64_v4_2020_02_14_country_idx_265306 on public.fact_publishers_64_v4_2020_02_14_265306 fact_publishers_v4_13 (cost=0.42..3,175.77 rows=4,036 width=4) (actual time=0.027..1.755 rows=3,724 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=257
19. 1.469 1.469 ↑ 1.0 3,761 1

Index Scan using fact_publishers_64_v4_2020_02_15_country_idx_265370 on public.fact_publishers_64_v4_2020_02_15_265370 fact_publishers_v4_14 (cost=0.42..3,289.30 rows=3,839 width=4) (actual time=0.045..1.469 rows=3,761 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=260
20. 5.873 43.383 ↑ 1.0 1 1

Aggregate (cost=80,850.21..80,850.22 rows=1 width=8) (actual time=43.383..43.383 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=4245
21. 7.047 37.510 ↑ 1.0 81,125 1

Append (cost=73.64..80,645.68 rows=81,813 width=4) (actual time=0.384..37.510 rows=81,125 loops=1)

  • Buffers: shared hit=4245
22. 1.499 1.847 ↓ 1.0 5,059 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264475 fact_publishers_v4 (cost=73.64..4,856.36 rows=4,996 width=4) (actual time=0.383..1.847 rows=5,059 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=240
  • Buffers: shared hit=266
23. 0.348 0.348 ↓ 1.0 5,059 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264475 (cost=0.00..72.39 rows=4,996 width=0) (actual time=0.348..0.348 rows=5,059 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=26
24. 1.451 1.784 ↓ 1.0 5,002 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264539 fact_publishers_v4_1 (cost=73.02..4,910.88 rows=4,916 width=4) (actual time=0.361..1.784 rows=5,002 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=237
  • Buffers: shared hit=265
25. 0.333 0.333 ↓ 1.0 5,002 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264539 (cost=0.00..71.79 rows=4,916 width=0) (actual time=0.333..0.333 rows=5,002 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=28
26. 1.572 1.960 ↑ 1.1 5,558 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264603 fact_publishers_v4_2 (cost=84.92..5,769.37 rows=5,871 width=4) (actual time=0.420..1.960 rows=5,558 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=264
  • Buffers: shared hit=293
27. 0.388 0.388 ↑ 1.1 5,558 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264603 (cost=0.00..83.45 rows=5,871 width=0) (actual time=0.388..0.388 rows=5,558 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
28. 1.597 1.969 ↓ 1.1 5,447 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264667 fact_publishers_v4_3 (cost=74.42..5,204.91 rows=5,097 width=4) (actual time=0.400..1.969 rows=5,447 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=256
  • Buffers: shared hit=283
29. 0.372 0.372 ↓ 1.1 5,447 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264667 (cost=0.00..73.15 rows=5,097 width=0) (actual time=0.372..0.372 rows=5,447 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=27
30. 1.641 1.981 ↓ 1.0 5,462 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264731 fact_publishers_v4_4 (cost=78.06..5,439.81 rows=5,373 width=4) (actual time=0.369..1.981 rows=5,462 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=253
  • Buffers: shared hit=282
31. 0.340 0.340 ↓ 1.0 5,462 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264731 (cost=0.00..76.72 rows=5,373 width=0) (actual time=0.340..0.340 rows=5,462 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
32. 1.617 1.973 ↑ 1.0 5,520 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_06_264795 fact_publishers_v4_5 (cost=83.94..5,730.25 rows=5,744 width=4) (actual time=0.387..1.973 rows=5,520 loops=1)

  • Output: fact_publishers_v4_5.views
  • Recheck Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Heap Blocks: exact=257
  • Buffers: shared hit=287
33. 0.356 0.356 ↑ 1.0 5,520 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_06_country_idx_264795 (cost=0.00..82.50 rows=5,744 width=0) (actual time=0.356..0.356 rows=5,520 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
34. 1.684 2.005 ↓ 1.0 5,420 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264859 fact_publishers_v4_6 (cost=79.67..5,395.89 rows=5,387 width=4) (actual time=0.350..2.005 rows=5,420 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=260
  • Buffers: shared hit=291
35. 0.321 0.321 ↓ 1.0 5,420 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264859 (cost=0.00..78.33 rows=5,387 width=0) (actual time=0.321..0.321 rows=5,420 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
36. 1.456 1.856 ↓ 1.0 4,777 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264923 fact_publishers_v4_7 (cost=69.51..4,714.37 rows=4,656 width=4) (actual time=0.425..1.856 rows=4,777 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=228
  • Buffers: shared hit=256
37. 0.400 0.400 ↓ 1.0 4,777 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264923 (cost=0.00..68.34 rows=4,656 width=0) (actual time=0.400..0.400 rows=4,777 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=28
38. 1.534 1.869 ↑ 1.0 5,264 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_264987 fact_publishers_v4_8 (cost=79.76..5,336.61 rows=5,399 width=4) (actual time=0.362..1.869 rows=5,264 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=247
  • Buffers: shared hit=274
39. 0.335 0.335 ↑ 1.0 5,264 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_264987 (cost=0.00..78.42 rows=5,399 width=0) (actual time=0.335..0.335 rows=5,264 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=27
40. 1.859 2.267 ↑ 1.0 5,958 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265051 fact_publishers_v4_9 (cost=87.14..5,868.80 rows=5,964 width=4) (actual time=0.442..2.267 rows=5,958 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=285
  • Buffers: shared hit=315
41. 0.408 0.408 ↑ 1.0 5,958 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265051 (cost=0.00..85.65 rows=5,964 width=0) (actual time=0.408..0.408 rows=5,958 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
42. 1.858 2.260 ↑ 1.0 5,782 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265115 fact_publishers_v4_10 (cost=86.78..5,757.26 rows=5,917 width=4) (actual time=0.434..2.260 rows=5,782 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=262
  • Buffers: shared hit=295
43. 0.402 0.402 ↑ 1.0 5,782 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265115 (cost=0.00..85.30 rows=5,917 width=0) (actual time=0.402..0.402 rows=5,782 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
44. 2.376 2.865 ↑ 1.0 5,712 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265179 fact_publishers_v4_11 (cost=86.55..5,704.48 rows=5,887 width=4) (actual time=0.536..2.865 rows=5,712 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=261
  • Buffers: shared hit=291
45. 0.489 0.489 ↑ 1.0 5,712 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265179 (cost=0.00..85.08 rows=5,887 width=0) (actual time=0.489..0.489 rows=5,712 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
46. 1.742 2.130 ↑ 1.0 5,723 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265243 fact_publishers_v4_12 (cost=83.97..5,531.18 rows=5,748 width=4) (actual time=0.422..2.130 rows=5,723 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=263
  • Buffers: shared hit=293
47. 0.388 0.388 ↑ 1.0 5,723 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265243 (cost=0.00..82.53 rows=5,748 width=0) (actual time=0.388..0.388 rows=5,723 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
48. 1.595 1.937 ↑ 1.0 5,395 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265307 fact_publishers_v4_13 (cost=80.62..5,158.71 rows=5,510 width=4) (actual time=0.373..1.937 rows=5,395 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=257
  • Buffers: shared hit=288
49. 0.342 0.342 ↑ 1.0 5,395 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265307 (cost=0.00..79.24 rows=5,510 width=0) (actual time=0.342..0.342 rows=5,395 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
50. 1.456 1.760 ↑ 1.1 5,046 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265371 fact_publishers_v4_14 (cost=77.87..4,857.72 rows=5,348 width=4) (actual time=0.333..1.760 rows=5,046 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=240
  • Buffers: shared hit=266
51. 0.304 0.304 ↑ 1.1 5,046 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265371 (cost=0.00..76.53 rows=5,348 width=0) (actual time=0.304..0.304 rows=5,046 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=26
52. 5.107 38.434 ↑ 1.0 1 1

Aggregate (cost=59,676.51..59,676.52 rows=1 width=8) (actual time=38.434..38.434 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=4611
53. 6.102 33.327 ↑ 1.0 71,811 1

Append (cost=69.70..59,495.71 rows=72,323 width=4) (actual time=0.391..33.327 rows=71,811 loops=1)

  • Buffers: shared hit=4611
54. 1.518 1.881 ↑ 1.0 4,536 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264476 fact_publishers_v4 (cost=69.70..3,833.90 rows=4,681 width=4) (actual time=0.390..1.881 rows=4,536 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=222
  • Buffers: shared hit=246
55. 0.363 0.363 ↑ 1.0 4,536 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264476 (cost=0.00..68.53 rows=4,681 width=0) (actual time=0.363..0.363 rows=4,536 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
56. 1.814 2.197 ↑ 1.0 4,838 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264540 fact_publishers_v4_1 (cost=71.29..3,960.61 rows=4,886 width=4) (actual time=0.409..2.197 rows=4,838 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=235
  • Buffers: shared hit=259
57. 0.383 0.383 ↑ 1.0 4,838 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264540 (cost=0.00..70.06 rows=4,886 width=0) (actual time=0.383..0.383 rows=4,838 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
58. 2.181 2.181 ↑ 1.0 5,059 1

Index Scan using fact_publishers_64_v4_2020_02_03_country_idx_264604 on public.fact_publishers_64_v4_2020_02_03_264604 fact_publishers_v4_2 (cost=0.42..4,417.10 rows=5,247 width=4) (actual time=0.024..2.181 rows=5,059 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=343
59. 2.078 2.078 ↑ 1.0 4,939 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264668 on public.fact_publishers_64_v4_2020_02_04_264668 fact_publishers_v4_3 (cost=0.42..3,992.49 rows=4,975 width=4) (actual time=0.028..2.078 rows=4,939 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=322
60. 1.984 1.984 ↑ 1.0 4,786 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264732 on public.fact_publishers_64_v4_2020_02_05_264732 fact_publishers_v4_4 (cost=0.42..4,010.44 rows=4,851 width=4) (actual time=0.025..1.984 rows=4,786 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=322
61. 2.014 2.014 ↓ 1.0 4,696 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264796 on public.fact_publishers_64_v4_2020_02_06_264796 fact_publishers_v4_5 (cost=0.42..3,804.73 rows=4,545 width=4) (actual time=0.024..2.014 rows=4,696 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=313
62. 1.219 1.219 ↓ 1.0 3,499 1

Index Scan using fact_publishers_64_v4_2020_02_07_country_idx_264860 on public.fact_publishers_64_v4_2020_02_07_264860 fact_publishers_v4_6 (cost=0.42..2,974.41 rows=3,489 width=4) (actual time=0.023..1.219 rows=3,499 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=252
63. 1.713 1.713 ↓ 1.0 4,669 1

Index Scan using fact_publishers_64_v4_2020_02_08_country_idx_264924 on public.fact_publishers_64_v4_2020_02_08_264924 fact_publishers_v4_7 (cost=0.42..3,677.95 rows=4,471 width=4) (actual time=0.024..1.713 rows=4,669 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=299
64. 1.929 1.929 ↑ 1.0 4,906 1

Index Scan using fact_publishers_64_v4_2020_02_09_country_idx_264988 on public.fact_publishers_64_v4_2020_02_09_264988 fact_publishers_v4_8 (cost=0.42..4,200.96 rows=5,029 width=4) (actual time=0.032..1.929 rows=4,906 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=318
65. 1.733 1.733 ↑ 1.0 4,984 1

Index Scan using fact_publishers_64_v4_2020_02_10_country_idx_265052 on public.fact_publishers_64_v4_2020_02_10_265052 fact_publishers_v4_9 (cost=0.42..4,258.62 rows=5,103 width=4) (actual time=0.057..1.733 rows=4,984 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=327
66. 1.751 1.751 ↑ 1.0 4,988 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265116 on public.fact_publishers_64_v4_2020_02_11_265116 fact_publishers_v4_10 (cost=0.42..4,088.49 rows=5,093 width=4) (actual time=0.027..1.751 rows=4,988 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=322
67. 1.567 1.567 ↓ 1.0 4,882 1

Index Scan using fact_publishers_64_v4_2020_02_12_country_idx_265180 on public.fact_publishers_64_v4_2020_02_12_265180 fact_publishers_v4_11 (cost=0.42..3,831.52 rows=4,680 width=4) (actual time=0.026..1.567 rows=4,882 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=322
68. 1.683 1.683 ↑ 1.0 5,172 1

Index Scan using fact_publishers_64_v4_2020_02_13_country_idx_265244 on public.fact_publishers_64_v4_2020_02_13_265244 fact_publishers_v4_12 (cost=0.42..4,145.59 rows=5,183 width=4) (actual time=0.022..1.683 rows=5,172 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=326
69. 1.670 1.670 ↑ 1.0 4,880 1

Index Scan using fact_publishers_64_v4_2020_02_14_country_idx_265308 on public.fact_publishers_64_v4_2020_02_14_265308 fact_publishers_v4_13 (cost=0.42..3,982.03 rows=5,057 width=4) (actual time=0.024..1.670 rows=4,880 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=317
70. 1.625 1.625 ↑ 1.0 4,977 1

Index Scan using fact_publishers_64_v4_2020_02_15_country_idx_265372 on public.fact_publishers_64_v4_2020_02_15_265372 fact_publishers_v4_14 (cost=0.42..3,955.25 rows=5,033 width=4) (actual time=0.025..1.625 rows=4,977 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=323
71. 1.466 11.572 ↑ 1.0 1 1

Aggregate (cost=21,721.11..21,721.12 rows=1 width=8) (actual time=11.571..11.572 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=2168
72. 1.683 10.106 ↓ 1.0 25,952 1

Append (cost=0.42..21,656.47 rows=25,856 width=4) (actual time=0.029..10.106 rows=25,952 loops=1)

  • Buffers: shared hit=2168
73. 0.521 0.521 ↓ 1.0 1,602 1

Index Scan using fact_publishers_64_v4_2020_02_01_country_idx_264477 on public.fact_publishers_64_v4_2020_02_01_264477 fact_publishers_v4 (cost=0.42..1,362.09 rows=1,584 width=4) (actual time=0.028..0.521 rows=1,602 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=135
74. 0.485 0.485 ↓ 1.1 1,598 1

Index Scan using fact_publishers_64_v4_2020_02_02_country_idx_264541 on public.fact_publishers_64_v4_2020_02_02_264541 fact_publishers_v4_1 (cost=0.42..1,352.04 rows=1,489 width=4) (actual time=0.019..0.485 rows=1,598 loops=1)

  • Output: fact_publishers_v4_1.views
  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=138
75. 0.574 0.574 ↓ 1.1 1,843 1

Index Scan using fact_publishers_64_v4_2020_02_03_country_idx_264605 on public.fact_publishers_64_v4_2020_02_03_264605 fact_publishers_v4_2 (cost=0.42..1,572.53 rows=1,755 width=4) (actual time=0.021..0.574 rows=1,843 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=158
76. 0.616 0.616 ↑ 1.0 1,777 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264669 on public.fact_publishers_64_v4_2020_02_04_264669 fact_publishers_v4_3 (cost=0.42..1,608.16 rows=1,788 width=4) (actual time=0.019..0.616 rows=1,777 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=143
77. 0.594 0.594 ↑ 1.1 1,873 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264733 on public.fact_publishers_64_v4_2020_02_05_264733 fact_publishers_v4_4 (cost=0.42..1,543.79 rows=1,992 width=4) (actual time=0.021..0.594 rows=1,873 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=145
78. 0.600 0.600 ↑ 1.0 1,785 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264797 on public.fact_publishers_64_v4_2020_02_06_264797 fact_publishers_v4_5 (cost=0.42..1,449.53 rows=1,836 width=4) (actual time=0.021..0.600 rows=1,785 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=154
79. 0.531 0.531 ↑ 1.1 1,776 1

Index Scan using fact_publishers_64_v4_2020_02_07_country_idx_264861 on public.fact_publishers_64_v4_2020_02_07_264861 fact_publishers_v4_6 (cost=0.42..1,528.59 rows=1,886 width=4) (actual time=0.022..0.531 rows=1,776 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=150
80. 0.485 0.485 ↑ 1.0 1,577 1

Index Scan using fact_publishers_64_v4_2020_02_08_country_idx_264925 on public.fact_publishers_64_v4_2020_02_08_264925 fact_publishers_v4_7 (cost=0.42..1,490.82 rows=1,599 width=4) (actual time=0.027..0.485 rows=1,577 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=137
81. 0.511 0.511 ↑ 1.0 1,746 1

Index Scan using fact_publishers_64_v4_2020_02_09_country_idx_264989 on public.fact_publishers_64_v4_2020_02_09_264989 fact_publishers_v4_8 (cost=0.42..1,603.01 rows=1,752 width=4) (actual time=0.019..0.511 rows=1,746 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=143
82. 0.589 0.589 ↑ 1.0 1,851 1

Index Scan using fact_publishers_64_v4_2020_02_10_country_idx_265053 on public.fact_publishers_64_v4_2020_02_10_265053 fact_publishers_v4_9 (cost=0.42..1,467.83 rows=1,898 width=4) (actual time=0.021..0.589 rows=1,851 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=155
83. 0.726 0.726 ↓ 1.0 1,810 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265117 on public.fact_publishers_64_v4_2020_02_11_265117 fact_publishers_v4_10 (cost=0.42..1,282.31 rows=1,762 width=4) (actual time=0.037..0.726 rows=1,810 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=148
84. 0.557 0.557 ↓ 1.0 1,691 1

Index Scan using fact_publishers_64_v4_2020_02_12_country_idx_265181 on public.fact_publishers_64_v4_2020_02_12_265181 fact_publishers_v4_11 (cost=0.42..1,179.51 rows=1,656 width=4) (actual time=0.019..0.557 rows=1,691 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=143
85. 0.554 0.554 ↓ 1.1 1,732 1

Index Scan using fact_publishers_64_v4_2020_02_13_country_idx_265245 on public.fact_publishers_64_v4_2020_02_13_265245 fact_publishers_v4_12 (cost=0.42..1,173.18 rows=1,600 width=4) (actual time=0.019..0.554 rows=1,732 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=146
86. 0.574 0.574 ↓ 1.0 1,735 1

Index Scan using fact_publishers_64_v4_2020_02_14_country_idx_265309 on public.fact_publishers_64_v4_2020_02_14_265309 fact_publishers_v4_13 (cost=0.42..1,335.32 rows=1,720 width=4) (actual time=0.022..0.574 rows=1,735 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=145
87. 0.506 0.506 ↓ 1.0 1,556 1

Index Scan using fact_publishers_64_v4_2020_02_15_country_idx_265373 on public.fact_publishers_64_v4_2020_02_15_265373 fact_publishers_v4_14 (cost=0.42..1,578.48 rows=1,539 width=4) (actual time=0.016..0.506 rows=1,556 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=128
88. 6.155 46.380 ↑ 1.0 1 1

Aggregate (cost=90,930.07..90,930.08 rows=1 width=8) (actual time=46.379..46.380 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=4772
89. 7.352 40.225 ↓ 1.0 94,195 1

Append (cost=86.82..90,697.51 rows=93,022 width=4) (actual time=0.457..40.225 rows=94,195 loops=1)

  • Buffers: shared hit=4772
90. 2.044 2.465 ↓ 1.0 6,040 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264478 fact_publishers_v4 (cost=86.82..5,571.25 rows=5,922 width=4) (actual time=0.456..2.465 rows=6,040 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=279
  • Buffers: shared hit=311
91. 0.421 0.421 ↓ 1.0 6,040 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264478 (cost=0.00..85.34 rows=5,922 width=0) (actual time=0.421..0.421 rows=6,040 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=32
92. 1.759 2.187 ↓ 1.1 6,025 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264542 fact_publishers_v4_1 (cost=83.76..5,492.07 rows=5,721 width=4) (actual time=0.515..2.187 rows=6,025 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=272
  • Buffers: shared hit=302
93. 0.428 0.428 ↓ 1.1 6,025 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264542 (cost=0.00..82.33 rows=5,721 width=0) (actual time=0.428..0.428 rows=6,025 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
94. 1.725 2.149 ↑ 1.0 6,549 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264606 fact_publishers_v4_2 (cost=96.89..6,392.85 rows=6,641 width=4) (actual time=0.456..2.149 rows=6,549 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=307
  • Buffers: shared hit=340
95. 0.424 0.424 ↑ 1.0 6,549 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264606 (cost=0.00..95.23 rows=6,641 width=0) (actual time=0.424..0.424 rows=6,549 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
96. 1.765 2.175 ↑ 1.0 6,664 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264670 fact_publishers_v4_3 (cost=100.63..6,573.75 rows=6,930 width=4) (actual time=0.439..2.175 rows=6,664 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=300
  • Buffers: shared hit=335
97. 0.410 0.410 ↑ 1.0 6,664 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264670 (cost=0.00..98.90 rows=6,930 width=0) (actual time=0.410..0.410 rows=6,664 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=35
98. 2.177 2.561 ↓ 1.0 6,642 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264734 fact_publishers_v4_4 (cost=96.85..6,446.03 rows=6,636 width=4) (actual time=0.412..2.561 rows=6,642 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=292
  • Buffers: shared hit=326
99. 0.384 0.384 ↓ 1.0 6,642 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264734 (cost=0.00..95.19 rows=6,636 width=0) (actual time=0.384..0.384 rows=6,642 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=34
100. 1.814 2.306 ↓ 1.0 6,403 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_06_264798 fact_publishers_v4_5 (cost=89.97..6,086.26 rows=6,135 width=4) (actual time=0.525..2.306 rows=6,403 loops=1)

  • Output: fact_publishers_v4_5.views
  • Recheck Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Heap Blocks: exact=301
  • Buffers: shared hit=335
101. 0.492 0.492 ↓ 1.0 6,403 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_06_country_idx_264798 (cost=0.00..88.43 rows=6,135 width=0) (actual time=0.492..0.492 rows=6,403 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=34
102. 1.805 2.259 ↑ 1.0 6,365 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264862 fact_publishers_v4_6 (cost=94.24..6,233.29 rows=6,493 width=4) (actual time=0.488..2.259 rows=6,365 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=298
  • Buffers: shared hit=329
103. 0.454 0.454 ↑ 1.0 6,365 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264862 (cost=0.00..92.62 rows=6,493 width=0) (actual time=0.454..0.454 rows=6,365 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
104. 1.872 2.286 ↓ 1.1 6,144 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264926 fact_publishers_v4_7 (cost=80.94..5,362.31 rows=5,551 width=4) (actual time=0.447..2.286 rows=6,144 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=279
  • Buffers: shared hit=308
105. 0.414 0.414 ↓ 1.1 6,144 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264926 (cost=0.00..79.55 rows=5,551 width=0) (actual time=0.414..0.414 rows=6,144 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
106. 1.870 2.239 ↑ 1.0 6,579 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_264990 fact_publishers_v4_8 (cost=100.05..6,288.42 rows=6,855 width=4) (actual time=0.399..2.239 rows=6,579 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=300
  • Buffers: shared hit=334
107. 0.369 0.369 ↑ 1.0 6,579 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_264990 (cost=0.00..98.33 rows=6,855 width=0) (actual time=0.369..0.369 rows=6,579 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=34
108. 1.621 2.199 ↑ 1.0 6,211 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265054 fact_publishers_v4_9 (cost=93.40..6,333.39 rows=6,384 width=4) (actual time=0.612..2.199 rows=6,211 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=287
  • Buffers: shared hit=320
109. 0.578 0.578 ↑ 1.0 6,211 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265054 (cost=0.00..91.80 rows=6,384 width=0) (actual time=0.578..0.578 rows=6,211 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
110. 1.639 1.986 ↓ 1.1 6,165 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265118 fact_publishers_v4_10 (cost=83.64..5,843.49 rows=5,705 width=4) (actual time=0.379..1.986 rows=6,165 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=277
  • Buffers: shared hit=307
111. 0.347 0.347 ↓ 1.1 6,165 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265118 (cost=0.00..82.21 rows=5,705 width=0) (actual time=0.347..0.347 rows=6,165 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
112. 1.561 1.959 ↑ 1.0 6,120 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265182 fact_publishers_v4_11 (cost=90.07..6,149.92 rows=6,148 width=4) (actual time=0.426..1.959 rows=6,120 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=277
  • Buffers: shared hit=308
113. 0.398 0.398 ↑ 1.0 6,120 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265182 (cost=0.00..88.53 rows=6,148 width=0) (actual time=0.398..0.398 rows=6,120 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
114. 1.512 1.863 ↓ 1.1 6,462 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265246 fact_publishers_v4_12 (cost=87.49..6,014.11 rows=6,009 width=4) (actual time=0.379..1.863 rows=6,462 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=286
  • Buffers: shared hit=320
115. 0.351 0.351 ↓ 1.1 6,462 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265246 (cost=0.00..85.99 rows=6,009 width=0) (actual time=0.351..0.351 rows=6,462 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=34
116. 1.553 1.871 ↑ 1.0 5,990 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265310 fact_publishers_v4_13 (cost=88.06..5,926.17 rows=6,082 width=4) (actual time=0.345..1.871 rows=5,990 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=270
  • Buffers: shared hit=302
117. 0.318 0.318 ↑ 1.0 5,990 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265310 (cost=0.00..86.54 rows=6,082 width=0) (actual time=0.318..0.318 rows=5,990 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=32
118. 1.887 2.368 ↓ 1.0 5,836 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265374 fact_publishers_v4_14 (cost=84.45..5,519.11 rows=5,810 width=4) (actual time=0.510..2.368 rows=5,836 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=265
  • Buffers: shared hit=295
119. 0.481 0.481 ↓ 1.0 5,836 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265374 (cost=0.00..83.00 rows=5,810 width=0) (actual time=0.481..0.481 rows=5,836 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
120. 2.484 19.371 ↑ 1.0 1 1

Aggregate (cost=34,068.68..34,068.69 rows=1 width=8) (actual time=19.371..19.371 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=2400
121. 2.955 16.887 ↑ 1.0 35,855 1

Append (cost=31.49..33,978.31 rows=36,147 width=4) (actual time=0.202..16.887 rows=35,855 loops=1)

  • Buffers: shared hit=2400
122. 0.967 1.140 ↓ 1.1 2,250 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264479 fact_publishers_v4 (cost=31.49..2,028.20 rows=2,074 width=4) (actual time=0.202..1.140 rows=2,250 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=139
  • Buffers: shared hit=154
123. 0.173 0.173 ↓ 1.1 2,250 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264479 (cost=0.00..30.97 rows=2,074 width=0) (actual time=0.173..0.173 rows=2,250 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
124. 0.874 1.069 ↑ 1.0 2,404 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264543 fact_publishers_v4_1 (cost=37.60..2,277.68 rows=2,475 width=4) (actual time=0.212..1.069 rows=2,404 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=138
  • Buffers: shared hit=153
125. 0.195 0.195 ↑ 1.0 2,404 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264543 (cost=0.00..36.98 rows=2,475 width=0) (actual time=0.195..0.195 rows=2,404 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
126. 0.768 0.933 ↓ 1.0 2,477 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264607 fact_publishers_v4_2 (cost=37.15..2,309.54 rows=2,417 width=4) (actual time=0.185..0.933 rows=2,477 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=147
  • Buffers: shared hit=162
127. 0.165 0.165 ↓ 1.0 2,477 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264607 (cost=0.00..36.54 rows=2,417 width=0) (actual time=0.165..0.165 rows=2,477 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
128. 0.891 0.891 ↑ 1.0 2,540 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264671 on public.fact_publishers_64_v4_2020_02_04_264671 fact_publishers_v4_3 (cost=0.42..2,368.65 rows=2,547 width=4) (actual time=0.022..0.891 rows=2,540 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=183
129. 0.894 0.894 ↑ 1.1 2,370 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264735 on public.fact_publishers_64_v4_2020_02_05_264735 fact_publishers_v4_4 (cost=0.42..2,366.91 rows=2,555 width=4) (actual time=0.048..0.894 rows=2,370 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=175
130. 0.876 0.876 ↓ 1.0 2,390 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264799 on public.fact_publishers_64_v4_2020_02_06_264799 fact_publishers_v4_5 (cost=0.42..2,231.82 rows=2,372 width=4) (actual time=0.024..0.876 rows=2,390 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=188
131. 0.789 0.939 ↑ 1.0 2,373 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264863 fact_publishers_v4_6 (cost=35.82..2,303.61 rows=2,439 width=4) (actual time=0.170..0.939 rows=2,373 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=146
  • Buffers: shared hit=161
132. 0.150 0.150 ↑ 1.0 2,373 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264863 (cost=0.00..35.21 rows=2,439 width=0) (actual time=0.150..0.150 rows=2,373 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
133. 0.776 0.953 ↑ 1.0 2,225 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264927 fact_publishers_v4_7 (cost=34.71..2,148.34 rows=2,296 width=4) (actual time=0.193..0.953 rows=2,225 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=138
  • Buffers: shared hit=154
134. 0.177 0.177 ↑ 1.0 2,225 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264927 (cost=0.00..34.14 rows=2,296 width=0) (actual time=0.177..0.177 rows=2,225 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=16
135. 0.695 0.844 ↓ 1.0 2,233 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_264991 fact_publishers_v4_8 (cost=32.65..2,091.31 rows=2,223 width=4) (actual time=0.167..0.844 rows=2,233 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=135
  • Buffers: shared hit=148
136. 0.149 0.149 ↓ 1.0 2,233 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_264991 (cost=0.00..32.09 rows=2,223 width=0) (actual time=0.149..0.149 rows=2,233 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
137. 0.774 0.952 ↑ 1.0 2,531 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265055 fact_publishers_v4_9 (cost=38.35..2,385.67 rows=2,572 width=4) (actual time=0.195..0.952 rows=2,531 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=158
  • Buffers: shared hit=174
138. 0.178 0.178 ↑ 1.0 2,531 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265055 (cost=0.00..37.71 rows=2,572 width=0) (actual time=0.178..0.178 rows=2,531 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=16
139. 0.744 0.898 ↑ 1.0 2,516 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265119 fact_publishers_v4_10 (cost=38.33..2,364.37 rows=2,570 width=4) (actual time=0.169..0.898 rows=2,516 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=130
  • Buffers: shared hit=145
140. 0.154 0.154 ↑ 1.0 2,516 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265119 (cost=0.00..37.69 rows=2,570 width=0) (actual time=0.154..0.154 rows=2,516 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
141. 0.724 0.892 ↑ 1.0 2,407 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265183 fact_publishers_v4_11 (cost=37.65..2,316.45 rows=2,482 width=4) (actual time=0.183..0.892 rows=2,407 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=137
  • Buffers: shared hit=152
142. 0.168 0.168 ↑ 1.0 2,407 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265183 (cost=0.00..37.03 rows=2,482 width=0) (actual time=0.168..0.168 rows=2,407 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
143. 0.779 0.955 ↓ 1.1 2,445 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265247 fact_publishers_v4_12 (cost=34.87..2,209.65 rows=2,317 width=4) (actual time=0.198..0.955 rows=2,445 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=141
  • Buffers: shared hit=155
144. 0.176 0.176 ↓ 1.1 2,445 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265247 (cost=0.00..34.29 rows=2,317 width=0) (actual time=0.176..0.176 rows=2,445 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=14
145. 0.742 0.895 ↑ 1.1 2,406 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265311 fact_publishers_v4_13 (cost=38.14..2,312.72 rows=2,545 width=4) (actual time=0.172..0.895 rows=2,406 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=142
  • Buffers: shared hit=157
146. 0.153 0.153 ↑ 1.1 2,406 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265311 (cost=0.00..37.50 rows=2,545 width=0) (actual time=0.153..0.153 rows=2,406 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
147. 0.653 0.801 ↓ 1.0 2,288 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265375 fact_publishers_v4_14 (cost=34.46..2,082.69 rows=2,263 width=4) (actual time=0.164..0.801 rows=2,288 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=124
  • Buffers: shared hit=139
148. 0.148 0.148 ↓ 1.0 2,288 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265375 (cost=0.00..33.89 rows=2,263 width=0) (actual time=0.148..0.148 rows=2,288 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
149. 5.313 39.574 ↑ 1.0 1 1

Aggregate (cost=70,458.48..70,458.49 rows=1 width=8) (actual time=39.573..39.574 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3881
150. 6.159 34.261 ↑ 1.0 72,492 1

Append (cost=67.74..70,277.10 rows=72,551 width=4) (actual time=0.403..34.261 rows=72,492 loops=1)

  • Buffers: shared hit=3881
151. 1.745 2.117 ↓ 1.0 4,790 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264480 fact_publishers_v4 (cost=67.74..4,621.04 rows=4,622 width=4) (actual time=0.402..2.117 rows=4,790 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=231
  • Buffers: shared hit=257
152. 0.372 0.372 ↓ 1.0 4,790 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264480 (cost=0.00..66.59 rows=4,622 width=0) (actual time=0.372..0.372 rows=4,790 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=26
153. 1.367 1.777 ↑ 1.0 4,777 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264544 fact_publishers_v4_1 (cost=70.51..4,747.80 rows=4,785 width=4) (actual time=0.438..1.777 rows=4,777 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=224
  • Buffers: shared hit=250
154. 0.410 0.410 ↑ 1.0 4,777 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264544 (cost=0.00..69.31 rows=4,785 width=0) (actual time=0.410..0.410 rows=4,777 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=26
155. 1.503 1.850 ↑ 1.0 5,375 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264608 fact_publishers_v4_2 (cost=79.69..5,443.61 rows=5,389 width=4) (actual time=0.376..1.850 rows=5,375 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=265
  • Buffers: shared hit=293
156. 0.347 0.347 ↑ 1.0 5,375 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264608 (cost=0.00..78.34 rows=5,389 width=0) (actual time=0.346..0.347 rows=5,375 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=28
157. 1.795 2.108 ↑ 1.0 5,255 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264672 fact_publishers_v4_3 (cost=79.79..5,252.34 rows=5,402 width=4) (actual time=0.339..2.108 rows=5,255 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=245
  • Buffers: shared hit=275
158. 0.313 0.313 ↑ 1.0 5,255 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264672 (cost=0.00..78.44 rows=5,402 width=0) (actual time=0.313..0.313 rows=5,255 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
159. 2.064 2.547 ↑ 1.0 5,594 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264736 fact_publishers_v4_4 (cost=85.42..5,523.56 rows=5,741 width=4) (actual time=0.514..2.547 rows=5,594 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=257
  • Buffers: shared hit=286
160. 0.483 0.483 ↑ 1.0 5,594 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264736 (cost=0.00..83.98 rows=5,741 width=0) (actual time=0.483..0.483 rows=5,594 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
161. 1.698 2.259 ↑ 1.0 5,417 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_06_264800 fact_publishers_v4_5 (cost=82.78..5,399.96 rows=5,595 width=4) (actual time=0.594..2.259 rows=5,417 loops=1)

  • Output: fact_publishers_v4_5.views
  • Recheck Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Heap Blocks: exact=265
  • Buffers: shared hit=296
162. 0.561 0.561 ↑ 1.0 5,417 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_06_country_idx_264800 (cost=0.00..81.39 rows=5,595 width=0) (actual time=0.561..0.561 rows=5,417 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
163. 1.438 1.741 ↓ 1.0 4,916 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264864 fact_publishers_v4_6 (cost=71.05..4,698.13 rows=4,855 width=4) (actual time=0.329..1.741 rows=4,916 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=246
  • Buffers: shared hit=273
164. 0.303 0.303 ↓ 1.0 4,916 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264864 (cost=0.00..69.83 rows=4,855 width=0) (actual time=0.303..0.303 rows=4,916 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=27
165. 1.311 1.612 ↑ 1.1 4,373 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264928 fact_publishers_v4_7 (cost=69.89..4,280.70 rows=4,706 width=4) (actual time=0.323..1.612 rows=4,373 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=221
  • Buffers: shared hit=244
166. 0.301 0.301 ↑ 1.1 4,373 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264928 (cost=0.00..68.72 rows=4,706 width=0) (actual time=0.301..0.301 rows=4,373 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
167. 1.607 2.078 ↓ 1.0 4,615 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_264992 fact_publishers_v4_8 (cost=67.29..4,263.86 rows=4,564 width=4) (actual time=0.501..2.078 rows=4,615 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=219
  • Buffers: shared hit=243
168. 0.471 0.471 ↓ 1.0 4,615 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_264992 (cost=0.00..66.15 rows=4,564 width=0) (actual time=0.471..0.471 rows=4,615 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
169. 1.499 1.849 ↓ 1.0 4,857 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265056 fact_publishers_v4_9 (cost=69.49..4,478.24 rows=4,654 width=4) (actual time=0.425..1.849 rows=4,857 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=239
  • Buffers: shared hit=265
170. 0.350 0.350 ↓ 1.0 4,857 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265056 (cost=0.00..68.33 rows=4,654 width=0) (actual time=0.350..0.350 rows=4,857 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=26
171. 1.298 1.740 ↓ 1.0 4,655 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265120 fact_publishers_v4_10 (cost=67.60..4,466.42 rows=4,604 width=4) (actual time=0.473..1.740 rows=4,655 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=223
  • Buffers: shared hit=248
172. 0.442 0.442 ↓ 1.0 4,655 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265120 (cost=0.00..66.45 rows=4,604 width=0) (actual time=0.442..0.442 rows=4,655 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
173. 1.446 1.707 ↑ 1.0 4,682 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265184 fact_publishers_v4_11 (cost=70.04..4,506.12 rows=4,725 width=4) (actual time=0.284..1.707 rows=4,682 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=217
  • Buffers: shared hit=240
174. 0.261 0.261 ↑ 1.0 4,682 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265184 (cost=0.00..68.86 rows=4,725 width=0) (actual time=0.261..0.261 rows=4,682 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
175. 1.367 1.715 ↑ 1.0 4,649 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265248 fact_publishers_v4_12 (cost=69.70..4,457.15 rows=4,681 width=4) (actual time=0.388..1.715 rows=4,649 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=224
  • Buffers: shared hit=251
176. 0.348 0.348 ↑ 1.0 4,649 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265248 (cost=0.00..68.53 rows=4,681 width=0) (actual time=0.348..0.348 rows=4,649 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=27
177. 1.325 1.571 ↓ 1.1 4,366 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265312 fact_publishers_v4_13 (cost=60.90..3,982.10 rows=4,126 width=4) (actual time=0.266..1.571 rows=4,366 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=211
  • Buffers: shared hit=236
178. 0.246 0.246 ↓ 1.1 4,366 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265312 (cost=0.00..59.87 rows=4,126 width=0) (actual time=0.246..0.246 rows=4,366 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
179. 1.165 1.431 ↓ 1.0 4,171 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265376 fact_publishers_v4_14 (cost=60.71..3,793.32 rows=4,102 width=4) (actual time=0.287..1.431 rows=4,171 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=201
  • Buffers: shared hit=224
180. 0.266 0.266 ↓ 1.0 4,171 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265376 (cost=0.00..59.69 rows=4,102 width=0) (actual time=0.266..0.266 rows=4,171 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
181. 7.187 41.912 ↑ 1.0 1 1

Aggregate (cost=47,291.70..47,291.71 rows=1 width=8) (actual time=41.912..41.912 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=5202
182. 7.303 34.725 ↓ 1.0 81,325 1

Append (cost=0.42..47,088.63 rows=81,230 width=4) (actual time=0.031..34.725 rows=81,325 loops=1)

  • Buffers: shared hit=5202
183. 1.764 1.764 ↓ 1.0 4,772 1

Index Scan using fact_publishers_64_v4_2020_02_01_country_idx_264481 on public.fact_publishers_64_v4_2020_02_01_264481 fact_publishers_v4 (cost=0.42..2,199.42 rows=4,647 width=4) (actual time=0.030..1.764 rows=4,772 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=308
184. 1.736 1.736 ↑ 1.0 5,263 1

Index Scan using fact_publishers_64_v4_2020_02_02_country_idx_264545 on public.fact_publishers_64_v4_2020_02_02_264545 fact_publishers_v4_1 (cost=0.42..2,815.76 rows=5,483 width=4) (actual time=0.025..1.736 rows=5,263 loops=1)

  • Output: fact_publishers_v4_1.views
  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=337
185. 2.048 2.048 ↓ 1.0 6,079 1

Index Scan using fact_publishers_64_v4_2020_02_03_country_idx_264609 on public.fact_publishers_64_v4_2020_02_03_264609 fact_publishers_v4_2 (cost=0.42..3,486.29 rows=5,826 width=4) (actual time=0.021..2.048 rows=6,079 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=389
186. 1.915 1.915 ↑ 1.0 5,773 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264673 on public.fact_publishers_64_v4_2020_02_04_264673 fact_publishers_v4_3 (cost=0.42..3,497.56 rows=5,978 width=4) (actual time=0.025..1.915 rows=5,773 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=367
187. 1.559 1.559 ↓ 1.1 5,831 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264737 on public.fact_publishers_64_v4_2020_02_05_264737 fact_publishers_v4_4 (cost=0.42..3,114.97 rows=5,517 width=4) (actual time=0.020..1.559 rows=5,831 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=364
188. 1.670 1.670 ↑ 1.0 5,754 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264801 on public.fact_publishers_64_v4_2020_02_06_264801 fact_publishers_v4_5 (cost=0.42..3,347.36 rows=5,761 width=4) (actual time=0.020..1.670 rows=5,754 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=370
189. 1.468 1.468 ↑ 1.1 5,618 1

Index Scan using fact_publishers_64_v4_2020_02_07_country_idx_264865 on public.fact_publishers_64_v4_2020_02_07_264865 fact_publishers_v4_6 (cost=0.42..3,058.74 rows=6,010 width=4) (actual time=0.024..1.468 rows=5,618 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=366
190. 1.556 1.556 ↓ 1.0 5,246 1

Index Scan using fact_publishers_64_v4_2020_02_08_country_idx_264929 on public.fact_publishers_64_v4_2020_02_08_264929 fact_publishers_v4_7 (cost=0.42..2,755.37 rows=5,239 width=4) (actual time=0.020..1.556 rows=5,246 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=337
191. 2.864 2.864 ↓ 1.0 5,614 1

Index Scan using fact_publishers_64_v4_2020_02_09_country_idx_264993 on public.fact_publishers_64_v4_2020_02_09_264993 fact_publishers_v4_8 (cost=0.42..2,994.71 rows=5,560 width=4) (actual time=0.022..2.864 rows=5,614 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=359
192. 2.333 2.333 ↓ 1.0 5,428 1

Index Scan using fact_publishers_64_v4_2020_02_10_country_idx_265057 on public.fact_publishers_64_v4_2020_02_10_265057 fact_publishers_v4_9 (cost=0.42..2,977.81 rows=5,358 width=4) (actual time=0.025..2.333 rows=5,428 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=356
193. 2.407 2.407 ↓ 1.0 5,465 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265121 on public.fact_publishers_64_v4_2020_02_11_265121 fact_publishers_v4_10 (cost=0.42..3,202.59 rows=5,226 width=4) (actual time=0.035..2.407 rows=5,465 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=345
194. 1.640 1.640 ↑ 1.0 5,368 1

Index Scan using fact_publishers_64_v4_2020_02_12_country_idx_265185 on public.fact_publishers_64_v4_2020_02_12_265185 fact_publishers_v4_11 (cost=0.42..3,113.88 rows=5,417 width=4) (actual time=0.024..1.640 rows=5,368 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=343
195. 1.578 1.578 ↑ 1.0 5,163 1

Index Scan using fact_publishers_64_v4_2020_02_13_country_idx_265249 on public.fact_publishers_64_v4_2020_02_13_265249 fact_publishers_v4_12 (cost=0.42..3,225.59 rows=5,210 width=4) (actual time=0.025..1.578 rows=5,163 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=329
196. 1.466 1.466 ↑ 1.0 5,086 1

Index Scan using fact_publishers_64_v4_2020_02_14_country_idx_265313 on public.fact_publishers_64_v4_2020_02_14_265313 fact_publishers_v4_13 (cost=0.42..3,475.26 rows=5,172 width=4) (actual time=0.027..1.466 rows=5,086 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=320
197. 1.418 1.418 ↓ 1.0 4,865 1

Index Scan using fact_publishers_64_v4_2020_02_15_country_idx_265377 on public.fact_publishers_64_v4_2020_02_15_265377 fact_publishers_v4_14 (cost=0.42..3,417.17 rows=4,826 width=4) (actual time=0.026..1.418 rows=4,865 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=312
198. 3.768 29.485 ↑ 1.0 1 1

Aggregate (cost=49,314.51..49,314.52 rows=1 width=8) (actual time=29.485..29.485 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3210
199. 4.821 25.717 ↑ 1.0 55,966 1

Append (cost=53.93..49,173.80 rows=56,283 width=4) (actual time=0.278..25.717 rows=55,966 loops=1)

  • Buffers: shared hit=3210
200. 1.119 1.373 ↑ 1.0 3,481 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264482 fact_publishers_v4 (cost=53.93..3,073.16 rows=3,615 width=4) (actual time=0.278..1.373 rows=3,481 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=187
  • Buffers: shared hit=205
201. 0.254 0.254 ↑ 1.0 3,481 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264482 (cost=0.00..53.03 rows=3,615 width=0) (actual time=0.254..0.254 rows=3,481 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=18
202. 1.085 1.303 ↑ 1.0 3,525 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264546 fact_publishers_v4_1 (cost=51.95..3,024.52 rows=3,553 width=4) (actual time=0.241..1.303 rows=3,525 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=177
  • Buffers: shared hit=197
203. 0.218 0.218 ↑ 1.0 3,525 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264546 (cost=0.00..51.06 rows=3,553 width=0) (actual time=0.218..0.218 rows=3,525 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
204. 1.297 1.539 ↑ 1.1 3,735 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264610 fact_publishers_v4_2 (cost=57.92..3,399.90 rows=3,935 width=4) (actual time=0.278..1.539 rows=3,735 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=199
  • Buffers: shared hit=219
205. 0.242 0.242 ↑ 1.1 3,735 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264610 (cost=0.00..56.93 rows=3,935 width=0) (actual time=0.242..0.242 rows=3,735 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
206. 1.065 1.329 ↑ 1.0 3,681 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264674 fact_publishers_v4_3 (cost=54.63..3,311.63 rows=3,705 width=4) (actual time=0.283..1.329 rows=3,681 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=186
  • Buffers: shared hit=207
207. 0.264 0.264 ↑ 1.0 3,681 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264674 (cost=0.00..53.71 rows=3,705 width=0) (actual time=0.263..0.264 rows=3,681 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
208. 1.018 1.284 ↓ 1.0 3,684 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264738 fact_publishers_v4_4 (cost=53.21..3,184.14 rows=3,521 width=4) (actual time=0.284..1.284 rows=3,684 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=190
  • Buffers: shared hit=212
209. 0.266 0.266 ↓ 1.0 3,684 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264738 (cost=0.00..52.33 rows=3,521 width=0) (actual time=0.266..0.266 rows=3,684 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
210. 1.216 1.519 ↑ 1.0 3,733 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_06_264802 fact_publishers_v4_5 (cost=57.09..3,374.08 rows=3,829 width=4) (actual time=0.328..1.519 rows=3,733 loops=1)

  • Output: fact_publishers_v4_5.views
  • Recheck Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Heap Blocks: exact=202
  • Buffers: shared hit=224
211. 0.303 0.303 ↑ 1.0 3,733 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_06_country_idx_264802 (cost=0.00..56.14 rows=3,829 width=0) (actual time=0.303..0.303 rows=3,733 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
212. 1.187 1.447 ↑ 1.0 4,101 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264866 fact_publishers_v4_6 (cost=62.88..3,536.50 rows=4,188 width=4) (actual time=0.284..1.447 rows=4,101 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=217
  • Buffers: shared hit=239
213. 0.260 0.260 ↑ 1.0 4,101 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264866 (cost=0.00..61.83 rows=4,188 width=0) (actual time=0.260..0.260 rows=4,101 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
214. 1.119 1.326 ↑ 1.0 4,069 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264930 fact_publishers_v4_7 (cost=60.56..3,348.07 rows=4,082 width=4) (actual time=0.228..1.326 rows=4,069 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=200
  • Buffers: shared hit=219
215. 0.207 0.207 ↑ 1.0 4,069 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264930 (cost=0.00..59.53 rows=4,082 width=0) (actual time=0.207..0.207 rows=4,069 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
216. 1.282 1.542 ↑ 1.0 4,187 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_264994 fact_publishers_v4_8 (cost=63.11..3,443.73 rows=4,218 width=4) (actual time=0.281..1.542 rows=4,187 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=204
  • Buffers: shared hit=228
217. 0.260 0.260 ↑ 1.0 4,187 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_264994 (cost=0.00..62.05 rows=4,218 width=0) (actual time=0.260..0.260 rows=4,187 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
218. 1.066 1.338 ↑ 1.0 3,666 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265058 fact_publishers_v4_9 (cost=56.76..3,322.90 rows=3,786 width=4) (actual time=0.309..1.338 rows=3,666 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=202
  • Buffers: shared hit=222
219. 0.272 0.272 ↑ 1.0 3,666 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265058 (cost=0.00..55.81 rows=3,786 width=0) (actual time=0.272..0.272 rows=3,666 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
220. 1.158 1.384 ↑ 1.0 3,692 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265122 fact_publishers_v4_10 (cost=54.59..3,318.66 rows=3,700 width=4) (actual time=0.244..1.384 rows=3,692 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=192
  • Buffers: shared hit=214
221. 0.226 0.226 ↑ 1.0 3,692 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265122 (cost=0.00..53.67 rows=3,700 width=0) (actual time=0.226..0.226 rows=3,692 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
222. 1.097 1.296 ↑ 1.0 3,608 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265186 fact_publishers_v4_11 (cost=54.51..3,247.41 rows=3,689 width=4) (actual time=0.219..1.296 rows=3,608 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=190
  • Buffers: shared hit=209
223. 0.199 0.199 ↑ 1.0 3,608 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265186 (cost=0.00..53.59 rows=3,689 width=0) (actual time=0.199..0.199 rows=3,608 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
224. 1.178 1.388 ↓ 1.1 3,678 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265250 fact_publishers_v4_12 (cost=51.37..3,137.16 rows=3,477 width=4) (actual time=0.231..1.388 rows=3,678 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=188
  • Buffers: shared hit=209
225. 0.210 0.210 ↓ 1.1 3,678 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265250 (cost=0.00..50.50 rows=3,477 width=0) (actual time=0.210..0.210 rows=3,678 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
226. 1.143 1.396 ↓ 1.0 3,620 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265314 fact_publishers_v4_13 (cost=53.55..3,151.95 rows=3,565 width=4) (actual time=0.276..1.396 rows=3,620 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=192
  • Buffers: shared hit=213
227. 0.253 0.253 ↓ 1.0 3,620 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265314 (cost=0.00..52.66 rows=3,565 width=0) (actual time=0.253..0.253 rows=3,620 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
228. 1.219 1.432 ↓ 1.0 3,506 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265378 fact_publishers_v4_14 (cost=50.92..3,018.55 rows=3,420 width=4) (actual time=0.231..1.432 rows=3,506 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=174
  • Buffers: shared hit=193
229. 0.213 0.213 ↓ 1.0 3,506 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265378 (cost=0.00..50.07 rows=3,420 width=0) (actual time=0.213..0.213 rows=3,506 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
230. 3.808 28.571 ↑ 1.0 1 1

Aggregate (cost=55,665.91..55,665.92 rows=1 width=8) (actual time=28.571..28.571 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3132
231. 4.502 24.763 ↓ 1.0 54,961 1

Append (cost=54.37..55,529.27 rows=54,657 width=4) (actual time=0.325..24.763 rows=54,961 loops=1)

  • Buffers: shared hit=3132
232. 1.354 1.652 ↓ 1.0 3,778 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264483 fact_publishers_v4 (cost=54.37..3,620.86 rows=3,671 width=4) (actual time=0.324..1.652 rows=3,778 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=192
  • Buffers: shared hit=213
233. 0.298 0.298 ↓ 1.0 3,778 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264483 (cost=0.00..53.45 rows=3,671 width=0) (actual time=0.298..0.298 rows=3,778 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
234. 1.434 1.647 ↓ 1.1 3,839 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264547 fact_publishers_v4_1 (cost=54.05..3,617.79 rows=3,630 width=4) (actual time=0.235..1.647 rows=3,839 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=194
  • Buffers: shared hit=214
235. 0.213 0.213 ↓ 1.1 3,839 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264547 (cost=0.00..53.14 rows=3,630 width=0) (actual time=0.213..0.213 rows=3,839 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
236. 1.069 1.279 ↓ 1.1 3,583 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264611 fact_publishers_v4_2 (cost=47.99..3,463.86 rows=3,235 width=4) (actual time=0.231..1.279 rows=3,583 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=200
  • Buffers: shared hit=219
237. 0.210 0.210 ↓ 1.1 3,583 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264611 (cost=0.00..47.18 rows=3,235 width=0) (actual time=0.210..0.210 rows=3,583 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
238. 0.986 1.225 ↓ 1.1 3,542 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264675 fact_publishers_v4_3 (cost=48.53..3,528.34 rows=3,304 width=4) (actual time=0.257..1.225 rows=3,542 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=181
  • Buffers: shared hit=199
239. 0.239 0.239 ↓ 1.1 3,542 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264675 (cost=0.00..47.70 rows=3,304 width=0) (actual time=0.239..0.239 rows=3,542 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=18
240. 1.070 1.268 ↑ 1.0 3,477 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264739 fact_publishers_v4_4 (cost=51.50..3,682.92 rows=3,494 width=4) (actual time=0.214..1.268 rows=3,477 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=175
  • Buffers: shared hit=194
241. 0.198 0.198 ↑ 1.0 3,477 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264739 (cost=0.00..50.62 rows=3,494 width=0) (actual time=0.198..0.198 rows=3,477 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
242. 1.012 1.220 ↑ 1.1 3,535 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_06_264803 fact_publishers_v4_5 (cost=57.60..4,001.60 rows=3,894 width=4) (actual time=0.230..1.220 rows=3,535 loops=1)

  • Output: fact_publishers_v4_5.views
  • Recheck Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Heap Blocks: exact=187
  • Buffers: shared hit=208
243. 0.208 0.208 ↑ 1.1 3,535 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_06_country_idx_264803 (cost=0.00..56.62 rows=3,894 width=0) (actual time=0.208..0.208 rows=3,535 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
244. 1.003 1.218 ↑ 1.0 3,561 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264867 fact_publishers_v4_6 (cost=53.94..3,674.49 rows=3,615 width=4) (actual time=0.238..1.218 rows=3,561 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=185
  • Buffers: shared hit=205
245. 0.215 0.215 ↑ 1.0 3,561 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264867 (cost=0.00..53.03 rows=3,615 width=0) (actual time=0.215..0.215 rows=3,561 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
246. 0.952 1.158 ↑ 1.0 3,448 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264931 fact_publishers_v4_7 (cost=51.17..3,427.70 rows=3,452 width=4) (actual time=0.228..1.158 rows=3,448 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=177
  • Buffers: shared hit=198
247. 0.206 0.206 ↑ 1.0 3,448 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264931 (cost=0.00..50.31 rows=3,452 width=0) (actual time=0.206..0.206 rows=3,448 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
248. 1.403 1.657 ↑ 1.0 3,676 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_264995 fact_publishers_v4_8 (cost=55.38..3,730.09 rows=3,801 width=4) (actual time=0.279..1.657 rows=3,676 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=193
  • Buffers: shared hit=212
249. 0.254 0.254 ↑ 1.0 3,676 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_264995 (cost=0.00..54.43 rows=3,801 width=0) (actual time=0.254..0.254 rows=3,676 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
250. 1.163 1.423 ↓ 1.0 3,914 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265059 fact_publishers_v4_9 (cost=56.71..3,873.24 rows=3,780 width=4) (actual time=0.298..1.423 rows=3,914 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=204
  • Buffers: shared hit=225
251. 0.260 0.260 ↓ 1.0 3,914 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265059 (cost=0.00..55.77 rows=3,780 width=0) (actual time=0.260..0.260 rows=3,914 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
252. 1.086 1.343 ↑ 1.0 3,643 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265123 fact_publishers_v4_10 (cost=56.82..3,876.69 rows=3,794 width=4) (actual time=0.278..1.343 rows=3,643 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=186
  • Buffers: shared hit=208
253. 0.257 0.257 ↑ 1.0 3,643 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265123 (cost=0.00..55.88 rows=3,794 width=0) (actual time=0.257..0.257 rows=3,643 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
254. 0.983 1.195 ↑ 1.0 3,517 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265187 fact_publishers_v4_11 (cost=54.11..3,763.01 rows=3,637 width=4) (actual time=0.231..1.195 rows=3,517 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=181
  • Buffers: shared hit=201
255. 0.212 0.212 ↑ 1.0 3,517 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265187 (cost=0.00..53.20 rows=3,637 width=0) (actual time=0.212..0.212 rows=3,517 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
256. 1.018 1.234 ↓ 1.0 3,620 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265251 fact_publishers_v4_12 (cost=51.20..3,582.97 rows=3,456 width=4) (actual time=0.239..1.234 rows=3,620 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=182
  • Buffers: shared hit=203
257. 0.216 0.216 ↓ 1.0 3,620 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265251 (cost=0.00..50.34 rows=3,456 width=0) (actual time=0.216..0.216 rows=3,620 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
258. 1.157 1.398 ↑ 1.1 3,989 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265315 fact_publishers_v4_13 (cost=61.48..3,953.03 rows=4,201 width=4) (actual time=0.264..1.398 rows=3,989 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=199
  • Buffers: shared hit=219
259. 0.241 0.241 ↑ 1.1 3,989 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265315 (cost=0.00..60.43 rows=4,201 width=0) (actual time=0.241..0.241 rows=3,989 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
260. 1.094 1.344 ↓ 1.0 3,839 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265379 fact_publishers_v4_14 (cost=54.54..3,459.40 rows=3,693 width=4) (actual time=0.275..1.344 rows=3,839 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=193
  • Buffers: shared hit=214
261. 0.250 0.250 ↓ 1.0 3,839 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265379 (cost=0.00..53.62 rows=3,693 width=0) (actual time=0.250..0.250 rows=3,839 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
262. 4.115 28.637 ↑ 1.0 1 1

Aggregate (cost=52,360.59..52,360.60 rows=1 width=8) (actual time=28.636..28.637 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3088
263. 4.462 24.522 ↓ 1.0 53,876 1

Append (cost=48.65..52,227.41 rows=53,273 width=4) (actual time=0.329..24.522 rows=53,876 loops=1)

  • Buffers: shared hit=3088
264. 1.224 1.510 ↓ 1.0 3,386 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264484 fact_publishers_v4 (cost=48.65..3,201.19 rows=3,320 width=4) (actual time=0.328..1.510 rows=3,386 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=176
  • Buffers: shared hit=195
265. 0.286 0.286 ↓ 1.0 3,386 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264484 (cost=0.00..47.82 rows=3,320 width=0) (actual time=0.286..0.286 rows=3,386 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
266. 1.194 1.423 ↓ 1.1 3,629 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264548 fact_publishers_v4_1 (cost=51.18..3,296.86 rows=3,453 width=4) (actual time=0.250..1.423 rows=3,629 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=190
  • Buffers: shared hit=210
267. 0.229 0.229 ↓ 1.1 3,629 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264548 (cost=0.00..50.32 rows=3,453 width=0) (actual time=0.229..0.229 rows=3,629 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
268. 1.124 1.384 ↓ 1.1 3,724 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264612 fact_publishers_v4_2 (cost=51.85..3,433.52 rows=3,540 width=4) (actual time=0.297..1.384 rows=3,724 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=198
  • Buffers: shared hit=218
269. 0.260 0.260 ↓ 1.1 3,724 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264612 (cost=0.00..50.97 rows=3,540 width=0) (actual time=0.260..0.260 rows=3,724 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
270. 1.045 1.298 ↓ 1.0 3,624 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264676 fact_publishers_v4_3 (cost=53.67..3,489.47 rows=3,581 width=4) (actual time=0.271..1.298 rows=3,624 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=188
  • Buffers: shared hit=210
271. 0.253 0.253 ↓ 1.0 3,624 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264676 (cost=0.00..52.78 rows=3,581 width=0) (actual time=0.253..0.253 rows=3,624 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
272. 1.047 1.264 ↓ 1.0 3,619 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264740 fact_publishers_v4_4 (cost=53.92..3,543.04 rows=3,613 width=4) (actual time=0.238..1.264 rows=3,619 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=183
  • Buffers: shared hit=202
273. 0.217 0.217 ↓ 1.0 3,619 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264740 (cost=0.00..53.02 rows=3,613 width=0) (actual time=0.217..0.217 rows=3,619 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
274. 1.124 1.333 ↑ 1.0 3,582 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_06_264804 fact_publishers_v4_5 (cost=54.66..3,618.39 rows=3,708 width=4) (actual time=0.238..1.333 rows=3,582 loops=1)

  • Output: fact_publishers_v4_5.views
  • Recheck Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Heap Blocks: exact=194
  • Buffers: shared hit=214
275. 0.209 0.209 ↑ 1.0 3,582 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_06_country_idx_264804 (cost=0.00..53.73 rows=3,708 width=0) (actual time=0.209..0.209 rows=3,582 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
276. 0.930 1.131 ↓ 1.0 3,414 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264868 fact_publishers_v4_6 (cost=50.71..3,353.35 rows=3,392 width=4) (actual time=0.221..1.131 rows=3,414 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=185
  • Buffers: shared hit=204
277. 0.201 0.201 ↓ 1.0 3,414 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264868 (cost=0.00..49.86 rows=3,392 width=0) (actual time=0.201..0.201 rows=3,414 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
278. 1.112 1.428 ↓ 1.0 3,520 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264932 fact_publishers_v4_7 (cost=51.01..3,319.49 rows=3,431 width=4) (actual time=0.332..1.428 rows=3,520 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=176
  • Buffers: shared hit=196
279. 0.316 0.316 ↓ 1.0 3,520 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264932 (cost=0.00..50.15 rows=3,431 width=0) (actual time=0.315..0.316 rows=3,520 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
280. 1.080 1.289 ↑ 1.1 3,591 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_264996 fact_publishers_v4_8 (cost=56.99..3,619.64 rows=3,816 width=4) (actual time=0.227..1.289 rows=3,591 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=185
  • Buffers: shared hit=204
281. 0.209 0.209 ↑ 1.1 3,591 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_264996 (cost=0.00..56.04 rows=3,816 width=0) (actual time=0.209..0.209 rows=3,591 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
282. 1.263 1.496 ↑ 1.0 3,785 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265060 fact_publishers_v4_9 (cost=57.22..3,755.54 rows=3,845 width=4) (actual time=0.253..1.496 rows=3,785 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=205
  • Buffers: shared hit=226
283. 0.233 0.233 ↑ 1.0 3,785 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265060 (cost=0.00..56.26 rows=3,845 width=0) (actual time=0.233..0.233 rows=3,785 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
284. 1.106 1.341 ↓ 1.0 3,580 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265124 fact_publishers_v4_10 (cost=51.15..3,479.72 rows=3,449 width=4) (actual time=0.256..1.341 rows=3,580 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=183
  • Buffers: shared hit=202
285. 0.235 0.235 ↓ 1.0 3,580 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265124 (cost=0.00..50.29 rows=3,449 width=0) (actual time=0.235..0.235 rows=3,580 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
286. 0.975 1.185 ↓ 1.1 3,583 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265188 fact_publishers_v4_11 (cost=50.63..3,414.33 rows=3,382 width=4) (actual time=0.231..1.185 rows=3,583 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=181
  • Buffers: shared hit=202
287. 0.210 0.210 ↓ 1.1 3,583 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265188 (cost=0.00..49.78 rows=3,382 width=0) (actual time=0.210..0.210 rows=3,583 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
288. 0.961 1.162 ↓ 1.0 3,535 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265252 fact_publishers_v4_12 (cost=50.53..3,397.22 rows=3,369 width=4) (actual time=0.221..1.162 rows=3,535 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=182
  • Buffers: shared hit=203
289. 0.201 0.201 ↓ 1.0 3,535 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265252 (cost=0.00..49.69 rows=3,369 width=0) (actual time=0.201..0.201 rows=3,535 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
290. 1.390 1.586 ↑ 1.0 3,641 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265316 fact_publishers_v4_13 (cost=54.28..3,568.33 rows=3,659 width=4) (actual time=0.216..1.586 rows=3,641 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=178
  • Buffers: shared hit=198
291. 0.196 0.196 ↑ 1.0 3,641 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265316 (cost=0.00..53.36 rows=3,659 width=0) (actual time=0.196..0.196 rows=3,641 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
292. 1.014 1.230 ↑ 1.0 3,663 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265380 fact_publishers_v4_14 (cost=54.71..3,470.96 rows=3,715 width=4) (actual time=0.236..1.230 rows=3,663 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=184
  • Buffers: shared hit=204
293. 0.216 0.216 ↑ 1.0 3,663 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265380 (cost=0.00..53.78 rows=3,715 width=0) (actual time=0.216..0.216 rows=3,663 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
294. 3.127 22.227 ↑ 1.0 1 1

Aggregate (cost=43,898.83..43,898.84 rows=1 width=8) (actual time=22.226..22.227 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3534
295. 3.706 19.100 ↓ 1.0 49,881 1

Append (cost=0.42..43,775.85 rows=49,194 width=4) (actual time=0.031..19.100 rows=49,881 loops=1)

  • Buffers: shared hit=3534
296. 0.894 0.894 ↓ 1.0 2,644 1

Index Scan using fact_publishers_64_v4_2020_02_01_country_idx_264485 on public.fact_publishers_64_v4_2020_02_01_264485 fact_publishers_v4 (cost=0.42..2,388.99 rows=2,535 width=4) (actual time=0.030..0.894 rows=2,644 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=190
297. 0.908 0.908 ↑ 1.1 2,857 1

Index Scan using fact_publishers_64_v4_2020_02_02_country_idx_264549 on public.fact_publishers_64_v4_2020_02_02_264549 fact_publishers_v4_1 (cost=0.42..2,836.38 rows=3,065 width=4) (actual time=0.021..0.908 rows=2,857 loops=1)

  • Output: fact_publishers_v4_1.views
  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=212
298. 0.924 0.924 ↑ 1.0 3,002 1

Index Scan using fact_publishers_64_v4_2020_02_03_country_idx_264613 on public.fact_publishers_64_v4_2020_02_03_264613 fact_publishers_v4_2 (cost=0.42..2,546.16 rows=3,078 width=4) (actual time=0.022..0.924 rows=3,002 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=229
299. 0.935 0.935 ↓ 1.0 2,976 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264677 on public.fact_publishers_64_v4_2020_02_04_264677 fact_publishers_v4_3 (cost=0.42..2,582.33 rows=2,955 width=4) (actual time=0.026..0.935 rows=2,976 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=209
300. 0.828 0.828 ↓ 1.1 2,917 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264741 on public.fact_publishers_64_v4_2020_02_05_264741 fact_publishers_v4_4 (cost=0.42..2,470.43 rows=2,768 width=4) (actual time=0.022..0.828 rows=2,917 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=209
301. 0.903 0.903 ↑ 1.0 3,007 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264805 on public.fact_publishers_64_v4_2020_02_06_264805 fact_publishers_v4_5 (cost=0.42..2,686.46 rows=3,057 width=4) (actual time=0.032..0.903 rows=3,007 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=225
302. 1.105 1.105 ↓ 1.0 3,473 1

Index Scan using fact_publishers_64_v4_2020_02_07_country_idx_264869 on public.fact_publishers_64_v4_2020_02_07_264869 fact_publishers_v4_6 (cost=0.42..2,979.73 rows=3,433 width=4) (actual time=0.022..1.105 rows=3,473 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=243
303. 1.083 1.083 ↓ 1.0 3,359 1

Index Scan using fact_publishers_64_v4_2020_02_08_country_idx_264933 on public.fact_publishers_64_v4_2020_02_08_264933 fact_publishers_v4_7 (cost=0.42..2,974.51 rows=3,268 width=4) (actual time=0.020..1.083 rows=3,359 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=240
304. 1.231 1.231 ↑ 1.1 3,714 1

Index Scan using fact_publishers_64_v4_2020_02_09_country_idx_264997 on public.fact_publishers_64_v4_2020_02_09_264997 fact_publishers_v4_8 (cost=0.42..3,482.41 rows=3,951 width=4) (actual time=0.021..1.231 rows=3,714 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=255
305. 1.293 1.293 ↓ 1.0 3,774 1

Index Scan using fact_publishers_64_v4_2020_02_10_country_idx_265061 on public.fact_publishers_64_v4_2020_02_10_265061 fact_publishers_v4_9 (cost=0.42..3,026.68 rows=3,637 width=4) (actual time=0.020..1.293 rows=3,774 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=260
306. 1.058 1.058 ↓ 1.0 3,812 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265125 on public.fact_publishers_64_v4_2020_02_11_265125 fact_publishers_v4_10 (cost=0.42..3,128.88 rows=3,705 width=4) (actual time=0.018..1.058 rows=3,812 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=263
307. 0.995 0.995 ↑ 1.0 3,647 1

Index Scan using fact_publishers_64_v4_2020_02_12_country_idx_265189 on public.fact_publishers_64_v4_2020_02_12_265189 fact_publishers_v4_11 (cost=0.42..3,156.15 rows=3,650 width=4) (actual time=0.029..0.995 rows=3,647 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=246
308. 1.233 1.233 ↓ 1.1 3,683 1

Index Scan using fact_publishers_64_v4_2020_02_13_country_idx_265253 on public.fact_publishers_64_v4_2020_02_13_265253 fact_publishers_v4_12 (cost=0.42..3,125.93 rows=3,507 width=4) (actual time=0.021..1.233 rows=3,683 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=260
309. 1.099 1.099 ↓ 1.1 3,604 1

Index Scan using fact_publishers_64_v4_2020_02_14_country_idx_265317 on public.fact_publishers_64_v4_2020_02_14_265317 fact_publishers_v4_13 (cost=0.42..3,106.28 rows=3,381 width=4) (actual time=0.026..1.099 rows=3,604 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=250
310. 0.905 0.905 ↓ 1.1 3,412 1

Index Scan using fact_publishers_64_v4_2020_02_15_country_idx_265381 on public.fact_publishers_64_v4_2020_02_15_265381 fact_publishers_v4_14 (cost=0.42..3,038.55 rows=3,204 width=4) (actual time=0.021..0.905 rows=3,412 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=243
311. 3.878 30.937 ↑ 1.0 1 1

Aggregate (cost=53,608.57..53,608.58 rows=1 width=8) (actual time=30.937..30.937 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3282
312. 4.821 27.059 ↓ 1.0 58,367 1

Append (cost=54.15..53,463.39 rows=58,071 width=4) (actual time=0.288..27.059 rows=58,367 loops=1)

  • Buffers: shared hit=3282
313. 1.455 1.719 ↑ 1.0 3,540 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264486 fact_publishers_v4 (cost=54.15..3,223.19 rows=3,642 width=4) (actual time=0.288..1.719 rows=3,540 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=178
  • Buffers: shared hit=198
314. 0.264 0.264 ↑ 1.0 3,540 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264486 (cost=0.00..53.23 rows=3,642 width=0) (actual time=0.264..0.264 rows=3,540 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
315. 1.567 1.791 ↓ 1.0 3,634 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264550 fact_publishers_v4_1 (cost=53.64..3,231.62 rows=3,577 width=4) (actual time=0.242..1.791 rows=3,634 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=187
  • Buffers: shared hit=207
316. 0.224 0.224 ↓ 1.0 3,634 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264550 (cost=0.00..52.75 rows=3,577 width=0) (actual time=0.223..0.224 rows=3,634 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
317. 1.502 1.754 ↓ 1.0 4,026 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264614 fact_publishers_v4_2 (cost=58.49..3,676.20 rows=4,009 width=4) (actual time=0.271..1.754 rows=4,026 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=209
  • Buffers: shared hit=231
318. 0.252 0.252 ↓ 1.0 4,026 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264614 (cost=0.00..57.49 rows=4,009 width=0) (actual time=0.252..0.252 rows=4,026 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
319. 1.261 1.579 ↑ 1.0 4,030 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264678 fact_publishers_v4_3 (cost=60.58..3,748.42 rows=4,085 width=4) (actual time=0.338..1.579 rows=4,030 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=204
  • Buffers: shared hit=225
320. 0.318 0.318 ↑ 1.0 4,030 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264678 (cost=0.00..59.56 rows=4,085 width=0) (actual time=0.318..0.318 rows=4,030 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
321. 1.066 1.285 ↓ 1.0 4,080 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264742 fact_publishers_v4_4 (cost=60.46..3,759.53 rows=4,070 width=4) (actual time=0.253..1.285 rows=4,080 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=198
  • Buffers: shared hit=219
322. 0.219 0.219 ↓ 1.0 4,080 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264742 (cost=0.00..59.45 rows=4,070 width=0) (actual time=0.219..0.219 rows=4,080 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
323. 1.104 1.333 ↑ 1.0 4,029 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_06_264806 fact_publishers_v4_5 (cost=60.17..3,758.47 rows=4,032 width=4) (actual time=0.249..1.333 rows=4,029 loops=1)

  • Output: fact_publishers_v4_5.views
  • Recheck Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Heap Blocks: exact=210
  • Buffers: shared hit=232
324. 0.229 0.229 ↑ 1.0 4,029 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_06_country_idx_264806 (cost=0.00..59.16 rows=4,032 width=0) (actual time=0.229..0.229 rows=4,029 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
325. 1.213 1.554 ↑ 1.0 4,057 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264870 fact_publishers_v4_6 (cost=61.10..3,789.59 rows=4,152 width=4) (actual time=0.397..1.554 rows=4,057 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=209
  • Buffers: shared hit=231
326. 0.341 0.341 ↑ 1.0 4,057 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264870 (cost=0.00..60.06 rows=4,152 width=0) (actual time=0.341..0.341 rows=4,057 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
327. 1.036 1.292 ↓ 1.1 3,866 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264934 fact_publishers_v4_7 (cost=54.39..3,382.74 rows=3,673 width=4) (actual time=0.276..1.292 rows=3,866 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=197
  • Buffers: shared hit=219
328. 0.256 0.256 ↓ 1.1 3,866 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264934 (cost=0.00..53.47 rows=3,673 width=0) (actual time=0.256..0.256 rows=3,866 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
329. 1.080 1.309 ↑ 1.0 3,926 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_264998 fact_publishers_v4_8 (cost=59.67..3,653.35 rows=3,968 width=4) (actual time=0.249..1.309 rows=3,926 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=200
  • Buffers: shared hit=222
330. 0.229 0.229 ↑ 1.0 3,926 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_264998 (cost=0.00..58.68 rows=3,968 width=0) (actual time=0.229..0.229 rows=3,926 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
331. 1.122 1.387 ↓ 1.0 3,949 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265062 fact_publishers_v4_9 (cost=57.67..3,710.27 rows=3,903 width=4) (actual time=0.288..1.387 rows=3,949 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=210
  • Buffers: shared hit=231
332. 0.265 0.265 ↓ 1.0 3,949 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265062 (cost=0.00..56.69 rows=3,903 width=0) (actual time=0.265..0.265 rows=3,949 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
333. 1.174 1.494 ↓ 1.0 3,930 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265126 fact_publishers_v4_10 (cost=57.47..3,617.35 rows=3,878 width=4) (actual time=0.339..1.494 rows=3,930 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=194
  • Buffers: shared hit=215
334. 0.320 0.320 ↓ 1.0 3,930 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265126 (cost=0.00..56.50 rows=3,878 width=0) (actual time=0.320..0.320 rows=3,930 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
335. 1.173 1.416 ↑ 1.0 3,871 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265190 fact_publishers_v4_11 (cost=59.84..3,651.27 rows=3,990 width=4) (actual time=0.267..1.416 rows=3,871 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=193
  • Buffers: shared hit=216
336. 0.243 0.243 ↑ 1.0 3,871 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265190 (cost=0.00..58.84 rows=3,990 width=0) (actual time=0.243..0.243 rows=3,871 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
337. 1.232 1.477 ↓ 1.1 3,927 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265254 fact_publishers_v4_12 (cost=54.39..3,407.37 rows=3,673 width=4) (actual time=0.267..1.477 rows=3,927 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=193
  • Buffers: shared hit=214
338. 0.245 0.245 ↓ 1.1 3,927 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265254 (cost=0.00..53.47 rows=3,673 width=0) (actual time=0.245..0.245 rows=3,927 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
339. 1.229 1.524 ↓ 1.0 3,786 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265318 fact_publishers_v4_13 (cost=55.23..3,384.85 rows=3,782 width=4) (actual time=0.336..1.524 rows=3,786 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=193
  • Buffers: shared hit=215
340. 0.295 0.295 ↓ 1.0 3,786 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265318 (cost=0.00..54.28 rows=3,782 width=0) (actual time=0.295..0.295 rows=3,786 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
341. 1.057 1.324 ↓ 1.0 3,716 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265382 fact_publishers_v4_14 (cost=54.11..3,178.81 rows=3,637 width=4) (actual time=0.285..1.324 rows=3,716 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=186
  • Buffers: shared hit=207
342. 0.267 0.267 ↓ 1.0 3,716 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265382 (cost=0.00..53.20 rows=3,637 width=0) (actual time=0.267..0.267 rows=3,716 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
343. 6.073 43.089 ↑ 1.0 1 1

Aggregate (cost=59,440.16..59,440.17 rows=1 width=8) (actual time=43.089..43.089 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=5154
344. 7.799 37.016 ↑ 1.0 81,676 1

Append (cost=79.38..59,235.70 rows=81,782 width=4) (actual time=0.404..37.016 rows=81,676 loops=1)

  • Buffers: shared hit=5154
345. 1.509 1.878 ↑ 1.0 5,280 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264487 fact_publishers_v4 (cost=79.38..4,328.58 rows=5,350 width=4) (actual time=0.403..1.878 rows=5,280 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=252
  • Buffers: shared hit=282
346. 0.369 0.369 ↑ 1.0 5,280 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264487 (cost=0.00..78.05 rows=5,350 width=0) (actual time=0.369..0.369 rows=5,280 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
347. 1.983 2.333 ↓ 1.0 5,351 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264551 fact_publishers_v4_1 (cost=76.84..4,287.36 rows=5,216 width=4) (actual time=0.380..2.333 rows=5,351 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=250
  • Buffers: shared hit=278
348. 0.350 0.350 ↓ 1.0 5,351 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264551 (cost=0.00..75.54 rows=5,216 width=0) (actual time=0.350..0.350 rows=5,351 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=28
349. 2.399 2.399 ↓ 1.0 5,395 1

Index Scan using fact_publishers_64_v4_2020_02_03_country_idx_264615 on public.fact_publishers_64_v4_2020_02_03_264615 fact_publishers_v4_2 (cost=0.42..4,558.07 rows=5,324 width=4) (actual time=0.020..2.399 rows=5,395 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=362
350. 2.159 2.159 ↑ 1.0 5,492 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264679 on public.fact_publishers_64_v4_2020_02_04_264679 fact_publishers_v4_3 (cost=0.42..4,500.56 rows=5,742 width=4) (actual time=0.042..2.159 rows=5,492 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=360
351. 2.038 2.038 ↓ 1.0 5,652 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264743 on public.fact_publishers_64_v4_2020_02_05_264743 fact_publishers_v4_4 (cost=0.42..4,307.31 rows=5,462 width=4) (actual time=0.031..2.038 rows=5,652 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=359
352. 1.904 1.904 ↓ 1.0 5,310 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264807 on public.fact_publishers_64_v4_2020_02_06_264807 fact_publishers_v4_5 (cost=0.42..3,945.68 rows=5,212 width=4) (actual time=0.026..1.904 rows=5,310 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=348
353. 1.904 1.904 ↓ 1.0 5,328 1

Index Scan using fact_publishers_64_v4_2020_02_07_country_idx_264871 on public.fact_publishers_64_v4_2020_02_07_264871 fact_publishers_v4_6 (cost=0.42..3,618.67 rows=5,247 width=4) (actual time=0.037..1.904 rows=5,328 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=343
354. 1.682 1.682 ↑ 1.0 5,248 1

Index Scan using fact_publishers_64_v4_2020_02_08_country_idx_264935 on public.fact_publishers_64_v4_2020_02_08_264935 fact_publishers_v4_7 (cost=0.42..3,332.40 rows=5,322 width=4) (actual time=0.026..1.682 rows=5,248 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=343
355. 1.880 1.880 ↓ 1.0 5,537 1

Index Scan using fact_publishers_64_v4_2020_02_09_country_idx_264999 on public.fact_publishers_64_v4_2020_02_09_264999 fact_publishers_v4_8 (cost=0.42..3,465.13 rows=5,327 width=4) (actual time=0.048..1.880 rows=5,537 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=361
356. 1.817 1.817 ↑ 1.1 5,496 1

Index Scan using fact_publishers_64_v4_2020_02_10_country_idx_265063 on public.fact_publishers_64_v4_2020_02_10_265063 fact_publishers_v4_9 (cost=0.42..4,246.80 rows=5,931 width=4) (actual time=0.028..1.817 rows=5,496 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=356
357. 1.792 1.792 ↑ 1.0 5,415 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265127 on public.fact_publishers_64_v4_2020_02_11_265127 fact_publishers_v4_10 (cost=0.42..3,915.42 rows=5,641 width=4) (actual time=0.040..1.792 rows=5,415 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=347
358. 1.966 1.966 ↑ 1.0 5,712 1

Index Scan using fact_publishers_64_v4_2020_02_12_country_idx_265191 on public.fact_publishers_64_v4_2020_02_12_265191 fact_publishers_v4_11 (cost=0.42..4,048.00 rows=5,830 width=4) (actual time=0.028..1.966 rows=5,712 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=357
359. 1.866 1.866 ↑ 1.0 5,677 1

Index Scan using fact_publishers_64_v4_2020_02_13_country_idx_265255 on public.fact_publishers_64_v4_2020_02_13_265255 fact_publishers_v4_12 (cost=0.42..3,512.54 rows=5,708 width=4) (actual time=0.028..1.866 rows=5,677 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=362
360. 1.767 1.767 ↓ 1.0 5,430 1

Index Scan using fact_publishers_64_v4_2020_02_14_country_idx_265319 on public.fact_publishers_64_v4_2020_02_14_265319 fact_publishers_v4_13 (cost=0.42..3,277.72 rows=5,302 width=4) (actual time=0.025..1.767 rows=5,430 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=344
361. 1.832 1.832 ↓ 1.0 5,353 1

Index Scan using fact_publishers_64_v4_2020_02_15_country_idx_265383 on public.fact_publishers_64_v4_2020_02_15_265383 fact_publishers_v4_14 (cost=0.42..3,482.57 rows=5,168 width=4) (actual time=0.026..1.832 rows=5,353 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=352
362. 4.006 29.899 ↑ 1.0 1 1

Aggregate (cost=57,844.97..57,844.98 rows=1 width=8) (actual time=29.898..29.899 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3834
363. 5.229 25.893 ↓ 1.0 58,338 1

Append (cost=47.28..57,700.24 rows=57,894 width=4) (actual time=0.228..25.893 rows=58,338 loops=1)

  • Buffers: shared hit=3834
364. 0.942 1.149 ↑ 1.0 3,086 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264488 fact_publishers_v4 (cost=47.28..3,274.05 rows=3,143 width=4) (actual time=0.227..1.149 rows=3,086 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=159
  • Buffers: shared hit=176
365. 0.207 0.207 ↑ 1.0 3,086 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264488 (cost=0.00..46.49 rows=3,143 width=0) (actual time=0.207..0.207 rows=3,086 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=17
366. 1.244 1.543 ↓ 1.1 3,224 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264552 fact_publishers_v4_1 (cost=44.82..3,190.65 rows=3,019 width=4) (actual time=0.334..1.543 rows=3,224 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=169
  • Buffers: shared hit=190
367. 0.299 0.299 ↓ 1.1 3,224 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264552 (cost=0.00..44.06 rows=3,019 width=0) (actual time=0.299..0.299 rows=3,224 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
368. 1.308 1.308 ↓ 1.0 3,495 1

Index Scan using fact_publishers_64_v4_2020_02_03_country_idx_264616 on public.fact_publishers_64_v4_2020_02_03_264616 fact_publishers_v4_2 (cost=0.42..3,671.12 rows=3,463 width=4) (actual time=0.040..1.308 rows=3,495 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=249
369. 1.121 1.121 ↓ 1.0 3,371 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264680 on public.fact_publishers_64_v4_2020_02_04_264680 fact_publishers_v4_3 (cost=0.42..3,366.06 rows=3,312 width=4) (actual time=0.027..1.121 rows=3,371 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=237
370. 1.156 1.156 ↓ 1.1 3,496 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264744 on public.fact_publishers_64_v4_2020_02_05_264744 fact_publishers_v4_4 (cost=0.42..3,122.90 rows=3,193 width=4) (actual time=0.026..1.156 rows=3,496 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=238
371. 1.188 1.188 ↓ 1.0 3,447 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264808 on public.fact_publishers_64_v4_2020_02_06_264808 fact_publishers_v4_5 (cost=0.42..3,307.90 rows=3,434 width=4) (actual time=0.033..1.188 rows=3,447 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=239
372. 1.342 1.342 ↓ 1.0 3,872 1

Index Scan using fact_publishers_64_v4_2020_02_07_country_idx_264872 on public.fact_publishers_64_v4_2020_02_07_264872 fact_publishers_v4_6 (cost=0.42..3,382.92 rows=3,738 width=4) (actual time=0.023..1.342 rows=3,872 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=273
373. 1.340 1.340 ↓ 1.0 3,863 1

Index Scan using fact_publishers_64_v4_2020_02_08_country_idx_264936 on public.fact_publishers_64_v4_2020_02_08_264936 fact_publishers_v4_7 (cost=0.42..3,550.60 rows=3,803 width=4) (actual time=0.026..1.340 rows=3,863 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=264
374. 1.444 1.444 ↑ 1.0 4,203 1

Index Scan using fact_publishers_64_v4_2020_02_09_country_idx_265000 on public.fact_publishers_64_v4_2020_02_09_265000 fact_publishers_v4_8 (cost=0.42..4,048.80 rows=4,253 width=4) (actual time=0.031..1.444 rows=4,203 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=284
375. 1.542 1.542 ↑ 1.0 4,342 1

Index Scan using fact_publishers_64_v4_2020_02_10_country_idx_265064 on public.fact_publishers_64_v4_2020_02_10_265064 fact_publishers_v4_9 (cost=0.42..3,931.75 rows=4,363 width=4) (actual time=0.033..1.542 rows=4,342 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=290
376. 1.543 1.543 ↑ 1.0 4,275 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265128 on public.fact_publishers_64_v4_2020_02_11_265128 fact_publishers_v4_10 (cost=0.42..4,178.24 rows=4,409 width=4) (actual time=0.029..1.543 rows=4,275 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=284
377. 1.500 1.500 ↑ 1.0 4,344 1

Index Scan using fact_publishers_64_v4_2020_02_12_country_idx_265192 on public.fact_publishers_64_v4_2020_02_12_265192 fact_publishers_v4_11 (cost=0.42..4,488.66 rows=4,415 width=4) (actual time=0.026..1.500 rows=4,344 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=285
378. 1.469 1.469 ↓ 1.0 4,590 1

Index Scan using fact_publishers_64_v4_2020_02_13_country_idx_265256 on public.fact_publishers_64_v4_2020_02_13_265256 fact_publishers_v4_12 (cost=0.42..4,772.54 rows=4,560 width=4) (actual time=0.029..1.469 rows=4,590 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=299
379. 1.590 1.590 ↑ 1.0 4,502 1

Index Scan using fact_publishers_64_v4_2020_02_14_country_idx_265320 on public.fact_publishers_64_v4_2020_02_14_265320 fact_publishers_v4_13 (cost=0.42..4,803.96 rows=4,610 width=4) (actual time=0.039..1.590 rows=4,502 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=297
380. 1.163 1.429 ↓ 1.0 4,228 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265384 fact_publishers_v4_14 (cost=62.81..4,320.62 rows=4,179 width=4) (actual time=0.295..1.429 rows=4,228 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=204
  • Buffers: shared hit=229
381. 0.266 0.266 ↓ 1.0 4,228 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265384 (cost=0.00..61.77 rows=4,179 width=0) (actual time=0.266..0.266 rows=4,228 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
382. 1.710 13.940 ↑ 1.0 1 1

Aggregate (cost=30,881.11..30,881.12 rows=1 width=8) (actual time=13.940..13.940 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=2009
383. 1.992 12.230 ↓ 1.0 28,531 1

Append (cost=24.67..30,810.49 rows=28,248 width=4) (actual time=0.124..12.230 rows=28,531 loops=1)

  • Buffers: shared hit=2009
384. 0.602 0.711 ↑ 1.1 1,455 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264489 fact_publishers_v4 (cost=24.67..1,741.19 rows=1,580 width=4) (actual time=0.123..0.711 rows=1,455 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=102
  • Buffers: shared hit=112
385. 0.109 0.109 ↑ 1.1 1,455 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264489 (cost=0.00..24.27 rows=1,580 width=0) (actual time=0.109..0.109 rows=1,455 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=10
386. 0.555 0.660 ↓ 1.0 1,529 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264553 fact_publishers_v4_1 (cost=22.40..1,658.81 rows=1,481 width=4) (actual time=0.114..0.660 rows=1,529 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=101
  • Buffers: shared hit=112
387. 0.105 0.105 ↓ 1.0 1,529 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264553 (cost=0.00..22.03 rows=1,481 width=0) (actual time=0.105..0.105 rows=1,529 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=11
388. 0.620 0.726 ↓ 1.1 1,629 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264617 fact_publishers_v4_2 (cost=22.17..1,663.15 rows=1,452 width=4) (actual time=0.119..0.726 rows=1,629 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=117
  • Buffers: shared hit=129
389. 0.106 0.106 ↓ 1.1 1,629 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264617 (cost=0.00..21.81 rows=1,452 width=0) (actual time=0.106..0.106 rows=1,629 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=12
390. 0.625 0.748 ↑ 1.1 1,669 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264681 fact_publishers_v4_3 (cost=26.04..1,951.62 rows=1,757 width=4) (actual time=0.134..0.748 rows=1,669 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=114
  • Buffers: shared hit=125
391. 0.123 0.123 ↑ 1.1 1,669 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264681 (cost=0.00..25.60 rows=1,757 width=0) (actual time=0.123..0.123 rows=1,669 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=11
392. 0.579 0.690 ↑ 1.0 1,641 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264745 fact_publishers_v4_4 (cost=25.29..1,862.29 rows=1,660 width=4) (actual time=0.122..0.690 rows=1,641 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=109
  • Buffers: shared hit=120
393. 0.111 0.111 ↑ 1.0 1,641 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264745 (cost=0.00..24.87 rows=1,660 width=0) (actual time=0.111..0.111 rows=1,641 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=11
394. 0.440 0.545 ↓ 1.0 1,628 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_06_264809 fact_publishers_v4_5 (cost=24.80..1,826.86 rows=1,597 width=4) (actual time=0.117..0.545 rows=1,628 loops=1)

  • Output: fact_publishers_v4_5.views
  • Recheck Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Heap Blocks: exact=116
  • Buffers: shared hit=127
395. 0.105 0.105 ↓ 1.0 1,628 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_06_country_idx_264809 (cost=0.00..24.40 rows=1,597 width=0) (actual time=0.105..0.105 rows=1,628 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=11
396. 0.572 0.678 ↓ 1.1 2,054 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264873 fact_publishers_v4_6 (cost=28.93..2,141.62 rows=1,937 width=4) (actual time=0.117..0.678 rows=2,054 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=132
  • Buffers: shared hit=146
397. 0.106 0.106 ↓ 1.1 2,054 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264873 (cost=0.00..28.45 rows=1,937 width=0) (actual time=0.106..0.106 rows=2,054 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=14
398. 0.613 0.727 ↑ 1.0 1,987 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264937 fact_publishers_v4_7 (cost=31.43..2,218.16 rows=2,066 width=4) (actual time=0.126..0.727 rows=1,987 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=123
  • Buffers: shared hit=137
399. 0.114 0.114 ↑ 1.0 1,987 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264937 (cost=0.00..30.91 rows=2,066 width=0) (actual time=0.114..0.114 rows=1,987 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=14
400. 0.514 0.618 ↑ 1.0 2,092 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_265001 fact_publishers_v4_8 (cost=31.81..2,234.34 rows=2,115 width=4) (actual time=0.117..0.618 rows=2,092 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=130
  • Buffers: shared hit=143
401. 0.104 0.104 ↑ 1.0 2,092 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_265001 (cost=0.00..31.28 rows=2,115 width=0) (actual time=0.104..0.104 rows=2,092 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
402. 0.548 0.682 ↑ 1.0 2,061 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265065 fact_publishers_v4_9 (cost=31.67..2,250.00 rows=2,097 width=4) (actual time=0.149..0.682 rows=2,061 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=129
  • Buffers: shared hit=142
403. 0.134 0.134 ↑ 1.0 2,061 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265065 (cost=0.00..31.15 rows=2,097 width=0) (actual time=0.134..0.134 rows=2,061 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
404. 0.575 0.682 ↓ 1.1 2,122 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265129 fact_publishers_v4_10 (cost=30.97..2,173.78 rows=2,007 width=4) (actual time=0.118..0.682 rows=2,122 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=120
  • Buffers: shared hit=134
405. 0.107 0.107 ↓ 1.1 2,122 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265129 (cost=0.00..30.47 rows=2,007 width=0) (actual time=0.106..0.107 rows=2,122 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=14
406. 0.609 0.712 ↓ 1.1 2,148 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265193 fact_publishers_v4_11 (cost=30.66..2,137.29 rows=1,967 width=4) (actual time=0.117..0.712 rows=2,148 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=132
  • Buffers: shared hit=144
407. 0.103 0.103 ↓ 1.1 2,148 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265193 (cost=0.00..30.17 rows=1,967 width=0) (actual time=0.103..0.103 rows=2,148 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=12
408. 0.564 0.668 ↑ 1.0 2,177 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265257 fact_publishers_v4_12 (cost=33.81..2,300.94 rows=2,180 width=4) (actual time=0.118..0.668 rows=2,177 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=135
  • Buffers: shared hit=148
409. 0.104 0.104 ↑ 1.0 2,177 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265257 (cost=0.00..33.27 rows=2,180 width=0) (actual time=0.104..0.104 rows=2,177 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
410. 0.569 0.675 ↓ 1.0 2,151 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265321 fact_publishers_v4_13 (cost=31.76..2,204.63 rows=2,109 width=4) (actual time=0.119..0.675 rows=2,151 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=133
  • Buffers: shared hit=146
411. 0.106 0.106 ↓ 1.0 2,151 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265321 (cost=0.00..31.24 rows=2,109 width=0) (actual time=0.106..0.106 rows=2,151 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
412. 0.594 0.716 ↑ 1.0 2,188 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265385 fact_publishers_v4_14 (cost=34.30..2,304.56 rows=2,243 width=4) (actual time=0.136..0.716 rows=2,188 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=131
  • Buffers: shared hit=144
413. 0.122 0.122 ↑ 1.0 2,188 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265385 (cost=0.00..33.74 rows=2,243 width=0) (actual time=0.122..0.122 rows=2,188 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
414. 4.915 35.444 ↑ 1.0 1 1

Aggregate (cost=63,708.26..63,708.27 rows=1 width=8) (actual time=35.443..35.444 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=4713
415. 5.862 30.529 ↑ 1.0 71,185 1

Append (cost=0.42..63,530.26 rows=71,202 width=4) (actual time=0.031..30.529 rows=71,185 loops=1)

  • Buffers: shared hit=4713
416. 1.981 1.981 ↑ 1.0 4,737 1

Index Scan using fact_publishers_64_v4_2020_02_01_country_idx_264490 on public.fact_publishers_64_v4_2020_02_01_264490 fact_publishers_v4 (cost=0.42..4,145.14 rows=4,796 width=4) (actual time=0.030..1.981 rows=4,737 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=315
417. 1.767 1.767 ↓ 1.0 4,777 1

Index Scan using fact_publishers_64_v4_2020_02_02_country_idx_264554 on public.fact_publishers_64_v4_2020_02_02_264554 fact_publishers_v4_1 (cost=0.42..4,214.57 rows=4,698 width=4) (actual time=0.023..1.767 rows=4,777 loops=1)

  • Output: fact_publishers_v4_1.views
  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=314
418. 1.786 1.786 ↓ 1.1 4,869 1

Index Scan using fact_publishers_64_v4_2020_02_03_country_idx_264618 on public.fact_publishers_64_v4_2020_02_03_264618 fact_publishers_v4_2 (cost=0.42..4,021.93 rows=4,560 width=4) (actual time=0.029..1.786 rows=4,869 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=324
419. 1.758 1.758 ↑ 1.1 4,858 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264682 on public.fact_publishers_64_v4_2020_02_04_264682 fact_publishers_v4_3 (cost=0.42..4,485.56 rows=5,237 width=4) (actual time=0.028..1.758 rows=4,858 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=317
420. 1.686 1.686 ↑ 1.0 4,824 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264746 on public.fact_publishers_64_v4_2020_02_05_264746 fact_publishers_v4_4 (cost=0.42..4,285.76 rows=4,875 width=4) (actual time=0.028..1.686 rows=4,824 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=317
421. 1.536 1.536 ↑ 1.0 4,729 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264810 on public.fact_publishers_64_v4_2020_02_06_264810 fact_publishers_v4_5 (cost=0.42..4,307.55 rows=4,796 width=4) (actual time=0.024..1.536 rows=4,729 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=327
422. 1.779 1.779 ↓ 1.1 4,714 1

Index Scan using fact_publishers_64_v4_2020_02_07_country_idx_264874 on public.fact_publishers_64_v4_2020_02_07_264874 fact_publishers_v4_6 (cost=0.42..3,988.55 rows=4,484 width=4) (actual time=0.048..1.779 rows=4,714 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=319
423. 1.453 1.453 ↑ 1.0 4,508 1

Index Scan using fact_publishers_64_v4_2020_02_08_country_idx_264938 on public.fact_publishers_64_v4_2020_02_08_264938 fact_publishers_v4_7 (cost=0.42..4,064.10 rows=4,514 width=4) (actual time=0.028..1.453 rows=4,508 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=295
424. 1.689 1.689 ↑ 1.0 4,874 1

Index Scan using fact_publishers_64_v4_2020_02_09_country_idx_265002 on public.fact_publishers_64_v4_2020_02_09_265002 fact_publishers_v4_8 (cost=0.42..4,446.69 rows=4,993 width=4) (actual time=0.024..1.689 rows=4,874 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=314
425. 1.659 1.659 ↓ 1.0 4,999 1

Index Scan using fact_publishers_64_v4_2020_02_10_country_idx_265066 on public.fact_publishers_64_v4_2020_02_10_265066 fact_publishers_v4_9 (cost=0.42..4,408.72 rows=4,946 width=4) (actual time=0.027..1.659 rows=4,999 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=335
426. 1.666 1.666 ↑ 1.1 4,988 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265130 on public.fact_publishers_64_v4_2020_02_11_265130 fact_publishers_v4_10 (cost=0.42..4,589.09 rows=5,250 width=4) (actual time=0.026..1.666 rows=4,988 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=330
427. 1.379 1.379 ↑ 1.0 4,581 1

Index Scan using fact_publishers_64_v4_2020_02_12_country_idx_265194 on public.fact_publishers_64_v4_2020_02_12_265194 fact_publishers_v4_11 (cost=0.42..4,131.51 rows=4,610 width=4) (actual time=0.025..1.379 rows=4,581 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=301
428. 1.546 1.546 ↓ 1.0 4,665 1

Index Scan using fact_publishers_64_v4_2020_02_13_country_idx_265258 on public.fact_publishers_64_v4_2020_02_13_265258 fact_publishers_v4_12 (cost=0.42..4,214.98 rows=4,652 width=4) (actual time=0.022..1.546 rows=4,665 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=313
429. 1.489 1.489 ↓ 1.1 4,645 1

Index Scan using fact_publishers_64_v4_2020_02_14_country_idx_265322 on public.fact_publishers_64_v4_2020_02_14_265322 fact_publishers_v4_13 (cost=0.42..3,918.65 rows=4,366 width=4) (actual time=0.028..1.489 rows=4,645 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=307
430. 1.493 1.493 ↑ 1.0 4,417 1

Index Scan using fact_publishers_64_v4_2020_02_15_country_idx_265386 on public.fact_publishers_64_v4_2020_02_15_265386 fact_publishers_v4_14 (cost=0.42..3,951.44 rows=4,425 width=4) (actual time=0.026..1.493 rows=4,417 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=285
431. 3.287 25.381 ↑ 1.0 1 1

Aggregate (cost=46,047.31..46,047.32 rows=1 width=8) (actual time=25.381..25.381 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3043
432. 4.055 22.094 ↓ 1.0 49,312 1

Append (cost=0.42..45,924.49 rows=49,126 width=4) (actual time=0.035..22.094 rows=49,312 loops=1)

  • Buffers: shared hit=3043
433. 1.344 1.344 ↓ 1.0 2,954 1

Index Scan using fact_publishers_64_v4_2020_02_01_country_idx_264491 on public.fact_publishers_64_v4_2020_02_01_264491 fact_publishers_v4 (cost=0.42..2,648.04 rows=2,931 width=4) (actual time=0.034..1.344 rows=2,954 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=214
434. 0.996 1.218 ↓ 1.0 3,145 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264555 fact_publishers_v4_1 (cost=44.79..2,746.61 rows=3,016 width=4) (actual time=0.252..1.218 rows=3,145 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=164
  • Buffers: shared hit=183
435. 0.222 0.222 ↓ 1.0 3,145 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264555 (cost=0.00..44.04 rows=3,016 width=0) (actual time=0.222..0.222 rows=3,145 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
436. 1.147 1.374 ↓ 1.0 3,603 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264619 fact_publishers_v4_2 (cost=52.10..3,277.88 rows=3,572 width=4) (actual time=0.246..1.374 rows=3,603 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=192
  • Buffers: shared hit=212
437. 0.227 0.227 ↓ 1.0 3,603 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264619 (cost=0.00..51.21 rows=3,572 width=0) (actual time=0.226..0.227 rows=3,603 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
438. 1.058 1.277 ↓ 1.0 3,552 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264683 fact_publishers_v4_3 (cost=51.13..3,219.85 rows=3,447 width=4) (actual time=0.239..1.277 rows=3,552 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=185
  • Buffers: shared hit=204
439. 0.219 0.219 ↓ 1.0 3,552 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264683 (cost=0.00..50.27 rows=3,447 width=0) (actual time=0.218..0.219 rows=3,552 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
440. 1.015 1.239 ↓ 1.0 3,427 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264747 fact_publishers_v4_4 (cost=50.51..3,181.14 rows=3,367 width=4) (actual time=0.244..1.239 rows=3,427 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=176
  • Buffers: shared hit=196
441. 0.224 0.224 ↓ 1.0 3,427 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264747 (cost=0.00..49.67 rows=3,367 width=0) (actual time=0.224..0.224 rows=3,427 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
442. 1.170 1.170 ↓ 1.0 3,314 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264811 on public.fact_publishers_64_v4_2020_02_06_264811 fact_publishers_v4_5 (cost=0.42..3,163.38 rows=3,280 width=4) (actual time=0.028..1.170 rows=3,314 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=230
443. 1.034 1.237 ↑ 1.1 3,416 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264875 fact_publishers_v4_6 (cost=54.35..3,321.15 rows=3,668 width=4) (actual time=0.225..1.237 rows=3,416 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=184
  • Buffers: shared hit=203
444. 0.203 0.203 ↑ 1.1 3,416 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264875 (cost=0.00..53.43 rows=3,668 width=0) (actual time=0.203..0.203 rows=3,416 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
445. 0.891 1.066 ↓ 1.0 2,929 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264939 fact_publishers_v4_7 (cost=43.93..2,697.30 rows=2,905 width=4) (actual time=0.195..1.066 rows=2,929 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=155
  • Buffers: shared hit=171
446. 0.175 0.175 ↓ 1.0 2,929 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264939 (cost=0.00..43.21 rows=2,905 width=0) (actual time=0.175..0.175 rows=2,929 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=16
447. 0.965 1.166 ↑ 1.0 3,328 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_265003 fact_publishers_v4_8 (cost=50.70..3,048.40 rows=3,391 width=4) (actual time=0.236..1.166 rows=3,328 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=180
  • Buffers: shared hit=199
448. 0.201 0.201 ↑ 1.0 3,328 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_265003 (cost=0.00..49.85 rows=3,391 width=0) (actual time=0.201..0.201 rows=3,328 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
449. 1.040 1.250 ↓ 1.0 3,505 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265067 fact_publishers_v4_9 (cost=50.59..3,228.35 rows=3,377 width=4) (actual time=0.230..1.250 rows=3,505 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=196
  • Buffers: shared hit=216
450. 0.210 0.210 ↓ 1.0 3,505 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265067 (cost=0.00..49.75 rows=3,377 width=0) (actual time=0.210..0.210 rows=3,505 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
451. 1.167 1.167 ↓ 1.0 3,349 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265131 on public.fact_publishers_64_v4_2020_02_11_265131 fact_publishers_v4_10 (cost=0.42..3,143.39 rows=3,281 width=4) (actual time=0.026..1.167 rows=3,349 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=233
452. 0.954 1.164 ↑ 1.1 3,311 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265195 fact_publishers_v4_11 (cost=53.83..3,316.33 rows=3,601 width=4) (actual time=0.230..1.164 rows=3,311 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=170
  • Buffers: shared hit=187
453. 0.210 0.210 ↑ 1.1 3,311 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265195 (cost=0.00..52.93 rows=3,601 width=0) (actual time=0.210..0.210 rows=3,311 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=17
454. 0.988 1.218 ↓ 1.0 3,328 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265259 fact_publishers_v4_12 (cost=48.43..3,112.42 rows=3,292 width=4) (actual time=0.249..1.218 rows=3,328 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=179
  • Buffers: shared hit=196
455. 0.230 0.230 ↓ 1.0 3,328 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265259 (cost=0.00..47.61 rows=3,292 width=0) (actual time=0.230..0.230 rows=3,328 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=17
456. 0.897 1.094 ↓ 1.0 3,150 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265323 fact_publishers_v4_13 (cost=47.20..2,922.46 rows=3,133 width=4) (actual time=0.215..1.094 rows=3,150 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=166
  • Buffers: shared hit=184
457. 0.197 0.197 ↓ 1.0 3,150 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265323 (cost=0.00..46.42 rows=3,133 width=0) (actual time=0.196..0.197 rows=3,150 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=18
458. 1.055 1.055 ↓ 1.0 3,001 1

Index Scan using fact_publishers_64_v4_2020_02_15_country_idx_265387 on public.fact_publishers_64_v4_2020_02_15_265387 fact_publishers_v4_14 (cost=0.42..2,652.17 rows=2,865 width=4) (actual time=0.037..1.055 rows=3,001 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=215
459. 5.536 39.939 ↑ 1.0 1 1

Aggregate (cost=66,041.46..66,041.47 rows=1 width=8) (actual time=39.938..39.939 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=4578
460. 7.369 34.403 ↓ 1.0 69,244 1

Append (cost=0.42..65,868.76 rows=69,083 width=4) (actual time=0.048..34.403 rows=69,244 loops=1)

  • Buffers: shared hit=4578
461. 2.097 2.097 ↓ 1.0 4,509 1

Index Scan using fact_publishers_64_v4_2020_02_01_country_idx_264492 on public.fact_publishers_64_v4_2020_02_01_264492 fact_publishers_v4 (cost=0.42..4,318.35 rows=4,404 width=4) (actual time=0.047..2.097 rows=4,509 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=296
462. 2.024 2.024 ↑ 1.0 4,489 1

Index Scan using fact_publishers_64_v4_2020_02_02_country_idx_264556 on public.fact_publishers_64_v4_2020_02_02_264556 fact_publishers_v4_1 (cost=0.42..4,544.03 rows=4,707 width=4) (actual time=0.051..2.024 rows=4,489 loops=1)

  • Output: fact_publishers_v4_1.views
  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=293
463. 1.919 1.919 ↓ 1.1 4,580 1

Index Scan using fact_publishers_64_v4_2020_02_03_country_idx_264620 on public.fact_publishers_64_v4_2020_02_03_264620 fact_publishers_v4_2 (cost=0.42..3,887.24 rows=4,052 width=4) (actual time=0.029..1.919 rows=4,580 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=308
464. 1.755 1.755 ↑ 1.0 4,720 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264684 on public.fact_publishers_64_v4_2020_02_04_264684 fact_publishers_v4_3 (cost=0.42..4,638.39 rows=4,869 width=4) (actual time=0.029..1.755 rows=4,720 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=315
465. 1.749 1.749 ↓ 1.1 4,655 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264748 on public.fact_publishers_64_v4_2020_02_05_264748 fact_publishers_v4_4 (cost=0.42..4,206.40 rows=4,379 width=4) (actual time=0.037..1.749 rows=4,655 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=315
466. 1.913 1.913 ↓ 1.0 4,660 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264812 on public.fact_publishers_64_v4_2020_02_06_264812 fact_publishers_v4_5 (cost=0.42..4,269.00 rows=4,465 width=4) (actual time=0.024..1.913 rows=4,660 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=321
467. 1.727 1.727 ↓ 1.0 4,506 1

Index Scan using fact_publishers_64_v4_2020_02_07_country_idx_264876 on public.fact_publishers_64_v4_2020_02_07_264876 fact_publishers_v4_6 (cost=0.42..4,228.38 rows=4,350 width=4) (actual time=0.047..1.727 rows=4,506 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=300
468. 1.828 1.828 ↓ 1.0 4,512 1

Index Scan using fact_publishers_64_v4_2020_02_08_country_idx_264940 on public.fact_publishers_64_v4_2020_02_08_264940 fact_publishers_v4_7 (cost=0.42..4,409.89 rows=4,448 width=4) (actual time=0.033..1.828 rows=4,512 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=294
469. 1.617 1.617 ↑ 1.0 4,746 1

Index Scan using fact_publishers_64_v4_2020_02_09_country_idx_265004 on public.fact_publishers_64_v4_2020_02_09_265004 fact_publishers_v4_8 (cost=0.42..4,664.43 rows=4,958 width=4) (actual time=0.030..1.617 rows=4,746 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=304
470. 1.772 1.772 ↑ 1.0 4,768 1

Index Scan using fact_publishers_64_v4_2020_02_10_country_idx_265068 on public.fact_publishers_64_v4_2020_02_10_265068 fact_publishers_v4_9 (cost=0.42..4,387.58 rows=4,829 width=4) (actual time=0.026..1.772 rows=4,768 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=321
471. 2.070 2.070 ↑ 1.0 4,701 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265132 on public.fact_publishers_64_v4_2020_02_11_265132 fact_publishers_v4_10 (cost=0.42..4,311.03 rows=4,722 width=4) (actual time=0.036..2.070 rows=4,701 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=316
472. 1.787 1.787 ↑ 1.1 4,704 1

Index Scan using fact_publishers_64_v4_2020_02_12_country_idx_265196 on public.fact_publishers_64_v4_2020_02_12_265196 fact_publishers_v4_11 (cost=0.42..4,511.35 rows=4,975 width=4) (actual time=0.028..1.787 rows=4,704 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=307
473. 1.622 1.622 ↓ 1.0 4,674 1

Index Scan using fact_publishers_64_v4_2020_02_13_country_idx_265260 on public.fact_publishers_64_v4_2020_02_13_265260 fact_publishers_v4_12 (cost=0.42..4,257.16 rows=4,618 width=4) (actual time=0.027..1.622 rows=4,674 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=306
474. 1.583 1.583 ↑ 1.1 4,507 1

Index Scan using fact_publishers_64_v4_2020_02_14_country_idx_265324 on public.fact_publishers_64_v4_2020_02_14_265324 fact_publishers_v4_13 (cost=0.42..4,508.91 rows=4,781 width=4) (actual time=0.029..1.583 rows=4,507 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=289
475. 1.571 1.571 ↑ 1.0 4,513 1

Index Scan using fact_publishers_64_v4_2020_02_15_country_idx_265388 on public.fact_publishers_64_v4_2020_02_15_265388 fact_publishers_v4_14 (cost=0.42..4,381.20 rows=4,526 width=4) (actual time=0.050..1.571 rows=4,513 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=293
476. 3.642 28.205 ↑ 1.0 1 1

Aggregate (cost=57,548.91..57,548.92 rows=1 width=8) (actual time=28.205..28.205 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3578
477. 4.320 24.563 ↑ 1.0 65,342 1

Append (cost=54.63..57,385.54 rows=65,347 width=4) (actual time=0.249..24.563 rows=65,342 loops=1)

  • Buffers: shared hit=3578
478. 1.319 1.547 ↓ 1.1 3,926 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264493 fact_publishers_v4 (cost=54.63..3,164.34 rows=3,705 width=4) (actual time=0.248..1.547 rows=3,926 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=196
  • Buffers: shared hit=219
479. 0.228 0.228 ↓ 1.1 3,926 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264493 (cost=0.00..53.71 rows=3,705 width=0) (actual time=0.228..0.228 rows=3,926 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
480. 1.149 1.473 ↑ 1.0 4,106 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264557 fact_publishers_v4_1 (cost=61.14..3,512.96 rows=4,157 width=4) (actual time=0.349..1.473 rows=4,106 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=203
  • Buffers: shared hit=225
481. 0.324 0.324 ↑ 1.0 4,106 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264557 (cost=0.00..60.10 rows=4,157 width=0) (actual time=0.324..0.324 rows=4,106 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
482. 1.166 1.418 ↓ 1.0 4,485 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264621 fact_publishers_v4_2 (cost=66.60..3,926.17 rows=4,475 width=4) (actual time=0.271..1.418 rows=4,485 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=227
  • Buffers: shared hit=251
483. 0.252 0.252 ↓ 1.0 4,485 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264621 (cost=0.00..65.48 rows=4,475 width=0) (actual time=0.252..0.252 rows=4,485 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
484. 1.233 1.467 ↑ 1.0 4,541 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264685 fact_publishers_v4_3 (cost=69.74..4,073.32 rows=4,686 width=4) (actual time=0.253..1.467 rows=4,541 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=227
  • Buffers: shared hit=252
485. 0.234 0.234 ↑ 1.0 4,541 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264685 (cost=0.00..68.56 rows=4,686 width=0) (actual time=0.234..0.234 rows=4,541 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
486. 1.091 1.369 ↓ 1.0 4,639 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264749 fact_publishers_v4_4 (cost=66.55..3,987.63 rows=4,468 width=4) (actual time=0.298..1.369 rows=4,639 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=232
  • Buffers: shared hit=257
487. 0.278 0.278 ↓ 1.0 4,639 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264749 (cost=0.00..65.43 rows=4,468 width=0) (actual time=0.278..0.278 rows=4,639 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
488. 1.139 1.373 ↓ 1.0 4,470 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_06_264813 fact_publishers_v4_5 (cost=65.86..3,930.39 rows=4,380 width=4) (actual time=0.253..1.373 rows=4,470 loops=1)

  • Output: fact_publishers_v4_5.views
  • Recheck Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Heap Blocks: exact=227
  • Buffers: shared hit=251
489. 0.234 0.234 ↓ 1.0 4,470 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_06_country_idx_264813 (cost=0.00..64.77 rows=4,380 width=0) (actual time=0.234..0.234 rows=4,470 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
490. 1.009 1.228 ↓ 1.0 4,374 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264877 fact_publishers_v4_6 (cost=64.06..3,814.18 rows=4,341 width=4) (actual time=0.238..1.228 rows=4,374 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=214
  • Buffers: shared hit=238
491. 0.219 0.219 ↓ 1.0 4,374 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264877 (cost=0.00..62.98 rows=4,341 width=0) (actual time=0.219..0.219 rows=4,374 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
492. 1.178 1.455 ↓ 1.0 3,982 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264941 fact_publishers_v4_7 (cost=57.29..3,343.02 rows=3,854 width=4) (actual time=0.297..1.455 rows=3,982 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=200
  • Buffers: shared hit=219
493. 0.277 0.277 ↓ 1.0 3,982 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264941 (cost=0.00..56.33 rows=3,854 width=0) (actual time=0.277..0.277 rows=3,982 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
494. 1.019 1.209 ↑ 1.1 4,197 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_265005 fact_publishers_v4_8 (cost=66.27..3,735.03 rows=4,432 width=4) (actual time=0.206..1.209 rows=4,197 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=214
  • Buffers: shared hit=237
495. 0.190 0.190 ↑ 1.1 4,197 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_265005 (cost=0.00..65.16 rows=4,432 width=0) (actual time=0.190..0.190 rows=4,197 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
496. 1.167 1.421 ↑ 1.1 4,555 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265069 fact_publishers_v4_9 (cost=70.53..4,152.07 rows=4,788 width=4) (actual time=0.271..1.421 rows=4,555 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=225
  • Buffers: shared hit=250
497. 0.254 0.254 ↑ 1.1 4,555 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265069 (cost=0.00..69.33 rows=4,788 width=0) (actual time=0.254..0.254 rows=4,555 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
498. 1.099 1.322 ↑ 1.0 4,471 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265133 fact_publishers_v4_10 (cost=69.19..4,013.99 rows=4,616 width=4) (actual time=0.238..1.322 rows=4,471 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=211
  • Buffers: shared hit=236
499. 0.223 0.223 ↑ 1.0 4,471 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265133 (cost=0.00..68.04 rows=4,616 width=0) (actual time=0.223..0.223 rows=4,471 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
500. 1.042 1.266 ↓ 1.0 4,510 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265197 fact_publishers_v4_11 (cost=64.25..3,903.66 rows=4,365 width=4) (actual time=0.242..1.266 rows=4,510 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=222
  • Buffers: shared hit=246
501. 0.224 0.224 ↓ 1.0 4,510 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265197 (cost=0.00..63.16 rows=4,365 width=0) (actual time=0.224..0.224 rows=4,510 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
502. 1.061 1.308 ↑ 1.0 4,547 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265261 fact_publishers_v4_12 (cost=67.47..4,070.08 rows=4,587 width=4) (actual time=0.267..1.308 rows=4,547 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=220
  • Buffers: shared hit=243
503. 0.247 0.247 ↑ 1.0 4,547 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265261 (cost=0.00..66.32 rows=4,587 width=0) (actual time=0.247..0.247 rows=4,547 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
504. 0.978 1.184 ↓ 1.0 4,299 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265325 fact_publishers_v4_13 (cost=63.69..3,798.30 rows=4,293 width=4) (actual time=0.226..1.184 rows=4,299 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=207
  • Buffers: shared hit=230
505. 0.206 0.206 ↓ 1.0 4,299 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265325 (cost=0.00..62.62 rows=4,293 width=0) (actual time=0.206..0.206 rows=4,299 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
506. 1.008 1.203 ↓ 1.0 4,240 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265389 fact_publishers_v4_14 (cost=61.47..3,633.65 rows=4,200 width=4) (actual time=0.214..1.203 rows=4,240 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=203
  • Buffers: shared hit=224
507. 0.195 0.195 ↓ 1.0 4,240 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265389 (cost=0.00..60.42 rows=4,200 width=0) (actual time=0.195..0.195 rows=4,240 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
508. 1.468 12.230 ↑ 1.0 1 1

Aggregate (cost=18,834.20..18,834.21 rows=1 width=8) (actual time=12.230..12.230 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=2091
509. 1.799 10.762 ↑ 1.0 24,419 1

Append (cost=0.42..18,772.98 rows=24,487 width=4) (actual time=0.032..10.762 rows=24,419 loops=1)

  • Buffers: shared hit=2091
510. 0.520 0.520 ↓ 1.0 1,538 1

Index Scan using fact_publishers_64_v4_2020_02_01_country_idx_264494 on public.fact_publishers_64_v4_2020_02_01_264494 fact_publishers_v4 (cost=0.42..1,076.99 rows=1,514 width=4) (actual time=0.031..0.520 rows=1,538 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=127
511. 0.661 0.661 ↑ 1.0 1,662 1

Index Scan using fact_publishers_64_v4_2020_02_02_country_idx_264558 on public.fact_publishers_64_v4_2020_02_02_264558 fact_publishers_v4_1 (cost=0.42..1,272.63 rows=1,732 width=4) (actual time=0.025..0.661 rows=1,662 loops=1)

  • Output: fact_publishers_v4_1.views
  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=142
512. 0.656 0.656 ↑ 1.0 1,680 1

Index Scan using fact_publishers_64_v4_2020_02_03_country_idx_264622 on public.fact_publishers_64_v4_2020_02_03_264622 fact_publishers_v4_2 (cost=0.42..1,172.78 rows=1,684 width=4) (actual time=0.021..0.656 rows=1,680 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=146
513. 0.603 0.603 ↑ 1.0 1,643 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264686 on public.fact_publishers_64_v4_2020_02_04_264686 fact_publishers_v4_3 (cost=0.42..1,154.76 rows=1,669 width=4) (actual time=0.024..0.603 rows=1,643 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=146
514. 0.510 0.510 ↓ 1.0 1,563 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264750 on public.fact_publishers_64_v4_2020_02_05_264750 fact_publishers_v4_4 (cost=0.42..1,158.45 rows=1,560 width=4) (actual time=0.022..0.510 rows=1,563 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=130
515. 0.550 0.550 ↑ 1.0 1,652 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264814 on public.fact_publishers_64_v4_2020_02_06_264814 fact_publishers_v4_5 (cost=0.42..1,240.21 rows=1,655 width=4) (actual time=0.023..0.550 rows=1,652 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=146
516. 0.654 0.654 ↓ 1.0 1,688 1

Index Scan using fact_publishers_64_v4_2020_02_07_country_idx_264878 on public.fact_publishers_64_v4_2020_02_07_264878 fact_publishers_v4_6 (cost=0.42..1,272.01 rows=1,629 width=4) (actual time=0.041..0.654 rows=1,688 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=155
517. 0.497 0.497 ↑ 1.0 1,454 1

Index Scan using fact_publishers_64_v4_2020_02_08_country_idx_264942 on public.fact_publishers_64_v4_2020_02_08_264942 fact_publishers_v4_7 (cost=0.42..1,096.42 rows=1,488 width=4) (actual time=0.027..0.497 rows=1,454 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=133
518. 0.677 0.677 ↑ 1.0 1,630 1

Index Scan using fact_publishers_64_v4_2020_02_09_country_idx_265006 on public.fact_publishers_64_v4_2020_02_09_265006 fact_publishers_v4_8 (cost=0.42..1,231.11 rows=1,679 width=4) (actual time=0.021..0.677 rows=1,630 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=137
519. 0.583 0.583 ↓ 1.0 1,766 1

Index Scan using fact_publishers_64_v4_2020_02_10_country_idx_265070 on public.fact_publishers_64_v4_2020_02_10_265070 fact_publishers_v4_9 (cost=0.42..1,312.89 rows=1,734 width=4) (actual time=0.033..0.583 rows=1,766 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=150
520. 0.621 0.621 ↑ 1.0 1,706 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265134 on public.fact_publishers_64_v4_2020_02_11_265134 fact_publishers_v4_10 (cost=0.42..1,302.15 rows=1,728 width=4) (actual time=0.018..0.621 rows=1,706 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=142
521. 0.686 0.686 ↑ 1.0 1,626 1

Index Scan using fact_publishers_64_v4_2020_02_12_country_idx_265198 on public.fact_publishers_64_v4_2020_02_12_265198 fact_publishers_v4_11 (cost=0.42..1,322.81 rows=1,662 width=4) (actual time=0.020..0.686 rows=1,626 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=135
522. 0.672 0.672 ↑ 1.0 1,682 1

Index Scan using fact_publishers_64_v4_2020_02_13_country_idx_265262 on public.fact_publishers_64_v4_2020_02_13_265262 fact_publishers_v4_12 (cost=0.42..1,485.14 rows=1,715 width=4) (actual time=0.023..0.672 rows=1,682 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=140
523. 0.578 0.578 ↓ 1.0 1,594 1

Index Scan using fact_publishers_64_v4_2020_02_14_country_idx_265326 on public.fact_publishers_64_v4_2020_02_14_265326 fact_publishers_v4_13 (cost=0.42..1,344.09 rows=1,588 width=4) (actual time=0.043..0.578 rows=1,594 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=135
524. 0.495 0.495 ↓ 1.1 1,535 1

Index Scan using fact_publishers_64_v4_2020_02_15_country_idx_265390 on public.fact_publishers_64_v4_2020_02_15_265390 fact_publishers_v4_14 (cost=0.42..1,208.11 rows=1,450 width=4) (actual time=0.018..0.495 rows=1,535 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=127
525. 6.299 44.980 ↑ 1.0 1 1

Aggregate (cost=81,372.05..81,372.06 rows=1 width=8) (actual time=44.980..44.980 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=4585
526. 7.412 38.681 ↑ 1.0 89,486 1

Append (cost=77.67..81,147.26 rows=89,914 width=4) (actual time=0.461..38.681 rows=89,486 loops=1)

  • Buffers: shared hit=4585
527. 1.483 1.907 ↓ 1.0 5,392 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264495 fact_publishers_v4 (cost=77.67..4,770.61 rows=5,323 width=4) (actual time=0.460..1.907 rows=5,392 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=249
  • Buffers: shared hit=278
528. 0.424 0.424 ↓ 1.0 5,392 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264495 (cost=0.00..76.34 rows=5,323 width=0) (actual time=0.424..0.424 rows=5,392 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
529. 1.562 1.969 ↓ 1.0 5,659 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264559 fact_publishers_v4_1 (cost=78.28..4,865.43 rows=5,401 width=4) (actual time=0.436..1.969 rows=5,659 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=262
  • Buffers: shared hit=293
530. 0.407 0.407 ↓ 1.0 5,659 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264559 (cost=0.00..76.93 rows=5,401 width=0) (actual time=0.407..0.407 rows=5,659 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
531. 1.777 2.142 ↑ 1.0 6,140 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264623 fact_publishers_v4_2 (cost=90.09..5,598.83 rows=6,151 width=4) (actual time=0.401..2.142 rows=6,140 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=288
  • Buffers: shared hit=319
532. 0.365 0.365 ↑ 1.0 6,140 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264623 (cost=0.00..88.55 rows=6,151 width=0) (actual time=0.365..0.365 rows=6,140 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
533. 1.808 2.200 ↑ 1.1 6,530 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264687 fact_publishers_v4_3 (cost=104.01..6,187.78 rows=7,172 width=4) (actual time=0.424..2.200 rows=6,530 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=299
  • Buffers: shared hit=331
534. 0.392 0.392 ↑ 1.1 6,530 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264687 (cost=0.00..102.21 rows=7,172 width=0) (actual time=0.392..0.392 rows=6,530 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=32
535. 1.879 2.288 ↓ 1.0 6,578 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264751 fact_publishers_v4_4 (cost=93.72..5,726.84 rows=6,425 width=4) (actual time=0.445..2.288 rows=6,578 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=293
  • Buffers: shared hit=327
536. 0.409 0.409 ↓ 1.0 6,578 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264751 (cost=0.00..92.11 rows=6,425 width=0) (actual time=0.409..0.409 rows=6,578 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=34
537. 1.910 2.325 ↓ 1.0 6,559 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_06_264815 fact_publishers_v4_5 (cost=94.09..5,755.63 rows=6,473 width=4) (actual time=0.451..2.325 rows=6,559 loops=1)

  • Output: fact_publishers_v4_5.views
  • Recheck Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Heap Blocks: exact=302
  • Buffers: shared hit=335
538. 0.415 0.415 ↓ 1.0 6,559 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_06_country_idx_264815 (cost=0.00..92.47 rows=6,473 width=0) (actual time=0.415..0.415 rows=6,559 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
539. 1.784 2.178 ↑ 1.1 6,102 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264879 fact_publishers_v4_6 (cost=96.02..5,698.11 rows=6,529 width=4) (actual time=0.427..2.178 rows=6,102 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=287
  • Buffers: shared hit=317
540. 0.394 0.394 ↑ 1.1 6,102 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264879 (cost=0.00..94.39 rows=6,529 width=0) (actual time=0.394..0.394 rows=6,102 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
541. 1.562 1.954 ↑ 1.1 5,684 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264943 fact_publishers_v4_7 (cost=89.16..5,202.12 rows=6,031 width=4) (actual time=0.425..1.954 rows=5,684 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=262
  • Buffers: shared hit=293
542. 0.392 0.392 ↑ 1.1 5,684 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264943 (cost=0.00..87.65 rows=6,031 width=0) (actual time=0.391..0.392 rows=5,684 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
543. 1.712 2.072 ↑ 1.0 5,952 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_265007 fact_publishers_v4_8 (cost=90.00..5,402.44 rows=6,139 width=4) (actual time=0.392..2.072 rows=5,952 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=274
  • Buffers: shared hit=305
544. 0.360 0.360 ↑ 1.0 5,952 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_265007 (cost=0.00..88.46 rows=6,139 width=0) (actual time=0.360..0.360 rows=5,952 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
545. 1.689 2.086 ↓ 1.0 6,115 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265071 fact_publishers_v4_9 (cost=86.83..5,535.27 rows=5,923 width=4) (actual time=0.431..2.086 rows=6,115 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=285
  • Buffers: shared hit=318
546. 0.397 0.397 ↓ 1.0 6,115 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265071 (cost=0.00..85.34 rows=5,923 width=0) (actual time=0.397..0.397 rows=6,115 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
547. 2.066 2.474 ↓ 1.0 6,037 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265135 fact_publishers_v4_10 (cost=84.50..5,461.74 rows=5,816 width=4) (actual time=0.441..2.474 rows=6,037 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=276
  • Buffers: shared hit=309
548. 0.408 0.408 ↓ 1.0 6,037 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265135 (cost=0.00..83.04 rows=5,816 width=0) (actual time=0.408..0.408 rows=6,037 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
549. 1.632 2.002 ↑ 1.0 5,768 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_12_265199 fact_publishers_v4_11 (cost=87.01..5,495.91 rows=5,947 width=4) (actual time=0.403..2.002 rows=5,768 loops=1)

  • Output: fact_publishers_v4_11.views
  • Recheck Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Heap Blocks: exact=263
  • Buffers: shared hit=292
550. 0.370 0.370 ↑ 1.0 5,768 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_12_country_idx_265199 (cost=0.00..85.52 rows=5,947 width=0) (actual time=0.370..0.370 rows=5,768 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
551. 1.592 1.950 ↓ 1.0 5,939 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_13_265263 fact_publishers_v4_12 (cost=86.83..5,373.96 rows=5,924 width=4) (actual time=0.390..1.950 rows=5,939 loops=1)

  • Output: fact_publishers_v4_12.views
  • Recheck Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Heap Blocks: exact=273
  • Buffers: shared hit=305
552. 0.358 0.358 ↓ 1.0 5,939 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_13_country_idx_265263 (cost=0.00..85.35 rows=5,924 width=0) (actual time=0.358..0.358 rows=5,939 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=32
553. 1.549 1.905 ↓ 1.1 5,559 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_14_265327 fact_publishers_v4_13 (cost=77.38..4,824.84 rows=5,285 width=4) (actual time=0.385..1.905 rows=5,559 loops=1)

  • Output: fact_publishers_v4_13.views
  • Recheck Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Heap Blocks: exact=251
  • Buffers: shared hit=281
554. 0.356 0.356 ↓ 1.1 5,559 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_14_country_idx_265327 (cost=0.00..76.06 rows=5,285 width=0) (actual time=0.356..0.356 rows=5,559 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
555. 1.493 1.817 ↓ 1.0 5,472 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_15_265391 fact_publishers_v4_14 (cost=79.58..4,798.18 rows=5,375 width=4) (actual time=0.352..1.817 rows=5,472 loops=1)

  • Output: fact_publishers_v4_14.views
  • Recheck Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Heap Blocks: exact=251
  • Buffers: shared hit=282
556. 0.324 0.324 ↓ 1.0 5,472 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_15_country_idx_265391 (cost=0.00..78.23 rows=5,375 width=0) (actual time=0.324..0.324 rows=5,472 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
557. 1.816 14.285 ↑ 1.0 1 1

Aggregate (cost=22,853.05..22,853.06 rows=1 width=8) (actual time=14.285..14.285 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=2004
558. 1.914 12.469 ↓ 1.0 22,748 1

Append (cost=0.42..22,797.23 rows=22,329 width=4) (actual time=0.046..12.469 rows=22,748 loops=1)

  • Buffers: shared hit=2004
559. 0.568 0.568 ↓ 1.1 1,259 1

Index Scan using fact_publishers_64_v4_2020_02_01_country_idx_264496 on public.fact_publishers_64_v4_2020_02_01_264496 fact_publishers_v4 (cost=0.42..1,216.72 rows=1,137 width=4) (actual time=0.045..0.568 rows=1,259 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=125
560. 0.490 0.490 ↓ 1.1 1,345 1

Index Scan using fact_publishers_64_v4_2020_02_02_country_idx_264560 on public.fact_publishers_64_v4_2020_02_02_264560 fact_publishers_v4_1 (cost=0.42..1,305.85 rows=1,239 width=4) (actual time=0.022..0.490 rows=1,345 loops=1)

  • Output: fact_publishers_v4_1.views
  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=123
561. 0.795 0.795 ↓ 1.0 1,480 1

Index Scan using fact_publishers_64_v4_2020_02_03_country_idx_264624 on public.fact_publishers_64_v4_2020_02_03_264624 fact_publishers_v4_2 (cost=0.42..1,575.85 rows=1,470 width=4) (actual time=0.024..0.795 rows=1,480 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=137
562. 0.966 0.966 ↓ 1.1 1,647 1

Index Scan using fact_publishers_64_v4_2020_02_04_country_idx_264688 on public.fact_publishers_64_v4_2020_02_04_264688 fact_publishers_v4_3 (cost=0.42..1,606.64 rows=1,493 width=4) (actual time=0.038..0.966 rows=1,647 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=144
563. 0.738 0.738 ↑ 1.0 1,639 1

Index Scan using fact_publishers_64_v4_2020_02_05_country_idx_264752 on public.fact_publishers_64_v4_2020_02_05_264752 fact_publishers_v4_4 (cost=0.42..1,736.95 rows=1,707 width=4) (actual time=0.026..0.738 rows=1,639 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=137
564. 0.724 0.724 ↓ 1.1 1,602 1

Index Scan using fact_publishers_64_v4_2020_02_06_country_idx_264816 on public.fact_publishers_64_v4_2020_02_06_264816 fact_publishers_v4_5 (cost=0.42..1,474.16 rows=1,514 width=4) (actual time=0.025..0.724 rows=1,602 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=147
565. 1.285 1.285 ↑ 1.1 1,553 1

Index Scan using fact_publishers_64_v4_2020_02_07_country_idx_264880 on public.fact_publishers_64_v4_2020_02_07_264880 fact_publishers_v4_6 (cost=0.42..1,625.06 rows=1,661 width=4) (actual time=0.029..1.285 rows=1,553 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=138
566. 0.680 0.680 ↑ 1.0 1,425 1

Index Scan using fact_publishers_64_v4_2020_02_08_country_idx_264944 on public.fact_publishers_64_v4_2020_02_08_264944 fact_publishers_v4_7 (cost=0.42..1,451.19 rows=1,477 width=4) (actual time=0.032..0.680 rows=1,425 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=130
567. 0.788 0.788 ↓ 1.0 1,540 1

Index Scan using fact_publishers_64_v4_2020_02_09_country_idx_265008 on public.fact_publishers_64_v4_2020_02_09_265008 fact_publishers_v4_8 (cost=0.42..1,519.62 rows=1,497 width=4) (actual time=0.036..0.788 rows=1,540 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=132
568. 0.596 0.596 ↓ 1.0 1,630 1

Index Scan using fact_publishers_64_v4_2020_02_10_country_idx_265072 on public.fact_publishers_64_v4_2020_02_10_265072 fact_publishers_v4_9 (cost=0.42..1,565.81 rows=1,574 width=4) (actual time=0.025..0.596 rows=1,630 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=144
569. 0.623 0.623 ↓ 1.1 1,586 1

Index Scan using fact_publishers_64_v4_2020_02_11_country_idx_265136 on public.fact_publishers_64_v4_2020_02_11_265136 fact_publishers_v4_10 (cost=0.42..1,508.25 rows=1,493 width=4) (actual time=0.024..0.623 rows=1,586 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=131
570. 0.649 0.649 ↑ 1.0 1,584 1

Index Scan using fact_publishers_64_v4_2020_02_12_country_idx_265200 on public.fact_publishers_64_v4_2020_02_12_265200 fact_publishers_v4_11 (cost=0.42..1,622.40 rows=1,636 width=4) (actual time=0.024..0.649 rows=1,584 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=130
571. 0.563 0.563 ↓ 1.0 1,541 1

Index Scan using fact_publishers_64_v4_2020_02_13_country_idx_265264 on public.fact_publishers_64_v4_2020_02_13_265264 fact_publishers_v4_12 (cost=0.42..1,544.02 rows=1,531 width=4) (actual time=0.019..0.563 rows=1,541 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=130
572. 0.518 0.518 ↑ 1.0 1,404 1

Index Scan using fact_publishers_64_v4_2020_02_14_country_idx_265328 on public.fact_publishers_64_v4_2020_02_14_265328 fact_publishers_v4_13 (cost=0.42..1,474.09 rows=1,417 width=4) (actual time=0.021..0.518 rows=1,404 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=121
573. 0.572 0.572 ↓ 1.0 1,513 1

Index Scan using fact_publishers_64_v4_2020_02_15_country_idx_265392 on public.fact_publishers_64_v4_2020_02_15_265392 fact_publishers_v4_14 (cost=0.42..1,458.98 rows=1,483 width=4) (actual time=0.023..0.572 rows=1,513 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=135
574. 3.983 29.412 ↑ 1.0 1 1

Aggregate (cost=64,346.17..64,346.18 rows=1 width=8) (actual time=29.412..29.412 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3453
575. 4.649 25.429 ↑ 1.0 62,409 1

Append (cost=57.61..64,189.10 rows=62,829 width=4) (actual time=0.441..25.429 rows=62,409 loops=1)

  • Buffers: shared hit=3453
576. 1.522 1.914 ↑ 1.0 3,833 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_01_264497 fact_publishers_v4 (cost=57.61..3,743.80 rows=3,896 width=4) (actual time=0.441..1.914 rows=3,833 loops=1)

  • Output: fact_publishers_v4.views
  • Recheck Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=198
  • Buffers: shared hit=219
577. 0.392 0.392 ↑ 1.0 3,833 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_01_country_idx_264497 (cost=0.00..56.64 rows=3,896 width=0) (actual time=0.392..0.392 rows=3,833 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
578. 1.313 1.640 ↓ 1.0 4,034 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_02_264561 fact_publishers_v4_1 (cost=57.30..3,787.96 rows=3,856 width=4) (actual time=0.417..1.640 rows=4,034 loops=1)

  • Output: fact_publishers_v4_1.views
  • Recheck Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Heap Blocks: exact=199
  • Buffers: shared hit=220
579. 0.327 0.327 ↓ 1.0 4,034 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_02_country_idx_264561 (cost=0.00..56.34 rows=3,856 width=0) (actual time=0.327..0.327 rows=4,034 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
580. 1.480 1.731 ↓ 1.1 4,610 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_03_264625 fact_publishers_v4_2 (cost=63.79..4,398.33 rows=4,305 width=4) (actual time=0.272..1.731 rows=4,610 loops=1)

  • Output: fact_publishers_v4_2.views
  • Recheck Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Heap Blocks: exact=233
  • Buffers: shared hit=260
581. 0.251 0.251 ↓ 1.1 4,610 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_03_country_idx_264625 (cost=0.00..62.71 rows=4,305 width=0) (actual time=0.251..0.251 rows=4,610 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=27
582. 1.137 1.446 ↓ 1.0 4,313 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_04_264689 fact_publishers_v4_3 (cost=60.81..4,238.99 rows=4,114 width=4) (actual time=0.328..1.446 rows=4,313 loops=1)

  • Output: fact_publishers_v4_3.views
  • Recheck Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Heap Blocks: exact=204
  • Buffers: shared hit=228
583. 0.309 0.309 ↓ 1.0 4,313 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_04_country_idx_264689 (cost=0.00..59.78 rows=4,114 width=0) (actual time=0.309..0.309 rows=4,313 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
584. 1.318 1.740 ↑ 1.0 4,230 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_05_264753 fact_publishers_v4_4 (cost=63.32..4,384.74 rows=4,245 width=4) (actual time=0.443..1.740 rows=4,230 loops=1)

  • Output: fact_publishers_v4_4.views
  • Recheck Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Heap Blocks: exact=214
  • Buffers: shared hit=237
585. 0.422 0.422 ↑ 1.0 4,230 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_05_country_idx_264753 (cost=0.00..62.26 rows=4,245 width=0) (actual time=0.422..0.422 rows=4,230 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
586. 1.163 1.401 ↑ 1.0 4,305 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_06_264817 fact_publishers_v4_5 (cost=66.87..4,659.02 rows=4,510 width=4) (actual time=0.260..1.401 rows=4,305 loops=1)

  • Output: fact_publishers_v4_5.views
  • Recheck Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Heap Blocks: exact=212
  • Buffers: shared hit=236
587. 0.238 0.238 ↑ 1.0 4,305 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_06_country_idx_264817 (cost=0.00..65.75 rows=4,510 width=0) (actual time=0.238..0.238 rows=4,305 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
588. 1.050 1.321 ↑ 1.1 4,171 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_07_264881 fact_publishers_v4_6 (cost=67.14..4,603.94 rows=4,544 width=4) (actual time=0.293..1.321 rows=4,171 loops=1)

  • Output: fact_publishers_v4_6.views
  • Recheck Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Heap Blocks: exact=213
  • Buffers: shared hit=235
589. 0.271 0.271 ↑ 1.1 4,171 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_07_country_idx_264881 (cost=0.00..66.00 rows=4,544 width=0) (actual time=0.271..0.271 rows=4,171 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
590. 0.982 1.177 ↑ 1.0 3,687 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_08_264945 fact_publishers_v4_7 (cost=56.51..3,843.62 rows=3,754 width=4) (actual time=0.213..1.177 rows=3,687 loops=1)

  • Output: fact_publishers_v4_7.views
  • Recheck Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Heap Blocks: exact=190
  • Buffers: shared hit=210
591. 0.195 0.195 ↑ 1.0 3,687 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_08_country_idx_264945 (cost=0.00..55.58 rows=3,754 width=0) (actual time=0.195..0.195 rows=3,687 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
592. 0.982 1.182 ↑ 1.1 3,999 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_09_265009 fact_publishers_v4_8 (cost=63.06..4,230.28 rows=4,212 width=4) (actual time=0.217..1.182 rows=3,999 loops=1)

  • Output: fact_publishers_v4_8.views
  • Recheck Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Heap Blocks: exact=198
  • Buffers: shared hit=219
593. 0.200 0.200 ↑ 1.1 3,999 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_09_country_idx_265009 (cost=0.00..62.01 rows=4,212 width=0) (actual time=0.200..0.200 rows=3,999 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
594. 1.062 1.287 ↑ 1.0 4,427 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_10_265073 fact_publishers_v4_9 (cost=67.21..4,696.59 rows=4,553 width=4) (actual time=0.244..1.287 rows=4,427 loops=1)

  • Output: fact_publishers_v4_9.views
  • Recheck Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Heap Blocks: exact=225
  • Buffers: shared hit=249
595. 0.225 0.225 ↑ 1.0 4,427 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_10_country_idx_265073 (cost=0.00..66.07 rows=4,553 width=0) (actual time=0.225..0.225 rows=4,427 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
596. 1.019 1.230 ↓ 1.0 4,321 1

Bitmap Heap Scan on public.fact_publishers_64_v4_2020_02_11_265137 fact_publishers_v4_10 (cost=63.72..4,468.83 rows=4,297 width=4) (actual time=0.227..1.230 rows=4,321 loops=1)

  • Output: fact_publishers_v4_10.views
  • Recheck Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Heap Blocks: exact=209
  • Buffers: shared hit=232
597. 0.211 0.211 ↓ 1.0 4,321 1

Bitmap Index Scan on fact_publishers_64_v4_2020_02_11_country_idx_265137 (cost=0.00..62.65 rows=4,297 width=0) (actual time=0.211..0.211 rows=4,321 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
598. 0.967 1.168 ↑ 1.1 4,294 1