explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9FCv

Settings
# exclusive inclusive rows x rows loops node
1. 610,215.839 610,215.839 ↑ 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=607,699.012..610,215.839 rows=5,599 loops=1)

  • Hash Cond: (tpi.placement_id = t_stat.placement_id)
2.          

CTE t_raw_params

3. 0.281 0.281 ↑ 1.0 1 1

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

4.          

CTE t_params

5. 0.286 0.286 ↑ 1.0 1 1

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

6.          

CTE t_lost_placements

7. 1,228.584 397,824.458 ↓ 1,332.6 266,517 1

GroupAggregate (cost=2,608.53..2,804.53 rows=200 width=5) (actual time=381,100.812..397,824.458 rows=266,517 loops=1)

  • Group Key: ch.id_placement
8. 7,268.084 396,595.874 ↓ 5,426.9 5,426,872 1

WindowAgg (cost=2,608.53..2,651.03 rows=1,000 width=176) (actual time=381,100.751..396,595.874 rows=5,426,872 loops=1)

9. 6,947.874 389,327.790 ↓ 5,426.9 5,426,872 1

WindowAgg (cost=2,608.53..2,631.03 rows=1,000 width=112) (actual time=381,100.728..389,327.790 rows=5,426,872 loops=1)

10. 6,434.831 382,379.916 ↓ 5,426.9 5,426,872 1

Sort (cost=2,608.53..2,611.03 rows=1,000 width=48) (actual time=381,100.021..382,379.916 rows=5,426,872 loops=1)

  • Sort Key: ch.id_placement, ch.a_date
  • Sort Method: external merge Disk: 198,600kB
11. 2,821.428 375,945.085 ↓ 5,426.9 5,426,872 1

Nested Loop Left Join (cost=0.93..2,558.70 rows=1,000 width=48) (actual time=345,161.045..375,945.085 rows=5,426,872 loops=1)

12. 345,989.297 345,989.297 ↓ 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=345,160.950..345,989.297 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,070.647 186,265.241 ↑ 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,447.894..186,265.241 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.003 0.003 ↑ 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.003 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.003 0.003 ↑ 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.003 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.007 0.007 ↑ 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.007 rows=1 loops=1)

25. 0.291 0.291 ↑ 1.0 1 1

CTE Scan on t_params t_params_8 (cost=0.00..0.02 rows=1 width=4) (actual time=0.291..0.291 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,443.620 176,194.274 ↓ 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,447.808..176,194.274 rows=17,531,199 loops=1)

  • Sort Key: acp.placement_id, acp.country, tsc.code
  • Sort Method: external merge Disk: 641,728kB
28. 3,997.425 157,750.654 ↓ 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,990.681..157,750.654 rows=17,531,199 loops=1)

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

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

30. 0.022 0.022 ↓ 0.0 0 1

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

  • Filter: ((a_date >= $12) AND (a_date <= $13))
