explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8rn

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

Aggregate (cost=0.00..0.00 rows=0 width=0) (actual time=498.598..498.598 rows=1 loops=1)

  • Output: (pg_catalog.sum(remote_scan." "))::bigint
  • Buffers: shared hit=3830
2. 0.000 498.548 ↓ 0.0 64 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=498.542..498.548 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. 3.882 27.990 ↑ 1.0 1 1

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

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

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

  • Buffers: shared hit=3866
5. 1.135 1.135 ↓ 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.030..1.135 rows=3,450 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=241
6. 1.236 1.236 ↓ 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.023..1.236 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.226 1.226 ↓ 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.025..1.226 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.299 1.299 ↓ 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.019..1.299 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.186 1.186 ↓ 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.017..1.186 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.311 1.311 ↑ 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.019..1.311 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.690 1.690 ↓ 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.018..1.690 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. 1.193 1.193 ↑ 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.019..1.193 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. 1.366 1.366 ↓ 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.021..1.366 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.325 1.325 ↓ 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.019..1.325 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.369 1.369 ↑ 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.019..1.369 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.246 1.246 ↑ 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.016..1.246 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.242 1.242 ↓ 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.020..1.242 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.344 1.344 ↑ 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.022..1.344 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.268 1.268 ↑ 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.018..1.268 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.671 40.749 ↑ 1.0 1 1

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

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

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

  • Buffers: shared hit=4245
22. 1.492 1.837 ↓ 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.375..1.837 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.345 0.345 ↓ 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.345..0.345 rows=5,059 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=26
24. 1.465 1.826 ↓ 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.387..1.826 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.361 0.361 ↓ 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.361..0.361 rows=5,002 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=28
26. 1.595 1.959 ↑ 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.395..1.959 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.364 0.364 ↑ 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.364..0.364 rows=5,558 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
28. 1.486 1.839 ↓ 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.380..1.839 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.353 0.353 ↓ 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.353..0.353 rows=5,447 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=27
30. 1.434 1.768 ↓ 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.361..1.768 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.334 0.334 ↓ 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.334..0.334 rows=5,462 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
32. 1.596 1.967 ↑ 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.400..1.967 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.371 0.371 ↑ 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.371..0.371 rows=5,520 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
34. 1.516 1.843 ↓ 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.357..1.843 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.327 0.327 ↓ 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.327..0.327 rows=5,420 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
36. 1.352 1.638 ↓ 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.314..1.638 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.286 0.286 ↓ 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.286..0.286 rows=4,777 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=28
38. 1.493 1.854 ↑ 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.390..1.854 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.361 0.361 ↑ 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.361..0.361 rows=5,264 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=27
40. 1.692 2.051 ↑ 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.394..2.051 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.359 0.359 ↑ 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.359..0.359 rows=5,958 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
42. 1.702 2.051 ↑ 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.385..2.051 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.349 0.349 ↑ 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.349..0.349 rows=5,782 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
44. 1.626 2.003 ↑ 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.408..2.003 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.377 0.377 ↑ 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.377..0.377 rows=5,712 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
46. 1.639 2.022 ↑ 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.415..2.022 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.383 0.383 ↑ 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.383..0.383 rows=5,723 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
48. 1.456 1.825 ↑ 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.400..1.825 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.369 0.369 ↑ 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.369..0.369 rows=5,395 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
50. 1.511 1.837 ↑ 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.352..1.837 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.326 0.326 ↑ 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.326..0.326 rows=5,046 loops=1)

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

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

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

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

  • Buffers: shared hit=4611
54. 1.846 2.127 ↑ 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.322..2.127 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.281 0.281 ↑ 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.281..0.281 rows=4,536 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
56. 1.395 1.710 ↑ 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.336..1.710 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.315 0.315 ↑ 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.315..0.315 rows=4,838 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
58. 1.951 1.951 ↑ 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.034..1.951 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. 1.515 1.515 ↑ 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.035..1.515 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.434 1.434 ↑ 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.017..1.434 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. 1.776 1.776 ↓ 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.016..1.776 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.047 1.047 ↓ 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.017..1.047 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.451 1.451 ↓ 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.017..1.451 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.689 1.689 ↑ 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.034..1.689 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.508 1.508 ↑ 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.032..1.508 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.481 1.481 ↑ 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.018..1.481 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.396 1.396 ↓ 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.019..1.396 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.482 1.482 ↑ 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.015..1.482 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.661 1.661 ↑ 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.018..1.661 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.843 1.843 ↑ 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.035..1.843 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.588 12.172 ↑ 1.0 1 1

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

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

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

  • Buffers: shared hit=2168
73. 0.565 0.565 ↓ 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.029..0.565 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.481 0.481 ↓ 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.481 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.602 0.602 ↓ 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.022..0.602 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.521 0.521 ↑ 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.521 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.543 0.543 ↑ 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.019..0.543 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.611 0.611 ↑ 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.018..0.611 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.587 0.587 ↑ 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.019..0.587 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.537 0.537 ↑ 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.020..0.537 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.617 0.617 ↑ 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.016..0.617 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.623 0.623 ↑ 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.017..0.623 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.632 0.632 ↓ 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.017..0.632 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.624 0.624 ↓ 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.017..0.624 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.684 0.684 ↓ 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.016..0.684 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.563 0.563 ↓ 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.034..0.563 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.563 0.563 ↓ 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.013..0.563 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.728 49.802 ↑ 1.0 1 1

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

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

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

  • Buffers: shared hit=4772
