explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L8Q1

Settings
# exclusive inclusive rows x rows loops node
1. 497.417 110,901.271 ↑ 1.8 949,629 1

Finalize GroupAggregate (cost=6,612,816.15..7,212,979.19 rows=1,674,758 width=80) (actual time=104,151.617..110,901.271 rows=949,629 loops=1)

  • Group Key: aggregated_compact_placements.a_date, aggregated_compact_placements.placement_id
  • Functions: 31,870
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 4153.913 ms, Inlining 498.122 ms, Optimization 135684.262 ms, Emission 94553.518 ms, Total 234889.815 ms
2. 5,712.118 110,403.854 ↑ 3.5 949,629 1

Gather Merge (cost=6,612,816.15..7,129,241.29 rows=3,349,516 width=80) (actual time=104,151.558..110,403.854 rows=949,629 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,206.258 104,691.736 ↑ 5.3 316,543 3 / 3

Partial GroupAggregate (cost=6,611,816.12..6,741,624.01 rows=1,674,758 width=80) (actual time=102,628.684..104,691.736 rows=316,543 loops=3)

  • Group Key: aggregated_compact_placements.a_date, aggregated_compact_placements.placement_id
4. 6,462.027 103,485.478 ↑ 1.3 5,452,837 3 / 3

Sort (cost=6,611,816.12..6,629,263.88 rows=6,979,101 width=21) (actual time=102,628.646..103,485.478 rows=5,452,837 loops=3)

  • Sort Key: aggregated_compact_placements.a_date, aggregated_compact_placements.placement_id
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: external merge Disk: 252,640kB
  • Worker 1: Sort Method: external merge Disk: 253,696kB
5. 348.590 97,023.451 ↑ 1.3 5,452,837 3 / 3

Parallel Append (cost=0.00..5,734,647.73 rows=6,979,101 width=21) (actual time=85,837.894..97,023.451 rows=5,452,837 loops=3)

6. 0.009 0.009 ↓ 0.0 0 1 / 3

Seq Scan on aggregated_compact_placements (cost=0.00..0.00 rows=1 width=52) (actual time=0.026..0.026 rows=0 loops=1)

  • Filter: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
7. 0.095 25,245.294 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20191101 (cost=55.42..3,002.83 rows=2,019 width=52) (actual time=75,735.882..75,735.882 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
8. 25,245.199 25,245.199 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20191101_pkey (cost=0.00..54.56 rows=3,433 width=0) (actual time=75,735.596..75,735.596 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
9. 0.013 25,789.600 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170719 (cost=30.81..1,670.50 rows=1,112 width=52) (actual time=77,368.801..77,368.801 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
10. 25,789.588 25,789.588 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170719_pkey (cost=0.00..30.33 rows=1,890 width=0) (actual time=77,368.762..77,368.763 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
11. 0.003 0.312 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170515 (cost=30.22..1,744.46 rows=1,205 width=52) (actual time=0.935..0.935 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
12. 0.309 0.309 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170515_pkey (cost=0.00..29.71 rows=2,048 width=0) (actual time=0.926..0.926 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
13. 0.002 0.251 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170506 (cost=30.21..1,754.98 rows=1,204 width=52) (actual time=0.752..0.752 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
14. 0.248 0.248 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170506_pkey (cost=0.00..29.70 rows=2,047 width=0) (actual time=0.745..0.745 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
15. 0.001 0.221 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171126 (cost=29.51..1,562.75 rows=1,038 width=52) (actual time=0.664..0.664 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
16. 0.220 0.220 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171126_pkey (cost=0.00..29.07 rows=1,764 width=0) (actual time=0.661..0.661 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
17. 0.002 0.042 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180419 (cost=29.46..1,565.51 rows=1,035 width=52) (actual time=0.125..0.125 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
18. 0.040 0.040 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180419_pkey (cost=0.00..29.02 rows=1,759 width=0) (actual time=0.119..0.119 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
19. 0.001 0.194 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171204 (cost=29.45..1,554.88 rows=1,034 width=52) (actual time=0.581..0.581 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
20. 0.193 0.193 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171204_pkey (cost=0.00..29.01 rows=1,758 width=0) (actual time=0.579..0.579 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
21. 0.002 0.045 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180428 (cost=29.35..1,559.40 rows=1,028 width=52) (actual time=0.136..0.136 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
22. 0.044 0.044 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180428_pkey (cost=0.00..28.91 rows=1,748 width=0) (actual time=0.131..0.131 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
23. 0.001 0.148 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170512 (cost=29.33..1,688.35 rows=1,154 width=52) (actual time=0.443..0.443 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
24. 0.147 0.147 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170512_pkey (cost=0.00..28.84 rows=1,961 width=0) (actual time=0.440..0.440 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
25. 0.001 0.253 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170723 (cost=29.23..1,555.79 rows=1,021 width=52) (actual time=0.759..0.759 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
26. 0.252 0.252 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170723_pkey (cost=0.00..28.79 rows=1,736 width=0) (actual time=0.757..0.757 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
27. 0.002 0.159 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180120 (cost=29.19..1,527.86 rows=1,019 width=52) (actual time=0.478..0.478 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
28. 0.158 0.158 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180120_pkey (cost=0.00..28.75 rows=1,732 width=0) (actual time=0.472..0.473 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
29. 0.001 0.033 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180404 (cost=29.17..1,543.36 rows=1,018 width=52) (actual time=0.100..0.100 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
30. 0.033 0.033 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180404_pkey (cost=0.00..28.73 rows=1,730 width=0) (actual time=0.098..0.098 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
31. 0.002 0.131 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180319 (cost=29.09..1,534.41 rows=1,014 width=52) (actual time=0.394..0.394 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
32. 0.130 0.130 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180319_pkey (cost=0.00..28.66 rows=1,723 width=0) (actual time=0.389..0.389 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
33. 0.001 0.150 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171128 (cost=29.01..1,523.41 rows=1,009 width=52) (actual time=0.449..0.450 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
34. 0.149 0.149 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171128_pkey (cost=0.00..28.58 rows=1,715 width=0) (actual time=0.447..0.447 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
35. 0.001 0.038 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180501 (cost=28.91..1,525.42 rows=1,003 width=52) (actual time=0.114..0.114 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
36. 0.037 0.037 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180501_pkey (cost=0.00..28.48 rows=1,705 width=0) (actual time=0.110..0.110 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
37. 0.001 0.061 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180218 (cost=28.88..1,505.64 rows=1,001 width=52) (actual time=0.184..0.184 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
38. 0.061 0.061 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180218_pkey (cost=0.00..28.45 rows=1,702 width=0) (actual time=0.182..0.182 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
39. 0.001 0.031 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180430 (cost=28.84..1,511.95 rows=999 width=52) (actual time=0.094..0.094 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
40. 0.031 0.031 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180430_pkey (cost=0.00..28.41 rows=1,698 width=0) (actual time=0.092..0.092 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
41. 0.002 0.029 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180417 (cost=28.78..1,523.25 rows=995 width=52) (actual time=0.085..0.086 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
42. 0.027 0.027 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180417_pkey (cost=0.00..28.35 rows=1,692 width=0) (actual time=0.081..0.081 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
43. 0.001 0.025 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180210 (cost=28.78..1,503.09 rows=995 width=52) (actual time=0.075..0.075 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
44. 0.024 0.024 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180210_pkey (cost=0.00..28.35 rows=1,692 width=0) (actual time=0.073..0.073 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
45. 0.002 0.044 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180130 (cost=28.70..1,500.18 rows=991 width=52) (actual time=0.131..0.132 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
46. 0.042 0.042 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180130_pkey (cost=0.00..28.28 rows=1,685 width=0) (actual time=0.127..0.127 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
47. 0.001 0.042 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180508 (cost=28.70..1,500.18 rows=991 width=52) (actual time=0.126..0.126 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
48. 0.041 0.041 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180508_pkey (cost=0.00..28.28 rows=1,685 width=0) (actual time=0.124..0.124 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
49. 0.003 0.296 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170731 (cost=28.60..1,498.65 rows=985 width=52) (actual time=0.887..0.887 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
50. 0.293 0.293 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170731_pkey (cost=0.00..28.18 rows=1,675 width=0) (actual time=0.877..0.878 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
51. 0.001 0.133 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170727 (cost=28.48..1,501.04 rows=978 width=52) (actual time=0.398..0.398 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
52. 0.132 0.132 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170727_pkey (cost=0.00..28.06 rows=1,663 width=0) (actual time=0.396..0.396 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
53. 0.001 0.058 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180304 (cost=28.37..1,474.76 rows=972 width=52) (actual time=0.175..0.175 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
54. 0.057 0.057 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180304_pkey (cost=0.00..27.95 rows=1,652 width=0) (actual time=0.171..0.171 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
55. 0.001 0.043 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180503 (cost=28.06..1,461.04 rows=954 width=52) (actual time=0.129..0.129 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
56. 0.042 0.042 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180503_pkey (cost=0.00..27.65 rows=1,622 width=0) (actual time=0.125..0.125 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
57. 0.001 0.128 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170518 (cost=27.94..1,592.90 rows=1,074 width=52) (actual time=0.383..0.383 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
58. 0.127 0.127 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170518_pkey (cost=0.00..27.48 rows=1,825 width=0) (actual time=0.380..0.380 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
59. 0.004 0.157 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170725 (cost=27.90..1,461.27 rows=945 width=52) (actual time=0.470..0.470 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
60. 0.153 0.153 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170725_pkey (cost=0.00..27.50 rows=1,607 width=0) (actual time=0.459..0.459 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
61. 0.001 0.033 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180414 (cost=27.87..1,455.56 rows=944 width=52) (actual time=0.098..0.098 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
62. 0.032 0.032 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180414_pkey (cost=0.00..27.47 rows=1,604 width=0) (actual time=0.096..0.096 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
63. 0.002 0.149 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170514 (cost=27.80..1,588.15 rows=1,065 width=52) (actual time=0.448..0.448 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
64. 0.148 0.148 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170514_pkey (cost=0.00..27.34 rows=1,811 width=0) (actual time=0.443..0.443 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
65. 0.001 0.137 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170803 (cost=27.75..1,494.37 rows=999 width=52) (actual time=0.409..0.410 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
66. 0.136 0.136 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170803_pkey (cost=0.00..27.32 rows=1,699 width=0) (actual time=0.407..0.407 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
67. 0.001 0.326 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170716 (cost=27.70..1,446.60 rows=934 width=52) (actual time=0.977..0.977 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
68. 0.325 0.325 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170716_pkey (cost=0.00..27.30 rows=1,587 width=0) (actual time=0.974..0.974 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
69. 0.002 0.171 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171213 (cost=27.62..1,490.66 rows=992 width=52) (actual time=0.514..0.514 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
70. 0.169 0.169 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171213_pkey (cost=0.00..27.20 rows=1,687 width=0) (actual time=0.508..0.508 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
71. 0.001 0.038 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180223 (cost=27.62..1,484.69 rows=992 width=52) (actual time=0.113..0.113 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
72. 0.037 0.037 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180223_pkey (cost=0.00..27.20 rows=1,687 width=0) (actual time=0.110..0.110 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
73. 0.002 0.047 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180505 (cost=27.57..1,421.67 rows=926 width=52) (actual time=0.142..0.142 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
74. 0.046 0.046 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180505_pkey (cost=0.00..27.17 rows=1,574 width=0) (actual time=0.137..0.137 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
75. 0.001 0.160 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170624 (cost=27.56..1,482.84 rows=989 width=52) (actual time=0.481..0.481 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
76. 0.160 0.160 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170624_pkey (cost=0.00..27.14 rows=1,681 width=0) (actual time=0.479..0.479 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
77. 0.001 0.118 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180215 (cost=27.56..1,482.84 rows=989 width=52) (actual time=0.354..0.354 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
78. 0.117 0.117 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180215_pkey (cost=0.00..27.14 rows=1,681 width=0) (actual time=0.352..0.352 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
79. 0.002 0.033 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180409 (cost=27.39..1,416.21 rows=916 width=52) (actual time=0.100..0.100 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
80. 0.032 0.032 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180409_pkey (cost=0.00..27.00 rows=1,557 width=0) (actual time=0.095..0.095 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
81. 0.001 0.084 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180208 (cost=27.07..1,460.06 rows=961 width=52) (actual time=0.252..0.252 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
82. 0.083 0.083 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180208_pkey (cost=0.00..26.66 rows=1,633 width=0) (actual time=0.250..0.250 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
83. 0.002 0.033 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180418 (cost=27.06..1,400.36 rows=897 width=52) (actual time=0.100..0.100 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
84. 0.031 0.031 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180418_pkey (cost=0.00..26.68 rows=1,525 width=0) (actual time=0.094..0.094 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
85. 0.001 0.161 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170630 (cost=26.93..1,447.22 rows=952 width=52) (actual time=0.482..0.482 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
86. 0.160 0.160 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170630_pkey (cost=0.00..26.52 rows=1,619 width=0) (actual time=0.480..0.480 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
87. 0.002 0.046 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180327 (cost=26.88..1,380.68 rows=886 width=52) (actual time=0.137..0.138 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
88. 0.044 0.044 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180327_pkey (cost=0.00..26.50 rows=1,507 width=0) (actual time=0.132..0.132 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
89. 0.001 0.030 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180412 (cost=26.81..1,377.79 rows=882 width=52) (actual time=0.089..0.089 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
90. 0.029 0.029 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180412_pkey (cost=0.00..26.43 rows=1,500 width=0) (actual time=0.087..0.087 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
91. 0.001 0.049 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180411 (cost=26.70..1,371.69 rows=876 width=52) (actual time=0.147..0.147 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
92. 0.048 0.048 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180411_pkey (cost=0.00..26.33 rows=1,490 width=0) (actual time=0.145..0.145 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
93. 0.002 0.154 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170828 (cost=26.70..1,427.91 rows=939 width=52) (actual time=0.461..0.461 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
94. 0.152 0.152 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170828_pkey (cost=0.00..26.30 rows=1,597 width=0) (actual time=0.455..0.455 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
95. 0.001 0.136 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170608 (cost=26.63..1,553.72 rows=1,062 width=52) (actual time=0.407..0.407 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
96. 0.135 0.135 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170608_pkey (cost=0.00..26.18 rows=1,805 width=0) (actual time=0.405..0.405 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
97. 0.002 0.071 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180312 (cost=26.44..1,338.48 rows=861 width=52) (actual time=0.213..0.214 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
98. 0.069 0.069 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180312_pkey (cost=0.00..26.07 rows=1,464 width=0) (actual time=0.207..0.207 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
99. 0.001 0.412 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170713 (cost=26.32..1,339.82 rows=854 width=52) (actual time=1.236..1.236 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
100. 0.411 0.411 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170713_pkey (cost=0.00..25.95 rows=1,452 width=0) (actual time=1.233..1.233 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
101. 0.003 0.183 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170809 (cost=26.27..1,397.42 rows=915 width=52) (actual time=0.548..0.548 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
102. 0.180 0.180 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170809_pkey (cost=0.00..25.88 rows=1,555 width=0) (actual time=0.539..0.539 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
103. 0.001 0.162 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170703 (cost=26.22..1,399.11 rows=912 width=52) (actual time=0.486..0.486 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
104. 0.161 0.161 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170703_pkey (cost=0.00..25.83 rows=1,550 width=0) (actual time=0.484..0.484 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
105. 0.001 0.146 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170611 (cost=26.19..1,374.52 rows=910 width=52) (actual time=0.438..0.438 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
106. 0.145 0.145 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170611_pkey (cost=0.00..25.80 rows=1,547 width=0) (actual time=0.436..0.436 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
107. 0.002 0.054 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180401 (cost=26.14..1,321.20 rows=844 width=52) (actual time=0.163..0.163 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
108. 0.053 0.053 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180401_pkey (cost=0.00..25.78 rows=1,435 width=0) (actual time=0.158..0.158 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
109. 0.001 0.161 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170810 (cost=26.02..1,380.90 rows=900 width=52) (actual time=0.483..0.483 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
110. 0.160 0.160 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170810_pkey (cost=0.00..25.63 rows=1,530 width=0) (actual time=0.481..0.481 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
111. 0.003 0.076 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180216 (cost=26.00..1,370.37 rows=899 width=52) (actual time=0.227..0.227 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
112. 0.072 0.072 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180216_pkey (cost=0.00..25.62 rows=1,529 width=0) (actual time=0.217..0.217 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
113. 0.001 0.136 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170817 (cost=25.97..1,377.67 rows=898 width=52) (actual time=0.407..0.407 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
114. 0.135 0.135 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170817_pkey (cost=0.00..25.59 rows=1,526 width=0) (actual time=0.405..0.405 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
115. 0.002 0.139 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170708 (cost=25.97..1,312.17 rows=834 width=52) (actual time=0.417..0.417 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
116. 0.137 0.137 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170708_pkey (cost=0.00..25.61 rows=1,418 width=0) (actual time=0.412..0.412 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
117. 0.001 0.127 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170919 (cost=25.86..1,358.53 rows=891 width=52) (actual time=0.380..0.380 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
118. 0.126 0.126 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170919_pkey (cost=0.00..25.48 rows=1,515 width=0) (actual time=0.378..0.378 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
119. 0.001 0.133 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170728 (cost=25.78..1,298.53 rows=824 width=52) (actual time=0.399..0.400 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
120. 0.133 0.133 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170728_pkey (cost=0.00..25.43 rows=1,400 width=0) (actual time=0.397..0.398 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
121. 0.002 0.116 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170730 (cost=25.78..1,298.53 rows=824 width=52) (actual time=0.347..0.347 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
122. 0.114 0.114 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170730_pkey (cost=0.00..25.43 rows=1,400 width=0) (actual time=0.341..0.341 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
123. 0.001 0.158 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170509 (cost=25.76..1,446.72 rows=948 width=52) (actual time=0.474..0.474 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
124. 0.157 0.157 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170509_pkey (cost=0.00..25.35 rows=1,612 width=0) (actual time=0.472..0.472 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
125. 0.002 0.106 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180101 (cost=25.71..1,338.70 rows=882 width=52) (actual time=0.318..0.318 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
126. 0.104 0.104 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180101_pkey (cost=0.00..25.33 rows=1,500 width=0) (actual time=0.313..0.313 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
127. 0.001 0.110 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170721 (cost=25.69..1,295.99 rows=818 width=52) (actual time=0.331..0.331 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
128. 0.110 0.110 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170721_pkey (cost=0.00..25.34 rows=1,391 width=0) (actual time=0.329..0.329 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
129. 0.002 0.129 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171226 (cost=25.69..1,351.96 rows=881 width=52) (actual time=0.386..0.386 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
130. 0.127 0.127 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171226_pkey (cost=0.00..25.31 rows=1,498 width=0) (actual time=0.380..0.380 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
131. 0.001 0.137 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170707 (cost=25.67..1,288.84 rows=817 width=52) (actual time=0.412..0.412 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
132. 0.137 0.137 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170707_pkey (cost=0.00..25.32 rows=1,389 width=0) (actual time=0.410..0.410 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
133. 0.001 0.038 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180507 (cost=25.67..1,288.84 rows=817 width=52) (actual time=0.115..0.115 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
134. 0.038 0.038 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180507_pkey (cost=0.00..25.32 rows=1,389 width=0) (actual time=0.113..0.113 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
135. 0.002 0.129 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170621 (cost=25.65..1,345.23 rows=879 width=52) (actual time=0.387..0.387 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
136. 0.127 0.127 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170621_pkey (cost=0.00..25.27 rows=1,494 width=0) (actual time=0.381..0.381 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
137. 0.001 0.119 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170724 (cost=25.50..1,282.30 rows=807 width=52) (actual time=0.356..0.356 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
138. 0.118 0.118 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170724_pkey (cost=0.00..25.15 rows=1,372 width=0) (actual time=0.354..0.354 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
139. 0.001 0.144 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170609 (cost=25.47..1,324.27 rows=869 width=52) (actual time=0.431..0.431 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
140. 0.142 0.142 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170609_pkey (cost=0.00..25.10 rows=1,477 width=0) (actual time=0.426..0.427 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
141. 0.001 0.134 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171224 (cost=25.37..1,312.20 rows=863 width=52) (actual time=0.403..0.403 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
142. 0.134 0.134 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171224_pkey (cost=0.00..25.00 rows=1,467 width=0) (actual time=0.400..0.401 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
143. 0.002 0.042 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180118 (cost=25.34..1,252.76 rows=798 width=52) (actual time=0.125..0.125 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
144. 0.040 0.040 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180118_pkey (cost=0.00..25.00 rows=1,357 width=0) (actual time=0.119..0.119 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
145. 0.002 0.052 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180416 (cost=25.29..1,262.97 rows=795 width=52) (actual time=0.157..0.157 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
146. 0.050 0.050 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180416_pkey (cost=0.00..24.95 rows=1,352 width=0) (actual time=0.151..0.151 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
147. 0.001 0.142 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170819 (cost=25.12..1,315.59 rows=849 width=52) (actual time=0.426..0.427 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
148. 0.142 0.142 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170819_pkey (cost=0.00..24.76 rows=1,443 width=0) (actual time=0.424..0.425 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
149. 0.002 0.136 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170628 (cost=25.08..1,317.32 rows=846 width=52) (actual time=0.409..0.409 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
150. 0.134 0.134 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170628_pkey (cost=0.00..24.72 rows=1,439 width=0) (actual time=0.403..0.403 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
151. 0.001 0.160 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180204 (cost=24.78..1,220.22 rows=766 width=52) (actual time=0.480..0.480 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
152. 0.159 0.159 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180204_pkey (cost=0.00..24.45 rows=1,302 width=0) (actual time=0.478..0.478 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
153. 0.002 0.132 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170709 (cost=24.72..1,218.40 rows=763 width=52) (actual time=0.397..0.397 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
154. 0.131 0.131 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170709_pkey (cost=0.00..24.40 rows=1,297 width=0) (actual time=0.392..0.392 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
155. 0.001 0.042 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180222 (cost=24.72..1,282.64 rows=826 width=52) (actual time=0.125..0.125 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
156. 0.041 0.041 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180222_pkey (cost=0.00..24.37 rows=1,404 width=0) (actual time=0.123..0.123 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
157. 0.002 0.066 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180325 (cost=24.69..1,215.19 rows=761 width=52) (actual time=0.199..0.199 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
158. 0.065 0.065 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180325_pkey (cost=0.00..24.37 rows=1,294 width=0) (actual time=0.194..0.194 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
159. 0.001 0.133 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170521 (cost=24.67..1,367.87 rows=886 width=52) (actual time=0.398..0.398 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
160. 0.132 0.132 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170521_pkey (cost=0.00..24.29 rows=1,506 width=0) (actual time=0.396..0.396 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
161. 0.002 0.136 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180317 (cost=24.63..1,213.33 rows=758 width=52) (actual time=0.407..0.407 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
162. 0.134 0.134 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180317_pkey (cost=0.00..24.31 rows=1,288 width=0) (actual time=0.401..0.401 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
163. 0.001 0.150 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170816 (cost=24.57..1,195.90 rows=754 width=52) (actual time=0.450..0.450 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
164. 0.149 0.149 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170816_pkey (cost=0.00..24.25 rows=1,282 width=0) (actual time=0.446..0.446 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
165. 0.001 0.126 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170920 (cost=24.53..1,257.06 rows=815 width=52) (actual time=0.379..0.379 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
166. 0.126 0.126 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170920_pkey (cost=0.00..24.18 rows=1,385 width=0) (actual time=0.377..0.377 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
167. 0.008 0.151 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170701 (cost=24.48..1,269.61 rows=812 width=52) (actual time=0.451..0.452 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
168. 0.143 0.143 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170701_pkey (cost=0.00..24.13 rows=1,380 width=0) (actual time=0.428..0.428 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
169. 0.001 0.050 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180122 (cost=24.46..1,268.50 rows=811 width=52) (actual time=0.148..0.149 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
170. 0.049 0.049 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180122_pkey (cost=0.00..24.11 rows=1,378 width=0) (actual time=0.146..0.146 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
171. 0.002 0.127 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180126 (cost=24.36..1,182.53 rows=742 width=52) (actual time=0.380..0.381 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
172. 0.125 0.125 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180126_pkey (cost=0.00..24.04 rows=1,261 width=0) (actual time=0.376..0.376 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
173. 0.001 0.120 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170513 (cost=24.34..1,344.91 rows=867 width=52) (actual time=0.361..0.361 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
174. 0.119 0.119 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170513_pkey (cost=0.00..23.97 rows=1,474 width=0) (actual time=0.358..0.358 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
175. 0.001 0.073 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180206 (cost=24.32..1,179.31 rows=740 width=52) (actual time=0.219..0.219 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
176. 0.072 0.072 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180206_pkey (cost=0.00..24.01 rows=1,258 width=0) (actual time=0.217..0.217 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
177. 0.001 0.068 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180322 (cost=24.29..1,179.62 rows=738 width=52) (actual time=0.205..0.205 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
178. 0.067 0.067 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180322_pkey (cost=0.00..23.98 rows=1,255 width=0) (actual time=0.201..0.201 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
179. 0.001 0.143 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170602 (cost=24.28..1,241.52 rows=801 width=52) (actual time=0.428..0.428 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
180. 0.142 0.142 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170602_pkey (cost=0.00..23.94 rows=1,361 width=0) (actual time=0.426..0.426 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
181. 0.001 0.143 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171222 (cost=24.24..1,240.74 rows=798 width=52) (actual time=0.428..0.428 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
182. 0.141 0.141 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171222_pkey (cost=0.00..23.90 rows=1,357 width=0) (actual time=0.424..0.424 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
183. 0.001 0.025 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180410 (cost=24.18..1,180.94 rows=732 width=52) (actual time=0.074..0.075 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
184. 0.024 0.024 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180410_pkey (cost=0.00..23.87 rows=1,244 width=0) (actual time=0.073..0.073 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
185. 0.001 0.146 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170923 (cost=24.15..1,234.63 rows=793 width=52) (actual time=0.439..0.439 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
186. 0.146 0.146 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170923_pkey (cost=0.00..23.81 rows=1,348 width=0) (actual time=0.437..0.437 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
187. 0.001 0.047 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180309 (cost=24.02..1,153.82 rows=722 width=52) (actual time=0.140..0.140 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
188. 0.045 0.045 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180309_pkey (cost=0.00..23.71 rows=1,228 width=0) (actual time=0.135..0.136 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
189. 0.001 0.178 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170522 (cost=23.93..1,305.92 rows=844 width=52) (actual time=0.535..0.535 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
190. 0.178 0.178 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170522_pkey (cost=0.00..23.57 rows=1,434 width=0) (actual time=0.533..0.533 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
191. 0.002 0.129 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170530 (cost=23.90..1,370.75 rows=905 width=52) (actual time=0.386..0.386 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
192. 0.127 0.127 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170530_pkey (cost=0.00..23.51 rows=1,538 width=0) (actual time=0.381..0.381 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
193. 0.001 0.146 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170807 (cost=23.76..1,214.65 rows=771 width=52) (actual time=0.437..0.437 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
194. 0.145 0.145 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170807_pkey (cost=0.00..23.43 rows=1,310 width=0) (actual time=0.434..0.434 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
195. 0.002 0.147 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171205 (cost=23.72..1,137.87 rows=705 width=52) (actual time=0.442..0.442 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
196. 0.146 0.146 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171205_pkey (cost=0.00..23.42 rows=1,199 width=0) (actual time=0.437..0.437 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
197. 0.001 0.162 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171214 (cost=23.66..1,202.52 rows=765 width=52) (actual time=0.485..0.485 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
198. 0.161 0.161 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171214_pkey (cost=0.00..23.33 rows=1,300 width=0) (actual time=0.483..0.483 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
199. 0.001 0.148 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170505 (cost=23.62..1,293.54 rows=826 width=52) (actual time=0.445..0.445 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
200. 0.147 0.147 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170505_pkey (cost=0.00..23.27 rows=1,404 width=0) (actual time=0.442..0.442 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
201. 0.002 0.123 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170606 (cost=23.57..1,190.07 rows=760 width=52) (actual time=0.369..0.369 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
202. 0.121 0.121 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170606_pkey (cost=0.00..23.25 rows=1,292 width=0) (actual time=0.363..0.363 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
203. 0.001 0.040 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180403 (cost=23.44..1,115.53 rows=689 width=52) (actual time=0.121..0.121 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
204. 0.039 0.039 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180403_pkey (cost=0.00..23.15 rows=1,172 width=0) (actual time=0.118..0.118 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
205. 0.002 0.148 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170916 (cost=23.41..1,177.50 rows=751 width=52) (actual time=0.444..0.444 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
206. 0.146 0.146 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170916_pkey (cost=0.00..23.09 rows=1,276 width=0) (actual time=0.439..0.439 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
207. 0.001 0.149 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170822 (cost=23.34..1,182.96 rows=746 width=52) (actual time=0.448..0.448 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
208. 0.148 0.148 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170822_pkey (cost=0.00..23.02 rows=1,269 width=0) (actual time=0.445..0.445 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
209. 0.002 0.069 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180221 (cost=23.19..1,170.06 rows=738 width=52) (actual time=0.207..0.207 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
210. 0.067 0.067 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180221_pkey (cost=0.00..22.88 rows=1,255 width=0) (actual time=0.202..0.202 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
211. 0.001 0.129 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170525 (cost=23.12..1,317.59 rows=860 width=52) (actual time=0.388..0.388 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
212. 0.129 0.129 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170525_pkey (cost=0.00..22.75 rows=1,462 width=0) (actual time=0.386..0.386 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
213. 0.002 0.159 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170519 (cost=23.04..1,244.42 rows=792 width=52) (actual time=0.477..0.477 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
214. 0.157 0.157 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170519_pkey (cost=0.00..22.70 rows=1,347 width=0) (actual time=0.470..0.470 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
215. 0.002 0.037 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180303 (cost=22.98..1,159.14 rows=726 width=52) (actual time=0.111..0.111 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
216. 0.035 0.035 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180303_pkey (cost=0.00..22.67 rows=1,234 width=0) (actual time=0.106..0.106 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
217. 0.001 0.121 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170610 (cost=22.98..1,142.30 rows=726 width=52) (actual time=0.364..0.364 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
218. 0.120 0.120 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170610_pkey (cost=0.00..22.67 rows=1,234 width=0) (actual time=0.361..0.361 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
219. 0.002 0.057 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180307 (cost=22.96..1,071.31 rows=662 width=52) (actual time=0.172..0.172 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
220. 0.055 0.055 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180307_pkey (cost=0.00..22.68 rows=1,125 width=0) (actual time=0.166..0.166 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
221. 0.001 0.154 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171231 (cost=22.95..1,136.65 rows=724 width=52) (actual time=0.462..0.462 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
222. 0.153 0.153 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171231_pkey (cost=0.00..22.64 rows=1,231 width=0) (actual time=0.460..0.460 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
223. 0.002 0.143 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171209 (cost=22.84..1,134.30 rows=718 width=52) (actual time=0.430..0.430 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
224. 0.141 0.141 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171209_pkey (cost=0.00..22.53 rows=1,220 width=0) (actual time=0.424..0.424 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
225. 0.001 0.138 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170520 (cost=22.82..1,228.57 rows=780 width=52) (actual time=0.414..0.414 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
226. 0.137 0.137 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170520_pkey (cost=0.00..22.49 rows=1,326 width=0) (actual time=0.412..0.412 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
227. 0.001 0.040 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180421 (cost=22.82..1,068.30 rows=654 width=52) (actual time=0.121..0.121 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
228. 0.039 0.039 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180421_pkey (cost=0.00..22.54 rows=1,111 width=0) (actual time=0.118..0.118 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
229. 0.002 0.037 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180427 (cost=22.79..1,066.12 rows=652 width=52) (actual time=0.110..0.110 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
230. 0.035 0.035 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180427_pkey (cost=0.00..22.51 rows=1,108 width=0) (actual time=0.105..0.105 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
231. 0.001 0.109 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180313 (cost=22.68..1,137.17 rows=709 width=52) (actual time=0.327..0.327 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
232. 0.108 0.108 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180313_pkey (cost=0.00..22.38 rows=1,205 width=0) (actual time=0.325..0.325 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
233. 0.002 0.149 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170613 (cost=22.53..1,107.37 rows=700 width=52) (actual time=0.447..0.447 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
234. 0.147 0.147 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170613_pkey (cost=0.00..22.23 rows=1,190 width=0) (actual time=0.441..0.441 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
235. 0.001 0.157 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170818 (cost=22.48..1,116.38 rows=697 width=52) (actual time=0.472..0.472 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
236. 0.157 0.157 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170818_pkey (cost=0.00..22.18 rows=1,185 width=0) (actual time=0.470..0.470 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
237. 0.002 0.037 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180107 (cost=22.46..1,108.28 rows=696 width=52) (actual time=0.111..0.111 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
238. 0.035 0.035 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180107_pkey (cost=0.00..22.16 rows=1,183 width=0) (actual time=0.105..0.105 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
239. 0.001 0.117 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170917 (cost=22.35..1,097.17 rows=690 width=52) (actual time=0.351..0.351 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
240. 0.116 0.116 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170917_pkey (cost=0.00..22.06 rows=1,173 width=0) (actual time=0.349..0.349 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
241. 0.001 0.042 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180502 (cost=22.34..1,028.99 rows=626 width=52) (actual time=0.127..0.127 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
242. 0.042 0.042 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180502_pkey (cost=0.00..22.07 rows=1,064 width=0) (actual time=0.125..0.125 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
243. 0.002 0.141 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180318 (cost=22.24..1,025.34 rows=621 width=52) (actual time=0.424..0.424 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
244. 0.140 0.140 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180318_pkey (cost=0.00..21.98 rows=1,055 width=0) (actual time=0.419..0.419 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
245. 0.001 0.031 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180423 (cost=22.24..1,022.84 rows=621 width=52) (actual time=0.094..0.094 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
246. 0.031 0.031 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180423_pkey (cost=0.00..21.98 rows=1,055 width=0) (actual time=0.092..0.092 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
247. 0.002 0.128 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170601 (cost=22.20..1,249.00 rows=807 width=52) (actual time=0.383..0.383 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
248. 0.126 0.126 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170601_pkey (cost=0.00..21.85 rows=1,372 width=0) (actual time=0.378..0.378 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
249. 0.001 0.036 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180323 (cost=22.18..1,017.42 rows=617 width=52) (actual time=0.107..0.107 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
250. 0.035 0.035 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180323_pkey (cost=0.00..21.92 rows=1,049 width=0) (actual time=0.105..0.105 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
251. 0.001 0.043 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180211 (cost=22.18..1,096.85 rows=680 width=52) (actual time=0.129..0.129 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
252. 0.042 0.042 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180211_pkey (cost=0.00..21.89 rows=1,156 width=0) (actual time=0.125..0.125 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
253. 0.001 0.142 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180214 (cost=21.88..1,069.89 rows=663 width=52) (actual time=0.427..0.427 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
254. 0.142 0.142 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180214_pkey (cost=0.00..21.60 rows=1,127 width=0) (actual time=0.425..0.425 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
255. 0.001 0.052 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180201 (cost=21.87..988.26 rows=599 width=52) (actual time=0.156..0.156 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
256. 0.051 0.051 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180201_pkey (cost=0.00..21.62 rows=1,019 width=0) (actual time=0.154..0.154 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
257. 0.002 0.133 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170710 (cost=21.86..992.16 rows=599 width=52) (actual time=0.399..0.399 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
258. 0.131 0.131 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170710_pkey (cost=0.00..21.61 rows=1,018 width=0) (actual time=0.394..0.394 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
259. 0.001 0.027 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180128 (cost=21.81..982.85 rows=596 width=52) (actual time=0.081..0.081 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
260. 0.026 0.026 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180128_pkey (cost=0.00..21.56 rows=1,013 width=0) (actual time=0.079..0.079 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
261. 0.002 0.154 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171221 (cost=21.66..1,124.30 rows=714 width=52) (actual time=0.462..0.462 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
262. 0.152 0.152 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171221_pkey (cost=0.00..21.36 rows=1,213 width=0) (actual time=0.457..0.457 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
263. 0.001 0.148 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170921 (cost=21.42..1,024.38 rows=636 width=52) (actual time=0.445..0.445 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
264. 0.147 0.147 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170921_pkey (cost=0.00..21.15 rows=1,082 width=0) (actual time=0.442..0.442 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
265. 0.003 0.130 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170808 (cost=21.39..945.36 rows=572 width=52) (actual time=0.389..0.389 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
266. 0.126 0.126 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170808_pkey (cost=0.00..21.15 rows=972 width=0) (actual time=0.378..0.379 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
267. 0.001 0.096 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180315 (cost=21.35..947.04 rows=569 width=52) (actual time=0.288..0.288 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
268. 0.095 0.095 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180315_pkey (cost=0.00..21.11 rows=968 width=0) (actual time=0.284..0.284 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
269. 0.001 0.170 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170802 (cost=21.35..944.55 rows=569 width=52) (actual time=0.510..0.510 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
270. 0.169 0.169 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170802_pkey (cost=0.00..21.11 rows=968 width=0) (actual time=0.507..0.507 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
271. 0.002 0.124 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170720 (cost=21.33..949.84 rows=568 width=52) (actual time=0.372..0.373 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
272. 0.122 0.122 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170720_pkey (cost=0.00..21.09 rows=966 width=0) (actual time=0.366..0.366 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
273. 0.001 0.098 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180117 (cost=21.33..1,026.60 rows=631 width=52) (actual time=0.293..0.293 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
274. 0.097 0.097 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180117_pkey (cost=0.00..21.06 rows=1,073 width=0) (actual time=0.290..0.290 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
275. 0.002 0.081 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180127 (cost=21.26..938.36 rows=564 width=52) (actual time=0.243..0.243 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
276. 0.079 0.079 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180127_pkey (cost=0.00..21.02 rows=959 width=0) (actual time=0.236..0.236 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
277. 0.001 0.138 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170503 (cost=21.21..1,107.63 rows=688 width=52) (actual time=0.414..0.414 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
278. 0.137 0.137 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170503_pkey (cost=0.00..20.92 rows=1,169 width=0) (actual time=0.411..0.411 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
279. 0.002 0.127 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170508 (cost=21.13..1,102.58 rows=683 width=52) (actual time=0.381..0.381 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
280. 0.125 0.125 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170508_pkey (cost=0.00..20.84 rows=1,161 width=0) (actual time=0.374..0.374 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
281. 0.003 0.131 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171127 (cost=21.12..924.34 rows=556 width=52) (actual time=0.393..0.393 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
282. 0.128 0.128 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171127_pkey (cost=0.00..20.88 rows=945 width=0) (actual time=0.385..0.385 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
283. 0.001 0.147 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170714 (cost=21.11..930.70 rows=555 width=52) (actual time=0.440..0.440 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
284. 0.146 0.146 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170714_pkey (cost=0.00..20.87 rows=944 width=0) (actual time=0.438..0.438 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
285. 0.004 0.039 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180506 (cost=21.08..927.47 rows=554 width=52) (actual time=0.116..0.116 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
286. 0.035 0.035 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180506_pkey (cost=0.00..20.84 rows=941 width=0) (actual time=0.105..0.105 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
287. 0.001 0.126 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171210 (cost=21.05..918.90 rows=552 width=52) (actual time=0.379..0.379 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
288. 0.125 0.125 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171210_pkey (cost=0.00..20.82 rows=939 width=0) (actual time=0.376..0.376 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
289. 0.002 0.127 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171217 (cost=21.03..1,001.05 rows=614 width=52) (actual time=0.382..0.382 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
290. 0.125 0.125 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171217_pkey (cost=0.00..20.77 rows=1,044 width=0) (actual time=0.375..0.375 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
291. 0.001 0.157 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170517 (cost=20.94..1,085.30 rows=672 width=52) (actual time=0.471..0.471 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
292. 0.156 0.156 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170517_pkey (cost=0.00..20.65 rows=1,142 width=0) (actual time=0.469..0.469 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
293. 0.001 0.155 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170614 (cost=20.90..979.37 rows=606 width=52) (actual time=0.465..0.465 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
294. 0.154 0.154 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170614_pkey (cost=0.00..20.64 rows=1,031 width=0) (actual time=0.461..0.461 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
295. 0.002 0.136 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170615 (cost=20.80..972.11 rows=601 width=52) (actual time=0.408..0.408 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
296. 0.134 0.134 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170615_pkey (cost=0.00..20.54 rows=1,021 width=0) (actual time=0.401..0.401 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
297. 0.001 0.045 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180109 (cost=20.76..976.22 rows=599 width=52) (actual time=0.135..0.135 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
298. 0.044 0.044 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180109_pkey (cost=0.00..20.51 rows=1,018 width=0) (actual time=0.132..0.132 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
299. 0.002 0.136 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171202 (cost=20.76..897.15 rows=535 width=52) (actual time=0.409..0.409 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
300. 0.134 0.134 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171202_pkey (cost=0.00..20.53 rows=910 width=0) (actual time=0.403..0.403 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
301. 0.001 0.130 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170524 (cost=20.72..1,062.36 rows=659 width=52) (actual time=0.390..0.390 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
302. 0.129 0.129 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170524_pkey (cost=0.00..20.44 rows=1,121 width=0) (actual time=0.388..0.388 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
303. 0.002 0.036 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180331 (cost=20.63..887.72 rows=528 width=52) (actual time=0.107..0.107 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
304. 0.034 0.034 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180331_pkey (cost=0.00..20.41 rows=898 width=0) (actual time=0.102..0.102 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
305. 0.001 0.033 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180213 (cost=20.61..969.56 rows=590 width=52) (actual time=0.099..0.099 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
306. 0.032 0.032 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180213_pkey (cost=0.00..20.36 rows=1,003 width=0) (actual time=0.097..0.097 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
307. 0.001 0.151 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170511 (cost=20.60..1,058.99 rows=652 width=52) (actual time=0.454..0.454 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
308. 0.150 0.150 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170511_pkey (cost=0.00..20.32 rows=1,109 width=0) (actual time=0.451..0.451 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
309. 0.002 0.143 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170627 (cost=20.57..968.76 rows=588 width=52) (actual time=0.428..0.428 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
310. 0.140 0.140 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170627_pkey (cost=0.00..20.32 rows=999 width=0) (actual time=0.421..0.421 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
311. 0.001 0.043 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180217 (cost=20.54..963.07 rows=586 width=52) (actual time=0.129..0.129 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
312. 0.042 0.042 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180217_pkey (cost=0.00..20.29 rows=996 width=0) (actual time=0.127..0.127 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
313. 0.002 0.152 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171130 (cost=20.51..962.31 rows=584 width=52) (actual time=0.457..0.457 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
314. 0.150 0.150 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171130_pkey (cost=0.00..20.26 rows=993 width=0) (actual time=0.451..0.451 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
315. 0.002 0.139 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170604 (cost=20.50..952.44 rows=584 width=52) (actual time=0.418..0.418 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
316. 0.137 0.137 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170604_pkey (cost=0.00..20.25 rows=992 width=0) (actual time=0.411..0.411 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
317. 0.002 0.034 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180203 (cost=20.40..868.49 rows=515 width=52) (actual time=0.102..0.102 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
318. 0.032 0.032 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180203_pkey (cost=0.00..20.18 rows=875 width=0) (actual time=0.096..0.096 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
319. 0.001 0.143 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170801 (cost=20.39..955.37 rows=577 width=52) (actual time=0.428..0.428 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
320. 0.142 0.142 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170801_pkey (cost=0.00..20.14 rows=981 width=0) (actual time=0.425..0.425 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
321. 0.001 0.157 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170722 (cost=20.31..863.74 rows=509 width=52) (actual time=0.471..0.471 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
322. 0.156 0.156 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170722_pkey (cost=0.00..20.09 rows=866 width=0) (actual time=0.467..0.467 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
323. 0.002 0.036 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180429 (cost=20.23..854.74 rows=505 width=52) (actual time=0.107..0.107 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
324. 0.034 0.034 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180429_pkey (cost=0.00..20.02 rows=859 width=0) (actual time=0.102..0.102 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
325. 0.001 0.143 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170706 (cost=20.21..852.59 rows=504 width=52) (actual time=0.430..0.430 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
326. 0.142 0.142 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170706_pkey (cost=0.00..20.00 rows=857 width=0) (actual time=0.427..0.427 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
327. 0.002 0.040 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180305 (cost=20.04..922.92 rows=557 width=52) (actual time=0.119..0.119 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
328. 0.037 0.037 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180305_pkey (cost=0.00..19.80 rows=947 width=0) (actual time=0.112..0.112 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
329. 0.001 0.027 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180112 (cost=19.98..915.04 rows=554 width=52) (actual time=0.082..0.082 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
330. 0.027 0.027 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180112_pkey (cost=0.00..19.74 rows=941 width=0) (actual time=0.080..0.080 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
331. 0.001 0.033 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180129 (cost=19.87..818.98 rows=484 width=52) (actual time=0.100..0.100 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
332. 0.032 0.032 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180129_pkey (cost=0.00..19.66 rows=823 width=0) (actual time=0.096..0.096 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
333. 0.001 0.022 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180224 (cost=19.77..900.50 rows=542 width=52) (actual time=0.065..0.065 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
334. 0.021 0.021 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180224_pkey (cost=0.00..19.54 rows=921 width=0) (actual time=0.063..0.063 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
335. 0.001 0.149 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170718 (cost=19.69..811.53 rows=474 width=52) (actual time=0.447..0.447 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
336. 0.148 0.148 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170718_pkey (cost=0.00..19.49 rows=806 width=0) (actual time=0.445..0.445 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
337. 0.002 0.146 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170616 (cost=19.68..883.11 rows=536 width=52) (actual time=0.438..0.438 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
338. 0.144 0.144 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170616_pkey (cost=0.00..19.45 rows=912 width=0) (actual time=0.432..0.432 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
339. 0.001 0.156 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171129 (cost=19.44..784.10 rows=459 width=52) (actual time=0.468..0.468 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
340. 0.155 0.155 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171129_pkey (cost=0.00..19.24 rows=781 width=0) (actual time=0.465..0.465 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
341. 0.002 0.036 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180209 (cost=19.26..858.14 rows=512 width=52) (actual time=0.108..0.108 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
342. 0.034 0.034 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180209_pkey (cost=0.00..19.04 rows=871 width=0) (actual time=0.102..0.102 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
343. 0.001 0.170 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170712 (cost=19.24..769.52 rows=448 width=52) (actual time=0.510..0.510 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
344. 0.169 0.169 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170712_pkey (cost=0.00..19.05 rows=762 width=0) (actual time=0.507..0.507 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
345. 0.002 0.037 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180425 (cost=19.21..768.73 rows=446 width=52) (actual time=0.112..0.112 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
346. 0.036 0.036 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180425_pkey (cost=0.00..19.02 rows=759 width=0) (actual time=0.107..0.107 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
347. 0.003 0.133 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171228 (cost=19.16..844.55 rows=506 width=52) (actual time=0.399..0.399 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
348. 0.130 0.130 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171228_pkey (cost=0.00..18.94 rows=861 width=0) (actual time=0.391..0.391 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
349. 0.001 0.030 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180116 (cost=18.95..831.36 rows=495 width=52) (actual time=0.091..0.091 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
350. 0.030 0.030 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180116_pkey (cost=0.00..18.74 rows=841 width=0) (actual time=0.089..0.089 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
351. 0.002 0.175 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180314 (cost=18.88..736.17 rows=428 width=52) (actual time=0.524..0.524 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
352. 0.172 0.172 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180314_pkey (cost=0.00..18.70 rows=727 width=0) (actual time=0.517..0.517 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
353. 0.001 0.035 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180311 (cost=18.75..724.17 rows=420 width=52) (actual time=0.105..0.105 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
354. 0.034 0.034 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180311_pkey (cost=0.00..18.57 rows=714 width=0) (actual time=0.103..0.103 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
355. 0.002 0.122 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170821 (cost=18.63..805.92 rows=476 width=52) (actual time=0.367..0.367 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
356. 0.121 0.121 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170821_pkey (cost=0.00..18.43 rows=810 width=0) (actual time=0.362..0.362 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
357. 0.001 0.146 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170619 (cost=18.57..791.78 rows=473 width=52) (actual time=0.438..0.438 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
358. 0.145 0.145 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170619_pkey (cost=0.00..18.37 rows=804 width=0) (actual time=0.435..0.435 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
359. 0.002 0.202 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170824 (cost=18.55..797.29 rows=472 width=52) (actual time=0.606..0.606 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
360. 0.200 0.200 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170824_pkey (cost=0.00..18.35 rows=802 width=0) (actual time=0.600..0.600 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
361. 0.001 0.103 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180402 (cost=18.48..701.95 rows=405 width=52) (actual time=0.310..0.310 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
362. 0.102 0.102 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180402_pkey (cost=0.00..18.31 rows=688 width=0) (actual time=0.307..0.307 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
363. 0.001 0.137 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170502 (cost=18.41..884.41 rows=527 width=52) (actual time=0.411..0.411 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
364. 0.136 0.136 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170502_pkey (cost=0.00..18.19 rows=896 width=0) (actual time=0.407..0.407 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
365. 0.002 0.146 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180205 (cost=18.36..689.98 rows=398 width=52) (actual time=0.438..0.438 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
366. 0.144 0.144 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180205_pkey (cost=0.00..18.19 rows=676 width=0) (actual time=0.431..0.431 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
367. 0.002 0.182 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170626 (cost=18.24..771.87 rows=454 width=52) (actual time=0.547..0.547 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
368. 0.180 0.180 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170626_pkey (cost=0.00..18.05 rows=772 width=0) (actual time=0.540..0.540 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
369. 0.002 0.124 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170612 (cost=18.18..760.15 rows=451 width=52) (actual time=0.373..0.373 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
370. 0.122 0.122 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170612_pkey (cost=0.00..17.99 rows=766 width=0) (actual time=0.367..0.367 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
371. 0.001 0.119 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180328 (cost=17.84..644.12 rows=368 width=52) (actual time=0.356..0.356 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
372. 0.118 0.118 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180328_pkey (cost=0.00..17.69 rows=626 width=0) (actual time=0.354..0.354 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
373. 0.002 0.138 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171216 (cost=17.84..735.26 rows=431 width=52) (actual time=0.414..0.414 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
374. 0.136 0.136 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171216_pkey (cost=0.00..17.66 rows=733 width=0) (actual time=0.408..0.408 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
375. 0.001 0.153 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170623 (cost=17.78..729.82 rows=428 width=52) (actual time=0.460..0.460 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
376. 0.152 0.152 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170623_pkey (cost=0.00..17.60 rows=727 width=0) (actual time=0.457..0.457 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
377. 0.001 0.146 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170825 (cost=17.69..722.52 rows=422 width=52) (actual time=0.439..0.439 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
378. 0.145 0.145 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170825_pkey (cost=0.00..17.51 rows=718 width=0) (actual time=0.435..0.436 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
379. 0.002 0.229 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170618 (cost=17.60..710.01 rows=417 width=52) (actual time=0.686..0.686 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
380. 0.226 0.226 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170618_pkey (cost=0.00..17.42 rows=709 width=0) (actual time=0.679..0.679 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
381. 0.001 0.153 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170826 (cost=17.49..707.86 rows=411 width=52) (actual time=0.459..0.459 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
382. 0.152 0.152 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170826_pkey (cost=0.00..17.32 rows=699 width=0) (actual time=0.456..0.456 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
383. 0.002 0.157 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170605 (cost=17.34..691.29 rows=402 width=52) (actual time=0.472..0.472 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
384. 0.155 0.155 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170605_pkey (cost=0.00..17.17 rows=684 width=0) (actual time=0.465..0.465 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
385. 0.001 0.107 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180131 (cost=17.33..597.80 rows=339 width=52) (actual time=0.321..0.321 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
386. 0.106 0.106 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180131_pkey (cost=0.00..17.19 rows=576 width=0) (actual time=0.318..0.318 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
387. 0.001 0.134 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170813 (cost=17.32..692.94 rows=401 width=52) (actual time=0.402..0.402 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
388. 0.133 0.133 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170813_pkey (cost=0.00..17.15 rows=682 width=0) (actual time=0.399..0.399 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
389. 0.002 0.135 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180316 (cost=17.26..591.58 rows=335 width=52) (actual time=0.405..0.405 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
390. 0.133 0.133 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180316_pkey (cost=0.00..17.12 rows=569 width=0) (actual time=0.398..0.398 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
391. 0.001 0.158 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170922 (cost=17.22..679.34 rows=395 width=52) (actual time=0.473..0.473 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
392. 0.157 0.157 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170922_pkey (cost=0.00..17.05 rows=672 width=0) (actual time=0.470..0.470 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
393. 0.002 0.141 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180324 (cost=17.20..587.49 rows=331 width=52) (actual time=0.423..0.423 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
394. 0.139 0.139 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180324_pkey (cost=0.00..17.06 rows=563 width=0) (actual time=0.418..0.418 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
395. 0.001 0.191 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170811 (cost=17.07..670.42 rows=387 width=52) (actual time=0.574..0.574 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
396. 0.190 0.190 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170811_pkey (cost=0.00..16.91 rows=658 width=0) (actual time=0.571..0.571 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
397. 0.002 0.122 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180225 (cost=17.07..670.41 rows=387 width=52) (actual time=0.366..0.366 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
398. 0.120 0.120 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180225_pkey (cost=0.00..16.91 rows=658 width=0) (actual time=0.360..0.360 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
399. 0.003 5.407 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170607 (cost=16.95..841.27 rows=506 width=52) (actual time=16.222..16.222 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
400. 5.405 5.405 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170607_pkey (cost=0.00..16.73 rows=860 width=0) (actual time=16.214..16.214 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
401. 0.003 3.059 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170527 (cost=16.90..836.96 rows=504 width=52) (actual time=9.178..9.178 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
402. 3.056 3.056 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170527_pkey (cost=0.00..16.69 rows=856 width=0) (actual time=9.169..9.169 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
403. 0.004 0.185 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170827 (cost=16.89..556.93 rows=314 width=52) (actual time=0.556..0.556 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
404. 0.181 0.181 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170827_pkey (cost=0.00..16.76 rows=533 width=0) (actual time=0.544..0.544 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
405. 0.001 0.235 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170531 (cost=16.84..548.76 rows=311 width=52) (actual time=0.704..0.704 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
406. 0.234 0.234 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170531_pkey (cost=0.00..16.71 rows=528 width=0) (actual time=0.701..0.701 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
407. 0.002 0.075 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180228 (cost=16.81..645.69 rows=372 width=52) (actual time=0.224..0.224 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
408. 0.072 0.072 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180228_pkey (cost=0.00..16.65 rows=632 width=0) (actual time=0.217..0.217 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
409. 0.001 0.163 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180329 (cost=16.59..530.20 rows=296 width=52) (actual time=0.488..0.488 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
410. 0.162 0.162 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180329_pkey (cost=0.00..16.47 rows=504 width=0) (actual time=0.485..0.485 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
411. 0.002 0.144 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180111 (cost=16.57..624.22 rows=358 width=52) (actual time=0.433..0.433 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
412. 0.142 0.142 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180111_pkey (cost=0.00..16.42 rows=609 width=0) (actual time=0.427..0.427 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
413. 0.001 0.158 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170805 (cost=16.56..623.12 rows=358 width=52) (actual time=0.473..0.473 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
414. 0.157 0.157 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170805_pkey (cost=0.00..16.41 rows=608 width=0) (actual time=0.470..0.470 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
415. 0.001 0.149 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170820 (cost=16.51..620.13 rows=355 width=52) (actual time=0.448..0.448 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
416. 0.148 0.148 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170820_pkey (cost=0.00..16.36 rows=603 width=0) (actual time=0.445..0.445 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
417. 0.004 0.141 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180110 (cost=16.49..616.58 rows=354 width=52) (actual time=0.424..0.424 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
418. 0.137 0.137 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180110_pkey (cost=0.00..16.34 rows=601 width=0) (actual time=0.412..0.412 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
419. 0.001 0.152 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171207 (cost=16.47..518.17 rows=289 width=52) (actual time=0.456..0.456 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
420. 0.151 0.151 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171207_pkey (cost=0.00..16.35 rows=492 width=0) (actual time=0.453..0.453 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
421. 0.002 0.193 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171201 (cost=16.44..514.91 rows=288 width=52) (actual time=0.579..0.579 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
422. 0.191 0.191 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171201_pkey (cost=0.00..16.32 rows=489 width=0) (actual time=0.572..0.572 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
423. 0.001 0.140 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180405 (cost=16.43..515.19 rows=287 width=52) (actual time=0.421..0.421 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
424. 0.139 0.139 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180405_pkey (cost=0.00..16.31 rows=488 width=0) (actual time=0.418..0.418 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
425. 0.002 0.151 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180105 (cost=16.38..605.68 rows=347 width=52) (actual time=0.454..0.454 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
426. 0.149 0.149 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180105_pkey (cost=0.00..16.23 rows=590 width=0) (actual time=0.448..0.448 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
427. 0.001 0.138 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180119 (cost=16.34..603.80 rows=345 width=52) (actual time=0.414..0.414 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
428. 0.137 0.137 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180119_pkey (cost=0.00..16.20 rows=587 width=0) (actual time=0.411..0.411 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
429. 0.001 0.150 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180413 (cost=16.26..499.06 rows=277 width=52) (actual time=0.451..0.451 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
430. 0.150 0.150 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180413_pkey (cost=0.00..16.14 rows=471 width=0) (actual time=0.449..0.449 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
431. 0.002 0.165 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170526 (cost=16.18..774.99 rows=462 width=52) (actual time=0.495..0.495 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
432. 0.163 0.163 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170526_pkey (cost=0.00..15.98 rows=785 width=0) (actual time=0.489..0.489 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
433. 0.001 0.145 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180330 (cost=16.12..584.75 rows=332 width=52) (actual time=0.436..0.436 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
434. 0.144 0.144 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180330_pkey (cost=0.00..15.98 rows=565 width=0) (actual time=0.433..0.433 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
435. 0.002 0.181 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170501 (cost=16.11..683.77 rows=395 width=52) (actual time=0.542..0.542 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
436. 0.178 0.178 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170501_pkey (cost=0.00..15.94 rows=671 width=0) (actual time=0.535..0.535 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
437. 0.001 0.154 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171218 (cost=16.03..574.64 rows=327 width=52) (actual time=0.462..0.462 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
438. 0.153 0.153 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171218_pkey (cost=0.00..15.89 rows=556 width=0) (actual time=0.460..0.460 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
439. 0.002 0.131 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180106 (cost=16.00..571.38 rows=325 width=52) (actual time=0.393..0.393 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
440. 0.129 0.129 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180106_pkey (cost=0.00..15.86 rows=553 width=0) (actual time=0.387..0.387 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
441. 0.001 0.269 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180115 (cost=15.99..571.67 rows=325 width=52) (actual time=0.808..0.808 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
442. 0.268 0.268 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180115_pkey (cost=0.00..15.85 rows=552 width=0) (actual time=0.805..0.805 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
443. 0.001 0.137 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170620 (cost=15.93..563.50 rows=322 width=52) (actual time=0.412..0.412 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
444. 0.137 0.137 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170620_pkey (cost=0.00..15.80 rows=547 width=0) (actual time=0.409..0.410 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
445. 0.002 0.105 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180124 (cost=15.72..448.17 rows=246 width=52) (actual time=0.316..0.316 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
446. 0.103 0.103 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180124_pkey (cost=0.00..15.62 rows=419 width=0) (actual time=0.310..0.310 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
447. 0.001 0.149 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170726 (cost=15.71..448.44 rows=246 width=52) (actual time=0.448..0.448 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
448. 0.148 0.148 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170726_pkey (cost=0.00..15.61 rows=418 width=0) (actual time=0.445..0.445 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
449. 0.002 0.135 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180426 (cost=15.70..447.34 rows=245 width=52) (actual time=0.404..0.404 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
450. 0.133 0.133 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180426_pkey (cost=0.00..15.60 rows=417 width=0) (actual time=0.398..0.398 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
451. 0.001 0.137 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180226 (cost=15.40..517.93 rows=291 width=52) (actual time=0.411..0.411 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
452. 0.136 0.136 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180226_pkey (cost=0.00..15.28 rows=495 width=0) (actual time=0.408..0.408 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
453. 0.002 0.140 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180113 (cost=15.39..415.59 rows=228 width=52) (actual time=0.420..0.420 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
454. 0.138 0.138 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180113_pkey (cost=0.00..15.30 rows=387 width=0) (actual time=0.414..0.414 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
455. 0.001 0.138 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171219 (cost=15.25..502.65 rows=282 width=52) (actual time=0.415..0.415 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
456. 0.138 0.138 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171219_pkey (cost=0.00..15.13 rows=480 width=0) (actual time=0.413..0.413 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
457. 0.001 0.201 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180227 (cost=15.24..502.90 rows=282 width=52) (actual time=0.602..0.602 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
458. 0.200 0.200 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180227_pkey (cost=0.00..15.12 rows=479 width=0) (actual time=0.599..0.599 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
459. 0.002 0.191 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171227 (cost=15.17..494.97 rows=278 width=52) (actual time=0.573..0.573 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
460. 0.189 0.189 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171227_pkey (cost=0.00..15.05 rows=472 width=0) (actual time=0.566..0.566 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
461. 0.001 0.157 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170510 (cost=15.16..597.81 rows=341 width=52) (actual time=0.470..0.470 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
462. 0.156 0.156 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170510_pkey (cost=0.00..15.02 rows=579 width=0) (actual time=0.467..0.467 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
463. 0.002 0.148 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180202 (cost=15.13..390.87 rows=212 width=52) (actual time=0.444..0.444 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
464. 0.146 0.146 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180202_pkey (cost=0.00..15.04 rows=361 width=0) (actual time=0.437..0.437 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
465. 0.001 0.158 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171212 (cost=15.00..481.29 rows=268 width=52) (actual time=0.475..0.475 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
466. 0.157 0.157 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171212_pkey (cost=0.00..14.89 rows=456 width=0) (actual time=0.472..0.472 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
467. 0.002 0.154 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170705 (cost=14.93..372.46 rows=201 width=52) (actual time=0.462..0.463 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
468. 0.152 0.152 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170705_pkey (cost=0.00..14.85 rows=342 width=0) (actual time=0.456..0.456 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
469. 0.002 0.038 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180320 (cost=14.93..372.46 rows=201 width=52) (actual time=0.113..0.113 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
470. 0.035 0.035 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180320_pkey (cost=0.00..14.85 rows=342 width=0) (actual time=0.106..0.106 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
471. 0.001 0.147 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170704 (cost=14.89..368.07 rows=199 width=52) (actual time=0.440..0.440 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
472. 0.146 0.146 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170704_pkey (cost=0.00..14.81 rows=338 width=0) (actual time=0.437..0.437 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
473. 0.002 0.135 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180220 (cost=14.88..469.56 rows=261 width=52) (actual time=0.405..0.405 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
474. 0.133 0.133 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180220_pkey (cost=0.00..14.77 rows=444 width=0) (actual time=0.398..0.398 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
475. 0.001 0.133 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180407 (cost=14.87..367.21 rows=198 width=52) (actual time=0.399..0.399 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
476. 0.132 0.132 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180407_pkey (cost=0.00..14.79 rows=336 width=0) (actual time=0.397..0.397 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
477. 0.002 0.146 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180123 (cost=14.75..457.77 rows=254 width=52) (actual time=0.438..0.438 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
478. 0.144 0.144 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180123_pkey (cost=0.00..14.64 rows=431 width=0) (actual time=0.432..0.432 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
479. 0.001 0.032 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180321 (cost=14.71..349.66 rows=188 width=52) (actual time=0.096..0.096 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
480. 0.031 0.031 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180321_pkey (cost=0.00..14.62 rows=320 width=0) (actual time=0.094..0.094 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
481. 0.002 0.126 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170717 (cost=14.64..344.41 rows=185 width=52) (actual time=0.377..0.377 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
482. 0.124 0.124 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170717_pkey (cost=0.00..14.56 rows=314 width=0) (actual time=0.372..0.372 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
483. 0.002 0.153 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180415 (cost=14.64..344.41 rows=185 width=52) (actual time=0.458..0.459 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
484. 0.151 0.151 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180415_pkey (cost=0.00..14.56 rows=314 width=0) (actual time=0.453..0.453 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
485. 0.001 0.134 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171206 (cost=14.52..332.29 rows=178 width=52) (actual time=0.403..0.403 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
486. 0.134 0.134 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171206_pkey (cost=0.00..14.44 rows=302 width=0) (actual time=0.401..0.401 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
487. 0.002 0.123 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170629 (cost=14.51..435.05 rows=240 width=52) (actual time=0.370..0.370 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
488. 0.121 0.121 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170629_pkey (cost=0.00..14.41 rows=408 width=0) (actual time=0.364..0.364 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
489. 0.001 0.093 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180301 (cost=14.45..428.50 rows=236 width=52) (actual time=0.280..0.280 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
490. 0.093 0.093 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180301_pkey (cost=0.00..14.35 rows=402 width=0) (actual time=0.278..0.278 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
491. 0.002 0.145 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180114 (cost=14.40..319.12 rows=171 width=52) (actual time=0.435..0.435 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
492. 0.143 0.143 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180114_pkey (cost=0.00..14.32 rows=290 width=0) (actual time=0.429..0.429 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
493. 0.001 0.129 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180207 (cost=14.38..423.24 rows=232 width=52) (actual time=0.387..0.387 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
494. 0.128 0.128 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180207_pkey (cost=0.00..14.28 rows=395 width=0) (actual time=0.385..0.385 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
495. 0.001 0.149 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170516 (cost=14.34..522.55 rows=294 width=52) (actual time=0.447..0.447 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
496. 0.148 0.148 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170516_pkey (cost=0.00..14.22 rows=499 width=0) (actual time=0.444..0.444 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
497. 0.002 0.071 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180420 (cost=14.34..313.85 rows=167 width=52) (actual time=0.213..0.213 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
498. 0.069 0.069 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180420_pkey (cost=0.00..14.26 rows=284 width=0) (actual time=0.207..0.207 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
499. 0.001 0.123 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170617 (cost=14.25..408.52 rows=225 width=52) (actual time=0.369..0.369 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
500. 0.122 0.122 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170617_pkey (cost=0.00..14.16 rows=383 width=0) (actual time=0.367..0.367 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
501. 0.002 0.153 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170711 (cost=14.21..301.98 rows=160 width=52) (actual time=0.458..0.458 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
502. 0.151 0.151 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170711_pkey (cost=0.00..14.14 rows=272 width=0) (actual time=0.452..0.452 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
503. 0.001 0.131 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180406 (cost=14.15..295.38 rows=156 width=52) (actual time=0.393..0.393 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
504. 0.130 0.130 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180406_pkey (cost=0.00..14.08 rows=266 width=0) (actual time=0.391..0.391 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
505. 0.002 0.103 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180121 (cost=13.96..382.11 rows=208 width=52) (actual time=0.309..0.309 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
506. 0.101 0.101 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180121_pkey (cost=0.00..13.87 rows=354 width=0) (actual time=0.302..0.302 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
507. 0.001 0.173 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170806 (cost=13.79..259.25 rows=136 width=52) (actual time=0.520..0.520 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
508. 0.172 0.172 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170806_pkey (cost=0.00..13.73 rows=231 width=0) (actual time=0.517..0.517 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
509. 0.001 0.338 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180424 (cost=13.78..258.38 rows=135 width=52) (actual time=1.014..1.014 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
510. 0.337 0.337 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180424_pkey (cost=0.00..13.72 rows=230 width=0) (actual time=1.011..1.011 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
511. 0.002 0.152 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180103 (cost=13.74..360.17 rows=196 width=52) (actual time=0.456..0.456 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
512. 0.150 0.150 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180103_pkey (cost=0.00..13.66 rows=333 width=0) (actual time=0.449..0.449 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
513. 0.001 0.408 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170804 (cost=13.57..345.01 rows=186 width=52) (actual time=1.223..1.223 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
514. 0.407 0.407 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170804_pkey (cost=0.00..13.49 rows=317 width=0) (actual time=1.220..1.220 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
515. 0.002 0.244 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171223 (cost=13.56..343.91 rows=186 width=52) (actual time=0.732..0.732 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
516. 0.242 0.242 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171223_pkey (cost=0.00..13.48 rows=316 width=0) (actual time=0.726..0.726 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
517. 0.001 0.128 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170603 (cost=13.50..228.60 rows=119 width=52) (actual time=0.384..0.384 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
518. 0.127 0.127 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170603_pkey (cost=0.00..13.44 rows=202 width=0) (actual time=0.382..0.382 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
519. 0.002 0.169 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180306 (cost=13.45..225.47 rows=116 width=52) (actual time=0.508..0.508 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
520. 0.168 0.168 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180306_pkey (cost=0.00..13.40 rows=198 width=0) (actual time=0.503..0.503 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
521. 0.002 0.266 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171225 (cost=13.43..329.67 rows=178 width=52) (actual time=0.799..0.799 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
522. 0.264 0.264 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171225_pkey (cost=0.00..13.36 rows=303 width=0) (actual time=0.792..0.792 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
523. 0.001 0.162 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170622 (cost=13.37..324.39 rows=175 width=52) (actual time=0.485..0.485 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
524. 0.161 0.161 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170622_pkey (cost=0.00..13.29 rows=297 width=0) (actual time=0.483..0.483 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
525. 0.002 0.140 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170715 (cost=13.32..211.34 rows=109 width=52) (actual time=0.421..0.421 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
526. 0.138 0.138 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170715_pkey (cost=0.00..13.27 rows=185 width=0) (actual time=0.414..0.414 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
527. 0.001 0.185 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180108 (cost=13.32..318.92 rows=172 width=52) (actual time=0.555..0.555 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
528. 0.184 0.184 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180108_pkey (cost=0.00..13.24 rows=292 width=0) (actual time=0.552..0.552 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
529. 0.002 0.117 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170729 (cost=13.30..209.14 rows=108 width=52) (actual time=0.350..0.350 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
530. 0.115 0.115 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170729_pkey (cost=0.00..13.25 rows=183 width=0) (actual time=0.344..0.344 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
531. 0.001 0.164 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180212 (cost=13.23..310.34 rows=166 width=52) (actual time=0.493..0.493 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
532. 0.164 0.164 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180212_pkey (cost=0.00..13.15 rows=283 width=0) (actual time=0.491..0.491 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
533. 0.002 0.265 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170702 (cost=12.96..284.39 rows=151 width=52) (actual time=0.794..0.794 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
534. 0.263 0.263 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170702_pkey (cost=0.00..12.89 rows=257 width=0) (actual time=0.788..0.788 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
535. 0.001 0.132 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180308 (cost=12.91..279.95 rows=148 width=52) (actual time=0.395..0.395 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
536. 0.131 0.131 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180308_pkey (cost=0.00..12.84 rows=252 width=0) (actual time=0.392..0.392 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
537. 0.001 0.141 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170823 (cost=12.91..279.95 rows=148 width=52) (actual time=0.422..0.422 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
538. 0.140 0.140 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170823_pkey (cost=0.00..12.84 rows=252 width=0) (actual time=0.420..0.420 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
539. 0.002 0.116 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180104 (cost=12.80..267.86 rows=142 width=52) (actual time=0.348..0.348 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
540. 0.114 0.114 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180104_pkey (cost=0.00..12.73 rows=241 width=0) (actual time=0.342..0.342 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
541. 0.001 0.159 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170529 (cost=12.38..225.31 rows=118 width=52) (actual time=0.477..0.477 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
542. 0.158 0.158 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170529_pkey (cost=0.00..12.32 rows=200 width=0) (actual time=0.475..0.475 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
543. 0.002 0.196 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170507 (cost=12.34..331.23 rows=179 width=52) (actual time=0.587..0.587 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
544. 0.194 0.194 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170507_pkey (cost=0.00..12.27 rows=304 width=0) (actual time=0.581..0.581 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
545. 0.001 0.129 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180219 (cost=12.27..215.55 rows=112 width=52) (actual time=0.386..0.386 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
546. 0.128 0.128 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20180219_pkey (cost=0.00..12.22 rows=190 width=0) (actual time=0.383..0.383 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
547. 0.002 0.136 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171220 (cost=12.18..205.63 rows=106 width=52) (actual time=0.409..0.409 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
548. 0.134 0.134 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171220_pkey (cost=0.00..12.13 rows=181 width=0) (actual time=0.402..0.402 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
549. 0.001 0.149 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171229 (cost=11.99..187.03 rows=96 width=52) (actual time=0.448..0.448 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
550. 0.149 0.149 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20171229_pkey (cost=0.00..11.95 rows=163 width=0) (actual time=0.446..0.446 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
551. 0.001 0.127 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170523 (cost=11.57..361.25 rows=198 width=52) (actual time=0.382..0.382 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
552. 0.127 0.127 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20170523_pkey (cost=0.00..11.49 rows=336 width=0) (actual time=0.380..0.380 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
553. 0.002 0.010 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200729 (cost=1.29..4.47 rows=2 width=52) (actual time=0.031..0.031 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
554. 0.009 0.009 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20200729_pkey (cost=0.00..1.29 rows=3 width=0) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
555. 0.001 0.011 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200730 (cost=1.29..4.47 rows=2 width=52) (actual time=0.032..0.032 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
556. 0.010 0.010 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20200730_pkey (cost=0.00..1.29 rows=3 width=0) (actual time=0.030..0.030 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
557. 0.001 0.008 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200731 (cost=1.29..4.47 rows=2 width=52) (actual time=0.024..0.024 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
558. 0.007 0.007 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20200731_pkey (cost=0.00..1.29 rows=3 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
559. 0.001 0.007 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200801 (cost=1.29..4.47 rows=2 width=52) (actual time=0.022..0.022 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
560. 0.007 0.007 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20200801_pkey (cost=0.00..1.29 rows=3 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
561. 0.001 0.008 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200802 (cost=1.29..4.47 rows=2 width=52) (actual time=0.024..0.024 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
562. 0.007 0.007 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20200802_pkey (cost=0.00..1.29 rows=3 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
563. 0.001 0.009 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200803 (cost=1.29..4.47 rows=2 width=52) (actual time=0.026..0.026 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
564. 0.008 0.008 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20200803_pkey (cost=0.00..1.29 rows=3 width=0) (actual time=0.024..0.024 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
565. 0.000 0.011 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200804 (cost=1.29..4.47 rows=2 width=52) (actual time=0.032..0.032 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
566. 0.010 0.010 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20200804_pkey (cost=0.00..1.29 rows=3 width=0) (actual time=0.031..0.031 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
567. 0.001 0.010 ↓ 0.0 0 1 / 3

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200805 (cost=1.29..4.47 rows=2 width=52) (actual time=0.031..0.031 rows=0 loops=1)

  • Recheck Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
568. 0.009 0.009 ↓ 0.0 0 1 / 3

Bitmap Index Scan on aggregated_compact_placements_20200805_pkey (cost=0.00..1.29 rows=3 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
569. 0.160 0.160 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200524_pkey on aggregated_compact_placements_20200524 (cost=0.44..2.65 rows=1 width=21) (actual time=0.479..0.479 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
570. 0.164 0.164 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200525_pkey on aggregated_compact_placements_20200525 (cost=0.44..2.65 rows=1 width=21) (actual time=0.493..0.493 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
571. 0.145 0.145 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200526_pkey on aggregated_compact_placements_20200526 (cost=0.44..2.65 rows=1 width=21) (actual time=0.435..0.435 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
572. 0.129 0.129 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200527_pkey on aggregated_compact_placements_20200527 (cost=0.44..2.65 rows=1 width=20) (actual time=0.386..0.386 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
573. 0.123 0.123 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200528_pkey on aggregated_compact_placements_20200528 (cost=0.44..2.65 rows=1 width=20) (actual time=0.368..0.368 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
574. 0.141 0.141 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200529_pkey on aggregated_compact_placements_20200529 (cost=0.44..2.65 rows=1 width=21) (actual time=0.423..0.423 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
575. 0.076 0.076 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200530_pkey on aggregated_compact_placements_20200530 (cost=0.44..2.65 rows=1 width=21) (actual time=0.228..0.228 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
576. 0.105 0.105 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200531_pkey on aggregated_compact_placements_20200531 (cost=0.44..2.65 rows=1 width=21) (actual time=0.316..0.316 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
577. 0.169 0.169 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200601_pkey on aggregated_compact_placements_20200601 (cost=0.44..2.65 rows=1 width=21) (actual time=0.507..0.507 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
578. 0.112 0.112 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200602_pkey on aggregated_compact_placements_20200602 (cost=0.44..2.65 rows=1 width=21) (actual time=0.336..0.336 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
579. 0.106 0.106 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200603_pkey on aggregated_compact_placements_20200603 (cost=0.44..2.65 rows=1 width=20) (actual time=0.317..0.317 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
580. 0.130 0.130 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200604_pkey on aggregated_compact_placements_20200604 (cost=0.44..2.65 rows=1 width=21) (actual time=0.391..0.391 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
581. 0.133 0.133 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200605_pkey on aggregated_compact_placements_20200605 (cost=0.44..2.65 rows=1 width=21) (actual time=0.400..0.400 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
582. 0.146 0.146 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200606_pkey on aggregated_compact_placements_20200606 (cost=0.44..2.65 rows=1 width=20) (actual time=0.439..0.439 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
583. 0.140 0.140 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200607_pkey on aggregated_compact_placements_20200607 (cost=0.44..2.65 rows=1 width=21) (actual time=0.419..0.419 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
584. 0.130 0.130 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200608_pkey on aggregated_compact_placements_20200608 (cost=0.44..2.65 rows=1 width=21) (actual time=0.391..0.391 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
585. 0.142 0.142 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200609_pkey on aggregated_compact_placements_20200609 (cost=0.44..2.65 rows=1 width=21) (actual time=0.427..0.427 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
586. 0.124 0.124 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200610_pkey on aggregated_compact_placements_20200610 (cost=0.44..2.65 rows=1 width=20) (actual time=0.371..0.371 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
587. 0.116 0.116 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200611_pkey on aggregated_compact_placements_20200611 (cost=0.44..2.65 rows=1 width=21) (actual time=0.349..0.349 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
588. 0.121 0.121 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200612_pkey on aggregated_compact_placements_20200612 (cost=0.44..2.65 rows=1 width=21) (actual time=0.362..0.362 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
589. 0.119 0.119 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200613_pkey on aggregated_compact_placements_20200613 (cost=0.44..2.65 rows=1 width=20) (actual time=0.357..0.357 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
590. 0.125 0.125 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200614_pkey on aggregated_compact_placements_20200614 (cost=0.44..2.65 rows=1 width=21) (actual time=0.375..0.375 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
591. 0.096 0.096 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200615_pkey on aggregated_compact_placements_20200615 (cost=0.44..2.65 rows=1 width=21) (actual time=0.289..0.289 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
592. 0.139 0.139 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200616_pkey on aggregated_compact_placements_20200616 (cost=0.44..2.65 rows=1 width=20) (actual time=0.417..0.417 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
593. 0.107 0.107 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200617_pkey on aggregated_compact_placements_20200617 (cost=0.44..2.65 rows=1 width=20) (actual time=0.321..0.321 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
594. 0.111 0.111 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200618_pkey on aggregated_compact_placements_20200618 (cost=0.44..2.65 rows=1 width=20) (actual time=0.334..0.334 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
595. 0.146 0.146 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200619_pkey on aggregated_compact_placements_20200619 (cost=0.44..2.65 rows=1 width=20) (actual time=0.438..0.438 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
596. 0.111 0.111 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200620_pkey on aggregated_compact_placements_20200620 (cost=0.44..2.65 rows=1 width=20) (actual time=0.333..0.333 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
597. 0.124 0.124 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200621_pkey on aggregated_compact_placements_20200621 (cost=0.44..2.65 rows=1 width=20) (actual time=0.371..0.371 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
598. 0.453 0.453 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200622_pkey on aggregated_compact_placements_20200622 (cost=0.44..2.65 rows=1 width=20) (actual time=1.360..1.360 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
599. 0.175 0.175 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200623_pkey on aggregated_compact_placements_20200623 (cost=0.44..2.65 rows=1 width=20) (actual time=0.525..0.525 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
600. 0.136 0.136 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200624_pkey on aggregated_compact_placements_20200624 (cost=0.44..2.65 rows=1 width=20) (actual time=0.407..0.407 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
601. 0.118 0.118 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200625_pkey on aggregated_compact_placements_20200625 (cost=0.44..2.65 rows=1 width=20) (actual time=0.354..0.354 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
602. 0.110 0.110 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200626_pkey on aggregated_compact_placements_20200626 (cost=0.44..2.65 rows=1 width=20) (actual time=0.331..0.331 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
603. 0.124 0.124 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200627_pkey on aggregated_compact_placements_20200627 (cost=0.44..2.65 rows=1 width=20) (actual time=0.372..0.372 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
604. 0.099 0.099 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200628_pkey on aggregated_compact_placements_20200628 (cost=0.44..2.65 rows=1 width=20) (actual time=0.298..0.298 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
605. 0.166 0.166 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200629_pkey on aggregated_compact_placements_20200629 (cost=0.44..2.65 rows=1 width=20) (actual time=0.499..0.499 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
606. 0.131 0.131 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200630_pkey on aggregated_compact_placements_20200630 (cost=0.44..2.65 rows=1 width=20) (actual time=0.394..0.394 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
607. 0.142 0.142 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200701_pkey on aggregated_compact_placements_20200701 (cost=0.44..2.65 rows=1 width=20) (actual time=0.427..0.427 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
608. 0.123 0.123 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200702_pkey on aggregated_compact_placements_20200702 (cost=0.44..2.65 rows=1 width=20) (actual time=0.369..0.369 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
609. 0.112 0.112 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200703_pkey on aggregated_compact_placements_20200703 (cost=0.44..2.65 rows=1 width=20) (actual time=0.337..0.337 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
610. 0.148 0.148 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200704_pkey on aggregated_compact_placements_20200704 (cost=0.44..2.65 rows=1 width=20) (actual time=0.445..0.445 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
611. 0.109 0.109 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200705_pkey on aggregated_compact_placements_20200705 (cost=0.44..2.65 rows=1 width=20) (actual time=0.326..0.326 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
612. 0.083 0.083 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200706_pkey on aggregated_compact_placements_20200706 (cost=0.44..2.65 rows=1 width=20) (actual time=0.249..0.249 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
613. 0.198 0.198 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200707_pkey on aggregated_compact_placements_20200707 (cost=0.44..2.65 rows=1 width=20) (actual time=0.593..0.593 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
614. 0.121 0.121 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200708_pkey on aggregated_compact_placements_20200708 (cost=0.44..2.65 rows=1 width=20) (actual time=0.363..0.363 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
615. 0.151 0.151 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200709_pkey on aggregated_compact_placements_20200709 (cost=0.44..2.65 rows=1 width=20) (actual time=0.452..0.452 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
616. 0.102 0.102 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200710_pkey on aggregated_compact_placements_20200710 (cost=0.44..2.65 rows=1 width=20) (actual time=0.306..0.306 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
617. 0.135 0.135 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200711_pkey on aggregated_compact_placements_20200711 (cost=0.44..2.65 rows=1 width=20) (actual time=0.405..0.405 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
618. 0.132 0.132 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200712_pkey on aggregated_compact_placements_20200712 (cost=0.44..2.65 rows=1 width=20) (actual time=0.395..0.395 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
619. 0.170 0.170 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200713_pkey on aggregated_compact_placements_20200713 (cost=0.44..2.65 rows=1 width=20) (actual time=0.509..0.509 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
620. 0.024 0.024 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20200728_pkey on aggregated_compact_placements_20200728 (cost=0.44..2.65 rows=1 width=20) (actual time=0.073..0.073 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
621. 0.061 0.061 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191104_pkey on aggregated_compact_placements_20191104 (cost=0.43..2.65 rows=1 width=21) (actual time=0.184..0.184 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
622. 0.122 0.122 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191105_pkey on aggregated_compact_placements_20191105 (cost=0.43..2.65 rows=1 width=21) (actual time=0.367..0.367 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
623. 0.113 0.113 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191106_pkey on aggregated_compact_placements_20191106 (cost=0.43..2.65 rows=1 width=22) (actual time=0.339..0.339 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
624. 0.116 0.116 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191107_pkey on aggregated_compact_placements_20191107 (cost=0.43..2.65 rows=1 width=21) (actual time=0.349..0.349 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
625. 0.063 0.063 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191108_pkey on aggregated_compact_placements_20191108 (cost=0.43..2.65 rows=1 width=21) (actual time=0.190..0.190 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
626. 0.056 0.056 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191109_pkey on aggregated_compact_placements_20191109 (cost=0.43..2.65 rows=1 width=21) (actual time=0.167..0.167 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
627. 0.139 0.139 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191110_pkey on aggregated_compact_placements_20191110 (cost=0.43..2.65 rows=1 width=21) (actual time=0.417..0.417 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
628. 0.123 0.123 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191111_pkey on aggregated_compact_placements_20191111 (cost=0.43..2.65 rows=1 width=22) (actual time=0.369..0.369 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
629. 0.150 0.150 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191112_pkey on aggregated_compact_placements_20191112 (cost=0.43..2.65 rows=1 width=21) (actual time=0.450..0.450 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
630. 0.105 0.105 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191113_pkey on aggregated_compact_placements_20191113 (cost=0.43..2.65 rows=1 width=21) (actual time=0.315..0.315 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
631. 0.133 0.133 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191114_pkey on aggregated_compact_placements_20191114 (cost=0.43..2.65 rows=1 width=22) (actual time=0.399..0.400 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
632. 0.133 0.133 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191115_pkey on aggregated_compact_placements_20191115 (cost=0.43..2.65 rows=1 width=22) (actual time=0.398..0.398 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
633. 0.121 0.121 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191116_pkey on aggregated_compact_placements_20191116 (cost=0.43..2.65 rows=1 width=22) (actual time=0.364..0.364 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
634. 0.194 0.194 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191117_pkey on aggregated_compact_placements_20191117 (cost=0.43..2.65 rows=1 width=22) (actual time=0.581..0.581 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
635. 0.133 0.133 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191118_pkey on aggregated_compact_placements_20191118 (cost=0.43..2.65 rows=1 width=22) (actual time=0.399..0.399 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
636. 0.146 0.146 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191119_pkey on aggregated_compact_placements_20191119 (cost=0.43..2.65 rows=1 width=21) (actual time=0.439..0.439 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
637. 0.129 0.129 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191120_pkey on aggregated_compact_placements_20191120 (cost=0.43..2.65 rows=1 width=21) (actual time=0.387..0.387 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
638. 0.164 0.164 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191121_pkey on aggregated_compact_placements_20191121 (cost=0.43..2.65 rows=1 width=22) (actual time=0.491..0.491 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
639. 0.164 0.164 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191122_pkey on aggregated_compact_placements_20191122 (cost=0.43..2.65 rows=1 width=21) (actual time=0.491..0.491 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
640. 0.129 0.129 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191123_pkey on aggregated_compact_placements_20191123 (cost=0.43..2.65 rows=1 width=22) (actual time=0.387..0.387 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
641. 0.175 0.175 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191124_pkey on aggregated_compact_placements_20191124 (cost=0.43..2.65 rows=1 width=22) (actual time=0.526..0.526 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
642. 0.121 0.121 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191125_pkey on aggregated_compact_placements_20191125 (cost=0.43..2.65 rows=1 width=22) (actual time=0.364..0.364 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
643. 0.144 0.144 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191126_pkey on aggregated_compact_placements_20191126 (cost=0.43..2.65 rows=1 width=22) (actual time=0.432..0.432 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
644. 0.049 0.049 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191127_pkey on aggregated_compact_placements_20191127 (cost=0.43..2.65 rows=1 width=22) (actual time=0.148..0.148 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
645. 1.280 1.280 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191128_pkey on aggregated_compact_placements_20191128 (cost=0.43..2.65 rows=1 width=22) (actual time=3.839..3.839 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
646. 0.115 0.115 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191129_pkey on aggregated_compact_placements_20191129 (cost=0.43..2.65 rows=1 width=22) (actual time=0.345..0.345 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
647. 0.119 0.119 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191130_pkey on aggregated_compact_placements_20191130 (cost=0.43..2.65 rows=1 width=22) (actual time=0.356..0.356 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
648. 0.112 0.112 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191201_pkey on aggregated_compact_placements_20191201 (cost=0.43..2.65 rows=1 width=22) (actual time=0.335..0.335 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
649. 0.130 0.130 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191202_pkey on aggregated_compact_placements_20191202 (cost=0.43..2.65 rows=1 width=21) (actual time=0.391..0.391 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
650. 0.159 0.159 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191203_pkey on aggregated_compact_placements_20191203 (cost=0.43..2.65 rows=1 width=21) (actual time=0.478..0.478 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
651. 0.103 0.103 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191204_pkey on aggregated_compact_placements_20191204 (cost=0.43..2.65 rows=1 width=22) (actual time=0.308..0.308 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
652. 0.125 0.125 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191205_pkey on aggregated_compact_placements_20191205 (cost=0.43..2.65 rows=1 width=22) (actual time=0.376..0.376 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
653. 0.106 0.106 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191206_pkey on aggregated_compact_placements_20191206 (cost=0.43..2.65 rows=1 width=22) (actual time=0.318..0.318 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
654. 0.101 0.101 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191207_pkey on aggregated_compact_placements_20191207 (cost=0.43..2.65 rows=1 width=22) (actual time=0.304..0.304 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
655. 0.141 0.141 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191208_pkey on aggregated_compact_placements_20191208 (cost=0.43..2.65 rows=1 width=22) (actual time=0.424..0.424 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
656. 0.131 0.131 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191209_pkey on aggregated_compact_placements_20191209 (cost=0.43..2.65 rows=1 width=22) (actual time=0.393..0.393 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
657. 0.171 0.171 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191210_pkey on aggregated_compact_placements_20191210 (cost=0.43..2.65 rows=1 width=22) (actual time=0.514..0.514 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
658. 0.127 0.127 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191211_pkey on aggregated_compact_placements_20191211 (cost=0.43..2.65 rows=1 width=22) (actual time=0.382..0.382 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
659. 0.143 0.143 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191212_pkey on aggregated_compact_placements_20191212 (cost=0.43..2.65 rows=1 width=21) (actual time=0.428..0.428 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
660. 0.142 0.142 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191213_pkey on aggregated_compact_placements_20191213 (cost=0.43..2.65 rows=1 width=22) (actual time=0.427..0.427 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
661. 0.140 0.140 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191214_pkey on aggregated_compact_placements_20191214 (cost=0.43..2.65 rows=1 width=22) (actual time=0.420..0.420 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
662. 0.106 0.106 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191215_pkey on aggregated_compact_placements_20191215 (cost=0.43..2.65 rows=1 width=22) (actual time=0.319..0.319 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
663. 0.158 0.158 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191216_pkey on aggregated_compact_placements_20191216 (cost=0.43..2.65 rows=1 width=22) (actual time=0.474..0.474 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
664. 0.097 0.097 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191217_pkey on aggregated_compact_placements_20191217 (cost=0.43..2.65 rows=1 width=22) (actual time=0.289..0.290 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
665. 0.132 0.132 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191218_pkey on aggregated_compact_placements_20191218 (cost=0.43..2.65 rows=1 width=22) (actual time=0.396..0.396 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))
666. 0.138 0.138 ↓ 0.0 0 1 / 3

Parallel Index Scan using aggregated_compact_placements_20191219_pkey on aggregated_compact_placements_20191219 (cost=0.43..2.65 rows=1 width=22) (actual time=0.414..0.414 rows=0 loops=1)

  • Index Cond: ((a_date >= (CURRENT_DATE - 14)) AND (a_date <= (CURRENT_DATE - 1)))