explain.depesz.com

PostgreSQL's explain analyze made readable

Result: px3L

Settings
# exclusive inclusive rows x rows loops node
1. 314.383 201,291.350 ↑ 1.2 2,318,957 1

Gather (cost=1,000.00..7,268,893.10 rows=2,708,042 width=55) (actual time=199,292.389..201,291.350 rows=2,318,957 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
  • Functions: 6,538
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 1093.909 ms, Inlining 133.110 ms, Optimization 43619.118 ms, Emission 49538.641 ms, Total 94384.778 ms
2. 116.109 200,976.967 ↓ 2.1 2,318,957 1

Parallel Append (cost=0.00..6,997,088.90 rows=1,129,306 width=55) (actual time=199,119.671..200,976.967 rows=2,318,957 loops=1)

3. 0.011 0.011 ↓ 0.0 0 1

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

  • Filter: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
4. 0.001 0.573 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20191101 (cost=55.44..3,033.14 rows=2,019 width=106) (actual time=0.573..0.573 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
5. 0.572 0.572 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
6. 0.005 0.343 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170719 (cost=30.82..1,687.19 rows=1,112 width=106) (actual time=0.343..0.343 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
7. 0.338 0.338 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170719_pkey (cost=0.00..30.35 rows=1,890 width=0) (actual time=0.338..0.338 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
8. 0.002 0.358 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170515 (cost=30.24..1,762.55 rows=1,205 width=106) (actual time=0.358..0.358 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
9. 0.356 0.356 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
10. 0.002 0.343 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170506 (cost=30.23..1,773.06 rows=1,204 width=106) (actual time=0.343..0.343 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
11. 0.341 0.341 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
12. 0.010 0.358 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171126 (cost=29.53..1,578.33 rows=1,038 width=106) (actual time=0.358..0.358 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
13. 0.348 0.348 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
14. 0.001 0.319 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180419 (cost=29.48..1,581.04 rows=1,035 width=106) (actual time=0.319..0.319 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
15. 0.318 0.318 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
16. 0.005 0.297 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171204 (cost=29.47..1,570.41 rows=1,034 width=106) (actual time=0.297..0.297 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
17. 0.292 0.292 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
18. 0.002 0.609 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180428 (cost=29.36..1,574.84 rows=1,028 width=106) (actual time=0.609..0.609 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
19. 0.607 0.607 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
20. 0.006 0.377 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170512 (cost=29.35..1,705.67 rows=1,154 width=106) (actual time=0.377..0.377 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
21. 0.371 0.371 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
22. 0.003 0.341 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170723 (cost=29.24..1,571.12 rows=1,021 width=106) (actual time=0.341..0.341 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
23. 0.338 0.338 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
24. 0.002 0.371 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180120 (cost=29.20..1,543.15 rows=1,019 width=106) (actual time=0.371..0.371 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
25. 0.369 0.369 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
26. 0.006 0.327 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180404 (cost=29.18..1,558.64 rows=1,018 width=106) (actual time=0.327..0.327 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
27. 0.321 0.321 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
28. 0.003 0.266 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180319 (cost=29.11..1,549.63 rows=1,014 width=106) (actual time=0.266..0.266 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
29. 0.263 0.263 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
30. 0.006 0.299 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171128 (cost=29.03..1,538.56 rows=1,009 width=106) (actual time=0.299..0.299 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
31. 0.293 0.293 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
32. 0.002 0.356 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180501 (cost=28.92..1,540.48 rows=1,003 width=106) (actual time=0.356..0.356 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
33. 0.354 0.354 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
34. 0.006 0.278 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180218 (cost=28.89..1,520.67 rows=1,001 width=106) (actual time=0.278..0.278 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
35. 0.272 0.272 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
36. 0.003 0.337 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180430 (cost=28.85..1,526.95 rows=999 width=106) (actual time=0.337..0.337 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
37. 0.334 0.334 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
38. 0.002 0.335 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180417 (cost=28.79..1,538.20 rows=995 width=106) (actual time=0.335..0.335 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
39. 0.333 0.333 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
40. 0.007 0.369 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180210 (cost=28.79..1,518.03 rows=995 width=106) (actual time=0.369..0.369 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
41. 0.362 0.362 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
42. 0.003 0.360 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180130 (cost=28.72..1,515.07 rows=991 width=106) (actual time=0.360..0.360 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
43. 0.357 0.357 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
44. 0.005 0.331 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180508 (cost=28.72..1,515.07 rows=991 width=106) (actual time=0.331..0.331 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
45. 0.326 0.326 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
46. 0.002 0.284 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170731 (cost=28.62..1,513.44 rows=985 width=106) (actual time=0.284..0.284 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
47. 0.282 0.282 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
48. 0.005 0.416 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170727 (cost=28.49..1,515.73 rows=978 width=106) (actual time=0.416..0.416 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
49. 0.411 0.411 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
50. 0.002 0.363 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180304 (cost=28.38..1,489.35 rows=972 width=106) (actual time=0.363..0.363 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
51. 0.361 0.361 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
52. 0.003 0.370 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180503 (cost=28.07..1,475.37 rows=954 width=106) (actual time=0.369..0.370 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
53. 0.367 0.367 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
54. 0.005 0.380 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170518 (cost=27.95..1,609.02 rows=1,074 width=106) (actual time=0.380..0.380 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
55. 0.375 0.375 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
56. 0.002 0.406 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170725 (cost=27.92..1,475.46 rows=945 width=106) (actual time=0.406..0.406 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
57. 0.404 0.404 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
58. 0.006 0.433 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180414 (cost=27.89..1,469.73 rows=944 width=106) (actual time=0.433..0.433 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
59. 0.427 0.427 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
60. 0.002 0.315 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170514 (cost=27.81..1,604.15 rows=1,065 width=106) (actual time=0.315..0.315 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
61. 0.313 0.313 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
62. 0.011 0.393 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170803 (cost=27.76..1,509.38 rows=999 width=106) (actual time=0.393..0.393 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
63. 0.382 0.382 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
64. 0.002 0.372 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170716 (cost=27.71..1,460.62 rows=934 width=106) (actual time=0.372..0.372 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
65. 0.370 0.370 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
66. 0.002 0.303 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171213 (cost=27.64..1,505.56 rows=992 width=106) (actual time=0.303..0.303 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
67. 0.301 0.301 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
68. 0.005 0.364 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180223 (cost=27.64..1,499.59 rows=992 width=106) (actual time=0.364..0.364 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
69. 0.359 0.359 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
70. 0.003 0.354 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180505 (cost=27.58..1,435.58 rows=926 width=106) (actual time=0.354..0.354 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
71. 0.351 0.351 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
72. 0.005 0.371 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170624 (cost=27.58..1,497.69 rows=989 width=106) (actual time=0.371..0.371 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
73. 0.366 0.366 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
74. 0.003 0.375 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180215 (cost=27.58..1,497.69 rows=989 width=106) (actual time=0.375..0.375 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
75. 0.372 0.372 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
76. 0.003 0.338 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180409 (cost=27.41..1,429.96 rows=916 width=106) (actual time=0.338..0.338 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
77. 0.335 0.335 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
78. 0.007 0.354 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180208 (cost=27.09..1,474.48 rows=961 width=106) (actual time=0.354..0.354 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
79. 0.347 0.347 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
80. 0.003 0.411 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180418 (cost=27.08..1,413.83 rows=897 width=106) (actual time=0.411..0.411 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
81. 0.408 0.408 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
82. 0.005 0.302 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170630 (cost=26.94..1,461.52 rows=952 width=106) (actual time=0.302..0.302 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
83. 0.297 0.297 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
84. 0.002 0.314 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180327 (cost=26.89..1,393.99 rows=886 width=106) (actual time=0.314..0.314 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
85. 0.312 0.312 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
86. 0.006 0.408 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180412 (cost=26.82..1,391.04 rows=882 width=106) (actual time=0.408..0.408 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
87. 0.402 0.402 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
88. 0.002 0.364 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180411 (cost=26.72..1,384.86 rows=876 width=106) (actual time=0.364..0.364 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
89. 0.362 0.362 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
90. 0.003 0.578 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170828 (cost=26.72..1,442.02 rows=939 width=106) (actual time=0.578..0.578 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
91. 0.575 0.575 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
92. 0.005 0.321 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170608 (cost=26.65..1,569.66 rows=1,062 width=106) (actual time=0.321..0.321 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
93. 0.316 0.316 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
94. 0.003 0.306 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180312 (cost=26.45..1,351.41 rows=861 width=106) (actual time=0.306..0.306 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
95. 0.303 0.303 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
96. 0.005 0.390 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170713 (cost=26.33..1,352.64 rows=854 width=106) (actual time=0.390..0.390 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
97. 0.385 0.385 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
98. 0.002 0.332 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170809 (cost=26.29..1,411.16 rows=915 width=106) (actual time=0.332..0.332 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
99. 0.330 0.330 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
100. 0.006 0.313 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170703 (cost=26.23..1,412.80 rows=912 width=106) (actual time=0.313..0.313 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
101. 0.307 0.307 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
102. 0.002 0.353 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170611 (cost=26.20..1,388.18 rows=910 width=106) (actual time=0.353..0.353 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
103. 0.351 0.351 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
104. 0.002 0.331 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180401 (cost=26.16..1,333.88 rows=844 width=106) (actual time=0.331..0.331 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
105. 0.329 0.329 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
106. 0.007 0.373 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170810 (cost=26.03..1,394.42 rows=900 width=106) (actual time=0.372..0.373 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
107. 0.366 0.366 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
108. 0.002 0.360 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180216 (cost=26.02..1,383.88 rows=899 width=106) (actual time=0.360..0.360 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
109. 0.358 0.358 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
110. 0.006 0.349 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170817 (cost=25.99..1,391.15 rows=898 width=106) (actual time=0.349..0.349 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
111. 0.343 0.343 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
112. 0.002 0.356 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170708 (cost=25.98..1,324.70 rows=834 width=106) (actual time=0.356..0.356 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
113. 0.354 0.354 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
114. 0.010 0.663 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170919 (cost=25.88..1,371.91 rows=891 width=106) (actual time=0.663..0.663 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
115. 0.653 0.653 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
116. 0.002 0.397 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170728 (cost=25.80..1,310.90 rows=824 width=106) (actual time=0.397..0.397 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
117. 0.395 0.395 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
118. 0.002 0.400 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170730 (cost=25.80..1,310.90 rows=824 width=106) (actual time=0.400..0.400 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
119. 0.398 0.398 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
120. 0.006 0.391 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170509 (cost=25.77..1,460.96 rows=948 width=106) (actual time=0.391..0.391 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
121. 0.385 0.385 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
122. 0.003 0.416 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180101 (cost=25.72..1,351.95 rows=882 width=106) (actual time=0.416..0.416 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
123. 0.413 0.413 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
124. 0.007 0.315 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170721 (cost=25.71..1,308.28 rows=818 width=106) (actual time=0.315..0.315 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
125. 0.308 0.308 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
126. 0.002 0.488 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171226 (cost=25.70..1,365.19 rows=881 width=106) (actual time=0.488..0.488 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
127. 0.486 0.486 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
128. 0.009 0.457 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170707 (cost=25.68..1,301.11 rows=817 width=106) (actual time=0.457..0.457 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
129. 0.448 0.448 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
130. 0.004 0.417 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180507 (cost=25.68..1,301.11 rows=817 width=106) (actual time=0.417..0.417 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
131. 0.413 0.413 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
132. 0.002 0.345 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170621 (cost=25.66..1,358.42 rows=879 width=106) (actual time=0.345..0.345 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
133. 0.343 0.343 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
134. 0.005 0.292 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170724 (cost=25.51..1,294.42 rows=807 width=106) (actual time=0.292..0.292 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
135. 0.287 0.287 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
136. 0.002 0.358 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170609 (cost=25.49..1,337.31 rows=869 width=106) (actual time=0.358..0.358 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
137. 0.356 0.356 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
138. 0.006 0.364 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171224 (cost=25.38..1,325.16 rows=863 width=106) (actual time=0.364..0.364 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
139. 0.358 0.358 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
140. 0.001 0.304 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180118 (cost=25.36..1,264.74 rows=798 width=106) (actual time=0.304..0.304 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
141. 0.303 0.303 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
142. 0.005 0.340 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180416 (cost=25.31..1,274.92 rows=795 width=106) (actual time=0.340..0.340 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
143. 0.335 0.335 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
144. 0.002 0.307 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170819 (cost=25.14..1,328.33 rows=849 width=106) (actual time=0.307..0.307 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
145. 0.305 0.305 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
146. 0.002 0.341 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170628 (cost=25.10..1,330.04 rows=846 width=106) (actual time=0.341..0.341 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
147. 0.339 0.339 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
148. 0.005 0.317 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180204 (cost=24.79..1,231.72 rows=766 width=106) (actual time=0.317..0.317 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
149. 0.312 0.312 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
150. 0.002 0.318 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170709 (cost=24.74..1,229.85 rows=763 width=106) (actual time=0.318..0.318 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
151. 0.316 0.316 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
152. 0.005 0.353 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180222 (cost=24.74..1,295.05 rows=826 width=106) (actual time=0.353..0.353 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
153. 0.348 0.348 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
154. 0.002 0.278 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180325 (cost=24.71..1,226.62 rows=761 width=106) (actual time=0.278..0.278 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
155. 0.276 0.276 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
156. 0.007 0.403 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170521 (cost=24.68..1,381.17 rows=886 width=106) (actual time=0.403..0.403 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
157. 0.396 0.396 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
158. 0.002 0.347 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180317 (cost=24.65..1,224.71 rows=758 width=106) (actual time=0.347..0.347 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
159. 0.345 0.345 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
160. 0.002 0.298 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170816 (cost=24.59..1,207.23 rows=754 width=106) (actual time=0.298..0.298 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
161. 0.296 0.296 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
162. 0.006 0.323 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170920 (cost=24.54..1,269.30 rows=815 width=106) (actual time=0.323..0.323 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
163. 0.317 0.317 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
164. 0.002 0.399 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170701 (cost=24.49..1,281.80 rows=812 width=106) (actual time=0.399..0.399 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
165. 0.397 0.397 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
166. 0.010 0.387 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180122 (cost=24.47..1,280.67 rows=811 width=106) (actual time=0.387..0.387 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
167. 0.377 0.377 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
168. 0.003 0.353 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180126 (cost=24.37..1,193.67 rows=742 width=106) (actual time=0.353..0.353 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
169. 0.350 0.350 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
170. 0.005 0.369 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170513 (cost=24.36..1,357.93 rows=867 width=106) (actual time=0.369..0.369 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
171. 0.364 0.364 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
172. 0.004 0.328 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180206 (cost=24.34..1,190.43 rows=740 width=106) (actual time=0.328..0.328 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
173. 0.324 0.324 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
174. 0.002 0.342 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180322 (cost=24.31..1,190.71 rows=738 width=106) (actual time=0.342..0.342 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
175. 0.340 0.340 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
176. 0.010 0.276 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170602 (cost=24.30..1,253.55 rows=801 width=106) (actual time=0.276..0.276 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
177. 0.266 0.266 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
178. 0.002 0.334 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171222 (cost=24.26..1,252.73 rows=798 width=106) (actual time=0.334..0.334 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
179. 0.332 0.332 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
180. 0.005 0.309 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180410 (cost=24.20..1,191.93 rows=732 width=106) (actual time=0.309..0.309 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
181. 0.304 0.304 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
182. 0.003 0.344 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170923 (cost=24.16..1,246.54 rows=793 width=106) (actual time=0.344..0.344 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
183. 0.341 0.341 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
184. 0.003 0.324 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180309 (cost=24.03..1,164.67 rows=722 width=106) (actual time=0.324..0.324 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
185. 0.321 0.321 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
186. 0.005 0.301 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170522 (cost=23.95..1,318.59 rows=844 width=106) (actual time=0.301..0.301 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
187. 0.296 0.296 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
188. 0.002 0.336 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170530 (cost=23.91..1,384.33 rows=905 width=106) (actual time=0.336..0.336 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
189. 0.334 0.334 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
190. 0.005 0.405 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170807 (cost=23.77..1,226.22 rows=771 width=106) (actual time=0.405..0.405 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
191. 0.400 0.400 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
192. 0.002 0.358 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171205 (cost=23.73..1,148.47 rows=705 width=106) (actual time=0.358..0.358 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
193. 0.356 0.356 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
194. 0.005 0.293 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171214 (cost=23.67..1,214.00 rows=765 width=106) (actual time=0.293..0.293 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
195. 0.288 0.288 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
196. 0.002 0.384 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170505 (cost=23.64..1,305.95 rows=826 width=106) (actual time=0.383..0.384 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
197. 0.382 0.382 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
198. 0.002 0.358 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170606 (cost=23.59..1,201.48 rows=760 width=106) (actual time=0.358..0.358 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
199. 0.356 0.356 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
200. 0.005 0.364 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180403 (cost=23.46..1,125.89 rows=689 width=106) (actual time=0.364..0.364 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
201. 0.359 0.359 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
202. 0.002 0.536 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170916 (cost=23.42..1,188.78 rows=751 width=106) (actual time=0.536..0.536 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
203. 0.534 0.534 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
204. 0.005 0.382 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170822 (cost=23.35..1,194.18 rows=746 width=106) (actual time=0.382..0.382 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
205. 0.377 0.377 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
206. 0.002 0.324 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180221 (cost=23.21..1,181.15 rows=738 width=106) (actual time=0.324..0.324 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
207. 0.322 0.322 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
208. 0.005 0.450 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170525 (cost=23.13..1,330.50 rows=860 width=106) (actual time=0.450..0.450 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
209. 0.445 0.445 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
210. 0.002 1.374 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170519 (cost=23.05..1,256.32 rows=792 width=106) (actual time=1.374..1.374 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
211. 1.372 1.372 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
212. 0.002 0.374 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180303 (cost=22.99..1,170.04 rows=726 width=106) (actual time=0.374..0.374 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
213. 0.372 0.372 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
214. 0.005 0.266 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170610 (cost=22.99..1,153.20 rows=726 width=106) (actual time=0.266..0.266 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
215. 0.261 0.261 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
216. 0.006 0.383 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180307 (cost=22.98..1,081.26 rows=662 width=106) (actual time=0.383..0.383 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
217. 0.377 0.377 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
218. 0.005 0.285 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171231 (cost=22.96..1,147.53 rows=724 width=106) (actual time=0.285..0.285 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
219. 0.280 0.280 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
220. 0.002 0.353 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171209 (cost=22.85..1,145.08 rows=718 width=106) (actual time=0.353..0.353 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
221. 0.351 0.351 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
222. 0.005 0.354 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170520 (cost=22.84..1,240.28 rows=780 width=106) (actual time=0.354..0.354 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
223. 0.349 0.349 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
224. 0.001 0.356 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180421 (cost=22.83..1,078.12 rows=654 width=106) (actual time=0.356..0.356 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
225. 0.355 0.355 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
226. 0.002 0.405 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180427 (cost=22.80..1,075.91 rows=652 width=106) (actual time=0.405..0.405 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
227. 0.403 0.403 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
228. 0.005 0.333 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180313 (cost=22.70..1,147.82 rows=709 width=106) (actual time=0.333..0.333 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
229. 0.328 0.328 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
230. 0.002 0.358 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170613 (cost=22.54..1,117.88 rows=700 width=106) (actual time=0.358..0.358 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
231. 0.356 0.356 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
232. 0.005 0.320 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170818 (cost=22.49..1,126.85 rows=697 width=106) (actual time=0.320..0.320 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
233. 0.315 0.315 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
234. 0.002 0.399 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180107 (cost=22.47..1,118.73 rows=696 width=106) (actual time=0.399..0.399 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
235. 0.397 0.397 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
236. 0.005 0.352 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170917 (cost=22.37..1,107.54 rows=690 width=106) (actual time=0.352..0.352 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
237. 0.347 0.347 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
238. 0.002 0.310 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180502 (cost=22.35..1,038.39 rows=626 width=106) (actual time=0.310..0.310 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
239. 0.308 0.308 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
240. 0.002 0.363 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180318 (cost=22.26..1,034.66 rows=621 width=106) (actual time=0.363..0.363 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
241. 0.361 0.361 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
242. 0.009 0.397 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180423 (cost=22.26..1,032.16 rows=621 width=106) (actual time=0.397..0.397 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
243. 0.388 0.388 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
244. 0.002 0.340 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170601 (cost=22.21..1,261.13 rows=807 width=106) (actual time=0.340..0.340 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
245. 0.338 0.338 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
246. 0.005 0.394 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180323 (cost=22.20..1,026.69 rows=617 width=106) (actual time=0.394..0.394 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
247. 0.389 0.389 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
248. 0.002 0.358 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180211 (cost=22.19..1,107.07 rows=680 width=106) (actual time=0.358..0.358 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
249. 0.356 0.356 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
250. 0.005 0.367 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180214 (cost=21.90..1,079.85 rows=663 width=106) (actual time=0.367..0.367 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
251. 0.362 0.362 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
252. 0.002 0.348 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180201 (cost=21.89..997.27 rows=599 width=106) (actual time=0.348..0.348 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
253. 0.346 0.346 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
254. 0.001 0.304 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170710 (cost=21.88..1,001.16 rows=599 width=106) (actual time=0.304..0.304 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
255. 0.303 0.303 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
256. 0.005 0.247 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180128 (cost=21.83..991.80 rows=596 width=106) (actual time=0.247..0.247 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
257. 0.242 0.242 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
258. 0.001 0.327 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171221 (cost=21.68..1,135.01 rows=714 width=106) (actual time=0.327..0.327 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
259. 0.326 0.326 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
260. 0.006 0.284 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170921 (cost=21.44..1,033.94 rows=636 width=106) (actual time=0.284..0.284 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
261. 0.278 0.278 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
262. 0.002 0.333 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170808 (cost=21.41..953.95 rows=572 width=106) (actual time=0.333..0.333 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
263. 0.331 0.331 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170808_pkey (cost=0.00..21.17 rows=972 width=0) (actual time=0.331..0.331 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
264. 0.005 0.312 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180315 (cost=21.37..955.59 rows=569 width=106) (actual time=0.312..0.312 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
265. 0.307 0.307 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
266. 0.001 0.359 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170802 (cost=21.37..953.11 rows=569 width=106) (actual time=0.359..0.359 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
267. 0.358 0.358 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
268. 0.006 0.316 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170720 (cost=21.35..958.37 rows=568 width=106) (actual time=0.316..0.316 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
269. 0.310 0.310 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
270. 0.009 0.290 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180117 (cost=21.34..1,036.08 rows=631 width=106) (actual time=0.290..0.290 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
271. 0.281 0.281 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
272. 0.002 0.416 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180127 (cost=21.27..946.84 rows=564 width=106) (actual time=0.416..0.416 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
273. 0.414 0.414 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
274. 0.005 0.330 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170503 (cost=21.23..1,117.96 rows=688 width=106) (actual time=0.330..0.330 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
275. 0.325 0.325 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
276. 0.002 0.346 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170508 (cost=21.15..1,112.83 rows=683 width=106) (actual time=0.346..0.346 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
277. 0.344 0.344 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
278. 0.002 0.404 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171127 (cost=21.13..932.69 rows=556 width=106) (actual time=0.404..0.404 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
279. 0.402 0.402 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
280. 0.005 0.356 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170714 (cost=21.12..939.04 rows=555 width=106) (actual time=0.356..0.356 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
281. 0.351 0.351 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
282. 0.002 0.389 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180506 (cost=21.09..935.79 rows=554 width=106) (actual time=0.388..0.389 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
283. 0.387 0.387 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
284. 0.005 0.316 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171210 (cost=21.07..927.20 rows=552 width=106) (actual time=0.316..0.316 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
285. 0.311 0.311 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
286. 0.002 0.376 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171217 (cost=21.05..1,010.28 rows=614 width=106) (actual time=0.376..0.376 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
287. 0.374 0.374 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
288. 0.004 0.318 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170517 (cost=20.95..1,095.39 rows=672 width=106) (actual time=0.318..0.318 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
289. 0.314 0.314 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
290. 0.002 0.296 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170614 (cost=20.91..988.48 rows=606 width=106) (actual time=0.296..0.296 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
291. 0.294 0.294 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
292. 0.003 0.369 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170615 (cost=20.81..981.14 rows=601 width=106) (actual time=0.369..0.369 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
293. 0.366 0.366 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
294. 0.004 0.329 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180109 (cost=20.78..985.21 rows=599 width=106) (actual time=0.329..0.329 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
295. 0.325 0.325 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
296. 0.002 0.380 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171202 (cost=20.77..905.19 rows=535 width=106) (actual time=0.380..0.380 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
297. 0.378 0.378 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
298. 0.005 0.351 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170524 (cost=20.74..1,072.27 rows=659 width=106) (actual time=0.351..0.351 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
299. 0.346 0.346 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
300. 0.002 0.391 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180331 (cost=20.65..895.65 rows=528 width=106) (actual time=0.391..0.391 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
301. 0.389 0.389 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
302. 0.005 0.344 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180213 (cost=20.63..978.42 rows=590 width=106) (actual time=0.344..0.344 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
303. 0.339 0.339 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
304. 0.001 0.331 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170511 (cost=20.61..1,068.79 rows=652 width=106) (actual time=0.331..0.331 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
305. 0.330 0.330 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
306. 0.002 0.277 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170627 (cost=20.58..977.59 rows=588 width=106) (actual time=0.277..0.277 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
307. 0.275 0.275 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
308. 0.005 0.291 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180217 (cost=20.55..971.87 rows=586 width=106) (actual time=0.291..0.291 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
309. 0.286 0.286 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
310. 0.002 0.349 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171130 (cost=20.52..971.08 rows=584 width=106) (actual time=0.349..0.349 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
311. 0.347 0.347 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
312. 0.005 0.344 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170604 (cost=20.51..961.21 rows=584 width=106) (actual time=0.344..0.344 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
313. 0.339 0.339 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
314. 0.002 0.261 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180203 (cost=20.41..876.22 rows=515 width=106) (actual time=0.261..0.261 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
315. 0.259 0.259 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
316. 0.005 0.323 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170801 (cost=20.40..964.04 rows=577 width=106) (actual time=0.323..0.323 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
317. 0.318 0.318 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
318. 0.006 0.341 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170722 (cost=20.32..871.39 rows=509 width=106) (actual time=0.341..0.341 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
319. 0.335 0.335 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
320. 0.002 0.307 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180429 (cost=20.25..862.34 rows=505 width=106) (actual time=0.307..0.307 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
321. 0.305 0.305 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
322. 0.005 0.310 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170706 (cost=20.23..860.16 rows=504 width=106) (actual time=0.310..0.310 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
323. 0.305 0.305 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
324. 0.002 0.314 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180305 (cost=20.05..931.29 rows=557 width=106) (actual time=0.314..0.314 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
325. 0.312 0.312 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
326. 0.005 0.364 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180112 (cost=19.99..923.36 rows=554 width=106) (actual time=0.364..0.364 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
327. 0.359 0.359 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
328. 0.002 0.339 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180129 (cost=19.88..826.26 rows=484 width=106) (actual time=0.339..0.339 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
329. 0.337 0.337 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
330. 0.005 0.385 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180224 (cost=19.79..908.64 rows=542 width=106) (actual time=0.385..0.385 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
331. 0.380 0.380 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
332. 0.002 0.289 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170718 (cost=19.71..818.66 rows=474 width=106) (actual time=0.289..0.289 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
333. 0.287 0.287 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
334. 0.002 0.376 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170616 (cost=19.69..891.17 rows=536 width=106) (actual time=0.376..0.376 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
335. 0.374 0.374 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
336. 0.005 0.317 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171129 (cost=19.45..791.01 rows=459 width=106) (actual time=0.317..0.317 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
337. 0.312 0.312 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
338. 0.002 0.353 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180209 (cost=19.27..865.84 rows=512 width=106) (actual time=0.353..0.353 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
339. 0.351 0.351 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
340. 0.005 0.377 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170712 (cost=19.26..776.25 rows=448 width=106) (actual time=0.377..0.377 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
341. 0.372 0.372 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
342. 0.002 0.376 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180425 (cost=19.22..775.44 rows=446 width=106) (actual time=0.376..0.376 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
343. 0.374 0.374 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
344. 0.007 0.373 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171228 (cost=19.17..852.17 rows=506 width=106) (actual time=0.373..0.373 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
345. 0.366 0.366 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
346. 0.002 0.455 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180116 (cost=18.97..838.79 rows=495 width=106) (actual time=0.455..0.455 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
347. 0.453 0.453 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
348. 0.002 0.434 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180314 (cost=18.90..742.60 rows=428 width=106) (actual time=0.434..0.434 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
349. 0.432 0.432 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
350. 0.005 0.366 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180311 (cost=18.76..730.48 rows=420 width=106) (actual time=0.366..0.366 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
351. 0.361 0.361 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
352. 0.002 0.304 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170821 (cost=18.65..813.09 rows=476 width=106) (actual time=0.304..0.304 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
353. 0.302 0.302 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
354. 0.010 0.385 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170619 (cost=18.59..798.89 rows=473 width=106) (actual time=0.385..0.385 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
355. 0.375 0.375 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
356. 0.002 0.361 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170824 (cost=18.57..804.38 rows=472 width=106) (actual time=0.361..0.361 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
357. 0.359 0.359 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
358. 0.005 0.313 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180402 (cost=18.50..708.04 rows=405 width=106) (actual time=0.313..0.313 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
359. 0.308 0.308 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
360. 0.001 0.333 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170502 (cost=18.43..892.33 rows=527 width=106) (actual time=0.333..0.333 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
361. 0.332 0.332 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
362. 0.002 0.325 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180205 (cost=18.37..695.96 rows=398 width=106) (actual time=0.325..0.325 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
363. 0.323 0.323 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
364. 0.005 0.331 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170626 (cost=18.26..778.69 rows=454 width=106) (actual time=0.331..0.331 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
365. 0.326 0.326 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
366. 0.002 0.689 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170612 (cost=18.20..766.92 rows=451 width=106) (actual time=0.689..0.689 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
367. 0.687 0.687 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
368. 0.006 0.311 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180328 (cost=17.86..649.66 rows=368 width=106) (actual time=0.310..0.311 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
369. 0.305 0.305 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
370. 0.007 0.367 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171216 (cost=17.86..741.74 rows=431 width=106) (actual time=0.367..0.367 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
371. 0.360 0.360 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
372. 0.005 0.296 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170623 (cost=17.80..736.25 rows=428 width=106) (actual time=0.296..0.296 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
373. 0.291 0.291 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
374. 0.005 0.381 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170825 (cost=17.70..728.87 rows=422 width=106) (actual time=0.381..0.381 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
375. 0.376 0.376 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170825_pkey (cost=0.00..17.53 rows=718 width=0) (actual time=0.376..0.376 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
376. 0.002 0.404 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170618 (cost=17.61..716.28 rows=417 width=106) (actual time=0.404..0.404 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
377. 0.402 0.402 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
378. 0.007 0.357 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170826 (cost=17.51..714.05 rows=411 width=106) (actual time=0.357..0.357 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
379. 0.350 0.350 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
380. 0.002 0.404 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170605 (cost=17.36..697.34 rows=402 width=106) (actual time=0.404..0.404 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
381. 0.402 0.402 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
382. 0.005 0.609 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180131 (cost=17.35..602.90 rows=339 width=106) (actual time=0.609..0.609 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
383. 0.604 0.604 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
384. 0.002 0.404 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170813 (cost=17.34..698.97 rows=401 width=106) (actual time=0.404..0.404 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
385. 0.402 0.402 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
386. 0.001 0.297 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180316 (cost=17.27..596.62 rows=335 width=106) (actual time=0.297..0.297 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
387. 0.296 0.296 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
388. 0.005 0.291 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170922 (cost=17.23..685.28 rows=395 width=106) (actual time=0.291..0.291 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
389. 0.286 0.286 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
390. 0.002 0.256 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180324 (cost=17.21..592.47 rows=331 width=106) (actual time=0.256..0.256 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
391. 0.254 0.254 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
392. 0.005 0.368 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170811 (cost=17.09..676.24 rows=387 width=106) (actual time=0.368..0.368 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
393. 0.363 0.363 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
394. 0.002 0.283 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180225 (cost=17.09..676.23 rows=387 width=106) (actual time=0.283..0.283 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
395. 0.281 0.281 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
396. 0.005 0.332 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170607 (cost=16.96..848.87 rows=506 width=106) (actual time=0.332..0.332 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
397. 0.327 0.327 ↓ 0.0 0 1

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

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
398. 0.002 0.347 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170527 (cost=16.92..844.53 rows=504 width=106) (actual time=0.347..0.347 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
399. 0.345 0.345 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170527_pkey (cost=0.00..16.71 rows=856 width=0) (actual time=0.345..0.345 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
400. 0.002 0.386 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170827 (cost=16.91..561.65 rows=314 width=106) (actual time=0.386..0.386 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
401. 0.384 0.384 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170827_pkey (cost=0.00..16.77 rows=533 width=0) (actual time=0.384..0.384 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
402. 0.004 0.412 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170531 (cost=16.85..553.43 rows=311 width=106) (actual time=0.412..0.412 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
403. 0.408 0.408 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170531_pkey (cost=0.00..16.72 rows=528 width=0) (actual time=0.408..0.408 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
404. 0.002 0.356 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180228 (cost=16.82..651.28 rows=372 width=106) (actual time=0.356..0.356 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
405. 0.354 0.354 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180228_pkey (cost=0.00..16.66 rows=632 width=0) (actual time=0.354..0.354 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
406. 0.005 0.325 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180329 (cost=16.61..534.66 rows=296 width=106) (actual time=0.325..0.325 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
407. 0.320 0.320 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180329_pkey (cost=0.00..16.48 rows=504 width=0) (actual time=0.320..0.320 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
408. 0.002 0.494 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180111 (cost=16.58..629.61 rows=358 width=106) (actual time=0.494..0.494 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
409. 0.492 0.492 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180111_pkey (cost=0.00..16.43 rows=609 width=0) (actual time=0.492..0.492 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
410. 0.005 0.460 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170805 (cost=16.57..628.50 rows=358 width=106) (actual time=0.460..0.460 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
411. 0.455 0.455 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170805_pkey (cost=0.00..16.42 rows=608 width=0) (actual time=0.455..0.455 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
412. 0.002 0.339 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170820 (cost=16.52..625.46 rows=355 width=106) (actual time=0.339..0.339 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
413. 0.337 0.337 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170820_pkey (cost=0.00..16.37 rows=603 width=0) (actual time=0.337..0.337 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
414. 0.002 0.353 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180110 (cost=16.50..621.89 rows=354 width=106) (actual time=0.353..0.353 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
415. 0.351 0.351 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180110_pkey (cost=0.00..16.35 rows=601 width=0) (actual time=0.351..0.351 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
416. 0.005 0.353 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171207 (cost=16.49..522.53 rows=289 width=106) (actual time=0.353..0.353 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
417. 0.348 0.348 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171207_pkey (cost=0.00..16.36 rows=492 width=0) (actual time=0.348..0.348 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
418. 0.002 0.323 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171201 (cost=16.45..519.24 rows=288 width=106) (actual time=0.323..0.323 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
419. 0.321 0.321 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171201_pkey (cost=0.00..16.33 rows=489 width=0) (actual time=0.321..0.321 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
420. 0.009 0.332 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180405 (cost=16.44..519.51 rows=287 width=106) (actual time=0.332..0.332 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
421. 0.323 0.323 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180405_pkey (cost=0.00..16.32 rows=488 width=0) (actual time=0.323..0.323 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
422. 0.007 0.363 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180105 (cost=16.39..610.90 rows=347 width=106) (actual time=0.363..0.363 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
423. 0.356 0.356 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180105_pkey (cost=0.00..16.24 rows=590 width=0) (actual time=0.356..0.356 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
424. 0.005 0.356 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180119 (cost=16.36..609.00 rows=345 width=106) (actual time=0.356..0.356 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
425. 0.351 0.351 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180119_pkey (cost=0.00..16.21 rows=587 width=0) (actual time=0.351..0.351 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
426. 0.002 0.389 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180413 (cost=16.27..503.24 rows=277 width=106) (actual time=0.389..0.389 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
427. 0.387 0.387 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180413_pkey (cost=0.00..16.15 rows=471 width=0) (actual time=0.387..0.387 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
428. 0.002 0.397 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170526 (cost=16.19..781.93 rows=462 width=106) (actual time=0.397..0.397 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
429. 0.395 0.395 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170526_pkey (cost=0.00..16.00 rows=785 width=0) (actual time=0.395..0.395 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
430. 0.005 0.298 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180330 (cost=16.13..589.75 rows=332 width=106) (actual time=0.298..0.298 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
431. 0.293 0.293 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180330_pkey (cost=0.00..15.99 rows=565 width=0) (actual time=0.293..0.293 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
432. 0.002 0.290 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170501 (cost=16.12..689.71 rows=395 width=106) (actual time=0.290..0.290 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
433. 0.288 0.288 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170501_pkey (cost=0.00..15.96 rows=671 width=0) (actual time=0.288..0.288 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
434. 0.005 0.352 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171218 (cost=16.04..579.56 rows=327 width=106) (actual time=0.352..0.352 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
435. 0.347 0.347 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171218_pkey (cost=0.00..15.90 rows=556 width=0) (actual time=0.347..0.347 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
436. 0.002 0.378 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180106 (cost=16.01..576.28 rows=325 width=106) (actual time=0.378..0.378 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
437. 0.376 0.376 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180106_pkey (cost=0.00..15.87 rows=553 width=0) (actual time=0.376..0.376 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
438. 0.004 0.277 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180115 (cost=16.00..576.55 rows=325 width=106) (actual time=0.277..0.277 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
439. 0.273 0.273 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180115_pkey (cost=0.00..15.86 rows=552 width=0) (actual time=0.273..0.273 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
440. 0.002 0.487 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170620 (cost=15.95..568.34 rows=322 width=106) (actual time=0.487..0.487 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
441. 0.485 0.485 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170620_pkey (cost=0.00..15.81 rows=547 width=0) (actual time=0.485..0.485 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
442. 0.002 0.342 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180124 (cost=15.74..451.88 rows=246 width=106) (actual time=0.342..0.342 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
443. 0.340 0.340 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180124_pkey (cost=0.00..15.63 rows=419 width=0) (actual time=0.340..0.340 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
444. 0.004 0.355 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170726 (cost=15.73..452.14 rows=246 width=106) (actual time=0.355..0.355 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
445. 0.351 0.351 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170726_pkey (cost=0.00..15.62 rows=418 width=0) (actual time=0.351..0.351 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
446. 0.001 0.340 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180426 (cost=15.72..451.04 rows=245 width=106) (actual time=0.340..0.340 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
447. 0.339 0.339 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180426_pkey (cost=0.00..15.61 rows=417 width=0) (actual time=0.338..0.339 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
448. 0.007 0.404 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180226 (cost=15.42..522.31 rows=291 width=106) (actual time=0.404..0.404 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
449. 0.397 0.397 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180226_pkey (cost=0.00..15.29 rows=495 width=0) (actual time=0.397..0.397 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
450. 0.002 0.319 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180113 (cost=15.41..419.02 rows=228 width=106) (actual time=0.319..0.319 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
451. 0.317 0.317 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180113_pkey (cost=0.00..15.31 rows=387 width=0) (actual time=0.317..0.317 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
452. 0.006 0.513 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171219 (cost=15.26..506.90 rows=282 width=106) (actual time=0.513..0.513 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
453. 0.507 0.507 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171219_pkey (cost=0.00..15.14 rows=480 width=0) (actual time=0.507..0.507 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
454. 0.002 0.781 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180227 (cost=15.25..507.14 rows=282 width=106) (actual time=0.781..0.781 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
455. 0.779 0.779 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180227_pkey (cost=0.00..15.13 rows=479 width=0) (actual time=0.779..0.779 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
456. 0.002 1.060 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171227 (cost=15.18..499.15 rows=278 width=106) (actual time=1.060..1.060 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
457. 1.058 1.058 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171227_pkey (cost=0.00..15.06 rows=472 width=0) (actual time=1.058..1.058 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
458. 0.005 1.760 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170510 (cost=15.18..602.94 rows=341 width=106) (actual time=1.760..1.760 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
459. 1.755 1.755 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170510_pkey (cost=0.00..15.03 rows=579 width=0) (actual time=1.755..1.755 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
460. 0.002 0.420 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180202 (cost=15.14..394.07 rows=212 width=106) (actual time=0.420..0.420 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
461. 0.418 0.418 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180202_pkey (cost=0.00..15.05 rows=361 width=0) (actual time=0.418..0.418 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
462. 0.005 0.341 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171212 (cost=15.02..485.33 rows=268 width=106) (actual time=0.341..0.341 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
463. 0.336 0.336 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171212_pkey (cost=0.00..14.90 rows=456 width=0) (actual time=0.336..0.336 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
464. 0.002 0.764 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170705 (cost=14.95..375.49 rows=201 width=106) (actual time=0.764..0.764 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
465. 0.762 0.762 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170705_pkey (cost=0.00..14.86 rows=342 width=0) (actual time=0.762..0.762 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
466. 0.005 0.355 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180320 (cost=14.95..375.49 rows=201 width=106) (actual time=0.355..0.355 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
467. 0.350 0.350 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180320_pkey (cost=0.00..14.86 rows=342 width=0) (actual time=0.350..0.350 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
468. 0.002 0.314 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170704 (cost=14.91..371.07 rows=199 width=106) (actual time=0.314..0.314 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
469. 0.312 0.312 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170704_pkey (cost=0.00..14.82 rows=338 width=0) (actual time=0.312..0.312 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
470. 0.002 0.355 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180220 (cost=14.89..473.49 rows=261 width=106) (actual time=0.355..0.355 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
471. 0.353 0.353 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180220_pkey (cost=0.00..14.78 rows=444 width=0) (actual time=0.353..0.353 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
472. 0.011 0.327 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180407 (cost=14.89..370.19 rows=198 width=106) (actual time=0.327..0.327 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
473. 0.316 0.316 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180407_pkey (cost=0.00..14.80 rows=336 width=0) (actual time=0.316..0.316 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
474. 0.002 0.365 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180123 (cost=14.76..461.59 rows=254 width=106) (actual time=0.365..0.365 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
475. 0.363 0.363 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180123_pkey (cost=0.00..14.65 rows=431 width=0) (actual time=0.363..0.363 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
476. 0.006 0.331 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180321 (cost=14.72..352.50 rows=188 width=106) (actual time=0.331..0.331 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
477. 0.325 0.325 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180321_pkey (cost=0.00..14.64 rows=320 width=0) (actual time=0.325..0.325 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
478. 0.002 0.422 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170717 (cost=14.66..347.20 rows=185 width=106) (actual time=0.422..0.422 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
479. 0.420 0.420 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170717_pkey (cost=0.00..14.58 rows=314 width=0) (actual time=0.420..0.420 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
480. 0.002 0.242 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180415 (cost=14.66..347.20 rows=185 width=106) (actual time=0.242..0.242 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
481. 0.240 0.240 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180415_pkey (cost=0.00..14.58 rows=314 width=0) (actual time=0.240..0.240 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
482. 0.004 0.535 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171206 (cost=14.54..334.97 rows=178 width=106) (actual time=0.535..0.535 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
483. 0.531 0.531 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171206_pkey (cost=0.00..14.46 rows=302 width=0) (actual time=0.530..0.531 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
484. 0.001 0.309 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170629 (cost=14.52..438.67 rows=240 width=106) (actual time=0.309..0.309 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
485. 0.308 0.308 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170629_pkey (cost=0.00..14.42 rows=408 width=0) (actual time=0.308..0.308 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
486. 0.006 0.352 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180301 (cost=14.46..432.06 rows=236 width=106) (actual time=0.352..0.352 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
487. 0.346 0.346 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180301_pkey (cost=0.00..14.36 rows=402 width=0) (actual time=0.346..0.346 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
488. 0.004 0.649 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180114 (cost=14.41..321.70 rows=171 width=106) (actual time=0.649..0.649 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
489. 0.645 0.645 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180114_pkey (cost=0.00..14.34 rows=290 width=0) (actual time=0.645..0.645 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
490. 0.008 0.454 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180207 (cost=14.39..426.74 rows=232 width=106) (actual time=0.454..0.454 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
491. 0.446 0.446 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180207_pkey (cost=0.00..14.29 rows=395 width=0) (actual time=0.446..0.446 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
492. 0.004 0.424 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170516 (cost=14.36..526.97 rows=294 width=106) (actual time=0.424..0.424 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
493. 0.420 0.420 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170516_pkey (cost=0.00..14.23 rows=499 width=0) (actual time=0.420..0.420 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
494. 0.002 0.394 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180420 (cost=14.35..316.37 rows=167 width=106) (actual time=0.394..0.394 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
495. 0.392 0.392 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180420_pkey (cost=0.00..14.28 rows=284 width=0) (actual time=0.392..0.392 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
496. 0.005 0.354 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170617 (cost=14.27..411.92 rows=225 width=106) (actual time=0.354..0.354 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
497. 0.349 0.349 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170617_pkey (cost=0.00..14.17 rows=383 width=0) (actual time=0.349..0.349 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
498. 0.002 0.329 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170711 (cost=14.23..304.39 rows=160 width=106) (actual time=0.329..0.329 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
499. 0.327 0.327 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170711_pkey (cost=0.00..14.16 rows=272 width=0) (actual time=0.327..0.327 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
500. 0.006 0.354 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180406 (cost=14.17..297.75 rows=156 width=106) (actual time=0.354..0.354 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
501. 0.348 0.348 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180406_pkey (cost=0.00..14.10 rows=266 width=0) (actual time=0.348..0.348 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
502. 0.002 0.457 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180121 (cost=13.97..385.25 rows=208 width=106) (actual time=0.457..0.457 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
503. 0.455 0.455 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180121_pkey (cost=0.00..13.88 rows=354 width=0) (actual time=0.455..0.455 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
504. 0.005 0.326 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170806 (cost=13.81..261.30 rows=136 width=106) (actual time=0.326..0.326 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
505. 0.321 0.321 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170806_pkey (cost=0.00..13.75 rows=231 width=0) (actual time=0.321..0.321 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
506. 0.002 0.356 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180424 (cost=13.80..260.43 rows=135 width=106) (actual time=0.356..0.356 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
507. 0.354 0.354 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180424_pkey (cost=0.00..13.74 rows=230 width=0) (actual time=0.354..0.354 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
508. 0.013 0.419 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180103 (cost=13.76..363.13 rows=196 width=106) (actual time=0.419..0.419 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
509. 0.406 0.406 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180103_pkey (cost=0.00..13.67 rows=333 width=0) (actual time=0.406..0.406 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
510. 0.007 0.431 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170804 (cost=13.59..347.83 rows=186 width=106) (actual time=0.431..0.431 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
511. 0.424 0.424 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170804_pkey (cost=0.00..13.51 rows=317 width=0) (actual time=0.424..0.424 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
512. 0.002 0.338 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171223 (cost=13.58..346.71 rows=186 width=106) (actual time=0.338..0.338 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
513. 0.336 0.336 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171223_pkey (cost=0.00..13.50 rows=316 width=0) (actual time=0.336..0.336 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
514. 0.007 1.302 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170603 (cost=13.51..230.40 rows=119 width=106) (actual time=1.302..1.302 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
515. 1.295 1.295 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170603_pkey (cost=0.00..13.46 rows=202 width=0) (actual time=1.294..1.295 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
516. 0.003 0.309 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180306 (cost=13.47..227.23 rows=116 width=106) (actual time=0.309..0.309 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
517. 0.306 0.306 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180306_pkey (cost=0.00..13.42 rows=198 width=0) (actual time=0.306..0.306 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
518. 0.008 0.359 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171225 (cost=13.45..332.36 rows=178 width=106) (actual time=0.358..0.359 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
519. 0.351 0.351 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171225_pkey (cost=0.00..13.37 rows=303 width=0) (actual time=0.351..0.351 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
520. 0.002 0.339 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170622 (cost=13.38..327.03 rows=175 width=106) (actual time=0.339..0.339 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
521. 0.337 0.337 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170622_pkey (cost=0.00..13.31 rows=297 width=0) (actual time=0.337..0.337 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
522. 0.002 0.361 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170715 (cost=13.34..212.99 rows=109 width=106) (actual time=0.361..0.361 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
523. 0.359 0.359 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170715_pkey (cost=0.00..13.29 rows=185 width=0) (actual time=0.359..0.359 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
524. 0.010 0.407 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180108 (cost=13.33..321.51 rows=172 width=106) (actual time=0.407..0.407 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
525. 0.397 0.397 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180108_pkey (cost=0.00..13.26 rows=292 width=0) (actual time=0.397..0.397 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
526. 0.004 0.465 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170729 (cost=13.32..210.77 rows=108 width=106) (actual time=0.465..0.465 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
527. 0.461 0.461 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170729_pkey (cost=0.00..13.27 rows=183 width=0) (actual time=0.460..0.461 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
528. 0.008 0.446 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180212 (cost=13.24..312.85 rows=166 width=106) (actual time=0.446..0.446 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
529. 0.438 0.438 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180212_pkey (cost=0.00..13.17 rows=283 width=0) (actual time=0.438..0.438 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
530. 0.005 0.524 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170702 (cost=12.97..286.67 rows=151 width=106) (actual time=0.524..0.524 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
531. 0.519 0.519 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170702_pkey (cost=0.00..12.91 rows=257 width=0) (actual time=0.519..0.519 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
532. 0.006 0.313 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180308 (cost=12.92..282.19 rows=148 width=106) (actual time=0.313..0.313 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
533. 0.307 0.307 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180308_pkey (cost=0.00..12.86 rows=252 width=0) (actual time=0.307..0.307 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
534. 0.002 0.373 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170823 (cost=12.92..282.19 rows=148 width=106) (actual time=0.373..0.373 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
535. 0.371 0.371 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170823_pkey (cost=0.00..12.86 rows=252 width=0) (actual time=0.371..0.371 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
536. 0.003 0.346 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180104 (cost=12.81..270.00 rows=142 width=106) (actual time=0.346..0.346 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
537. 0.343 0.343 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180104_pkey (cost=0.00..12.75 rows=241 width=0) (actual time=0.343..0.343 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
538. 0.006 0.401 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170529 (cost=12.39..227.08 rows=118 width=106) (actual time=0.401..0.401 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
539. 0.395 0.395 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170529_pkey (cost=0.00..12.34 rows=200 width=0) (actual time=0.395..0.395 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
540. 0.002 0.300 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170507 (cost=12.36..333.93 rows=179 width=106) (actual time=0.300..0.300 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
541. 0.298 0.298 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170507_pkey (cost=0.00..12.28 rows=304 width=0) (actual time=0.298..0.298 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
542. 0.004 1.325 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180219 (cost=12.29..217.24 rows=112 width=106) (actual time=1.325..1.325 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
543. 1.321 1.321 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180219_pkey (cost=0.00..12.24 rows=190 width=0) (actual time=1.321..1.321 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
544. 0.002 0.372 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171220 (cost=12.20..207.24 rows=106 width=106) (actual time=0.372..0.372 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
545. 0.370 0.370 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171220_pkey (cost=0.00..12.15 rows=181 width=0) (actual time=0.370..0.370 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
546. 0.007 0.354 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171229 (cost=12.01..188.48 rows=96 width=106) (actual time=0.354..0.354 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
547. 0.347 0.347 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171229_pkey (cost=0.00..11.97 rows=163 width=0) (actual time=0.347..0.347 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
548. 0.003 0.456 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170812 (cost=11.92..178.64 rows=91 width=106) (actual time=0.456..0.456 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
549. 0.453 0.453 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170812_pkey (cost=0.00..11.88 rows=154 width=0) (actual time=0.453..0.453 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
550. 0.002 0.391 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171211 (cost=11.91..178.61 rows=90 width=106) (actual time=0.391..0.391 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
551. 0.389 0.389 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171211_pkey (cost=0.00..11.87 rows=153 width=0) (actual time=0.389..0.389 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
552. 0.005 0.420 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20180302 (cost=11.90..177.49 rows=89 width=106) (actual time=0.420..0.420 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
553. 0.415 0.415 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20180302_pkey (cost=0.00..11.86 rows=152 width=0) (actual time=0.415..0.415 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
554. 0.002 0.308 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171215 (cost=11.68..154.27 rows=77 width=106) (actual time=0.308..0.308 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
555. 0.306 0.306 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171215_pkey (cost=0.00..11.65 rows=131 width=0) (actual time=0.306..0.306 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
556. 0.004 0.335 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20171230 (cost=11.64..149.81 rows=75 width=106) (actual time=0.335..0.335 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
557. 0.331 0.331 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20171230_pkey (cost=0.00..11.61 rows=127 width=0) (actual time=0.330..0.331 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
558. 0.002 0.371 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20170523 (cost=11.59..364.23 rows=198 width=106) (actual time=0.371..0.371 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
559. 0.369 0.369 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20170523_pkey (cost=0.00..11.50 rows=336 width=0) (actual time=0.368..0.369 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
560. 0.004 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200812 (cost=1.31..4.51 rows=2 width=106) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
561. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20200812_pkey (cost=0.00..1.30 rows=3 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
562. 0.001 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200805 (cost=1.31..4.51 rows=2 width=106) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
563. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20200805_pkey (cost=0.00..1.30 rows=3 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
564. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200806 (cost=1.31..4.51 rows=2 width=106) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
565. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20200806_pkey (cost=0.00..1.30 rows=3 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
566. 0.003 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200807 (cost=1.31..4.51 rows=2 width=106) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
567. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20200807_pkey (cost=0.00..1.30 rows=3 width=0) (actual time=0.009..0.010 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
568. 0.002 0.012 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200808 (cost=1.31..4.51 rows=2 width=106) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
569. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20200808_pkey (cost=0.00..1.30 rows=3 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
570. 0.004 0.014 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200809 (cost=1.31..4.51 rows=2 width=106) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
571. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20200809_pkey (cost=0.00..1.30 rows=3 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
572. 0.001 0.013 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200810 (cost=1.31..4.51 rows=2 width=106) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
573. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20200810_pkey (cost=0.00..1.30 rows=3 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
574. 0.205 0.214 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on aggregated_compact_placements_20200811 (cost=1.31..4.51 rows=2 width=106) (actual time=0.214..0.214 rows=0 loops=1)

  • Recheck Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
575. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20200811_pkey (cost=0.00..1.30 rows=3 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
576. 0.048 0.048 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200524_pkey on aggregated_compact_placements_20200524 (cost=0.45..2.67 rows=1 width=48) (actual time=0.048..0.048 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
577. 0.417 0.417 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200525_pkey on aggregated_compact_placements_20200525 (cost=0.45..2.67 rows=1 width=48) (actual time=0.417..0.417 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
578. 0.430 0.430 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200526_pkey on aggregated_compact_placements_20200526 (cost=0.45..2.67 rows=1 width=48) (actual time=0.430..0.430 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
579. 0.374 0.374 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200527_pkey on aggregated_compact_placements_20200527 (cost=0.45..2.67 rows=1 width=47) (actual time=0.374..0.374 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
580. 0.448 0.448 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200528_pkey on aggregated_compact_placements_20200528 (cost=0.45..2.67 rows=1 width=47) (actual time=0.448..0.448 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
581. 0.305 0.305 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200529_pkey on aggregated_compact_placements_20200529 (cost=0.45..2.67 rows=1 width=48) (actual time=0.305..0.305 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
582. 0.416 0.416 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200530_pkey on aggregated_compact_placements_20200530 (cost=0.45..2.67 rows=1 width=48) (actual time=0.416..0.416 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
583. 0.369 0.369 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200531_pkey on aggregated_compact_placements_20200531 (cost=0.45..2.67 rows=1 width=48) (actual time=0.369..0.369 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
584. 0.040 0.040 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200601_pkey on aggregated_compact_placements_20200601 (cost=0.45..2.67 rows=1 width=48) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
585. 0.047 0.047 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200602_pkey on aggregated_compact_placements_20200602 (cost=0.45..2.67 rows=1 width=48) (actual time=0.047..0.047 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
586. 0.513 0.513 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200603_pkey on aggregated_compact_placements_20200603 (cost=0.45..2.67 rows=1 width=47) (actual time=0.513..0.513 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
587. 0.043 0.043 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200604_pkey on aggregated_compact_placements_20200604 (cost=0.45..2.67 rows=1 width=48) (actual time=0.043..0.043 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
588. 0.398 0.398 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200605_pkey on aggregated_compact_placements_20200605 (cost=0.45..2.67 rows=1 width=48) (actual time=0.398..0.398 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
589. 0.042 0.042 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200606_pkey on aggregated_compact_placements_20200606 (cost=0.45..2.67 rows=1 width=47) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
590. 0.044 0.044 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200607_pkey on aggregated_compact_placements_20200607 (cost=0.45..2.67 rows=1 width=48) (actual time=0.044..0.044 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
591. 0.516 0.516 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200608_pkey on aggregated_compact_placements_20200608 (cost=0.45..2.67 rows=1 width=48) (actual time=0.516..0.516 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
592. 0.367 0.367 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200609_pkey on aggregated_compact_placements_20200609 (cost=0.45..2.67 rows=1 width=48) (actual time=0.367..0.367 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
593. 0.047 0.047 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200610_pkey on aggregated_compact_placements_20200610 (cost=0.45..2.67 rows=1 width=47) (actual time=0.047..0.047 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
594. 0.058 0.058 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200611_pkey on aggregated_compact_placements_20200611 (cost=0.45..2.67 rows=1 width=48) (actual time=0.058..0.058 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
595. 0.048 0.048 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200612_pkey on aggregated_compact_placements_20200612 (cost=0.45..2.67 rows=1 width=48) (actual time=0.048..0.048 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
596. 0.250 0.250 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200613_pkey on aggregated_compact_placements_20200613 (cost=0.45..2.67 rows=1 width=47) (actual time=0.250..0.250 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
597. 0.042 0.042 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200614_pkey on aggregated_compact_placements_20200614 (cost=0.45..2.67 rows=1 width=48) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
598. 0.041 0.041 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200615_pkey on aggregated_compact_placements_20200615 (cost=0.45..2.67 rows=1 width=48) (actual time=0.041..0.041 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
599. 0.043 0.043 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200616_pkey on aggregated_compact_placements_20200616 (cost=0.45..2.67 rows=1 width=47) (actual time=0.043..0.043 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
600. 0.041 0.041 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200617_pkey on aggregated_compact_placements_20200617 (cost=0.45..2.67 rows=1 width=47) (actual time=0.041..0.041 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
601. 0.042 0.042 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200618_pkey on aggregated_compact_placements_20200618 (cost=0.45..2.67 rows=1 width=47) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
602. 0.047 0.047 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200619_pkey on aggregated_compact_placements_20200619 (cost=0.45..2.67 rows=1 width=47) (actual time=0.047..0.047 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
603. 0.042 0.042 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200620_pkey on aggregated_compact_placements_20200620 (cost=0.45..2.67 rows=1 width=47) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
604. 0.041 0.041 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200621_pkey on aggregated_compact_placements_20200621 (cost=0.45..2.67 rows=1 width=47) (actual time=0.041..0.041 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
605. 0.044 0.044 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200622_pkey on aggregated_compact_placements_20200622 (cost=0.45..2.67 rows=1 width=47) (actual time=0.044..0.044 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
606. 0.049 0.049 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200623_pkey on aggregated_compact_placements_20200623 (cost=0.45..2.67 rows=1 width=47) (actual time=0.049..0.049 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
607. 0.042 0.042 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200624_pkey on aggregated_compact_placements_20200624 (cost=0.45..2.67 rows=1 width=47) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
608. 0.387 0.387 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200625_pkey on aggregated_compact_placements_20200625 (cost=0.45..2.67 rows=1 width=47) (actual time=0.387..0.387 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
609. 0.043 0.043 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200626_pkey on aggregated_compact_placements_20200626 (cost=0.45..2.67 rows=1 width=47) (actual time=0.043..0.043 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
610. 0.042 0.042 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200627_pkey on aggregated_compact_placements_20200627 (cost=0.45..2.67 rows=1 width=47) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
611. 0.043 0.043 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200628_pkey on aggregated_compact_placements_20200628 (cost=0.45..2.67 rows=1 width=47) (actual time=0.043..0.043 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
612. 0.039 0.039 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200629_pkey on aggregated_compact_placements_20200629 (cost=0.45..2.67 rows=1 width=47) (actual time=0.039..0.039 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
613. 0.037 0.037 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200630_pkey on aggregated_compact_placements_20200630 (cost=0.45..2.67 rows=1 width=47) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
614. 0.040 0.040 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200701_pkey on aggregated_compact_placements_20200701 (cost=0.45..2.67 rows=1 width=47) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
615. 0.037 0.037 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200702_pkey on aggregated_compact_placements_20200702 (cost=0.45..2.67 rows=1 width=47) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
616. 0.040 0.040 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200703_pkey on aggregated_compact_placements_20200703 (cost=0.45..2.67 rows=1 width=47) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
617. 0.049 0.049 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200704_pkey on aggregated_compact_placements_20200704 (cost=0.45..2.67 rows=1 width=47) (actual time=0.049..0.049 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
618. 0.040 0.040 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200705_pkey on aggregated_compact_placements_20200705 (cost=0.45..2.67 rows=1 width=47) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
619. 0.040 0.040 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200706_pkey on aggregated_compact_placements_20200706 (cost=0.45..2.67 rows=1 width=47) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
620. 0.039 0.039 ↓ 0.0 0 1

Parallel Index Scan using aggregated_compact_placements_20200707_pkey on aggregated_compact_placements_20200707 (cost=0.45..2.67 rows=1 width=47) (actual time=0.039..0.039 rows=0 loops=1)

  • Index Cond: ((a_date >= ((timezone('UTC'::text, (CURRENT_DATE)::timestamp with time zone))::date - 2)) AND (a_date <= ((timezone('UTC'::text, (CURRENT_DATE)::timest