90. 2.120 2.602 ↓ 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.518..2.602 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.482 0.482 ↓ 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.482..0.482 rows=6,040 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=32
92. 2.682 3.092 ↓ 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.440..3.092 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.410 0.410 ↓ 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.410..0.410 rows=6,025 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
94. 1.707 2.102 ↑ 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.428..2.102 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.395 0.395 ↑ 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.395..0.395 rows=6,549 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
96. 1.676 2.025 ↑ 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.377..2.025 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.349 0.349 ↑ 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.349..0.349 rows=6,664 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=35
98. 2.118 2.532 ↓ 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.443..2.532 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.414 0.414 ↓ 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.414..0.414 rows=6,642 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=34
100. 1.759 2.174 ↓ 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.447..2.174 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.415 0.415 ↓ 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.415..0.415 rows=6,403 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=34
102. 1.866 2.271 ↑ 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.438..2.271 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.405 0.405 ↑ 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.405..0.405 rows=6,365 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
104. 1.738 2.128 ↓ 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.422..2.128 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.390 0.390 ↓ 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.390..0.390 rows=6,144 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
106. 2.382 2.820 ↑ 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.471..2.820 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.438 0.438 ↑ 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.438..0.438 rows=6,579 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=34
108. 1.807 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.427..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.392 0.392 ↑ 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.392..0.392 rows=6,211 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
110. 1.816 2.205 ↓ 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.422..2.205 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.389 0.389 ↓ 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.389..0.389 rows=6,165 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
112. 1.839 2.452 ↑ 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.649..2.452 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.613 0.613 ↑ 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.613..0.613 rows=6,120 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
114. 1.837 2.253 ↓ 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.466..2.253 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.416 0.416 ↓ 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.416..0.416 rows=6,462 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=34
116. 1.863 2.248 ↑ 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.417..2.248 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.385 0.385 ↑ 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.385..0.385 rows=5,990 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=32
118. 1.556 1.895 ↓ 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.371..1.895 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.339 0.339 ↓ 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.339..0.339 rows=5,836 loops=1)

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

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

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

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

  • Buffers: shared hit=2400
122. 0.901 1.060 ↓ 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.180..1.060 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.159 0.159 ↓ 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.159..0.159 rows=2,250 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
124. 0.902 1.088 ↑ 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.202..1.088 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.186 0.186 ↑ 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.186..0.186 rows=2,404 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
126. 0.928 1.117 ↓ 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.208..1.117 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.189 0.189 ↓ 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.189..0.189 rows=2,477 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
128. 1.106 1.106 ↑ 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.023..1.106 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. 1.019 1.019 ↑ 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.022..1.019 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.913 0.913 ↓ 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.018..0.913 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.750 0.892 ↑ 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.158..0.892 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.142 0.142 ↑ 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.142..0.142 rows=2,373 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
133. 0.695 0.847 ↑ 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.167..0.847 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.152 0.152 ↑ 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.152..0.152 rows=2,225 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=16
135. 0.638 0.772 ↓ 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.150..0.772 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.134 0.134 ↓ 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.134..0.134 rows=2,233 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
137. 0.757 0.903 ↑ 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.162..0.903 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.146 0.146 ↑ 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.146..0.146 rows=2,531 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=16
139. 0.733 0.881 ↑ 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.162..0.881 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.148 0.148 ↑ 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.147..0.148 rows=2,516 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
141. 0.682 0.841 ↑ 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.174..0.841 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.159 0.159 ↑ 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.158..0.159 rows=2,407 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
143. 0.799 0.946 ↓ 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.162..0.946 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.147 0.147 ↓ 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.147..0.147 rows=2,445 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=14
145. 0.769 0.913 ↑ 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.160..0.913 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.144 0.144 ↑ 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.144..0.144 rows=2,406 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=15
147. 0.643 0.784 ↓ 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.156..0.784 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.141 0.141 ↓ 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.141..0.141 rows=2,288 loops=1)

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

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

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

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

  • Buffers: shared hit=3881