31. 0.006 0.006 ↓ 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.006..0.006 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.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
34. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
35. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
36. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
37. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
38. 0.008 0.008 ↓ 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.008..0.008 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.006 0.006 ↓ 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.006 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
41. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
42. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

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

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

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 137
44. 14.797 14.797 ↓ 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=14.797..14.797 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 83,774
45. 17.382 17.382 ↓ 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=17.382..17.382 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 95,049
46. 19.990 19.990 ↓ 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=19.990..19.990 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 95,765
47. 17.009 17.009 ↓ 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=17.009..17.009 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 94,277
48. 34.714 34.714 ↓ 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=34.714..34.714 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 96,954
49. 21.212 21.212 ↓ 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=21.212..21.212 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 92,934
50. 23.041 23.041 ↓ 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=23.041..23.041 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 95,643
51. 20.170 20.170 ↓ 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=20.170..20.170 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 96,260
52. 20.888 20.888 ↓ 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=20.888..20.888 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 97,175
53. 21.938 21.938 ↓ 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=21.938..21.938 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 99,032
54. 21.658 21.658 ↓ 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=21.658..21.658 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 98,113
55. 23.072 23.072 ↓ 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=23.072..23.072 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 97,084
56. 22.707 22.707 ↓ 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=22.707..22.707 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 96,562
57. 20.548 20.548 ↓ 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=20.548..20.548 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 96,459
58. 25.922 25.922 ↓ 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=25.922..25.922 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 95,135
59. 20.635 20.635 ↓ 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=20.635..20.635 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 98,395
60. 20.807 20.807 ↓ 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=20.807..20.807 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 99,318
61. 23.205 23.205 ↓ 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=23.205..23.205 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 98,624
62. 21.857 21.857 ↓ 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=21.857..21.857 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 99,179
63. 22.045 22.045 ↓ 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=22.045..22.045 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 99,599
64. 19.310 19.310 ↓ 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=19.310..19.310 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 101,786
65. 20.571 20.571 ↓ 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=20.571..20.571 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 101,219
66. 21.883 21.883 ↓ 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=21.883..21.883 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 103,317
67. 22.426 22.426 ↓ 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=22.426..22.426 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 103,479
68. 21.303 21.303 ↓ 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=21.303..21.303 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 101,523
69. 22.772 22.772 ↓ 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=22.772..22.772 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 101,914
70. 21.967 21.967 ↓ 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=21.967..21.967 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 103,231
71. 22.505 22.505 ↓ 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=22.505..22.505 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 103,481
72. 22.459 22.459 ↓ 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=22.459..22.459 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 105,911
73. 22.873 22.873 ↓ 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=22.873..22.873 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 107,412
74. 22.100 22.100 ↓ 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=22.100..22.100 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 107,320
75. 22.416 22.416 ↓ 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=22.416..22.416 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 107,221
76. 24.421 24.421 ↓ 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=24.421..24.421 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 105,526
77. 21.678 21.678 ↓ 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=21.678..21.678 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 107,205
78. 20.822 20.822 ↓ 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=20.822..20.822 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 106,185
79. 19.946 19.946 ↓ 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=19.946..19.946 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 106,130
80. 23.002 23.002 ↓ 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=23.002..23.002 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 107,489
81. 34.704 34.704 ↓ 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=34.704..34.704 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 108,460
82. 20.901 20.901 ↓ 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=20.901..20.901 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 105,623
83. 22.137 22.137 ↓ 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=22.137..22.137 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 106,346
84. 21.286 21.286 ↓ 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=21.286..21.286 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 105,464
85. 21.753 21.753 ↓ 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=21.753..21.753 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 105,673
86. 23.056 23.056 ↓ 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=23.055..23.056 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 106,375
87. 22.894 22.894 ↓ 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=22.894..22.894 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 109,167
88. 22.612 22.612 ↓ 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=22.612..22.612 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 109,625
89. 22.378 22.378 ↓ 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=22.378..22.378 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 109,795
90. 21.129 21.129 ↓ 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=21.129..21.129 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 108,326
91. 21.574 21.574 ↓ 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=21.574..21.574 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 110,250
92. 21.335 21.335 ↓ 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=21.335..21.335 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 109,240
93. 22.658 22.658 ↓ 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=22.658..22.658 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 111,365
94. 22.517 22.517 ↓ 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=22.517..22.517 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 113,935
95. 22.946 22.946 ↓ 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=22.946..22.946 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 112,701
96. 25.403 25.403 ↓ 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=25.403..25.403 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 114,151
97. 24.929 24.929 ↓ 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=24.928..24.929 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 116,729
98. 27.546 27.546 ↓ 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=27.545..27.546 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 116,367
99. 34.237 34.237 ↓ 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=34.237..34.237 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 114,088
100. 23.688 23.688 ↓ 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=23.688..23.688 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 112,623
101. 28.549 28.549 ↓ 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=28.549..28.549 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 113,338
102. 26.956 26.956 ↓ 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=26.956..26.956 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 111,818
103. 26.155 26.155 ↓ 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=26.155..26.155 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 112,446
104. 26.535 26.535 ↓ 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=26.535..26.535 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 119,794
105. 28.330 28.330 ↓ 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=28.330..28.330 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 114,778
106. 21.364 21.364 ↓ 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=21.364..21.364 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 115,589
107. 24.624 24.624 ↓ 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=24.624..24.624 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 116,048
108. 24.869 24.869 ↓ 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=24.869..24.869 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 118,679
109. 26.330 26.330 ↓ 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=26.330..26.330 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 119,115
110. 31.815 31.815 ↓ 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=31.815..31.815 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 116,438
111. 26.525 26.525 ↓ 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=26.525..26.525 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 117,714
112. 35.268 35.268 ↓ 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=35.268..35.268 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 120,523
113. 27.192 27.192 ↓ 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=27.192..27.192 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 119,779
114. 28.854 28.854 ↓ 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=28.854..28.854 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 118,840
115. 27.659 27.659 ↓ 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=27.659..27.659 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 122,502
116. 28.095 28.095 ↓ 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=28.095..28.095 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 121,996
117. 27.319 27.319 ↓ 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=27.319..27.319 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 115,514
118. 33.707 33.707 ↓ 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=33.707..33.707 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 121,170
119. 38.037 38.037 ↓ 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=38.037..38.037 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 122,379
120. 46.041 46.041 ↓ 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=46.041..46.041 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 122,803
121. 40.805 40.805 ↓ 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=40.805..40.805 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,413
122. 26.994 26.994 ↓ 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=26.994..26.994 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,208
123. 35.579 35.579 ↓ 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=35.578..35.579 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,539
124. 26.911 26.911 ↓ 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=26.911..26.911 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,612
125. 23.070 23.070 ↓ 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=23.070..23.070 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 124,329
126. 30.545 30.545 ↓ 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=30.545..30.545 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 125,078
127. 28.781 28.781 ↓ 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=28.781..28.781 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 124,090
128. 26.889 26.889 ↓ 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=26.889..26.889 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,676
129. 27.357 27.357 ↓ 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=27.357..27.357 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 124,810
130. 53.634 53.634 ↓ 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=53.634..53.634 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,751
131. 20.496 20.496 ↓ 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=20.496..20.496 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 121,679
132. 23.241 23.241 ↓ 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=23.241..23.241 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,042
133. 20.521 20.521 ↓ 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=20.521..20.521 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 121,203
134. 20.032 20.032 ↓ 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=20.032..20.032 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 124,186
135. 29.449 29.449 ↓ 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=29.449..29.449 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 122,700
136. 27.667 27.667 ↓ 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=27.667..27.667 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 124,240
137. 27.939 27.939 ↓ 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=27.939..27.939 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,386
138. 28.726 28.726 ↓ 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=28.726..28.726 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,442
139. 35.447 35.447 ↓ 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=35.447..35.447 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,855
140. 24.241 24.241 ↓ 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=24.241..24.241 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 110,937
141. 26.245 26.245 ↓ 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=26.245..26.245 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 121,284
142. 27.662 27.662 ↓ 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=27.662..27.662 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 123,253
143. 37.692 37.692 ↓ 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=37.692..37.692 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 125,840
144. 34.120 34.120 ↓ 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=34.120..34.120 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,372
145. 26.702 26.702 ↓ 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=26.702..26.702 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,554
146. 25.720 25.720 ↓ 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=25.720..25.720 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 125,264
147. 27.169 27.169 ↓ 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=27.169..27.169 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,150
148. 32.633 32.633 ↓ 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=32.633..32.633 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 122,236
149. 27.055 27.055 ↓ 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=27.055..27.055 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 125,176
150. 27.925 27.925 ↓ 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=27.925..27.925 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,231
151. 32.264 32.264 ↓ 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=32.264..32.264 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,571
152. 30.131 30.131 ↓ 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=30.131..30.131 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,632
153. 28.457 28.457 ↓ 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=28.457..28.457 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 128,531
154. 28.846 28.846 ↓ 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=28.846..28.846 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 128,754
155. 28.329 28.329 ↓ 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=28.329..28.329 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,815
156. 29.994 29.994 ↓ 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=29.994..29.994 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 130,597
157. 28.094 28.094 ↓ 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=28.094..28.094 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 133,568
158. 21.831 21.831 ↓ 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=21.831..21.831 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,205
159. 21.035 21.035 ↓ 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=21.035..21.035 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 130,627
160. 28.219 28.219 ↓ 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=28.219..28.219 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,533
161. 28.402 28.402 ↓ 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=28.402..28.402 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 134,320
162. 23.120 23.120 ↓ 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=23.120..23.120 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,646
163. 23.766 23.766 ↓ 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=23.766..23.766 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 129,542
164. 30.566 30.566 ↓ 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=30.566..30.566 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 130,983
165. 36.830 36.830 ↓ 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=36.829..36.830 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,253
166. 34.932 34.932 ↓ 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=34.932..34.932 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 129,160
167. 37.004 37.004 ↓ 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=37.004..37.004 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 130,108
168. 27.146 27.146 ↓ 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=27.146..27.146 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 128,788
169. 26.111 26.111 ↓ 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=26.111..26.111 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 126,783
170. 21.133 21.133 ↓ 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=21.133..21.133 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 127,159
171. 27.115 27.115 ↓ 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=27.115..27.115 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 130,582
172. 31.323 31.323 ↓ 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=31.323..31.323 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,315
173. 25.760 25.760 ↓ 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=25.760..25.760 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 128,257
174. 25.709 25.709 ↓ 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=25.709..25.709 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,444
175. 21.171 21.171 ↓ 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=21.171..21.171 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 133,259
176. 27.980 27.980 ↓ 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=27.980..27.980 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,131
177. 27.880 27.880 ↓ 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=27.880..27.880 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,359
178. 31.439 31.439 ↓ 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=31.439..31.439 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 135,454
179. 27.806 27.806 ↓ 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=27.805..27.806 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 134,032
180. 31.105 31.105 ↓ 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=31.105..31.105 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 131,568
181. 23.786 23.786 ↓ 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=23.786..23.786 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,960
182. 22.276 22.276 ↓ 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=22.276..22.276 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 133,858
183. 22.528 22.528 ↓ 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=22.528..22.528 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 133,673
184. 27.729 27.729 ↓ 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=27.729..27.729 rows=0 loops=1)

  • Filter: ((a_date >= $12) AND (a_date <= $13))
  • Rows Removed by Filter: 132,601
185. 28.063 28.063 ↓ 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=28.063..28.063 rows=0 loops=1)