explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aPH1

Settings
# exclusive inclusive rows x rows loops node
1. 227.231 611,008.751 ↑ 105.7 5,599 1

Hash Right Join (cost=10,713,861.80..10,765,628.17 rows=591,616 width=1,830) (actual time=608,669.119..611,008.751 rows=5,599 loops=1)

  • Hash Cond: (tpi.placement_id = t_stat.placement_id)
  • Functions: 10,941
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 1233.760 ms, Inlining 71.207 ms, Optimization 42403.602 ms, Emission 27011.291 ms, Total 70719.860 ms
2.          

CTE t_raw_params

3. 0.278 0.278 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=12) (actual time=0.278..0.278 rows=1 loops=1)

4.          

CTE t_params

5. 0.283 0.283 ↑ 1.0 1 1

CTE Scan on t_raw_params (cost=0.00..0.02 rows=1 width=16) (actual time=0.283..0.283 rows=1 loops=1)

6.          

CTE t_lost_placements

7. 1,285.370 396,769.547 ↓ 1,332.6 266,517 1

GroupAggregate (cost=2,608.53..2,804.53 rows=200 width=5) (actual time=378,979.590..396,769.547 rows=266,517 loops=1)

  • Group Key: ch.id_placement
8. 7,673.426 395,484.177 ↓ 5,426.9 5,426,872 1

WindowAgg (cost=2,608.53..2,651.03 rows=1,000 width=176) (actual time=378,979.529..395,484.177 rows=5,426,872 loops=1)

9. 7,322.859 387,810.751 ↓ 5,426.9 5,426,872 1

WindowAgg (cost=2,608.53..2,631.03 rows=1,000 width=112) (actual time=378,979.508..387,810.751 rows=5,426,872 loops=1)

10. 6,536.487 380,487.892 ↓ 5,426.9 5,426,872 1

Sort (cost=2,608.53..2,611.03 rows=1,000 width=48) (actual time=378,978.696..380,487.892 rows=5,426,872 loops=1)

  • Sort Key: ch.id_placement, ch.a_date
  • Sort Method: external merge Disk: 198,600kB
11. 3,465.653 373,951.405 ↓ 5,426.9 5,426,872 1

Nested Loop Left Join (cost=0.93..2,558.70 rows=1,000 width=48) (actual time=342,480.352..373,951.405 rows=5,426,872 loops=1)

12. 343,351.392 343,351.392 ↓ 5,426.9 5,426,872 1

Function Scan on clickhouse_make_query_post ch (cost=0.50..10.50 rows=1,000 width=44) (actual time=342,480.270..343,351.392 rows=5,426,872 loops=1)

13. 27,134.360 27,134.360 ↑ 1.0 1 5,426,872

Index Scan using placements_pkey on placements pl (cost=0.43..2.55 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=5,426,872)

  • Index Cond: (ch.id_placement = id)
14.          

CTE t_stat

15. 10,302.342 186,412.599 ↑ 1.4 2,961,631 1

GroupAggregate (cost=7,773,675.43..8,112,555.51 rows=4,236,001 width=153) (actual time=167,514.941..186,412.599 rows=2,961,631 loops=1)

  • Group Key: acp.placement_id, acp.country, tsc.code
16.          

Initplan (for GroupAggregate)

17. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on t_params (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

18. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on t_params t_params_1 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

19. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on t_params t_params_2 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

20. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on t_params t_params_3 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

21. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on t_params t_params_4 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

22. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on t_params t_params_5 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

23. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on t_params t_params_6 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

24. 0.006 0.006 ↑ 1.0 1 1

CTE Scan on t_params t_params_7 (cost=0.00..0.02 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1)

25. 0.289 0.289 ↑ 1.0 1 1

CTE Scan on t_params t_params_8 (cost=0.00..0.02 rows=1 width=4) (actual time=0.288..0.289 rows=1 loops=1)

26. 0.006 0.006 ↑ 1.0 1 1

CTE Scan on t_params t_params_9 (cost=0.00..0.02 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=1)

27. 18,349.249 176,109.942 ↓ 4.1 17,531,199 1

Sort (cost=7,773,675.23..7,784,265.23 rows=4,236,001 width=32) (actual time=167,514.858..176,109.942 rows=17,531,199 loops=1)

  • Sort Key: acp.placement_id, acp.country, tsc.code
  • Sort Method: external merge Disk: 641,728kB
28. 4,126.975 157,760.693 ↓ 4.1 17,531,199 1

Hash Left Join (cost=7.76..7,248,048.95 rows=4,236,001 width=32) (actual time=117,895.480..157,760.693 rows=17,531,199 loops=1)

  • Hash Cond: (acp.country = tsc.id)
29. 1,313.903 153,633.609 ↓ 4.1 17,531,199 1

Append (cost=0.00..7,236,737.60 rows=4,236,001 width=29) (actual time=117,757.134..153,633.609 rows=17,531,199 loops=1)

30. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements acp (cost=0.00..0.00 rows=1 width=66) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
31. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141213 acp_1 (cost=0.00..19.00 rows=3 width=66) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
32. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141214 acp_2 (cost=0.00..19.00 rows=3 width=66) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
33. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141215 acp_3 (cost=0.00..19.00 rows=3 width=66) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
34. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141216 acp_4 (cost=0.00..19.00 rows=3 width=66) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
35. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141217 acp_5 (cost=0.00..19.00 rows=3 width=66) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
36. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141218 acp_6 (cost=0.00..19.00 rows=3 width=66) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
37. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141219 acp_7 (cost=0.00..19.00 rows=3 width=66) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
38. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141220 acp_8 (cost=0.00..19.00 rows=3 width=66) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
39. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141221 acp_9 (cost=0.00..19.00 rows=3 width=66) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
40. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141222 acp_10 (cost=0.00..19.00 rows=3 width=66) (actual time=0.006..0.007 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
41. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141223 acp_11 (cost=0.00..19.00 rows=3 width=66) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
42. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141224 acp_12 (cost=0.00..19.00 rows=3 width=66) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
43. 69,526.558 69,526.558 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141225 acp_13 (cost=0.00..4.05 rows=1 width=20) (actual time=69,526.558..69,526.558 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 137
44. 11.728 11.728 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141226 acp_14 (cost=0.00..2,115.99 rows=418 width=23) (actual time=11.728..11.728 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 83,774
45. 32.549 32.549 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141227 acp_15 (cost=0.00..2,396.07 rows=471 width=24) (actual time=32.549..32.549 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 95,049
46. 15.761 15.761 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141228 acp_16 (cost=0.00..2,416.22 rows=476 width=24) (actual time=15.761..15.761 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 95,765
47. 13.936 13.936 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141229 acp_17 (cost=0.00..2,378.87 rows=467 width=24) (actual time=13.936..13.936 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 94,277
48. 14.027 14.027 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141230 acp_18 (cost=0.00..2,448.94 rows=482 width=24) (actual time=14.027..14.027 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 96,954
49. 12.865 12.865 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20141231 acp_19 (cost=0.00..2,347.58 rows=464 width=23) (actual time=12.865..12.865 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 92,934
50. 12.693 12.693 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150101 acp_20 (cost=0.00..2,419.54 rows=477 width=24) (actual time=12.693..12.693 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 95,643
51. 12.563 12.563 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150102 acp_21 (cost=0.00..2,437.04 rows=480 width=24) (actual time=12.563..12.563 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 96,260
52. 13.830 13.830 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150103 acp_22 (cost=0.00..2,463.68 rows=486 width=24) (actual time=13.830..13.830 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 97,175
53. 15.179 15.179 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150104 acp_23 (cost=0.00..2,507.01 rows=494 width=24) (actual time=15.178..15.179 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 99,032
54. 14.783 14.783 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150105 acp_24 (cost=0.00..2,482.81 rows=488 width=24) (actual time=14.783..14.783 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 98,113
55. 14.213 14.213 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150106 acp_25 (cost=0.00..2,460.72 rows=485 width=24) (actual time=14.213..14.213 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 97,084
56. 14.500 14.500 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150107 acp_26 (cost=0.00..2,440.11 rows=480 width=24) (actual time=14.500..14.500 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 96,562
57. 14.560 14.560 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150108 acp_27 (cost=0.00..2,439.78 rows=480 width=24) (actual time=14.560..14.560 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 96,459
58. 14.491 14.491 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150109 acp_28 (cost=0.00..2,413.89 rows=476 width=24) (actual time=14.491..14.491 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 95,135
59. 13.595 13.595 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150110 acp_29 (cost=0.00..2,493.61 rows=492 width=24) (actual time=13.595..13.595 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 98,395
60. 13.036 13.036 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150111 acp_30 (cost=0.00..2,508.76 rows=493 width=24) (actual time=13.036..13.036 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 99,318
61. 14.825 14.825 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150112 acp_31 (cost=0.00..2,499.12 rows=492 width=24) (actual time=14.825..14.825 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 98,624
62. 15.444 15.444 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150113 acp_32 (cost=0.00..2,508.31 rows=494 width=24) (actual time=15.444..15.444 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 99,179
63. 14.383 14.383 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150114 acp_33 (cost=0.00..2,511.95 rows=495 width=23) (actual time=14.383..14.383 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 99,599
64. 14.970 14.970 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150115 acp_34 (cost=0.00..2,566.23 rows=506 width=23) (actual time=14.970..14.970 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 101,786
65. 14.569 14.569 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150116 acp_35 (cost=0.00..2,549.11 rows=503 width=23) (actual time=14.569..14.569 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 101,219
66. 13.334 13.334 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150117 acp_36 (cost=0.00..2,603.92 rows=516 width=23) (actual time=13.334..13.334 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 103,317
67. 13.836 13.836 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150118 acp_37 (cost=0.00..2,598.73 rows=516 width=23) (actual time=13.836..13.836 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 103,479
68. 13.743 13.743 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150119 acp_38 (cost=0.00..2,564.85 rows=508 width=23) (actual time=13.743..13.743 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 101,523
69. 14.731 14.731 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150120 acp_39 (cost=0.00..2,572.10 rows=507 width=23) (actual time=14.731..14.731 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 101,914
70. 14.661 14.661 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150121 acp_40 (cost=0.00..2,608.63 rows=515 width=23) (actual time=14.661..14.661 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 103,231
71. 15.134 15.134 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150122 acp_41 (cost=0.00..2,608.04 rows=514 width=23) (actual time=15.134..15.134 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 103,481
72. 14.603 14.603 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150123 acp_42 (cost=0.00..2,673.86 rows=528 width=23) (actual time=14.602..14.603 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 105,911
73. 14.561 14.561 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150124 acp_43 (cost=0.00..2,715.51 rows=537 width=23) (actual time=14.561..14.561 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 107,412
74. 13.352 13.352 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150125 acp_44 (cost=0.00..2,714.12 rows=536 width=23) (actual time=13.352..13.352 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 107,320
75. 14.217 14.217 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150126 acp_45 (cost=0.00..2,710.07 rows=535 width=23) (actual time=14.217..14.217 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 107,221
76. 14.209 14.209 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150127 acp_46 (cost=0.00..2,665.92 rows=527 width=23) (actual time=14.209..14.209 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 105,526
77. 15.033 15.033 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150128 acp_47 (cost=0.00..2,696.19 rows=532 width=23) (actual time=15.033..15.033 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 107,205
78. 14.501 14.501 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150129 acp_48 (cost=0.00..2,675.68 rows=529 width=23) (actual time=14.501..14.501 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 106,185
79. 14.801 14.801 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150130 acp_49 (cost=0.00..2,666.10 rows=526 width=23) (actual time=14.801..14.801 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 106,130
80. 14.495 14.495 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150131 acp_50 (cost=0.00..2,702.26 rows=535 width=23) (actual time=14.495..14.495 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 107,489
81. 14.951 14.951 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150201 acp_51 (cost=0.00..2,719.84 rows=538 width=23) (actual time=14.951..14.951 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 108,460
82. 13.546 13.546 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150202 acp_52 (cost=0.00..2,658.30 rows=527 width=23) (actual time=13.546..13.546 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 105,623
83. 14.286 14.286 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150203 acp_53 (cost=0.00..2,680.24 rows=531 width=23) (actual time=14.286..14.286 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 106,346
84. 13.714 13.714 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150204 acp_54 (cost=0.00..2,652.07 rows=525 width=23) (actual time=13.714..13.714 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 105,464
85. 14.551 14.551 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150205 acp_55 (cost=0.00..2,667.23 rows=525 width=24) (actual time=14.551..14.551 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 105,673
86. 15.126 15.126 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150206 acp_56 (cost=0.00..2,701.14 rows=531 width=24) (actual time=15.126..15.126 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 106,375
87. 16.025 16.025 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150207 acp_57 (cost=0.00..2,766.30 rows=544 width=24) (actual time=16.025..16.025 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 109,167
88. 17.399 17.399 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150208 acp_58 (cost=0.00..2,776.80 rows=545 width=24) (actual time=17.399..17.399 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 109,625
89. 17.500 17.500 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150209 acp_59 (cost=0.00..2,788.20 rows=547 width=24) (actual time=17.500..17.500 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 109,795
90. 15.040 15.040 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150210 acp_60 (cost=0.00..2,737.74 rows=539 width=24) (actual time=15.040..15.040 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 108,326
91. 15.216 15.216 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150211 acp_61 (cost=0.00..2,775.32 rows=550 width=23) (actual time=15.216..15.216 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 110,250
92. 15.870 15.870 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150212 acp_62 (cost=0.00..2,742.56 rows=543 width=23) (actual time=15.870..15.870 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 109,240
93. 18.790 18.790 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150213 acp_63 (cost=0.00..2,794.81 rows=553 width=23) (actual time=18.790..18.790 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 111,365
94. 16.891 16.891 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150214 acp_64 (cost=0.00..2,859.76 rows=566 width=23) (actual time=16.891..16.891 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 113,935
95. 17.480 17.480 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150215 acp_65 (cost=0.00..2,858.44 rows=561 width=24) (actual time=17.480..17.480 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 112,701
96. 18.800 18.800 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150216 acp_66 (cost=0.00..2,908.51 rows=569 width=24) (actual time=18.800..18.800 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 114,151
97. 16.640 16.640 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150217 acp_67 (cost=0.00..2,975.89 rows=582 width=24) (actual time=16.640..16.640 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 116,729
98. 16.133 16.133 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150218 acp_68 (cost=0.00..2,964.35 rows=581 width=24) (actual time=16.133..16.133 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 116,367
99. 15.985 15.985 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150219 acp_69 (cost=0.00..2,896.75 rows=568 width=24) (actual time=15.985..15.985 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 114,088
100. 16.323 16.323 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150220 acp_70 (cost=0.00..2,853.27 rows=559 width=24) (actual time=16.323..16.323 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 112,623
101. 16.801 16.801 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150221 acp_71 (cost=0.00..2,875.21 rows=565 width=24) (actual time=16.801..16.801 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 113,338
102. 15.256 15.256 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150222 acp_72 (cost=0.00..2,831.25 rows=557 width=24) (actual time=15.256..15.256 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 111,818
103. 14.123 14.123 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150223 acp_73 (cost=0.00..2,857.28 rows=562 width=24) (actual time=14.123..14.123 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 112,446
104. 16.723 16.723 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150224 acp_74 (cost=0.00..3,053.91 rows=599 width=24) (actual time=16.723..16.723 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 119,794
105. 20.008 20.008 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150225 acp_75 (cost=0.00..2,926.09 rows=572 width=24) (actual time=20.007..20.008 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 114,778
106. 15.919 15.919 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150226 acp_76 (cost=0.00..2,947.84 rows=575 width=24) (actual time=15.919..15.919 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 115,589
107. 15.257 15.257 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150227 acp_77 (cost=0.00..2,962.61 rows=579 width=24) (actual time=15.257..15.257 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 116,048
108. 13.776 13.776 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150228 acp_78 (cost=0.00..3,026.48 rows=591 width=24) (actual time=13.776..13.776 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 118,679
109. 15.745 15.745 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150301 acp_79 (cost=0.00..3,039.94 rows=594 width=24) (actual time=15.745..15.745 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 119,115
110. 14.800 14.800 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150302 acp_80 (cost=0.00..2,974.01 rows=581 width=24) (actual time=14.800..14.800 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 116,438
111. 14.790 14.790 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150303 acp_81 (cost=0.00..3,004.49 rows=588 width=24) (actual time=14.790..14.790 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 117,714
112. 19.566 19.566 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150304 acp_82 (cost=0.00..3,062.77 rows=599 width=24) (actual time=19.566..19.566 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 120,523
113. 20.445 20.445 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150305 acp_83 (cost=0.00..3,056.20 rows=598 width=24) (actual time=20.445..20.445 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 119,779
114. 18.256 18.256 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150306 acp_84 (cost=0.00..3,027.55 rows=593 width=24) (actual time=18.256..18.256 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 118,840
115. 16.591 16.591 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150307 acp_85 (cost=0.00..3,122.29 rows=611 width=24) (actual time=16.591..16.591 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 122,502
116. 16.591 16.591 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150308 acp_86 (cost=0.00..3,107.46 rows=608 width=24) (actual time=16.591..16.591 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 121,996
117. 16.217 16.217 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150309 acp_87 (cost=0.00..2,940.34 rows=575 width=24) (actual time=16.217..16.217 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 115,514
118. 11.240 11.240 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150310 acp_88 (cost=0.00..3,084.51 rows=603 width=24) (actual time=11.240..11.240 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 121,170
119. 10.858 10.858 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150311 acp_89 (cost=0.00..3,108.35 rows=609 width=24) (actual time=10.858..10.858 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 122,379
120. 11.823 11.823 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150312 acp_90 (cost=0.00..3,122.16 rows=613 width=24) (actual time=11.823..11.823 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 122,803
121. 14.592 14.592 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150313 acp_91 (cost=0.00..3,142.19 rows=617 width=24) (actual time=14.592..14.592 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,413
122. 15.772 15.772 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150314 acp_92 (cost=0.00..3,214.36 rows=630 width=24) (actual time=15.772..15.772 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,208
123. 17.292 17.292 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150315 acp_93 (cost=0.00..3,219.61 rows=631 width=24) (actual time=17.292..17.292 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,539
124. 14.672 14.672 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150316 acp_94 (cost=0.00..3,149.45 rows=616 width=24) (actual time=14.672..14.672 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,612
125. 15.474 15.474 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150317 acp_95 (cost=0.00..3,168.99 rows=621 width=24) (actual time=15.474..15.474 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 124,329
126. 16.488 16.488 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150318 acp_96 (cost=0.00..3,180.45 rows=622 width=24) (actual time=16.488..16.488 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 125,078
127. 15.818 15.818 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150319 acp_97 (cost=0.00..3,160.30 rows=619 width=24) (actual time=15.818..15.818 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 124,090
128. 16.762 16.762 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150320 acp_98 (cost=0.00..3,154.57 rows=618 width=24) (actual time=16.762..16.762 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,676
129. 16.527 16.527 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150321 acp_99 (cost=0.00..3,179.86 rows=622 width=24) (actual time=16.527..16.527 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 124,810
130. 16.438 16.438 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150322 acp_100 (cost=0.00..3,234.99 rows=634 width=24) (actual time=16.438..16.438 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,751
131. 15.219 15.219 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150323 acp_101 (cost=0.00..3,099.44 rows=605 width=24) (actual time=15.219..15.219 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 121,679
132. 15.616 15.616 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150324 acp_102 (cost=0.00..3,134.52 rows=614 width=24) (actual time=15.616..15.616 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,042
133. 16.117 16.117 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150325 acp_103 (cost=0.00..3,091.37 rows=606 width=24) (actual time=16.117..16.117 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 121,203
134. 16.291 16.291 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150326 acp_104 (cost=0.00..3,153.86 rows=618 width=24) (actual time=16.291..16.291 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 124,186
135. 16.005 16.005 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150327 acp_105 (cost=0.00..3,116.69 rows=611 width=24) (actual time=16.005..16.005 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 122,700
136. 16.214 16.214 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150328 acp_106 (cost=0.00..3,152.10 rows=617 width=24) (actual time=16.214..16.214 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 124,240
137. 12.217 12.217 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150329 acp_107 (cost=0.00..3,211.76 rows=630 width=24) (actual time=12.217..12.217 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,386
138. 11.351 11.351 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150330 acp_108 (cost=0.00..3,144.06 rows=616 width=24) (actual time=11.351..11.351 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,442
139. 11.691 11.691 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150331 acp_109 (cost=0.00..3,150.15 rows=617 width=24) (actual time=11.691..11.691 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,855
140. 10.288 10.288 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150401 acp_110 (cost=0.00..2,811.99 rows=551 width=24) (actual time=10.288..10.288 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 110,937
141. 12.231 12.231 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150402 acp_111 (cost=0.00..3,069.14 rows=603 width=24) (actual time=12.231..12.231 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 121,284
142. 12.434 12.434 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150403 acp_112 (cost=0.00..3,123.05 rows=614 width=24) (actual time=12.434..12.434 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,253
143. 14.566 14.566 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150404 acp_113 (cost=0.00..3,186.07 rows=626 width=24) (actual time=14.566..14.566 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 125,840
144. 13.176 13.176 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150405 acp_114 (cost=0.00..3,203.97 rows=630 width=24) (actual time=13.176..13.176 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,372
145. 14.988 14.988 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150406 acp_115 (cost=0.00..3,208.53 rows=630 width=24) (actual time=14.987..14.988 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,554
146. 14.074 14.074 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150407 acp_116 (cost=0.00..3,181.31 rows=625 width=24) (actual time=14.073..14.074 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 125,264
147. 14.967 14.967 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150408 acp_117 (cost=0.00..3,226.31 rows=634 width=24) (actual time=14.967..14.967 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,150
148. 13.441 13.441 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150409 acp_118 (cost=0.00..3,091.72 rows=607 width=24) (actual time=13.441..13.441 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 122,236
149. 17.805 17.805 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150410 acp_119 (cost=0.00..3,170.78 rows=623 width=24) (actual time=17.805..17.805 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 125,176
150. 17.354 17.354 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150411 acp_120 (cost=0.00..3,227.95 rows=635 width=24) (actual time=17.354..17.354 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,231
151. 14.635 14.635 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150412 acp_121 (cost=0.00..3,228.01 rows=634 width=24) (actual time=14.635..14.635 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,571
152. 14.252 14.252 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150413 acp_122 (cost=0.00..3,235.60 rows=636 width=24) (actual time=14.252..14.252 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,632
153. 23.500 23.500 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150414 acp_123 (cost=0.00..3,259.22 rows=640 width=24) (actual time=23.500..23.500 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 128,531
154. 18.925 18.925 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150415 acp_124 (cost=0.00..3,265.64 rows=642 width=24) (actual time=18.925..18.925 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 128,754
155. 20.325 20.325 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150416 acp_125 (cost=0.00..3,230.20 rows=636 width=24) (actual time=20.325..20.325 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,815
156. 21.314 21.314 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150417 acp_126 (cost=0.00..3,293.96 rows=651 width=23) (actual time=21.314..21.314 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 130,597
157. 29.647 29.647 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150418 acp_127 (cost=0.00..3,366.57 rows=666 width=23) (actual time=29.647..29.647 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 133,568
158. 17.461 17.461 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150419 acp_128 (cost=0.00..3,337.70 rows=658 width=24) (actual time=17.461..17.461 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,205
159. 18.905 18.905 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150420 acp_129 (cost=0.00..3,303.78 rows=653 width=24) (actual time=18.905..18.905 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 130,627
160. 18.771 18.771 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150421 acp_130 (cost=0.00..3,343.11 rows=662 width=23) (actual time=18.771..18.771 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,533
161. 19.296 19.296 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150422 acp_131 (cost=0.00..3,378.11 rows=669 width=23) (actual time=19.296..19.296 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 134,320
162. 17.731 17.731 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150423 acp_132 (cost=0.00..3,309.46 rows=655 width=23) (actual time=17.731..17.731 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,646
163. 20.085 20.085 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150424 acp_133 (cost=0.00..3,251.47 rows=644 width=23) (actual time=20.085..20.085 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 129,542
164. 21.966 21.966 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150425 acp_134 (cost=0.00..3,291.93 rows=651 width=23) (actual time=21.966..21.966 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 130,983
165. 20.092 20.092 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150426 acp_135 (cost=0.00..3,309.14 rows=655 width=23) (actual time=20.092..20.092 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,253
166. 18.700 18.700 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150427 acp_136 (cost=0.00..3,253.94 rows=643 width=23) (actual time=18.700..18.700 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 129,160
167. 18.667 18.667 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150428 acp_137 (cost=0.00..3,279.95 rows=649 width=23) (actual time=18.667..18.667 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 130,108
168. 18.173 18.173 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150429 acp_138 (cost=0.00..3,252.82 rows=644 width=23) (actual time=18.173..18.173 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 128,788
169. 17.233 17.233 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150430 acp_139 (cost=0.00..3,200.43 rows=632 width=23) (actual time=17.233..17.233 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,783
170. 18.105 18.105 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150501 acp_140 (cost=0.00..3,206.18 rows=632 width=23) (actual time=18.105..18.105 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,159
171. 18.435 18.435 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150502 acp_141 (cost=0.00..3,290.90 rows=649 width=23) (actual time=18.435..18.435 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 130,582
172. 18.878 18.878 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150503 acp_142 (cost=0.00..3,336.93 rows=658 width=23) (actual time=18.878..18.878 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,315
173. 19.183 19.183 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150504 acp_143 (cost=0.00..3,240.84 rows=639 width=24) (actual time=19.183..19.183 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 128,257
174. 17.235 17.235 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150505 acp_144 (cost=0.00..3,314.40 rows=654 width=23) (actual time=17.235..17.235 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,444
175. 14.986 14.986 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150506 acp_145 (cost=0.00..3,358.84 rows=663 width=23) (actual time=14.986..14.986 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 133,259
176. 14.371 14.371 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150507 acp_146 (cost=0.00..3,302.55 rows=652 width=23) (actual time=14.371..14.371 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,131
177. 14.334 14.334 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150508 acp_147 (cost=0.00..3,312.31 rows=655 width=23) (actual time=14.334..14.334 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,359
178. 15.198 15.198 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150509 acp_148 (cost=0.00..3,410.56 rows=675 width=23) (actual time=15.198..15.198 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 135,454
179. 14.159 14.159 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150510 acp_149 (cost=0.00..3,381.05 rows=669 width=23) (actual time=14.159..14.159 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 134,032
180. 18.610 18.610 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150511 acp_150 (cost=0.00..3,312.69 rows=654 width=23) (actual time=18.610..18.610 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,568
181. 19.115 19.115 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150512 acp_151 (cost=0.00..3,353.30 rows=663 width=23) (actual time=19.115..19.115 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,960
182. 17.811 17.811 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150513 acp_152 (cost=0.00..3,368.34 rows=667 width=23) (actual time=17.811..17.811 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 133,858
183. 19.559 19.559 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150514 acp_153 (cost=0.00..3,362.40 rows=666 width=23) (actual time=19.559..19.559 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 133,673
184. 21.752 21.752 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150515 acp_154 (cost=0.00..3,333.64 rows=660 width=23) (actual time=21.752..21.752 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,601
185. 22.730 22.730 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150516 acp_155 (cost=0.00..3,326.77 rows=658 width=23) (actual time=22.730..22.730 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,455
186. 19.517 19.517 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150517 acp_156 (cost=0.00..3,395.21 rows=672 width=23) (actual time=19.517..19.517 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 134,990
187. 21.574 21.574 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150518 acp_157 (cost=0.00..3,339.73 rows=662 width=23) (actual time=21.574..21.574 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,512
188. 19.286 19.286 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150519 acp_158 (cost=0.00..3,343.35 rows=663 width=23) (actual time=19.286..19.286 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,632
189. 23.609 23.609 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150520 acp_159 (cost=0.00..3,421.52 rows=677 width=23) (actual time=23.609..23.609 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 135,866
190. 19.089 19.089 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150521 acp_160 (cost=0.00..3,456.25 rows=684 width=23) (actual time=19.089..19.089 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 137,314
191. 19.540 19.540 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150522 acp_161 (cost=0.00..3,505.59 rows=692 width=23) (actual time=19.540..19.540 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 139,066
192. 20.616 20.616 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150523 acp_162 (cost=0.00..3,533.36 rows=696 width=23) (actual time=20.616..20.616 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 140,146
193. 21.875 21.875 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150524 acp_163 (cost=0.00..3,606.78 rows=711 width=23) (actual time=21.875..21.875 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 143,071
194. 19.936 19.936 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150525 acp_164 (cost=0.00..3,630.03 rows=716 width=23) (actual time=19.936..19.936 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 143,647
195. 18.709 18.709 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150526 acp_165 (cost=0.00..3,629.83 rows=717 width=24) (actual time=18.709..18.709 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 143,493
196. 14.607 14.607 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150527 acp_166 (cost=0.00..3,674.86 rows=725 width=24) (actual time=14.607..14.607 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 145,572
197. 16.742 16.742 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150528 acp_167 (cost=0.00..3,696.52 rows=730 width=24) (actual time=16.742..16.742 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 146,148
198. 16.528 16.528 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150529 acp_168 (cost=0.00..3,745.82 rows=738 width=23) (actual time=16.528..16.528 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 148,492
199. 23.340 23.340 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150530 acp_169 (cost=0.00..3,831.07 rows=756 width=23) (actual time=23.340..23.340 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 151,604
200. 25.172 25.172 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150531 acp_170 (cost=0.00..3,830.79 rows=755 width=24) (actual time=25.172..25.172 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 151,215
201. 20.594 20.594 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150601 acp_171 (cost=0.00..3,792.63 rows=746 width=24) (actual time=20.594..20.594 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 149,595
202. 16.146 16.146 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150602 acp_172 (cost=0.00..3,822.26 rows=752 width=24) (actual time=16.146..16.146 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 150,691
203. 17.070 17.070 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150603 acp_173 (cost=0.00..3,913.43 rows=772 width=23) (actual time=17.070..17.070 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 155,041
204. 16.181 16.181 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150604 acp_174 (cost=0.00..3,916.29 rows=774 width=23) (actual time=16.181..16.181 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 155,075
205. 18.363 18.363 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150605 acp_175 (cost=0.00..3,967.48 rows=784 width=23) (actual time=18.363..18.363 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 157,663
206. 20.845 20.845 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150606 acp_176 (cost=0.00..4,022.19 rows=796 width=23) (actual time=20.845..20.845 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 159,827
207. 15.089 15.089 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150607 acp_177 (cost=0.00..3,996.12 rows=791 width=23) (actual time=15.089..15.089 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 158,441
208. 20.455 20.455 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150608 acp_178 (cost=0.00..3,901.82 rows=772 width=23) (actual time=20.454..20.455 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 154,514
209. 23.362 23.362 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150609 acp_179 (cost=0.00..3,918.14 rows=773 width=23) (actual time=23.362..23.362 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 155,513
210. 22.536 22.536 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150610 acp_180 (cost=0.00..3,929.15 rows=777 width=23) (actual time=22.536..22.536 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 155,581
211. 18.712 18.712 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150611 acp_181 (cost=0.00..3,947.26 rows=781 width=23) (actual time=18.712..18.712 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 156,668
212. 16.464 16.464 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150612 acp_182 (cost=0.00..3,974.86 rows=786 width=23) (actual time=16.463..16.464 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 157,554
213. 16.387 16.387 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150613 acp_183 (cost=0.00..3,980.62 rows=787 width=23) (actual time=16.387..16.387 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 157,762
214. 18.597 18.597 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150614 acp_184 (cost=0.00..3,951.18 rows=780 width=23) (actual time=18.597..18.597 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 156,795
215. 18.138 18.138 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150615 acp_185 (cost=0.00..3,969.35 rows=784 width=23) (actual time=18.138..18.138 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 157,286
216. 33.991 33.991 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150616 acp_186 (cost=0.00..3,935.18 rows=777 width=23) (actual time=33.991..33.991 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 156,055
217. 36.591 36.591 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150617 acp_187 (cost=0.00..3,834.28 rows=758 width=23) (actual time=36.591..36.591 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 152,096
218. 36.970 36.970 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150618 acp_188 (cost=0.00..3,675.47 rows=727 width=23) (actual time=36.970..36.970 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 145,712
219. 34.084 34.084 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150619 acp_189 (cost=0.00..3,695.70 rows=730 width=23) (actual time=34.084..34.084 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 146,759
220. 35.067 35.067 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150620 acp_190 (cost=0.00..3,693.29 rows=730 width=23) (actual time=35.066..35.067 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 146,221
221. 33.651 33.651 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150621 acp_191 (cost=0.00..3,694.01 rows=729 width=23) (actual time=33.651..33.651 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 146,488
222. 47.021 47.021 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150622 acp_192 (cost=0.00..3,723.82 rows=735 width=23) (actual time=47.021..47.021 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 147,762
223. 64.286 64.286 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150623 acp_193 (cost=0.00..3,773.45 rows=745 width=23) (actual time=64.286..64.286 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 149,876
224. 36.970 36.970 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150624 acp_194 (cost=0.00..3,841.57 rows=759 width=23) (actual time=36.970..36.970 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 152,614
225. 28.969 28.969 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150625 acp_195 (cost=0.00..3,850.38 rows=761 width=23) (actual time=28.969..28.969 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 153,016
226. 40.614 40.614 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150626 acp_196 (cost=0.00..3,888.52 rows=770 width=23) (actual time=40.614..40.614 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 154,166
227. 61.367 61.367 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150627 acp_197 (cost=0.00..3,903.44 rows=771 width=23) (actual time=61.367..61.367 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 155,136
228. 42.709 42.709 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150628 acp_198 (cost=0.00..3,740.63 rows=740 width=23) (actual time=42.709..42.709 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 148,578
229. 37.428 37.428 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150629 acp_199 (cost=0.00..3,897.43 rows=771 width=23) (actual time=37.428..37.428 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 154,760
230. 48.010 48.010 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150630 acp_200 (cost=0.00..3,935.97 rows=779 width=23) (actual time=48.010..48.010 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 156,427
231. 28.297 28.297 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150701 acp_201 (cost=0.00..3,983.75 rows=789 width=23) (actual time=28.297..28.297 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 158,246
232. 38.551 38.551 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150702 acp_202 (cost=0.00..3,997.61 rows=793 width=23) (actual time=38.551..38.551 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 158,822
233. 35.767 35.767 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150703 acp_203 (cost=0.00..4,036.05 rows=801 width=23) (actual time=35.767..35.767 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 160,302
234. 59.351 59.351 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150704 acp_204 (cost=0.00..4,130.65 rows=819 width=23) (actual time=59.351..59.351 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 164,500
235. 38.519 38.519 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150705 acp_205 (cost=0.00..4,146.31 rows=822 width=23) (actual time=38.519..38.519 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 164,964
236. 47.083 47.083 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150706 acp_206 (cost=0.00..4,160.01 rows=825 width=23) (actual time=47.083..47.083 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 165,811
237. 31.520 31.520 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150707 acp_207 (cost=0.00..4,156.32 rows=825 width=23) (actual time=31.520..31.520 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 165,785
238. 44.971 44.971 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150708 acp_208 (cost=0.00..4,180.58 rows=831 width=23) (actual time=44.971..44.971 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 166,675
239. 62.387 62.387 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150709 acp_209 (cost=0.00..4,259.57 rows=847 width=23) (actual time=62.387..62.387 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 169,681
240. 56.662 56.662 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150710 acp_210 (cost=0.00..4,305.14 rows=856 width=23) (actual time=56.661..56.662 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 171,294
241. 41.182 41.182 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150711 acp_211 (cost=0.00..4,344.26 rows=863 width=23) (actual time=41.182..41.182 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 173,230
242. 83.128 83.128 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150712 acp_212 (cost=0.00..4,368.63 rows=868 width=23) (actual time=83.128..83.128 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 173,991
243. 20.599 20.599 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150713 acp_213 (cost=0.00..4,311.69 rows=856 width=23) (actual time=20.599..20.599 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 171,651
244. 44.146 44.146 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150714 acp_214 (cost=0.00..4,365.79 rows=869 width=23) (actual time=44.146..44.146 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 173,831
245. 42.510 42.510 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150715 acp_215 (cost=0.00..4,382.70 rows=871 width=23) (actual time=42.510..42.510 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 174,778
246. 47.031 47.031 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150716 acp_216 (cost=0.00..4,351.93 rows=865 width=23) (actual time=47.031..47.031 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 173,386
247. 68.927 68.927 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150717 acp_217 (cost=0.00..4,474.07 rows=888 width=23) (actual time=68.927..68.927 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 178,394
248. 59.879 59.879 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150718 acp_218 (cost=0.00..4,617.67 rows=917 width=23) (actual time=59.879..59.879 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 184,010
249. 42.455 42.455 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150719 acp_219 (cost=0.00..4,638.31 rows=921 width=23) (actual time=42.454..42.455 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 184,867
250. 48.211 48.211 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150720 acp_220 (cost=0.00..4,700.51 rows=934 width=23) (actual time=48.211..48.211 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 187,019
251. 46.906 46.906 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150721 acp_221 (cost=0.00..4,696.09 rows=934 width=23) (actual time=46.906..46.906 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 186,973
252. 49.087 49.087 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150722 acp_222 (cost=0.00..4,719.25 rows=938 width=23) (actual time=49.086..49.087 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 188,268
253. 40.456 40.456 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150723 acp_223 (cost=0.00..4,733.64 rows=941 width=23) (actual time=40.456..40.456 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 188,372
254. 52.760 52.760 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150724 acp_224 (cost=0.00..4,698.74 rows=932 width=23) (actual time=52.760..52.760 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 187,157
255. 28.875 28.875 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150725 acp_225 (cost=0.00..4,725.15 rows=938 width=23) (actual time=28.875..28.875 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 188,236
256. 45.455 45.455 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150726 acp_226 (cost=0.00..4,688.36 rows=931 width=23) (actual time=45.455..45.455 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 186,530
257. 44.253 44.253 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150727 acp_227 (cost=0.00..4,672.03 rows=927 width=23) (actual time=44.253..44.253 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 186,041
258. 43.080 43.080 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150728 acp_228 (cost=0.00..4,625.32 rows=919 width=23) (actual time=43.080..43.080 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 183,825
259. 39.516 39.516 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150729 acp_229 (cost=0.00..4,686.50 rows=932 width=23) (actual time=39.516..39.516 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 186,559
260. 38.074 38.074 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150730 acp_230 (cost=0.00..4,747.68 rows=943 width=23) (actual time=38.074..38.074 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 188,831
261. 36.661 36.661 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150731 acp_231 (cost=0.00..4,696.81 rows=933 width=23) (actual time=36.661..36.661 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 186,636
262. 42.115 42.115 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150801 acp_232 (cost=0.00..4,771.94 rows=948 width=23) (actual time=42.115..42.115 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 189,704
263. 42.917 42.917 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150802 acp_233 (cost=0.00..4,737.07 rows=940 width=23) (actual time=42.917..42.917 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 188,575
264. 44.421 44.421 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150803 acp_234 (cost=0.00..4,718.98 rows=936 width=23) (actual time=44.421..44.421 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 187,724
265. 53.807 53.807 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150804 acp_235 (cost=0.00..4,825.07 rows=957 width=23) (actual time=53.807..53.807 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 192,251
266. 43.686 43.686 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150805 acp_236 (cost=0.00..4,852.85 rows=964 width=23) (actual time=43.686..43.686 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 193,215
267. 47.844 47.844 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150806 acp_237 (cost=0.00..4,883.35 rows=970 width=23) (actual time=47.844..47.844 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 194,383
268. 46.851 46.851 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150807 acp_238 (cost=0.00..4,866.89 rows=966 width=23) (actual time=46.851..46.851 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 193,882
269. 42.349 42.349 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150808 acp_239 (cost=0.00..4,964.73 rows=986 width=23) (actual time=42.349..42.349 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 197,738
270. 41.152 41.152 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150809 acp_240 (cost=0.00..5,011.07 rows=994 width=23) (actual time=41.152..41.152 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 199,579
271. 43.702 43.702 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150810 acp_241 (cost=0.00..4,990.03 rows=989 width=23) (actual time=43.702..43.702 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 198,274
272. 44.874 44.874 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150811 acp_242 (cost=0.00..5,045.75 rows=1,000 width=23) (actual time=44.874..44.874 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 200,491
273. 36.408 36.408 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150812 acp_243 (cost=0.00..4,907.37 rows=973 width=23) (actual time=36.408..36.408 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 194,909
274. 38.841 38.841 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150813 acp_244 (cost=0.00..4,975.76 rows=987 width=23) (actual time=38.841..38.841 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 197,523
275. 44.268 44.268 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150814 acp_245 (cost=0.00..5,126.97 rows=1,018 width=23) (actual time=44.268..44.268 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 203,886
276. 48.461 48.461 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150815 acp_246 (cost=0.00..5,162.08 rows=1,024 width=23) (actual time=48.461..48.461 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 205,358
277. 51.070 51.070 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150816 acp_247 (cost=0.00..5,154.14 rows=1,022 width=23) (actual time=51.070..51.070 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 204,553
278. 58.735 58.735 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150817 acp_248 (cost=0.00..5,251.91 rows=1,040 width=23) (actual time=58.735..58.735 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 208,705
279. 43.426 43.426 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150818 acp_249 (cost=0.00..5,253.99 rows=1,041 width=23) (actual time=43.426..43.426 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 208,608
280. 46.759 46.759 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150819 acp_250 (cost=0.00..5,181.88 rows=1,027 width=23) (actual time=46.759..46.759 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 205,473
281. 49.968 49.968 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150820 acp_251 (cost=0.00..5,151.05 rows=1,021 width=23) (actual time=49.968..49.968 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 204,446
282. 48.408 48.408 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150821 acp_252 (cost=0.00..5,131.01 rows=1,017 width=23) (actual time=48.408..48.408 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 203,361
283. 56.559 56.559 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150822 acp_253 (cost=0.00..5,146.19 rows=1,018 width=23) (actual time=56.559..56.559 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 204,465
284. 60.948 60.948 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150823 acp_254 (cost=0.00..5,194.91 rows=1,028 width=23) (actual time=60.948..60.948 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 206,417
285. 40.049 40.049 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150824 acp_255 (cost=0.00..5,258.60 rows=1,038 width=23) (actual time=40.049..40.049 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 208,009
286. 48.360 48.360 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150825 acp_256 (cost=0.00..5,205.51 rows=1,027 width=24) (actual time=48.360..48.360 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 205,994
287. 56.372 56.372 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150826 acp_257 (cost=0.00..5,161.76 rows=1,019 width=23) (actual time=56.372..56.372 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 204,283
288. 43.099 43.099 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150827 acp_258 (cost=0.00..5,195.34 rows=1,028 width=23) (actual time=43.098..43.099 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 206,377
289. 36.492 36.492 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150828 acp_259 (cost=0.00..5,220.32 rows=1,036 width=23) (actual time=36.491..36.492 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 207,581
290. 38.367 38.367 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150829 acp_260 (cost=0.00..5,373.28 rows=1,068 width=23) (actual time=38.367..38.367 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 214,153
291. 41.187 41.187 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150830 acp_261 (cost=0.00..5,394.23 rows=1,072 width=23) (actual time=41.187..41.187 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 214,845
292. 43.168 43.168 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150831 acp_262 (cost=0.00..5,368.82 rows=1,067 width=23) (actual time=43.168..43.168 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 213,626
293. 55.967 55.967 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150901 acp_263 (cost=0.00..5,343.53 rows=1,061 width=23) (actual time=55.967..55.967 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 212,831
294. 43.501 43.501 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150902 acp_264 (cost=0.00..5,402.21 rows=1,072 width=23) (actual time=43.501..43.501 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 214,909
295. 47.675 47.675 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150903 acp_265 (cost=0.00..5,497.75 rows=1,091 width=23) (actual time=47.675..47.675 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 218,675
296. 50.570 50.570 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150904 acp_266 (cost=0.00..5,306.07 rows=1,051 width=23) (actual time=50.570..50.570 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 211,036
297. 45.647 45.647 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150905 acp_267 (cost=0.00..5,415.84 rows=1,073 width=23) (actual time=45.647..45.647 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 215,372
298. 42.337 42.337 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150906 acp_268 (cost=0.00..5,441.12 rows=1,079 width=23) (actual time=42.337..42.337 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 215,925
299. 47.730 47.730 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150907 acp_269 (cost=0.00..5,438.98 rows=1,078 width=23) (actual time=47.730..47.730 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 216,171
300. 48.819 48.819 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150908 acp_270 (cost=0.00..5,574.16 rows=1,106 width=23) (actual time=48.819..48.819 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 221,769
301. 49.082 49.082 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150909 acp_271 (cost=0.00..5,536.15 rows=1,100 width=23) (actual time=49.082..49.082 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 220,199
302. 42.389 42.389 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150910 acp_272 (cost=0.00..5,502.61 rows=1,094 width=23) (actual time=42.389..42.389 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 219,116
303. 49.812 49.812 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150911 acp_273 (cost=0.00..5,553.75 rows=1,105 width=23) (actual time=49.812..49.812 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 221,232
304. 49.719 49.719 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150912 acp_274 (cost=0.00..5,688.90 rows=1,129 width=23) (actual time=49.719..49.719 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 226,707
305. 52.313 52.313 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150913 acp_275 (cost=0.00..5,700.04 rows=1,133 width=23) (actual time=52.313..52.313 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 226,680
306. 46.381 46.381 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150914 acp_276 (cost=0.00..5,614.41 rows=1,115 width=23) (actual time=46.381..46.381 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 223,267
307. 51.637 51.637 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150915 acp_277 (cost=0.00..5,650.60 rows=1,123 width=23) (actual time=51.637..51.637 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 224,633
308. 47.003 47.003 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150916 acp_278 (cost=0.00..5,296.23 rows=1,052 width=23) (actual time=47.003..47.003 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 211,199
309. 48.086 48.086 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150917 acp_279 (cost=0.00..5,319.10 rows=1,058 width=23) (actual time=48.086..48.086 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 211,841
310. 49.616 49.616 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150918 acp_280 (cost=0.00..5,531.65 rows=1,099 width=23) (actual time=49.616..49.616 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 220,302
311. 49.824 49.824 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150919 acp_281 (cost=0.00..5,690.25 rows=1,130 width=23) (actual time=49.824..49.824 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 226,598
312. 50.412 50.412 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150920 acp_282 (cost=0.00..5,747.34 rows=1,141 width=23) (actual time=50.412..50.412 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 228,568
313. 54.520 54.520 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150921 acp_283 (cost=0.00..5,736.88 rows=1,138 width=23) (actual time=54.520..54.520 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 228,249
314. 52.184 52.184 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150922 acp_284 (cost=0.00..5,886.60 rows=1,168 width=23) (actual time=52.184..52.184 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 234,108
315. 40.495 40.495 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150923 acp_285 (cost=0.00..5,973.43 rows=1,185 width=23) (actual time=40.495..40.495 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 237,722
316. 55.962 55.962 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150924 acp_286 (cost=0.00..5,869.69 rows=1,166 width=23) (actual time=55.961..55.962 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 233,266
317. 65.771 65.771 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150925 acp_287 (cost=0.00..5,821.39 rows=1,155 width=23) (actual time=65.771..65.771 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 231,602
318. 53.430 53.430 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150926 acp_288 (cost=0.00..5,931.06 rows=1,178 width=23) (actual time=53.430..53.430 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 236,376
319. 55.289 55.289 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150927 acp_289 (cost=0.00..5,944.27 rows=1,181 width=23) (actual time=55.289..55.289 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 236,688
320. 51.278 51.278 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150928 acp_290 (cost=0.00..5,919.25 rows=1,176 width=23) (actual time=51.278..51.278 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 235,752
321. 57.244 57.244 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150929 acp_291 (cost=0.00..6,114.07 rows=1,216 width=23) (actual time=57.244..57.244 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 243,741
322. 62.076 62.076 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20150930 acp_292 (cost=0.00..6,126.32 rows=1,218 width=23) (actual time=62.076..62.076 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 244,246
323. 60.311 60.311 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151001 acp_293 (cost=0.00..6,200.86 rows=1,232 width=23) (actual time=60.311..60.311 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 247,035
324. 65.321 65.321 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151002 acp_294 (cost=0.00..6,217.41 rows=1,236 width=23) (actual time=65.321..65.321 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 247,565
325. 54.367 54.367 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151003 acp_295 (cost=0.00..6,279.16 rows=1,249 width=23) (actual time=54.367..54.367 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 250,297
326. 53.860 53.860 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151004 acp_296 (cost=0.00..6,195.91 rows=1,233 width=23) (actual time=53.860..53.860 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 246,994
327. 46.122 46.122 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151005 acp_297 (cost=0.00..6,059.05 rows=1,202 width=23) (actual time=46.122..46.122 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 241,213
328. 42.896 42.896 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151006 acp_298 (cost=0.00..6,034.44 rows=1,197 width=23) (actual time=42.896..42.896 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 239,640
329. 65.247 65.247 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151007 acp_299 (cost=0.00..5,994.79 rows=1,190 width=23) (actual time=65.247..65.247 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 238,139
330. 44.255 44.255 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151008 acp_300 (cost=0.00..6,162.25 rows=1,223 width=23) (actual time=44.255..44.255 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 244,761
331. 55.169 55.169 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151009 acp_301 (cost=0.00..6,143.50 rows=1,218 width=23) (actual time=55.169..55.169 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 243,952
332. 56.677 56.677 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151010 acp_302 (cost=0.00..6,210.66 rows=1,230 width=23) (actual time=56.677..56.677 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 246,890
333. 61.106 61.106 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151011 acp_303 (cost=0.00..6,145.97 rows=1,218 width=23) (actual time=61.106..61.106 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 244,224
334. 56.682 56.682 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151012 acp_304 (cost=0.00..6,175.10 rows=1,224 width=23) (actual time=56.682..56.682 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 244,947
335. 63.368 63.368 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151013 acp_305 (cost=0.00..6,134.71 rows=1,215 width=23) (actual time=63.368..63.368 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 243,760
336. 47.385 47.385 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151014 acp_306 (cost=0.00..6,186.91 rows=1,225 width=23) (actual time=47.385..47.385 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 245,763
337. 58.095 58.095 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151015 acp_307 (cost=0.00..6,173.29 rows=1,222 width=23) (actual time=58.095..58.095 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 245,278
338. 56.212 56.212 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151016 acp_308 (cost=0.00..6,229.90 rows=1,235 width=23) (actual time=56.212..56.212 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 247,645
339. 57.856 57.856 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151017 acp_309 (cost=0.00..6,427.31 rows=1,274 width=23) (actual time=57.856..57.856 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 255,121
340. 46.036 46.036 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151018 acp_310 (cost=0.00..6,391.89 rows=1,267 width=23) (actual time=46.035..46.036 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 253,695
341. 43.565 43.565 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151019 acp_311 (cost=0.00..6,315.27 rows=1,251 width=23) (actual time=43.565..43.565 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 250,596
342. 51.723 51.723 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151020 acp_312 (cost=0.00..6,387.88 rows=1,266 width=23) (actual time=51.723..51.723 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 253,503
343. 54.743 54.743 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151021 acp_313 (cost=0.00..6,413.50 rows=1,272 width=23) (actual time=54.743..54.743 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 254,858
344. 53.305 53.305 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151022 acp_314 (cost=0.00..6,474.23 rows=1,285 width=23) (actual time=53.305..53.305 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 257,370
345. 54.402 54.402 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151023 acp_315 (cost=0.00..6,394.22 rows=1,270 width=23) (actual time=54.402..54.402 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 254,806
346. 58.821 58.821 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151024 acp_316 (cost=0.00..6,481.72 rows=1,288 width=23) (actual time=58.821..58.821 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 258,204
347. 61.345 61.345 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151025 acp_317 (cost=0.00..6,554.15 rows=1,303 width=23) (actual time=61.345..61.345 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 260,983
348. 56.009 56.009 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151026 acp_318 (cost=0.00..6,465.88 rows=1,284 width=23) (actual time=56.009..56.009 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 257,427
349. 69.941 69.941 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151027 acp_319 (cost=0.00..6,592.60 rows=1,310 width=23) (actual time=69.941..69.941 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 262,594
350. 51.726 51.726 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151028 acp_320 (cost=0.00..6,615.99 rows=1,315 width=23) (actual time=51.726..51.726 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 263,876
351. 53.567 53.567 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151029 acp_321 (cost=0.00..6,651.43 rows=1,325 width=23) (actual time=53.567..53.567 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 265,106
352. 58.096 58.096 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151030 acp_322 (cost=0.00..6,658.48 rows=1,325 width=23) (actual time=58.096..58.096 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 265,262
353. 72.113 72.113 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151031 acp_323 (cost=0.00..6,748.98 rows=1,342 width=23) (actual time=72.113..72.113 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 268,816
354. 41.770 41.770 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151101 acp_324 (cost=0.00..6,756.23 rows=1,345 width=23) (actual time=41.770..41.770 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 268,985
355. 62.946 62.946 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151102 acp_325 (cost=0.00..6,709.08 rows=1,337 width=22) (actual time=62.946..62.946 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 267,841
356. 63.446 63.446 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151103 acp_326 (cost=0.00..6,686.38 rows=1,333 width=22) (actual time=63.445..63.446 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 266,751
357. 62.601 62.601 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151104 acp_327 (cost=0.00..6,666.93 rows=1,327 width=23) (actual time=62.601..62.601 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 265,588
358. 65.725 65.725 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151105 acp_328 (cost=0.00..6,692.46 rows=1,340 width=22) (actual time=65.725..65.725 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 268,180
359. 60.558 60.558 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151106 acp_329 (cost=0.00..6,721.31 rows=1,340 width=22) (actual time=60.557..60.558 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 268,946
360. 53.728 53.728 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151107 acp_330 (cost=0.00..6,756.53 rows=1,347 width=22) (actual time=53.728..53.728 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 270,224
361. 51.524 51.524 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151108 acp_331 (cost=0.00..6,669.40 rows=1,327 width=23) (actual time=51.524..51.524 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 265,616
362. 62.193 62.193 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151109 acp_332 (cost=0.00..6,872.76 rows=1,362 width=23) (actual time=62.193..62.193 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 273,000
363. 61.777 61.777 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151110 acp_333 (cost=0.00..6,928.34 rows=1,375 width=23) (actual time=61.777..61.777 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 275,280
364. 62.956 62.956 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151111 acp_334 (cost=0.00..7,051.64 rows=1,401 width=23) (actual time=62.955..62.956 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 280,608
365. 49.125 49.125 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151112 acp_335 (cost=0.00..7,182.41 rows=1,428 width=23) (actual time=49.125..49.125 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 285,802
366. 63.109 63.109 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151113 acp_336 (cost=0.00..7,273.11 rows=1,446 width=23) (actual time=63.109..63.109 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 289,220
367. 59.766 59.766 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151114 acp_337 (cost=0.00..7,207.19 rows=1,432 width=23) (actual time=59.766..59.766 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 286,584
368. 47.606 47.606 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151115 acp_338 (cost=0.00..7,135.86 rows=1,418 width=23) (actual time=47.606..47.606 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 284,029
369. 49.837 49.837 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151116 acp_339 (cost=0.00..7,098.57 rows=1,411 width=23) (actual time=49.837..49.837 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 282,276
370. 52.269 52.269 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151117 acp_340 (cost=0.00..7,160.47 rows=1,423 width=23) (actual time=52.269..52.269 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 285,110
371. 52.361 52.361 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151118 acp_341 (cost=0.00..7,111.82 rows=1,410 width=23) (actual time=52.361..52.361 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 282,717
372. 57.365 57.365 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151119 acp_342 (cost=0.00..7,017.14 rows=1,389 width=23) (actual time=57.365..57.365 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 278,731
373. 50.786 50.786 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151120 acp_343 (cost=0.00..7,039.35 rows=1,394 width=23) (actual time=50.786..50.786 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 279,538
374. 64.860 64.860 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151121 acp_344 (cost=0.00..7,249.35 rows=1,438 width=23) (actual time=64.860..64.860 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 287,827
375. 50.411 50.411 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151122 acp_345 (cost=0.00..7,180.97 rows=1,424 width=23) (actual time=50.411..50.411 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 285,055
376. 53.344 53.344 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151123 acp_346 (cost=0.00..7,166.06 rows=1,420 width=23) (actual time=53.344..53.344 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 284,198
377. 66.403 66.403 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151124 acp_347 (cost=0.00..7,124.41 rows=1,411 width=23) (actual time=66.403..66.403 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 282,449
378. 67.883 67.883 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151125 acp_348 (cost=0.00..7,124.91 rows=1,409 width=23) (actual time=67.883..67.883 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 282,605
379. 67.580 67.580 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151126 acp_349 (cost=0.00..7,179.70 rows=1,421 width=23) (actual time=67.580..67.580 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 284,256
380. 52.384 52.384 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151127 acp_350 (cost=0.00..7,021.09 rows=1,390 width=23) (actual time=52.383..52.384 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 277,957
381. 42.464 42.464 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151128 acp_351 (cost=0.00..7,087.64 rows=1,403 width=23) (actual time=42.464..42.464 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 280,871
382. 52.400 52.400 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151129 acp_352 (cost=0.00..7,114.06 rows=1,407 width=23) (actual time=52.400..52.400 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 282,262
383. 46.864 46.864 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151130 acp_353 (cost=0.00..7,096.64 rows=1,406 width=23) (actual time=46.864..46.864 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 281,172
384. 52.549 52.549 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151201 acp_354 (cost=0.00..7,028.60 rows=1,391 width=23) (actual time=52.549..52.549 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 278,704
385. 57.741 57.741 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151202 acp_355 (cost=0.00..7,151.47 rows=1,415 width=23) (actual time=57.741..57.741 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 283,318
386. 52.164 52.164 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151203 acp_356 (cost=0.00..7,199.36 rows=1,419 width=24) (actual time=52.164..52.164 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 284,670
387. 55.251 55.251 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151204 acp_357 (cost=0.00..7,159.18 rows=1,412 width=24) (actual time=55.251..55.251 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 282,709
388. 51.179 51.179 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151205 acp_358 (cost=0.00..7,099.65 rows=1,399 width=24) (actual time=51.179..51.179 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 280,638
389. 62.616 62.616 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151206 acp_359 (cost=0.00..7,082.69 rows=1,396 width=24) (actual time=62.616..62.616 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 279,611
390. 67.079 67.079 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151207 acp_360 (cost=0.00..7,062.73 rows=1,392 width=24) (actual time=67.079..67.079 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 278,571
391. 63.327 63.327 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151208 acp_361 (cost=0.00..7,155.76 rows=1,410 width=24) (actual time=63.327..63.327 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 282,850
392. 62.884 62.884 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151209 acp_362 (cost=0.00..7,214.69 rows=1,421 width=24) (actual time=62.884..62.884 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 284,608
393. 76.423 76.423 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151210 acp_363 (cost=0.00..7,308.66 rows=1,438 width=24) (actual time=76.423..76.423 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 288,285
394. 57.625 57.625 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151211 acp_364 (cost=0.00..7,234.85 rows=1,427 width=24) (actual time=57.625..57.625 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 286,052
395. 67.432 67.432 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151212 acp_365 (cost=0.00..7,470.98 rows=1,475 width=24) (actual time=67.432..67.432 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 295,215
396. 69.915 69.915 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151213 acp_366 (cost=0.00..7,539.85 rows=1,490 width=23) (actual time=69.915..69.915 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 298,278
397. 62.273 62.273 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151214 acp_367 (cost=0.00..7,485.90 rows=1,478 width=24) (actual time=62.273..62.273 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 296,193
398. 69.158 69.158 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151215 acp_368 (cost=0.00..7,445.61 rows=1,475 width=23) (actual time=69.158..69.158 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 295,496
399. 67.448 67.448 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151216 acp_369 (cost=0.00..7,386.49 rows=1,458 width=24) (actual time=67.448..67.448 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 292,317
400. 71.741 71.741 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151217 acp_370 (cost=0.00..7,513.48 rows=1,483 width=24) (actual time=71.741..71.741 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 297,100
401. 69.795 69.795 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151218 acp_371 (cost=0.00..7,506.41 rows=1,474 width=24) (actual time=69.795..69.795 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 295,587
402. 72.243 72.243 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151219 acp_372 (cost=0.00..7,543.14 rows=1,477 width=24) (actual time=72.243..72.243 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 296,012
403. 66.768 66.768 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151220 acp_373 (cost=0.00..7,506.52 rows=1,470 width=24) (actual time=66.768..66.768 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 294,445
404. 78.643 78.643 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151221 acp_374 (cost=0.00..7,433.09 rows=1,456 width=24) (actual time=78.643..78.643 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 291,346
405. 60.341 60.341 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151222 acp_375 (cost=0.00..7,334.72 rows=1,437 width=24) (actual time=60.341..60.341 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 287,745
406. 57.975 57.975 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151223 acp_376 (cost=0.00..7,225.72 rows=1,414 width=24) (actual time=57.975..57.975 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 283,271
407. 59.085 59.085 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151224 acp_377 (cost=0.00..6,894.39 rows=1,349 width=24) (actual time=59.085..59.085 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 270,344
408. 52.361 52.361 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151225 acp_378 (cost=0.00..6,892.06 rows=1,347 width=24) (actual time=52.361..52.361 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 270,133
409. 53.745 53.745 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151226 acp_379 (cost=0.00..7,196.16 rows=1,407 width=24) (actual time=53.745..53.745 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 281,857
410. 66.392 66.392 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151227 acp_380 (cost=0.00..7,078.25 rows=1,384 width=24) (actual time=66.392..66.392 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 277,209
411. 63.863 63.863 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151228 acp_381 (cost=0.00..7,162.36 rows=1,402 width=24) (actual time=63.863..63.863 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 281,148
412. 58.813 58.813 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151229 acp_382 (cost=0.00..6,879.26 rows=1,355 width=24) (actual time=58.813..58.813 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 271,255
413. 62.174 62.174 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151230 acp_383 (cost=0.00..7,247.03 rows=1,427 width=24) (actual time=62.174..62.174 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 286,113
414. 61.935 61.935 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20151231 acp_384 (cost=0.00..6,921.26 rows=1,365 width=24) (actual time=61.935..61.935 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 273,363
415. 52.834 52.834 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160101 acp_385 (cost=0.00..6,932.27 rows=1,368 width=24) (actual time=52.834..52.834 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 273,928
416. 44.976 44.976 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160102 acp_386 (cost=0.00..7,312.96 rows=1,443 width=24) (actual time=44.976..44.976 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 288,808
417. 56.542 56.542 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160103 acp_387 (cost=0.00..7,337.32 rows=1,444 width=24) (actual time=56.542..56.542 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 289,248
418. 58.843 58.843 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160104 acp_388 (cost=0.00..7,318.94 rows=1,440 width=24) (actual time=58.843..58.843 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 288,158
419. 66.325 66.325 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160105 acp_389 (cost=0.00..7,385.57 rows=1,452 width=24) (actual time=66.325..66.325 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 291,158
420. 91.909 91.909 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160106 acp_390 (cost=0.00..7,474.84 rows=1,471 width=24) (actual time=91.909..91.909 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 294,499
421. 63.318 63.318 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160107 acp_391 (cost=0.00..7,291.70 rows=1,432 width=24) (actual time=63.318..63.318 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 286,713
422. 74.614 74.614 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160108 acp_392 (cost=0.00..7,335.95 rows=1,437 width=24) (actual time=74.614..74.614 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 287,888
423. 68.034 68.034 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160109 acp_393 (cost=0.00..7,454.17 rows=1,459 width=24) (actual time=68.034..68.034 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 292,679
424. 61.783 61.783 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160110 acp_394 (cost=0.00..7,467.76 rows=1,462 width=24) (actual time=61.783..61.783 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 293,108
425. 56.436 56.436 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160111 acp_395 (cost=0.00..7,387.20 rows=1,448 width=24) (actual time=56.436..56.436 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 290,031
426. 64.171 64.171 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160112 acp_396 (cost=0.00..7,377.84 rows=1,446 width=24) (actual time=64.171..64.171 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 289,693
427. 67.000 67.000 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160113 acp_397 (cost=0.00..7,393.85 rows=1,448 width=24) (actual time=67.000..67.000 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 290,269
428. 69.410 69.410 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160114 acp_398 (cost=0.00..7,383.10 rows=1,445 width=24) (actual time=69.410..69.410 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 289,766
429. 65.037 65.037 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160115 acp_399 (cost=0.00..7,465.48 rows=1,462 width=24) (actual time=65.037..65.037 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 292,895
430. 64.145 64.145 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160116 acp_400 (cost=0.00..7,542.68 rows=1,479 width=24) (actual time=64.145..64.145 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 295,899
431. 69.624 69.624 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160117 acp_401 (cost=0.00..7,559.70 rows=1,483 width=24) (actual time=69.624..69.624 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 296,836
432. 66.005 66.005 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160118 acp_402 (cost=0.00..7,401.55 rows=1,448 width=24) (actual time=66.005..66.005 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 290,160
433. 85.599 85.599 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160119 acp_403 (cost=0.00..7,395.32 rows=1,445 width=24) (actual time=85.599..85.599 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 289,744
434. 66.073 66.073 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160120 acp_404 (cost=0.00..7,385.93 rows=1,448 width=24) (actual time=66.073..66.073 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 289,631
435. 54.122 54.122 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160121 acp_405 (cost=0.00..7,367.08 rows=1,442 width=24) (actual time=54.122..54.122 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 289,201
436. 60.692 60.692 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160122 acp_406 (cost=0.00..7,456.28 rows=1,462 width=24) (actual time=60.692..60.692 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 292,514
437. 74.135 74.135 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160123 acp_407 (cost=0.00..7,611.39 rows=1,492 width=24) (actual time=74.135..74.135 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 298,440
438. 69.767 69.767 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160124 acp_408 (cost=0.00..7,632.39 rows=1,496 width=24) (actual time=69.767..69.767 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 299,375
439. 52.797 52.797 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160125 acp_409 (cost=0.00..7,349.83 rows=1,444 width=24) (actual time=52.797..52.797 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 289,532
440. 66.964 66.964 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160126 acp_410 (cost=0.00..7,393.39 rows=1,457 width=24) (actual time=66.964..66.964 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 291,738
441. 64.498 64.498 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160127 acp_411 (cost=0.00..7,393.03 rows=1,457 width=24) (actual time=64.498..64.498 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 291,957
442. 60.622 60.622 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160128 acp_412 (cost=0.00..7,334.99 rows=1,446 width=24) (actual time=60.622..60.622 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 289,933
443. 52.531 52.531 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160129 acp_413 (cost=0.00..7,382.40 rows=1,456 width=24) (actual time=52.531..52.531 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 291,767
444. 64.990 64.990 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160130 acp_414 (cost=0.00..7,399.22 rows=1,459 width=24) (actual time=64.990..64.990 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 292,052
445. 64.913 64.913 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160131 acp_415 (cost=0.00..7,355.51 rows=1,451 width=24) (actual time=64.913..64.913 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 290,299
446. 62.342 62.342 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160201 acp_416 (cost=0.00..7,200.02 rows=1,419 width=24) (actual time=62.342..62.342 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 284,360
447. 60.506 60.506 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160202 acp_417 (cost=0.00..7,303.91 rows=1,438 width=24) (actual time=60.506..60.506 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 288,228
448. 56.472 56.472 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160203 acp_418 (cost=0.00..7,378.25 rows=1,453 width=24) (actual time=56.472..56.472 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 291,297
449. 64.314 64.314 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160204 acp_419 (cost=0.00..7,344.57 rows=1,448 width=24) (actual time=64.314..64.314 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 289,595
450. 54.839 54.839 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160205 acp_420 (cost=0.00..7,263.23 rows=1,431 width=24) (actual time=54.839..54.839 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 286,726
451. 62.964 62.964 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160206 acp_421 (cost=0.00..7,318.07 rows=1,441 width=24) (actual time=62.964..62.964 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 288,921
452. 60.091 60.091 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160207 acp_422 (cost=0.00..7,371.27 rows=1,451 width=24) (actual time=60.091..60.091 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 290,848
453. 72.122 72.122 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160208 acp_423 (cost=0.00..7,266.20 rows=1,432 width=24) (actual time=72.122..72.122 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 286,549
454. 51.281 51.281 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160209 acp_424 (cost=0.00..7,344.04 rows=1,449 width=24) (actual time=51.280..51.281 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 290,285
455. 53.933 53.933 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160210 acp_425 (cost=0.00..7,444.65 rows=1,469 width=24) (actual time=53.933..53.933 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 294,461
456. 60.112 60.112 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160211 acp_426 (cost=0.00..7,410.54 rows=1,463 width=23) (actual time=60.112..60.112 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 293,500
457. 53.132 53.132 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160212 acp_427 (cost=0.00..7,512.76 rows=1,485 width=23) (actual time=53.132..53.132 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 297,168
458. 52.869 52.869 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160213 acp_428 (cost=0.00..7,603.85 rows=1,502 width=23) (actual time=52.869..52.869 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 301,110
459. 51.089 51.089 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160214 acp_429 (cost=0.00..7,652.46 rows=1,513 width=23) (actual time=51.089..51.089 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 302,888
460. 57.309 57.309 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160215 acp_430 (cost=0.00..7,550.00 rows=1,493 width=23) (actual time=57.309..57.309 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 298,618
461. 59.602 59.602 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160216 acp_431 (cost=0.00..7,657.85 rows=1,514 width=23) (actual time=59.602..59.602 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 303,015
462. 57.617 57.617 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160217 acp_432 (cost=0.00..7,766.55 rows=1,538 width=23) (actual time=57.617..57.617 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 307,574
463. 60.826 60.826 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160218 acp_433 (cost=0.00..7,853.66 rows=1,554 width=23) (actual time=60.826..60.826 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 311,142
464. 57.341 57.341 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160219 acp_434 (cost=0.00..7,873.12 rows=1,556 width=23) (actual time=57.341..57.341 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 311,676
465. 62.312 62.312 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160220 acp_435 (cost=0.00..8,075.73 rows=1,596 width=23) (actual time=62.312..62.312 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 319,330
466. 60.813 60.813 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160221 acp_436 (cost=0.00..8,099.62 rows=1,601 width=23) (actual time=60.813..60.813 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 320,256
467. 54.936 54.936 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160222 acp_437 (cost=0.00..7,948.51 rows=1,571 width=23) (actual time=54.936..54.936 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 314,347
468. 62.902 62.902 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160223 acp_438 (cost=0.00..7,939.61 rows=1,569 width=23) (actual time=62.902..62.902 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 314,003
469. 88.270 88.270 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160224 acp_439 (cost=0.00..7,879.61 rows=1,557 width=23) (actual time=88.270..88.270 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 311,981
470. 74.338 74.338 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160225 acp_440 (cost=0.00..7,981.39 rows=1,579 width=23) (actual time=74.337..74.338 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 315,759
471. 61.071 61.071 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160226 acp_441 (cost=0.00..7,873.85 rows=1,549 width=24) (actual time=61.071..61.071 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 310,065
472. 56.963 56.963 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160227 acp_442 (cost=0.00..8,133.55 rows=1,596 width=24) (actual time=56.963..56.963 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 319,228
473. 54.484 54.484 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160228 acp_443 (cost=0.00..8,115.14 rows=1,592 width=24) (actual time=54.484..54.484 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 318,352
474. 58.416 58.416 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160229 acp_444 (cost=0.00..8,026.61 rows=1,572 width=24) (actual time=58.416..58.416 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 314,981
475. 54.673 54.673 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160301 acp_445 (cost=0.00..7,922.38 rows=1,556 width=24) (actual time=54.673..54.673 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 311,553
476. 57.787 57.787 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160302 acp_446 (cost=0.00..7,669.21 rows=1,516 width=23) (actual time=57.787..57.787 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 303,511
477. 52.301 52.301 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160303 acp_447 (cost=0.00..7,451.60 rows=1,471 width=24) (actual time=52.301..52.301 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 294,596
478. 53.158 53.158 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160304 acp_448 (cost=0.00..7,372.03 rows=1,453 width=24) (actual time=53.158..53.158 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 291,119
479. 54.936 54.936 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160305 acp_449 (cost=0.00..7,415.60 rows=1,461 width=24) (actual time=54.936..54.936 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 292,702
480. 46.770 46.770 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160306 acp_450 (cost=0.00..7,374.76 rows=1,454 width=24) (actual time=46.770..46.770 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 291,364
481. 56.262 56.262 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160307 acp_451 (cost=0.00..7,116.70 rows=1,403 width=24) (actual time=56.262..56.262 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 280,607
482. 57.878 57.878 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160308 acp_452 (cost=0.00..7,274.75 rows=1,431 width=24) (actual time=57.878..57.878 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 286,988
483. 59.568 59.568 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160309 acp_453 (cost=0.00..7,313.79 rows=1,440 width=24) (actual time=59.568..59.568 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 288,103
484. 48.920 48.920 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160310 acp_454 (cost=0.00..7,249.89 rows=1,427 width=24) (actual time=48.920..48.920 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 285,618
485. 60.922 60.922 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160311 acp_455 (cost=0.00..7,091.19 rows=1,396 width=24) (actual time=60.922..60.922 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 279,348
486. 57.739 57.739 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160312 acp_456 (cost=0.00..7,170.55 rows=1,412 width=24) (actual time=57.739..57.739 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 282,955
487. 45.251 45.251 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160313 acp_457 (cost=0.00..7,280.14 rows=1,435 width=24) (actual time=45.251..45.251 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 287,103
488. 47.281 47.281 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160314 acp_458 (cost=0.00..7,302.50 rows=1,440 width=24) (actual time=47.281..47.281 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 288,141
489. 50.528 50.528 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160315 acp_459 (cost=0.00..7,403.55 rows=1,460 width=24) (actual time=50.528..50.528 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 292,348
490. 51.098 51.098 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160316 acp_460 (cost=0.00..7,445.06 rows=1,467 width=24) (actual time=51.098..51.098 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 293,933
491. 62.121 62.121 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160317 acp_461 (cost=0.00..7,458.93 rows=1,469 width=24) (actual time=62.121..62.121 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 294,188
492. 53.423 53.423 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160318 acp_462 (cost=0.00..7,425.43 rows=1,462 width=24) (actual time=53.423..53.423 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 292,992
493. 57.044 57.044 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160319 acp_463 (cost=0.00..7,516.69 rows=1,480 width=24) (actual time=57.044..57.044 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 296,525
494. 53.610 53.610 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160320 acp_464 (cost=0.00..7,534.84 rows=1,483 width=24) (actual time=53.610..53.610 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 297,232
495. 54.885 54.885 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160321 acp_465 (cost=0.00..7,427.07 rows=1,464 width=24) (actual time=54.885..54.885 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 293,018
496. 55.118 55.118 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160322 acp_466 (cost=0.00..7,512.41 rows=1,479 width=24) (actual time=55.118..55.118 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 295,923
497. 56.881 56.881 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160323 acp_467 (cost=0.00..7,633.47 rows=1,502 width=24) (actual time=56.881..56.881 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 300,750
498. 52.299 52.299 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160324 acp_468 (cost=0.00..7,675.45 rows=1,511 width=24) (actual time=52.299..52.299 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 302,761
499. 55.635 55.635 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160325 acp_469 (cost=0.00..7,857.97 rows=1,549 width=24) (actual time=55.635..55.635 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 310,414
500. 56.399 56.399 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160326 acp_470 (cost=0.00..7,806.71 rows=1,538 width=24) (actual time=56.399..56.399 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 307,829
501. 68.984 68.984 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160327 acp_471 (cost=0.00..7,762.91 rows=1,529 width=24) (actual time=68.984..68.984 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 305,879
502. 67.883 67.883 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160328 acp_472 (cost=0.00..7,668.97 rows=1,511 width=24) (actual time=67.882..67.883 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 302,704
503. 58.298 58.298 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160329 acp_473 (cost=0.00..7,630.49 rows=1,505 width=24) (actual time=58.298..58.298 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 301,744
504. 63.913 63.913 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160330 acp_474 (cost=0.00..7,562.40 rows=1,492 width=24) (actual time=63.913..63.913 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 298,445
505. 50.807 50.807 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160331 acp_475 (cost=0.00..7,568.88 rows=1,493 width=24) (actual time=50.807..50.807 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 298,723
506. 54.507 54.507 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160401 acp_476 (cost=0.00..7,546.69 rows=1,487 width=24) (actual time=54.507..54.507 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 298,018
507. 54.949 54.949 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160402 acp_477 (cost=0.00..7,755.46 rows=1,530 width=24) (actual time=54.949..54.949 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 305,982
508. 47.034 47.034 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160403 acp_478 (cost=0.00..7,643.36 rows=1,506 width=24) (actual time=47.034..47.034 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 301,622
509. 58.738 58.738 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160404 acp_479 (cost=0.00..7,613.06 rows=1,501 width=24) (actual time=58.738..58.738 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 300,483
510. 62.048 62.048 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160405 acp_480 (cost=0.00..7,952.88 rows=1,567 width=24) (actual time=62.048..62.048 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 314,111
511. 53.091 53.091 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160406 acp_481 (cost=0.00..8,014.80 rows=1,579 width=24) (actual time=53.091..53.091 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 316,510
512. 0.009 0.044 ↓ 0.0 0 1

Bitmap Heap Scan on aggregated_compact_placements_20200812 acp_482 (cost=1.28..4.46 rows=3 width=66) (actual time=0.044..0.044 rows=0 loops=1)

  • Recheck Cond: ((a_date >= $12) AND (a_date <= $13))
513. 0.035 0.035 ↓ 0.0 0 1

Bitmap Index Scan on aggregated_compact_placements_20200812_pkey (cost=0.00..1.28 rows=3 width=0) (actual time=0.035..0.035 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
514. 52.346 52.346 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160407 acp_483 (cost=0.00..7,921.89 rows=1,561 width=24) (actual time=52.346..52.346 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 312,499
515. 0.431 0.431 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191104_pkey on aggregated_compact_placements_20191104 acp_484 (cost=0.42..1,425.68 rows=3,370 width=27) (actual time=0.431..0.431 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
516. 52.942 52.942 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160408 acp_485 (cost=0.00..7,939.77 rows=1,565 width=24) (actual time=52.942..52.942 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 313,259
517. 55.212 55.212 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160409 acp_486 (cost=0.00..8,107.41 rows=1,599 width=24) (actual time=55.212..55.212 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 319,851
518. 0.400 0.400 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191105_pkey on aggregated_compact_placements_20191105 acp_487 (cost=0.42..1,445.89 rows=3,418 width=27) (actual time=0.400..0.400 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
519. 47.279 47.279 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160410 acp_488 (cost=0.00..8,131.26 rows=1,603 width=24) (actual time=47.279..47.279 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 321,035
520. 65.150 65.150 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160411 acp_489 (cost=0.00..8,110.63 rows=1,599 width=24) (actual time=65.150..65.150 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 319,869
521. 55.970 55.970 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160412 acp_490 (cost=0.00..8,360.51 rows=1,648 width=24) (actual time=55.970..55.970 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 330,358
522. 0.373 0.373 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191106_pkey on aggregated_compact_placements_20191106 acp_491 (cost=0.42..1,450.94 rows=3,426 width=27) (actual time=0.373..0.373 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
523. 62.233 62.233 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160413 acp_492 (cost=0.00..8,395.94 rows=1,655 width=24) (actual time=62.233..62.233 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 331,742
524. 62.004 62.004 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160414 acp_493 (cost=0.00..8,359.92 rows=1,649 width=24) (actual time=62.004..62.004 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 330,097
525. 0.341 0.341 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191107_pkey on aggregated_compact_placements_20191107 acp_494 (cost=0.42..1,434.28 rows=3,391 width=27) (actual time=0.341..0.341 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
526. 60.652 60.652 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160415 acp_495 (cost=0.00..8,440.42 rows=1,665 width=24) (actual time=60.652..60.652 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 333,190
527. 61.870 61.870 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160416 acp_496 (cost=0.00..8,727.08 rows=1,721 width=24) (actual time=61.870..61.870 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 344,578
528. 0.332 0.332 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191108_pkey on aggregated_compact_placements_20191108 acp_497 (cost=0.42..1,422.51 rows=3,363 width=27) (actual time=0.332..0.332 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
529. 70.496 70.496 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160417 acp_498 (cost=0.00..8,791.36 rows=1,735 width=24) (actual time=70.496..70.496 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 347,249
530. 0.396 0.396 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191109_pkey on aggregated_compact_placements_20191109 acp_499 (cost=0.42..1,464.19 rows=3,463 width=27) (actual time=0.396..0.396 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
531. 65.444 65.444 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160418 acp_500 (cost=0.00..8,592.24 rows=1,695 width=24) (actual time=65.444..65.444 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 339,259
532. 67.230 67.230 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160419 acp_501 (cost=0.00..8,615.42 rows=1,698 width=24) (actual time=67.230..67.230 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 340,283
533. 0.426 0.426 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191110_pkey on aggregated_compact_placements_20191110 acp_502 (cost=0.42..1,477.85 rows=3,496 width=27) (actual time=0.425..0.426 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
534. 67.334 67.334 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160420 acp_503 (cost=0.00..8,754.75 rows=1,725 width=24) (actual time=67.334..67.334 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 345,839
535. 0.389 0.389 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191111_pkey on aggregated_compact_placements_20191111 acp_504 (cost=0.42..1,427.64 rows=3,372 width=27) (actual time=0.389..0.389 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
536. 0.304 0.304 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191112_pkey on aggregated_compact_placements_20191112 acp_505 (cost=0.42..1,431.75 rows=3,385 width=27) (actual time=0.304..0.304 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
537. 64.363 64.363 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160421 acp_506 (cost=0.00..8,502.94 rows=1,676 width=24) (actual time=64.363..64.363 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 335,553
538. 0.339 0.339 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191113_pkey on aggregated_compact_placements_20191113 acp_507 (cost=0.42..1,421.01 rows=3,360 width=27) (actual time=0.339..0.339 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
539. 60.999 60.999 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160422 acp_508 (cost=0.00..8,250.06 rows=1,625 width=24) (actual time=60.999..60.999 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 325,698
540. 0.353 0.353 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191114_pkey on aggregated_compact_placements_20191114 acp_509 (cost=0.42..1,450.44 rows=3,425 width=27) (actual time=0.353..0.353 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
541. 0.336 0.336 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191115_pkey on aggregated_compact_placements_20191115 acp_510 (cost=0.42..1,458.06 rows=3,445 width=27) (actual time=0.336..0.336 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
542. 50.617 50.617 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160423 acp_511 (cost=0.00..8,285.80 rows=1,632 width=24) (actual time=50.617..50.617 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 327,066
543. 0.410 0.410 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191116_pkey on aggregated_compact_placements_20191116 acp_512 (cost=0.42..1,462.61 rows=3,456 width=27) (actual time=0.410..0.410 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
544. 62.653 62.653 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160424 acp_513 (cost=0.00..8,305.35 rows=1,635 width=24) (actual time=62.653..62.653 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 327,644
545. 0.364 0.364 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191117_pkey on aggregated_compact_placements_20191117 acp_514 (cost=0.42..1,463.09 rows=3,456 width=27) (actual time=0.364..0.364 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
546. 60.371 60.371 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160425 acp_515 (cost=0.00..8,346.22 rows=1,643 width=24) (actual time=60.371..60.371 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 329,263
547. 0.458 0.458 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191118_pkey on aggregated_compact_placements_20191118 acp_516 (cost=0.42..1,442.32 rows=3,408 width=27) (actual time=0.458..0.458 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
548. 67.936 67.936 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160426 acp_517 (cost=0.00..8,524.36 rows=1,679 width=24) (actual time=67.936..67.936 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 336,224
549. 0.317 0.317 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191119_pkey on aggregated_compact_placements_20191119 acp_518 (cost=0.42..1,429.72 rows=3,380 width=27) (actual time=0.317..0.317 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
550. 65.377 65.377 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160427 acp_519 (cost=0.00..8,511.90 rows=1,678 width=24) (actual time=65.377..65.377 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 335,851
551. 64.818 64.818 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160428 acp_520 (cost=0.00..8,440.80 rows=1,663 width=24) (actual time=64.818..64.818 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 333,008
552. 64.960 64.960 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160429 acp_521 (cost=0.00..8,400.72 rows=1,655 width=24) (actual time=64.960..64.960 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 331,715
553. 0.471 0.471 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191120_pkey on aggregated_compact_placements_20191120 acp_522 (cost=0.42..1,438.81 rows=3,401 width=27) (actual time=0.471..0.471 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
554. 64.373 64.373 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160430 acp_523 (cost=0.00..8,516.63 rows=1,678 width=24) (actual time=64.373..64.373 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 335,986
555. 61.161 61.161 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160501 acp_524 (cost=0.00..8,552.21 rows=1,684 width=24) (actual time=61.161..61.161 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 337,550
556. 63.642 63.642 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160502 acp_525 (cost=0.00..8,594.08 rows=1,692 width=24) (actual time=63.642..63.642 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 338,720
557. 67.239 67.239 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160503 acp_526 (cost=0.00..8,683.14 rows=1,710 width=24) (actual time=67.239..67.239 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 342,108
558. 0.390 0.390 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191121_pkey on aggregated_compact_placements_20191121 acp_527 (cost=0.42..1,434.26 rows=3,390 width=27) (actual time=0.390..0.390 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
559. 65.149 65.149 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160504 acp_528 (cost=0.00..8,674.97 rows=1,707 width=24) (actual time=65.149..65.149 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 342,150
560. 65.961 65.961 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160505 acp_529 (cost=0.00..8,587.61 rows=1,692 width=24) (actual time=65.961..65.961 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 338,649
561. 71.829 71.829 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160506 acp_530 (cost=0.00..8,496.04 rows=1,674 width=24) (actual time=71.829..71.829 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 335,549
562. 0.427 0.427 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191122_pkey on aggregated_compact_placements_20191122 acp_531 (cost=0.42..1,457.54 rows=3,443 width=27) (actual time=0.427..0.427 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
563. 71.642 71.642 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160507 acp_532 (cost=0.00..8,698.36 rows=1,714 width=24) (actual time=71.642..71.642 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 343,636
564. 70.504 70.504 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160508 acp_533 (cost=0.00..8,686.85 rows=1,712 width=24) (actual time=70.504..70.504 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 342,633
565. 76.864 76.864 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160509 acp_534 (cost=0.00..8,573.03 rows=1,690 width=24) (actual time=76.864..76.864 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 338,542
566. 0.417 0.417 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191123_pkey on aggregated_compact_placements_20191123 acp_535 (cost=0.42..1,511.29 rows=3,569 width=27) (actual time=0.417..0.417 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
567. 74.118 74.118 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160510 acp_536 (cost=0.00..8,596.41 rows=1,694 width=24) (actual time=74.118..74.118 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 339,469
568. 73.432 73.432 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160511 acp_537 (cost=0.00..8,542.55 rows=1,685 width=24) (actual time=73.432..73.432 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 337,452
569. 76.134 76.134 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160512 acp_538 (cost=0.00..8,641.50 rows=1,704 width=24) (actual time=76.134..76.134 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 341,240
570. 73.558 73.558 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160513 acp_539 (cost=0.00..8,629.42 rows=1,700 width=24) (actual time=73.558..73.558 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 340,633
571. 0.429 0.429 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191124_pkey on aggregated_compact_placements_20191124 acp_540 (cost=0.42..1,506.75 rows=3,559 width=27) (actual time=0.428..0.429 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
572. 74.143 74.143 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160514 acp_541 (cost=0.00..8,827.15 rows=1,741 width=24) (actual time=74.143..74.143 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 348,602
573. 74.543 74.543 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160515 acp_542 (cost=0.00..8,873.47 rows=1,750 width=24) (actual time=74.543..74.543 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 350,310
574. 0.374 0.374 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191125_pkey on aggregated_compact_placements_20191125 acp_543 (cost=0.42..1,474.72 rows=3,484 width=27) (actual time=0.374..0.374 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
575. 55.342 55.342 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160516 acp_544 (cost=0.00..8,773.42 rows=1,729 width=24) (actual time=55.342..55.342 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 346,603
576. 60.856 60.856 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160517 acp_545 (cost=0.00..8,831.13 rows=1,741 width=24) (actual time=60.856..60.856 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 348,789
577. 57.435 57.435 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160518 acp_546 (cost=0.00..8,840.06 rows=1,742 width=24) (actual time=57.435..57.435 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 348,948
578. 0.397 0.397 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191126_pkey on aggregated_compact_placements_20191126 acp_547 (cost=0.42..1,508.78 rows=3,564 width=27) (actual time=0.397..0.397 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
579. 78.861 78.861 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160519 acp_548 (cost=0.00..8,773.62 rows=1,731 width=24) (actual time=78.860..78.861 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 346,378
580. 110.652 110.652 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160520 acp_549 (cost=0.00..8,786.52 rows=1,734 width=24) (actual time=110.652..110.652 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 347,353
581. 0.418 0.418 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191127_pkey on aggregated_compact_placements_20191127 acp_550 (cost=0.42..1,510.23 rows=3,571 width=27) (actual time=0.418..0.418 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
582. 69.298 69.298 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160521 acp_551 (cost=0.00..8,884.06 rows=1,753 width=24) (actual time=69.298..69.298 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 351,266
583. 69.155 69.155 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160522 acp_552 (cost=0.00..8,933.90 rows=1,763 width=24) (actual time=69.154..69.155 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 352,746
584. 0.483 0.483 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191128_pkey on aggregated_compact_placements_20191128 acp_553 (cost=0.42..1,507.18 rows=3,563 width=27) (actual time=0.483..0.483 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
585. 61.718 61.718 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160523 acp_554 (cost=0.00..8,889.97 rows=1,753 width=24) (actual time=61.718..61.718 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 351,232
586. 81.839 81.839 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160524 acp_555 (cost=0.00..8,953.67 rows=1,767 width=24) (actual time=81.839..81.839 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 353,900
587. 75.621 75.621 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160525 acp_556 (cost=0.00..8,967.32 rows=1,770 width=24) (actual time=75.621..75.621 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 354,115
588. 0.393 0.393 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191129_pkey on aggregated_compact_placements_20191129 acp_557 (cost=0.42..1,486.95 rows=3,514 width=27) (actual time=0.393..0.393 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
589. 67.710 67.710 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160526 acp_558 (cost=0.00..8,923.86 rows=1,761 width=24) (actual time=67.710..67.710 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 352,722
590. 65.788 65.788 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160527 acp_559 (cost=0.00..9,012.14 rows=1,779 width=24) (actual time=65.788..65.788 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 356,245
591. 0.339 0.339 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191130_pkey on aggregated_compact_placements_20191130 acp_560 (cost=0.42..1,519.41 rows=3,590 width=27) (actual time=0.339..0.339 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
592. 60.596 60.596 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160528 acp_561 (cost=0.00..9,053.38 rows=1,788 width=24) (actual time=60.596..60.596 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 358,201
593. 67.666 67.666 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160529 acp_562 (cost=0.00..9,066.42 rows=1,791 width=24) (actual time=67.666..67.666 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 358,701
594. 63.720 63.720 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160530 acp_563 (cost=0.00..9,081.67 rows=1,795 width=23) (actual time=63.720..63.720 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 359,365
595. 0.423 0.423 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191201_pkey on aggregated_compact_placements_20191201 acp_564 (cost=0.42..1,538.19 rows=3,635 width=27) (actual time=0.423..0.423 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
596. 81.147 81.147 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160531 acp_565 (cost=0.00..9,082.58 rows=1,796 width=23) (actual time=81.147..81.147 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 359,726
597. 0.445 0.445 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191202_pkey on aggregated_compact_placements_20191202 acp_566 (cost=0.42..1,491.02 rows=3,525 width=27) (actual time=0.445..0.445 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
598. 91.178 91.178 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160601 acp_567 (cost=0.00..9,120.59 rows=1,805 width=23) (actual time=91.177..91.178 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 361,113
599. 62.786 62.786 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160602 acp_568 (cost=0.00..9,099.42 rows=1,799 width=23) (actual time=62.786..62.786 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 360,674
600. 0.405 0.405 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191203_pkey on aggregated_compact_placements_20191203 acp_569 (cost=0.42..1,483.38 rows=3,508 width=27) (actual time=0.405..0.405 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
601. 100.237 100.237 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160603 acp_570 (cost=0.00..9,112.30 rows=1,803 width=23) (actual time=100.237..100.237 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 360,773
602. 0.935 0.935 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191204_pkey on aggregated_compact_placements_20191204 acp_571 (cost=0.42..1,509.82 rows=3,568 width=27) (actual time=0.935..0.935 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
603. 85.114 85.114 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160604 acp_572 (cost=0.00..9,104.53 rows=1,800 width=23) (actual time=85.114..85.114 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 360,806
604. 70.060 70.060 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160605 acp_573 (cost=0.00..9,044.98 rows=1,789 width=23) (actual time=70.060..70.060 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 358,380
605. 76.350 76.350 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160606 acp_574 (cost=0.00..8,928.31 rows=1,766 width=23) (actual time=76.350..76.350 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 353,842
606. 71.907 71.907 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160607 acp_575 (cost=0.00..8,959.48 rows=1,772 width=23) (actual time=71.907..71.907 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 355,170
607. 0.425 0.425 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191205_pkey on aggregated_compact_placements_20191205 acp_576 (cost=0.42..1,499.72 rows=3,544 width=27) (actual time=0.425..0.425 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
608. 82.691 82.691 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160608 acp_577 (cost=0.00..8,988.92 rows=1,779 width=23) (actual time=82.691..82.691 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 356,155
609. 74.151 74.151 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160609 acp_578 (cost=0.00..9,107.92 rows=1,803 width=23) (actual time=74.151..74.151 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 361,057
610. 0.436 0.436 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191206_pkey on aggregated_compact_placements_20191206 acp_579 (cost=0.42..1,507.72 rows=3,566 width=27) (actual time=0.436..0.436 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
611. 73.304 73.304 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160610 acp_580 (cost=0.00..8,971.61 rows=1,777 width=23) (actual time=73.304..73.304 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 355,468
612. 69.137 69.137 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160611 acp_581 (cost=0.00..9,014.44 rows=1,784 width=23) (actual time=69.137..69.137 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 357,397
613. 0.364 0.364 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191207_pkey on aggregated_compact_placements_20191207 acp_582 (cost=0.42..1,560.97 rows=3,691 width=27) (actual time=0.364..0.364 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
614. 70.309 70.309 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160612 acp_583 (cost=0.00..8,966.94 rows=1,774 width=23) (actual time=70.309..70.309 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 355,314
615. 79.916 79.916 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160613 acp_584 (cost=0.00..9,009.53 rows=1,783 width=23) (actual time=79.915..79.916 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 356,943
616. 81.445 81.445 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160614 acp_585 (cost=0.00..8,989.24 rows=1,779 width=23) (actual time=81.445..81.445 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 356,292
617. 75.127 75.127 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160615 acp_586 (cost=0.00..9,131.47 rows=1,808 width=23) (actual time=75.127..75.127 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 361,716
618. 0.433 0.433 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191208_pkey on aggregated_compact_placements_20191208 acp_587 (cost=0.42..1,550.34 rows=3,665 width=27) (actual time=0.433..0.433 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
619. 78.983 78.983 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160616 acp_588 (cost=0.00..9,256.64 rows=1,833 width=23) (actual time=78.983..78.983 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 367,080
620. 77.509 77.509 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160617 acp_589 (cost=0.00..9,240.42 rows=1,830 width=23) (actual time=77.509..77.509 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 366,388
621. 70.584 70.584 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160618 acp_590 (cost=0.00..9,282.13 rows=1,838 width=23) (actual time=70.584..70.584 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 368,289
622. 0.384 0.384 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191209_pkey on aggregated_compact_placements_20191209 acp_591 (cost=0.42..1,517.40 rows=3,586 width=27) (actual time=0.384..0.384 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
623. 73.795 73.795 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160619 acp_592 (cost=0.00..9,339.39 rows=1,851 width=23) (actual time=73.795..73.795 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 370,384
624. 53.811 53.811 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160620 acp_593 (cost=0.00..9,384.02 rows=1,860 width=23) (actual time=53.811..53.811 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 372,581
625. 67.745 67.745 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160621 acp_594 (cost=0.00..9,513.08 rows=1,887 width=23) (actual time=67.745..67.745 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 377,535
626. 67.881 67.881 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160622 acp_595 (cost=0.00..9,469.20 rows=1,878 width=23) (actual time=67.880..67.881 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 376,436
627. 0.846 0.846 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191210_pkey on aggregated_compact_placements_20191210 acp_596 (cost=0.42..1,558.92 rows=3,685 width=27) (actual time=0.846..0.846 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
628. 69.875 69.875 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160623 acp_597 (cost=0.00..9,314.74 rows=1,847 width=23) (actual time=69.875..69.875 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 370,196
629. 71.228 71.228 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160624 acp_598 (cost=0.00..9,106.40 rows=1,805 width=23) (actual time=71.228..71.228 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 361,534
630. 0.391 0.391 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191211_pkey on aggregated_compact_placements_20191211 acp_599 (cost=0.42..1,546.29 rows=3,655 width=27) (actual time=0.391..0.391 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
631. 63.536 63.536 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160625 acp_600 (cost=0.00..9,072.83 rows=1,799 width=23) (actual time=63.536..63.536 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 359,722
632. 73.795 73.795 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160626 acp_601 (cost=0.00..9,048.30 rows=1,792 width=23) (actual time=73.795..73.795 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 358,911
633. 63.129 63.129 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160627 acp_602 (cost=0.00..9,143.61 rows=1,811 width=23) (actual time=63.129..63.129 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 362,295
634. 66.434 66.434 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160628 acp_603 (cost=0.00..9,023.50 rows=1,786 width=23) (actual time=66.434..66.434 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 357,208
635. 0.401 0.401 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191212_pkey on aggregated_compact_placements_20191212 acp_604 (cost=0.42..1,526.57 rows=3,607 width=27) (actual time=0.401..0.401 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
636. 206.691 206.691 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160629 acp_605 (cost=0.00..8,968.40 rows=1,777 width=23) (actual time=206.691..206.691 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 355,396
637. 171.004 171.004 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160630 acp_606 (cost=0.00..8,957.74 rows=1,775 width=23) (actual time=171.004..171.004 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 354,925
638. 0.996 0.996 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191213_pkey on aggregated_compact_placements_20191213 acp_607 (cost=0.42..1,507.18 rows=3,563 width=27) (actual time=0.996..0.996 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
639. 88.604 88.604 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160701 acp_608 (cost=0.00..8,873.99 rows=1,754 width=23) (actual time=88.604..88.604 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 351,282
640. 79.296 79.296 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160702 acp_609 (cost=0.00..8,965.19 rows=1,771 width=24) (actual time=79.296..79.296 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 354,258
641. 74.830 74.830 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160703 acp_610 (cost=0.00..9,041.97 rows=1,786 width=24) (actual time=74.830..74.830 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 357,446
642. 0.424 0.424 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191214_pkey on aggregated_compact_placements_20191214 acp_611 (cost=0.42..1,554.86 rows=3,674 width=27) (actual time=0.424..0.424 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
643. 73.186 73.186 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160704 acp_612 (cost=0.00..8,954.40 rows=1,769 width=24) (actual time=73.186..73.186 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 353,886
644. 71.372 71.372 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160705 acp_613 (cost=0.00..8,912.90 rows=1,761 width=24) (actual time=71.372..71.372 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 352,352
645. 71.810 71.810 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160706 acp_614 (cost=0.00..9,142.74 rows=1,806 width=24) (actual time=71.810..71.810 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 361,548
646. 70.723 70.723 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160707 acp_615 (cost=0.00..9,221.29 rows=1,821 width=24) (actual time=70.723..70.723 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 364,583
647. 0.375 0.375 ↓ 0.0 0 1

Index Scan using aggregated_compact_placements_20191215_pkey on aggregated_compact_placements_20191215 acp_616 (cost=0.42..1,573.62 rows=3,718 width=27) (actual time=0.375..0.375 rows=0 loops=1)

  • Index Cond: ((a_date >= $12) AND (a_date <= $13))
648. 72.236 72.236 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160708 acp_617 (cost=0.00..9,132.93 rows=1,804 width=24) (actual time=72.236..72.236 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 361,278
649. 76.874 76.874 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160709 acp_618 (cost=0.00..9,115.43 rows=1,800 width=24) (actual time=76.874..76.874 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 360,542
650. 66.430 66.430 ↓ 0.0 0 1

Seq Scan on aggregated_compact_placements_20160710 acp_619 (cost=0.00..9,239.01 rows=1,824