151. 1.644 1.957 ↓ 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.340..1.957 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.313 0.313 ↓ 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.313..0.313 rows=4,790 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=26
153. 1.584 1.887 ↑ 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.324..1.887 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.303 0.303 ↑ 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.303..0.303 rows=4,777 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=26
155. 1.856 2.197 ↑ 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.365..2.197 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.341 0.341 ↑ 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.341..0.341 rows=5,375 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=28
157. 1.745 2.109 ↑ 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.386..2.109 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.364 0.364 ↑ 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.364..0.364 rows=5,255 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
159. 1.811 2.155 ↑ 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.367..2.155 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.344 0.344 ↑ 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.344..0.344 rows=5,594 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
161. 2.034 2.526 ↑ 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.544..2.526 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.492 0.492 ↑ 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.492..0.492 rows=5,417 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
163. 1.599 1.862 ↓ 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.303..1.862 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.263 0.263 ↓ 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.263..0.263 rows=4,916 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=27
165. 1.258 1.555 ↑ 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.330..1.555 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.297 0.297 ↑ 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.296..0.297 rows=4,373 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
167. 1.437 1.769 ↓ 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.356..1.769 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.332 0.332 ↓ 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.332..0.332 rows=4,615 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
169. 1.218 1.495 ↓ 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.301..1.495 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.277 0.277 ↓ 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.277..0.277 rows=4,857 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=26
171. 1.317 1.641 ↓ 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.343..1.641 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.324 0.324 ↓ 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.324..0.324 rows=4,655 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
173. 1.486 1.745 ↑ 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.279..1.745 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.259 0.259 ↑ 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.259..0.259 rows=4,682 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
175. 1.333 1.619 ↑ 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.308..1.619 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.286 0.286 ↑ 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.286..0.286 rows=4,649 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=27
177. 1.309 1.559 ↓ 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.270..1.559 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.250 0.250 ↓ 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.250..0.250 rows=4,366 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
179. 1.070 1.319 ↓ 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.268..1.319 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.249 0.249 ↓ 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.249..0.249 rows=4,171 loops=1)

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

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

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

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

  • Buffers: shared hit=5202
183. 2.215 2.215 ↓ 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..2.215 rows=4,772 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=308
184. 2.088 2.088 ↑ 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.026..2.088 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.897 2.897 ↓ 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.022..2.897 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. 2.313 2.313 ↑ 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.033..2.313 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.672 1.672 ↓ 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.025..1.672 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. 2.234 2.234 ↑ 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.022..2.234 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. 2.336 2.336 ↑ 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.034..2.336 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. 2.394 2.394 ↓ 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.057..2.394 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. 1.954 1.954 ↓ 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.025..1.954 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. 1.496 1.496 ↓ 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.023..1.496 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. 1.547 1.547 ↓ 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.018..1.547 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.514 1.514 ↑ 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.019..1.514 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.972 1.972 ↑ 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.024..1.972 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.581 1.581 ↑ 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.028..1.581 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.913 1.913 ↓ 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.022..1.913 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.755 28.876 ↑ 1.0 1 1

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

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

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

  • Buffers: shared hit=3210
200. 1.177 1.395 ↑ 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.245..1.395 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.218 0.218 ↑ 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.218..0.218 rows=3,481 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=18
202. 1.153 1.374 ↑ 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.245..1.374 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.221 0.221 ↑ 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.221..0.221 rows=3,525 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
204. 1.125 1.364 ↑ 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.258..1.364 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.239 0.239 ↑ 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.239..0.239 rows=3,735 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
206. 1.044 1.285 ↑ 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.260..1.285 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.241 0.241 ↑ 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.241..0.241 rows=3,681 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
208. 1.058 1.302 ↓ 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.262..1.302 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.244 0.244 ↓ 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.244..0.244 rows=3,684 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
210. 0.992 1.227 ↑ 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.256..1.227 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.235 0.235 ↑ 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.235..0.235 rows=3,733 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
212. 1.405 1.633 ↑ 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.250..1.633 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.228 0.228 ↑ 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.228..0.228 rows=4,101 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
214. 1.267 1.559 ↑ 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.348..1.559 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.292 0.292 ↑ 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.291..0.292 rows=4,069 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
216. 1.245 1.514 ↑ 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.289..1.514 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.269 0.269 ↑ 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.269..0.269 rows=4,187 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
218. 1.098 1.329 ↑ 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.251..1.329 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.231 0.231 ↑ 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.231..0.231 rows=3,666 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
220. 1.097 1.339 ↑ 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.260..1.339 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.242 0.242 ↑ 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.242..0.242 rows=3,692 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
222. 1.154 1.362 ↑ 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.230..1.362 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.208 0.208 ↑ 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.208..0.208 rows=3,608 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
224. 1.006 1.222 ↓ 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.245..1.222 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.216 0.216 ↓ 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.216..0.216 rows=3,678 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
226. 0.925 1.118 ↓ 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.212..1.118 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.193 0.193 ↓ 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.193..0.193 rows=3,620 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
228. 1.153 1.400 ↓ 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.264..1.400 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.247 0.247 ↓ 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.247..0.247 rows=3,506 loops=1)

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

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

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

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

  • Buffers: shared hit=3132
232. 1.474 1.756 ↓ 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.310..1.756 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.282 0.282 ↓ 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.282..0.282 rows=3,778 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
234. 1.417 1.676 ↓ 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.282..1.676 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.259 0.259 ↓ 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.259..0.259 rows=3,839 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
236. 2.440 2.675 ↓ 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.257..2.675 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.235 0.235 ↓ 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.235..0.235 rows=3,583 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
238. 1.014 1.232 ↓ 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.236..1.232 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.218 0.218 ↓ 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.218..0.218 rows=3,542 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=18
240. 0.981 1.194 ↑ 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.231..1.194 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.213 0.213 ↑ 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.212..0.213 rows=3,477 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
242. 0.972 1.186 ↑ 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.236..1.186 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.214 0.214 ↑ 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.214..0.214 rows=3,535 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
244. 1.020 1.232 ↑ 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.234..1.232 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.212 0.212 ↑ 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.212..0.212 rows=3,561 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
246. 1.018 1.224 ↑ 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.226..1.224 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.063 1.291 ↑ 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.251..1.291 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.228 0.228 ↑ 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.227..0.228 rows=3,676 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
250. 1.192 1.434 ↓ 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.263..1.434 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.242 0.242 ↓ 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.242..0.242 rows=3,914 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
252. 1.056 1.273 ↑ 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.239..1.273 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.217 0.217 ↑ 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.217..0.217 rows=3,643 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
254. 0.973 1.181 ↑ 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.227..1.181 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.208 0.208 ↑ 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.208..0.208 rows=3,517 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
256. 1.022 1.249 ↓ 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.250..1.249 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.227 0.227 ↓ 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.227..0.227 rows=3,620 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
258. 1.233 1.455 ↑ 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.244..1.455 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.222 0.222 ↑ 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.222..0.222 rows=3,989 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
260. 1.083 1.309 ↓ 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.249..1.309 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.226 0.226 ↓ 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.226..0.226 rows=3,839 loops=1)

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

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

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

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

  • Buffers: shared hit=3088
264. 1.186 1.406 ↓ 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.237..1.406 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.220 0.220 ↓ 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.219..0.220 rows=3,386 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
266. 1.278 1.501 ↓ 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.239..1.501 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.223 0.223 ↓ 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.223..0.223 rows=3,629 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
268. 1.146 1.343 ↓ 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.217..1.343 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.197 0.197 ↓ 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.196..0.197 rows=3,724 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
270. 0.901 1.093 ↓ 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.212..1.093 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.192 0.192 ↓ 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.192..0.192 rows=3,624 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
272. 1.058 1.242 ↓ 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.202..1.242 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.184 0.184 ↓ 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.184..0.184 rows=3,619 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
274. 0.889 1.075 ↑ 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.205..1.075 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.186 0.186 ↑ 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.186..0.186 rows=3,582 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
276. 0.921 1.093 ↓ 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.204..1.093 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.172 0.172 ↓ 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.172..0.172 rows=3,414 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
278. 1.296 1.470 ↓ 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.188..1.470 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.174 0.174 ↓ 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.174..0.174 rows=3,520 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
280. 0.989 1.227 ↑ 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.254..1.227 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.238 0.238 ↑ 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.238..0.238 rows=3,591 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
282. 1.169 1.436 ↑ 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.304..1.436 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.267 0.267 ↑ 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.267..0.267 rows=3,785 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
284. 1.138 1.352 ↓ 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.269..1.352 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.214 0.214 ↓ 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.214..0.214 rows=3,580 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
286. 1.187 1.385 ↓ 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.218..1.385 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.198 0.198 ↓ 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.198..0.198 rows=3,583 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
288. 1.149 1.348 ↓ 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.216..1.348 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.199 0.199 ↓ 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.199..0.199 rows=3,535 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
290. 1.158 1.416 ↑ 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.276..1.416 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.258 0.258 ↑ 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.258..0.258 rows=3,641 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
292. 0.935 1.134 ↑ 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.216..1.134 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.199 0.199 ↑ 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.199..0.199 rows=3,663 loops=1)

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

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

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

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

  • Buffers: shared hit=3534
296. 0.839 0.839 ↓ 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.021..0.839 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.886 0.886 ↑ 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.016..0.886 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. 1.042 1.042 ↑ 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.017..1.042 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. 1.047 1.047 ↓ 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.018..1.047 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.954 0.954 ↓ 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.044..0.954 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. 1.055 1.055 ↑ 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.013..1.055 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.150 1.150 ↓ 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.018..1.150 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.191 1.191 ↓ 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.018..1.191 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.265 1.265 ↑ 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.020..1.265 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.357 1.357 ↓ 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.017..1.357 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.141 1.141 ↓ 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.016..1.141 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. 1.252 1.252 ↑ 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.019..1.252 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.499 1.499 ↓ 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.041..1.499 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.112 1.112 ↓ 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.020..1.112 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. 1.036 1.036 ↓ 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.017..1.036 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.522 28.007 ↑ 1.0 1 1

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

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

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

  • Buffers: shared hit=3282
313. 0.884 1.077 ↑ 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.214..1.077 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.193 0.193 ↑ 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.193..0.193 rows=3,540 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
315. 1.107 1.389 ↓ 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.319..1.389 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.282 0.282 ↓ 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.282..0.282 rows=3,634 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
317. 1.199 1.441 ↓ 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.261..1.441 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.242 0.242 ↓ 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.242..0.242 rows=4,026 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
319. 1.257 1.492 ↑ 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.256..1.492 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.235 0.235 ↑ 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.235..0.235 rows=4,030 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
321. 1.166 1.471 ↓ 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.324..1.471 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.305 0.305 ↓ 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.305..0.305 rows=4,080 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
323. 1.032 1.266 ↑ 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.255..1.266 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.234 0.234 ↑ 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.234..0.234 rows=4,029 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
325. 1.128 1.324 ↑ 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.216..1.324 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.196 0.196 ↑ 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.196..0.196 rows=4,057 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
327. 1.267 1.537 ↓ 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.328..1.537 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.270 0.270 ↓ 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.270..0.270 rows=3,866 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
329. 1.067 1.371 ↑ 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.339..1.371 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.304 0.304 ↑ 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.304..0.304 rows=3,926 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
331. 1.067 1.252 ↓ 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.202..1.252 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.185 0.185 ↓ 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.185..0.185 rows=3,949 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
333. 1.052 1.238 ↓ 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.200..1.238 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.186 0.186 ↓ 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.186..0.186 rows=3,930 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
335. 0.917 1.095 ↑ 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.196..1.095 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.178 0.178 ↑ 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.178..0.178 rows=3,871 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
337. 1.070 1.266 ↓ 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.231..1.266 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.196 0.196 ↓ 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.196..0.196 rows=3,927 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
339. 1.763 1.992 ↓ 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.248..1.992 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.229 0.229 ↓ 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.229..0.229 rows=3,786 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
341. 0.882 1.168 ↓ 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.302..1.168 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.286 0.286 ↓ 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.286..0.286 rows=3,716 loops=1)

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

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

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

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

  • Buffers: shared hit=5154
345. 1.953 2.391 ↑ 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.488..2.391 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.438 0.438 ↑ 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.438..0.438 rows=5,280 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
347. 2.011 2.426 ↓ 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.444..2.426 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.415 0.415 ↓ 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.415..0.415 rows=5,351 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=28
349. 2.431 2.431 ↓ 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.017..2.431 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.198 2.198 ↑ 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.029..2.198 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.018 2.018 ↓ 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.026..2.018 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. 2.421 2.421 ↓ 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.028..2.421 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.814 1.814 ↓ 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.026..1.814 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.687 1.687 ↑ 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.025..1.687 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. 2.233 2.233 ↓ 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.024..2.233 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.951 1.951 ↑ 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.056..1.951 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.712 1.712 ↑ 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.026..1.712 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.934 1.934 ↑ 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.025..1.934 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.838 1.838 ↑ 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.029..1.838 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.770 1.770 ↓ 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.021..1.770 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. 2.123 2.123 ↓ 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.024..2.123 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. 5.920 32.821 ↑ 1.0 1 1

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

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

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

  • Buffers: shared hit=3834
364. 1.249 1.598 ↑ 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.393..1.598 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.349 0.349 ↑ 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.349..0.349 rows=3,086 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=17
366. 1.214 1.458 ↓ 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.268..1.458 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.244 0.244 ↓ 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.244..0.244 rows=3,224 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
368. 1.471 1.471 ↓ 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.033..1.471 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.521 1.521 ↓ 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.028..1.521 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.521 1.521 ↓ 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.032..1.521 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.213 1.213 ↓ 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.036..1.213 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.269 1.269 ↓ 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.025..1.269 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.228 1.228 ↓ 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.023..1.228 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.536 1.536 ↑ 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.023..1.536 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.354 1.354 ↑ 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.027..1.354 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.386 1.386 ↑ 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.025..1.386 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.603 1.603 ↑ 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.024..1.603 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.685 1.685 ↓ 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.042..1.685 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.619 1.619 ↑ 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.025..1.619 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.132 1.418 ↓ 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.309..1.418 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.286 0.286 ↓ 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.286..0.286 rows=4,228 loops=1)

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

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

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

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

  • Buffers: shared hit=2009
384. 0.423 0.511 ↑ 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.100..0.511 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.088 0.088 ↑ 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.087..0.088 rows=1,455 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=10
386. 0.389 0.489 ↓ 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.109..0.489 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.100 0.100 ↓ 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.100..0.100 rows=1,529 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=11
388. 0.494 0.578 ↓ 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.096..0.578 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.084 0.084 ↓ 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.084..0.084 rows=1,629 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=12
390. 0.650 0.739 ↑ 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.117..0.739 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.089 0.089 ↑ 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.089..0.089 rows=1,669 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=11
392. 0.431 0.523 ↑ 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.102..0.523 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.092 0.092 ↑ 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.092..0.092 rows=1,641 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=11
394. 0.450 0.535 ↓ 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.097..0.535 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.085 0.085 ↓ 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.085..0.085 rows=1,628 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=11
396. 0.637 0.814 ↓ 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.191..0.814 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.177 0.177 ↓ 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.177..0.177 rows=2,054 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=14
398. 0.541 0.642 ↑ 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.111..0.642 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.101 0.101 ↑ 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.101..0.101 rows=1,987 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=14
400. 0.521 0.627 ↑ 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.119..0.627 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.106 0.106 ↑ 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.106..0.106 rows=2,092 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
402. 0.513 0.628 ↑ 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.128..0.628 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.115 0.115 ↑ 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.115..0.115 rows=2,061 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
404. 0.662 0.771 ↓ 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.120..0.771 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.109 0.109 ↓ 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.109..0.109 rows=2,122 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=14
406. 0.570 0.695 ↓ 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.140..0.695 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.125 0.125 ↓ 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.125..0.125 rows=2,148 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=12
408. 0.720 0.827 ↑ 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.122..0.827 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.107 0.107 ↑ 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.107..0.107 rows=2,177 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
410. 0.538 0.691 ↓ 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.166..0.691 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.153 0.153 ↓ 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.153..0.153 rows=2,151 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
412. 0.557 0.660 ↑ 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.117..0.660 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.103 0.103 ↑ 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.103..0.103 rows=2,188 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=13
414. 5.129 37.640 ↑ 1.0 1 1

Aggregate (cost=63,708.26..63,708.27 rows=1 width=8) (actual time=37.640..37.640 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=4713
415. 5.859 32.511 ↑ 1.0 71,185 1

Append (cost=0.42..63,530.26 rows=71,202 width=4) (actual time=0.050..32.511 rows=71,185 loops=1)

  • Buffers: shared hit=4713
416. 2.382 2.382 ↑ 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.049..2.382 rows=4,737 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=315
417. 2.060 2.060 ↓ 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.022..2.060 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. 2.151 2.151 ↓ 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.028..2.151 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.848 1.848 ↑ 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.031..1.848 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.623 1.623 ↑ 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.044..1.623 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.583 1.583 ↑ 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.026..1.583 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.655 1.655 ↓ 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.025..1.655 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.546 1.546 ↑ 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.039..1.546 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.797 1.797 ↑ 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.025..1.797 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.642 1.642 ↓ 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.029..1.642 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.734 1.734 ↑ 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.024..1.734 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.614 1.614 ↑ 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.027..1.614 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.671 1.671 ↓ 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.025..1.671 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.889 1.889 ↓ 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.035..1.889 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.457 1.457 ↑ 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.457 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.383 26.352 ↑ 1.0 1 1

Aggregate (cost=46,047.31..46,047.32 rows=1 width=8) (actual time=26.351..26.352 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3043
432. 4.320 22.969 ↓ 1.0 49,312 1

Append (cost=0.42..45,924.49 rows=49,126 width=4) (actual time=0.057..22.969 rows=49,312 loops=1)

  • Buffers: shared hit=3043
433. 1.370 1.370 ↓ 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.057..1.370 rows=2,954 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=214
434. 1.200 1.416 ↓ 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.238..1.416 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.216 0.216 ↓ 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.216..0.216 rows=3,145 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
436. 1.301 1.539 ↓ 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.257..1.539 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.238 0.238 ↓ 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.238..0.238 rows=3,603 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
438. 1.322 1.537 ↓ 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.235..1.537 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.215 0.215 ↓ 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.215..0.215 rows=3,552 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
440. 1.062 1.251 ↓ 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.205..1.251 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.189 0.189 ↓ 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.189..0.189 rows=3,427 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
442. 1.149 1.149 ↓ 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.024..1.149 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.024 1.225 ↑ 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.220..1.225 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.201 0.201 ↑ 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.201..0.201 rows=3,416 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
445. 0.819 0.988 ↓ 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.186..0.988 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.169 0.169 ↓ 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.169..0.169 rows=2,929 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=16
447. 0.910 1.101 ↑ 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.208..1.101 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.191 0.191 ↑ 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.191..0.191 rows=3,328 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
449. 1.061 1.283 ↓ 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.243..1.283 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.222 0.222 ↓ 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.222..0.222 rows=3,505 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
451. 1.091 1.091 ↓ 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.019..1.091 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.931 1.115 ↑ 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.202..1.115 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.184 0.184 ↑ 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.184..0.184 rows=3,311 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=17
454. 1.261 1.449 ↓ 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.218..1.449 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.188 0.188 ↓ 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.188..0.188 rows=3,328 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=17
456. 0.895 1.081 ↓ 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.205..1.081 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.186 0.186 ↓ 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.186..0.186 rows=3,150 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=18
458. 1.054 1.054 ↓ 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.022..1.054 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. 4.480 36.577 ↑ 1.0 1 1

Aggregate (cost=66,041.46..66,041.47 rows=1 width=8) (actual time=36.577..36.577 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=4578
460. 5.929 32.097 ↓ 1.0 69,244 1

Append (cost=0.42..65,868.76 rows=69,083 width=4) (actual time=0.031..32.097 rows=69,244 loops=1)

  • Buffers: shared hit=4578
461. 1.692 1.692 ↓ 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.030..1.692 rows=4,509 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=296
462. 1.941 1.941 ↑ 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.023..1.941 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.796 1.796 ↓ 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.025..1.796 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.893 1.893 ↑ 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.036..1.893 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. 2.077 2.077 ↓ 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.019..2.077 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.654 1.654 ↓ 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.021..1.654 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.839 1.839 ↓ 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.058..1.839 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.923 1.923 ↓ 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.028..1.923 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.764 1.764 ↑ 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.026..1.764 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. 2.093 2.093 ↑ 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.034..2.093 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. 1.814 1.814 ↑ 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.029..1.814 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.451 1.451 ↑ 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.027..1.451 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.407 1.407 ↓ 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.022..1.407 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.333 1.333 ↑ 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.333 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.491 1.491 ↑ 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.025..1.491 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.823 30.394 ↑ 1.0 1 1

Aggregate (cost=57,548.91..57,548.92 rows=1 width=8) (actual time=30.394..30.394 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3578
477. 4.690 26.571 ↑ 1.0 65,342 1

Append (cost=54.63..57,385.54 rows=65,347 width=4) (actual time=0.273..26.571 rows=65,342 loops=1)

  • Buffers: shared hit=3578
478. 1.280 1.533 ↓ 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.273..1.533 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.253 0.253 ↓ 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.252..0.253 rows=3,926 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
480. 1.444 1.720 ↑ 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.297..1.720 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.276 0.276 ↑ 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.276..0.276 rows=4,106 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
482. 1.166 1.448 ↓ 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.301..1.448 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.282 0.282 ↓ 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.282..0.282 rows=4,485 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
484. 1.207 1.417 ↑ 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.227..1.417 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.210 0.210 ↑ 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.210..0.210 rows=4,541 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
486. 1.380 1.743 ↓ 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.383..1.743 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.363 0.363 ↓ 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.362..0.363 rows=4,639 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
488. 1.061 1.281 ↓ 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.241..1.281 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.220 0.220 ↓ 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.220..0.220 rows=4,470 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
490. 1.020 1.218 ↓ 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.225..1.218 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.198 0.198 ↓ 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.198..0.198 rows=4,374 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
492. 1.127 1.395 ↓ 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.302..1.395 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.268 0.268 ↓ 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.268..0.268 rows=3,982 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=19
494. 1.113 1.326 ↑ 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.229..1.326 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.213 0.213 ↑ 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.213..0.213 rows=4,197 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
496. 1.378 1.815 ↑ 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.473..1.815 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.437 0.437 ↑ 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.437..0.437 rows=4,555 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
498. 1.141 1.357 ↑ 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.231..1.357 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.216 0.216 ↑ 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.216..0.216 rows=4,471 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=25
500. 1.087 1.306 ↓ 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.238..1.306 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.219 0.219 ↓ 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.219..0.219 rows=4,510 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
502. 1.154 1.413 ↑ 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.280..1.413 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.259 0.259 ↑ 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.259..0.259 rows=4,547 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
504. 1.085 1.274 ↓ 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.209..1.274 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.189 0.189 ↓ 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.189..0.189 rows=4,299 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
506. 1.354 1.635 ↓ 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.304..1.635 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.281 0.281 ↓ 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.281..0.281 rows=4,240 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
508. 1.755 13.055 ↑ 1.0 1 1

Aggregate (cost=18,834.20..18,834.21 rows=1 width=8) (actual time=13.054..13.055 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=2091
509. 1.969 11.300 ↑ 1.0 24,419 1

Append (cost=0.42..18,772.98 rows=24,487 width=4) (actual time=0.033..11.300 rows=24,419 loops=1)

  • Buffers: shared hit=2091
510. 0.669 0.669 ↓ 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.032..0.669 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.689 0.689 ↑ 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.026..0.689 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.634 0.634 ↑ 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.024..0.634 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.614 0.614 ↑ 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.031..0.614 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.581 0.581 ↓ 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.026..0.581 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.648 0.648 ↑ 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.026..0.648 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.603 0.603 ↓ 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.024..0.603 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.515 0.515 ↑ 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.024..0.515 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.725 0.725 ↑ 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.027..0.725 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.651 0.651 ↓ 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.026..0.651 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.668 0.668 ↑ 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.025..0.668 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.648 0.648 ↑ 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.031..0.648 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.625 0.625 ↑ 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.024..0.625 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.517 0.517 ↓ 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.020..0.517 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.544 0.544 ↓ 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.028..0.544 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.237 44.435 ↑ 1.0 1 1

Aggregate (cost=81,372.05..81,372.06 rows=1 width=8) (actual time=44.435..44.435 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=4585
526. 7.274 38.198 ↑ 1.0 89,486 1

Append (cost=77.67..81,147.26 rows=89,914 width=4) (actual time=0.406..38.198 rows=89,486 loops=1)

  • Buffers: shared hit=4585
527. 1.571 1.943 ↓ 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.405..1.943 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.372 0.372 ↓ 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.372..0.372 rows=5,392 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
529. 1.586 1.971 ↓ 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.415..1.971 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.385 0.385 ↓ 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.385..0.385 rows=5,659 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
531. 1.763 2.140 ↑ 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.410..2.140 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.377 0.377 ↑ 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.377..0.377 rows=6,140 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
533. 1.827 2.221 ↑ 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.426..2.221 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.394 0.394 ↑ 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.394..0.394 rows=6,530 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=32
535. 1.834 2.211 ↓ 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.409..2.211 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.377 0.377 ↓ 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.376..0.377 rows=6,578 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=34
537. 1.935 2.396 ↓ 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.496..2.396 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.461 0.461 ↓ 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.461..0.461 rows=6,559 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
539. 1.691 2.052 ↑ 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.393..2.052 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.361 0.361 ↑ 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.361..0.361 rows=6,102 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
541. 1.564 1.928 ↑ 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.395..1.928 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.364 0.364 ↑ 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.364..0.364 rows=5,684 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
543. 1.653 2.026 ↑ 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.405..2.026 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.373 0.373 ↑ 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.373..0.373 rows=5,952 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
545. 1.797 2.171 ↓ 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.405..2.171 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.374 0.374 ↓ 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.374..0.374 rows=6,115 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
547. 1.733 2.157 ↓ 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.455..2.157 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.424 0.424 ↓ 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.424..0.424 rows=6,037 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=33
549. 1.639 2.007 ↑ 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.434..2.007 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.368 0.368 ↑ 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.368..0.368 rows=5,768 loops=1)

  • Index Cond: (fact_publishers_v4_11.country = 'United Kingdom'::text)
  • Buffers: shared hit=29
551. 1.621 1.991 ↓ 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.402..1.991 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.370 0.370 ↓ 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.370..0.370 rows=5,939 loops=1)

  • Index Cond: (fact_publishers_v4_12.country = 'United Kingdom'::text)
  • Buffers: shared hit=32
553. 1.540 1.909 ↓ 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.398..1.909 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.369 0.369 ↓ 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.369..0.369 rows=5,559 loops=1)

  • Index Cond: (fact_publishers_v4_13.country = 'United Kingdom'::text)
  • Buffers: shared hit=30
555. 1.469 1.801 ↓ 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.360..1.801 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.332 0.332 ↓ 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.332..0.332 rows=5,472 loops=1)

  • Index Cond: (fact_publishers_v4_14.country = 'United Kingdom'::text)
  • Buffers: shared hit=31
557. 1.770 13.971 ↑ 1.0 1 1

Aggregate (cost=22,853.05..22,853.06 rows=1 width=8) (actual time=13.970..13.971 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=2004
558. 1.830 12.201 ↓ 1.0 22,748 1

Append (cost=0.42..22,797.23 rows=22,329 width=4) (actual time=0.027..12.201 rows=22,748 loops=1)

  • Buffers: shared hit=2004
559. 0.556 0.556 ↓ 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.027..0.556 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.599 0.599 ↓ 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.023..0.599 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.624 0.624 ↓ 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.032..0.624 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.731 0.731 ↓ 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.045..0.731 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.625 0.625 ↑ 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.023..0.625 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.818 0.818 ↓ 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.046..0.818 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. 0.734 0.734 ↑ 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..0.734 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.623 0.623 ↑ 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.026..0.623 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.798 0.798 ↓ 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.024..0.798 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.681 0.681 ↓ 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.024..0.681 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.666 0.666 ↓ 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.023..0.666 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.696 0.696 ↑ 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.023..0.696 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.797 0.797 ↓ 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.023..0.797 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.722 0.722 ↑ 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.043..0.722 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.701 0.701 ↓ 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.701 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.972 29.436 ↑ 1.0 1 1

Aggregate (cost=64,346.17..64,346.18 rows=1 width=8) (actual time=29.436..29.436 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=3453
575. 4.895 25.464 ↑ 1.0 62,409 1

Append (cost=57.61..64,189.10 rows=62,829 width=4) (actual time=0.421..25.464 rows=62,409 loops=1)

  • Buffers: shared hit=3453
576. 1.294 1.688 ↑ 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.421..1.688 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.394 0.394 ↑ 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.394..0.394 rows=3,833 loops=1)

  • Index Cond: (fact_publishers_v4.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
578. 1.699 1.949 ↓ 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.268..1.949 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.250 0.250 ↓ 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.250..0.250 rows=4,034 loops=1)

  • Index Cond: (fact_publishers_v4_1.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
580. 1.257 1.678 ↓ 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.443..1.678 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.421 0.421 ↓ 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.421..0.421 rows=4,610 loops=1)

  • Index Cond: (fact_publishers_v4_2.country = 'United Kingdom'::text)
  • Buffers: shared hit=27
582. 0.997 1.209 ↓ 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.229..1.209 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.212 0.212 ↓ 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.212..0.212 rows=4,313 loops=1)

  • Index Cond: (fact_publishers_v4_3.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
584. 1.032 1.251 ↑ 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.236..1.251 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.219 0.219 ↑ 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.219..0.219 rows=4,230 loops=1)

  • Index Cond: (fact_publishers_v4_4.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
586. 1.023 1.237 ↑ 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.234..1.237 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.214 0.214 ↑ 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.214..0.214 rows=4,305 loops=1)

  • Index Cond: (fact_publishers_v4_5.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
588. 1.235 1.433 ↑ 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.217..1.433 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.198 0.198 ↑ 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.198..0.198 rows=4,171 loops=1)

  • Index Cond: (fact_publishers_v4_6.country = 'United Kingdom'::text)
  • Buffers: shared hit=22
590. 1.066 1.384 ↑ 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.342..1.384 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.318 0.318 ↑ 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.318..0.318 rows=3,687 loops=1)

  • Index Cond: (fact_publishers_v4_7.country = 'United Kingdom'::text)
  • Buffers: shared hit=20
592. 0.965 1.154 ↑ 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.205..1.154 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.189 0.189 ↑ 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.189..0.189 rows=3,999 loops=1)

  • Index Cond: (fact_publishers_v4_8.country = 'United Kingdom'::text)
  • Buffers: shared hit=21
594. 1.104 1.315 ↑ 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.228..1.315 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.211 0.211 ↑ 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.211..0.211 rows=4,427 loops=1)

  • Index Cond: (fact_publishers_v4_9.country = 'United Kingdom'::text)
  • Buffers: shared hit=24
596. 1.042 1.245 ↓ 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.219..1.245 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.203 0.203 ↓ 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.203..0.203 rows=4,321 loops=1)

  • Index Cond: (fact_publishers_v4_10.country = 'United Kingdom'::text)
  • Buffers: shared hit=23
598. 1.161 1.413 ↑ 1.1 4,294 1