explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hkeO

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 20.328 7,292.531 ↑ 2.7 61,429 1

Sort (cost=514,434.59..514,848.36 rows=165,508 width=80) (actual time=7,289.040..7,292.531 rows=61,429 loops=1)

  • Sort Key: cr.date_time
  • Sort Method: quicksort Memory: 10175kB
  • Functions: 560
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 110.757 ms, Inlining 28.595 ms, Optimization 4409.715 ms, Emission 2712.107 ms, Total 7261.174 ms
2. 3.782 7,272.203 ↑ 2.7 61,429 1

Append (cost=5.11..500,087.90 rows=165,508 width=80) (actual time=7,161.463..7,272.203 rows=61,429 loops=1)

3. 0.003 0.025 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201006 cr (cost=5.11..694.62 rows=179 width=80) (actual time=0.025..0.025 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
4. 0.022 0.022 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201006_pkey (cost=0.00..5.07 rows=179 width=0) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
5. 0.001 0.016 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201007 cr_1 (cost=20.74..3,024.49 rows=830 width=80) (actual time=0.016..0.016 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
6. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201007_pkey (cost=0.00..20.53 rows=830 width=0) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
7. 0.000 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201008 cr_2 (cost=21.63..3,058.19 rows=837 width=80) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
8. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201008_pkey (cost=0.00..21.42 rows=837 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
9. 0.000 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201009 cr_3 (cost=20.46..2,958.82 rows=808 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
10. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201009_pkey (cost=0.00..20.26 rows=808 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
11. 0.001 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201010 cr_4 (cost=23.40..3,327.92 rows=913 width=80) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
12. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201010_pkey (cost=0.00..23.17 rows=913 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
13. 0.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201011 cr_5 (cost=22.15..3,207.25 rows=878 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
14. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201011_pkey (cost=0.00..21.93 rows=878 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
15. 0.000 0.015 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201012 cr_6 (cost=23.28..3,324.34 rows=904 width=80) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
16. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201012_pkey (cost=0.00..23.05 rows=904 width=0) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
17. 0.000 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201101 cr_7 (cost=24.40..3,653.50 rows=992 width=80) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
18. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201101_pkey (cost=0.00..24.16 rows=992 width=0) (actual time=0.012..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
19. 0.000 0.016 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201102 cr_8 (cost=22.43..3,320.92 rows=900 width=80) (actual time=0.016..0.016 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
20. 0.016 0.016 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201102_pkey (cost=0.00..22.20 rows=900 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
21. 0.000 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201103 cr_9 (cost=24.48..3,685.59 rows=998 width=80) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
22. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201103_pkey (cost=0.00..24.23 rows=998 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
23. 0.000 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201104 cr_10 (cost=24.33..3,645.45 rows=986 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
24. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201104_pkey (cost=0.00..24.08 rows=986 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
25. 0.000 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201105 cr_11 (cost=25.77..3,834.83 rows=1,036 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
26. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201105_pkey (cost=0.00..25.51 rows=1,036 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
27. 0.000 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201106 cr_12 (cost=25.50..3,985.76 rows=1,078 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
28. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201106_pkey (cost=0.00..25.23 rows=1,078 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
29. 0.000 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201107 cr_13 (cost=25.86..3,881.85 rows=1,043 width=80) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
30. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201107_pkey (cost=0.00..25.60 rows=1,043 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
31. 0.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201108 cr_14 (cost=27.46..4,328.75 rows=1,169 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
32. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201108_pkey (cost=0.00..27.17 rows=1,169 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
33. 0.000 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201109 cr_15 (cost=24.30..3,684.23 rows=984 width=80) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
34. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201109_pkey (cost=0.00..24.06 rows=984 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
35. 0.001 0.015 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201110 cr_16 (cost=24.18..3,647.53 rows=974 width=80) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
36. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201110_pkey (cost=0.00..23.93 rows=974 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
37. 0.001 0.015 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201111 cr_17 (cost=24.01..3,595.28 rows=961 width=80) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
38. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201111_pkey (cost=0.00..23.77 rows=961 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
39. 0.000 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201112 cr_18 (cost=24.52..3,744.03 rows=1,001 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
40. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201112_pkey (cost=0.00..24.27 rows=1,001 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
41. 0.000 0.016 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201201 cr_19 (cost=23.95..3,585.46 rows=956 width=80) (actual time=0.016..0.016 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
42. 0.016 0.016 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201201_pkey (cost=0.00..23.71 rows=956 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
43. 0.000 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201202 cr_20 (cost=24.65..3,784.80 rows=1,011 width=80) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
44. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201202_pkey (cost=0.00..24.40 rows=1,011 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
45. 0.001 0.015 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201203 cr_21 (cost=26.06..3,977.58 rows=1,059 width=80) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
46. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201203_pkey (cost=0.00..25.80 rows=1,059 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
47. 0.000 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201204 cr_22 (cost=25.17..3,949.77 rows=1,052 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
48. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201204_pkey (cost=0.00..24.91 rows=1,052 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
49. 0.001 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201205 cr_23 (cost=26.28..4,049.60 rows=1,076 width=80) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
50. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201205_pkey (cost=0.00..26.01 rows=1,076 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
51. 0.001 0.015 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201206 cr_24 (cost=26.11..4,003.08 rows=1,063 width=80) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
52. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201206_pkey (cost=0.00..25.85 rows=1,063 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
53. 0.001 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201207 cr_25 (cost=27.77..4,255.32 rows=1,130 width=80) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
54. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201207_pkey (cost=0.00..27.48 rows=1,130 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
55. 0.000 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201208 cr_26 (cost=26.84..4,219.67 rows=1,120 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
56. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201208_pkey (cost=0.00..26.56 rows=1,120 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
57. 0.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201209 cr_27 (cost=26.60..4,151.24 rows=1,101 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
58. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201209_pkey (cost=0.00..26.32 rows=1,101 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
59. 0.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201210 cr_28 (cost=26.77..3,988.00 rows=1,052 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
60. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201210_pkey (cost=0.00..26.51 rows=1,052 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
61. 0.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201211 cr_29 (cost=25.69..3,909.36 rows=1,030 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
62. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201211_pkey (cost=0.00..25.43 rows=1,030 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
63. 0.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201212 cr_30 (cost=27.34..4,167.61 rows=1,097 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
64. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201212_pkey (cost=0.00..27.07 rows=1,097 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
65. 0.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201301 cr_31 (cost=27.18..4,123.28 rows=1,084 width=80) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
66. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201301_pkey (cost=0.00..26.91 rows=1,084 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
67. 7,161.058 7,161.100 ↑ 14.2 70 1

Bitmap Heap Scan on countdata_raw201302 cr_32 (cost=25.24..3,785.89 rows=995 width=80) (actual time=7,160.989..7,161.100 rows=70 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=2
68. 0.042 0.042 ↑ 5.1 194 1

Bitmap Index Scan on countdata_raw201302_pkey (cost=0.00..25.00 rows=995 width=0) (actual time=0.042..0.042 rows=194 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
69. 1.127 1.482 ↑ 1.6 743 1

Bitmap Heap Scan on countdata_raw201303 cr_33 (cost=29.45..4,543.79 rows=1,199 width=80) (actual time=0.452..1.482 rows=743 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
70. 0.355 0.355 ↓ 1.9 2,229 1

Bitmap Index Scan on countdata_raw201303_pkey (cost=0.00..29.15 rows=1,199 width=0) (actual time=0.355..0.355 rows=2,229 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
71. 1.029 1.330 ↑ 1.6 720 1

Bitmap Heap Scan on countdata_raw201304 cr_34 (cost=28.95..4,403.00 rows=1,160 width=80) (actual time=0.382..1.330 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
72. 0.301 0.301 ↓ 1.9 2,160 1

Bitmap Index Scan on countdata_raw201304_pkey (cost=0.00..28.66 rows=1,160 width=0) (actual time=0.301..0.301 rows=2,160 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
73. 1.129 1.450 ↑ 1.6 744 1

Bitmap Heap Scan on countdata_raw201305 cr_35 (cost=29.51..4,566.10 rows=1,204 width=80) (actual time=0.401..1.450 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
74. 0.321 0.321 ↓ 1.9 2,232 1

Bitmap Index Scan on countdata_raw201305_pkey (cost=0.00..29.21 rows=1,204 width=0) (actual time=0.321..0.321 rows=2,232 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
75. 1.029 1.332 ↑ 1.6 720 1

Bitmap Heap Scan on countdata_raw201306 cr_36 (cost=29.17..4,474.35 rows=1,177 width=80) (actual time=0.391..1.332 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
76. 0.303 0.303 ↓ 1.8 2,160 1

Bitmap Index Scan on countdata_raw201306_pkey (cost=0.00..28.87 rows=1,177 width=0) (actual time=0.303..0.303 rows=2,160 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
77. 1.111 1.429 ↑ 1.7 744 1

Bitmap Heap Scan on countdata_raw201307 cr_37 (cost=30.80..4,727.77 rows=1,242 width=80) (actual time=0.401..1.429 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
78. 0.318 0.318 ↓ 1.8 2,232 1

Bitmap Index Scan on countdata_raw201307_pkey (cost=0.00..30.48 rows=1,242 width=0) (actual time=0.318..0.318 rows=2,232 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
79. 1.112 1.440 ↑ 1.8 744 1

Bitmap Heap Scan on countdata_raw201308 cr_38 (cost=31.62..4,967.27 rows=1,307 width=80) (actual time=0.425..1.440 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
80. 0.328 0.328 ↓ 1.7 2,232 1

Bitmap Index Scan on countdata_raw201308_pkey (cost=0.00..31.30 rows=1,307 width=0) (actual time=0.328..0.328 rows=2,232 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
81. 1.025 1.334 ↑ 1.8 720 1

Bitmap Heap Scan on countdata_raw201309 cr_39 (cost=31.04..4,804.04 rows=1,261 width=80) (actual time=0.391..1.334 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
82. 0.309 0.309 ↓ 1.7 2,160 1

Bitmap Index Scan on countdata_raw201309_pkey (cost=0.00..30.72 rows=1,261 width=0) (actual time=0.309..0.309 rows=2,160 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
83. 1.152 1.455 ↑ 1.7 745 1

Bitmap Heap Scan on countdata_raw201310 cr_40 (cost=31.79..4,806.57 rows=1,257 width=80) (actual time=0.409..1.455 rows=745 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
84. 0.303 0.303 ↓ 1.7 2,126 1

Bitmap Index Scan on countdata_raw201310_pkey (cost=0.00..31.47 rows=1,257 width=0) (actual time=0.303..0.303 rows=2,126 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
85. 1.057 1.282 ↑ 1.7 720 1

Bitmap Heap Scan on countdata_raw201311 cr_41 (cost=31.32..4,665.66 rows=1,220 width=80) (actual time=0.273..1.282 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
86. 0.225 0.225 ↓ 1.2 1,440 1

Bitmap Index Scan on countdata_raw201311_pkey (cost=0.00..31.01 rows=1,220 width=0) (actual time=0.225..0.225 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
87. 1.080 1.306 ↑ 1.8 744 1

Bitmap Heap Scan on countdata_raw201312 cr_42 (cost=32.97..5,154.56 rows=1,350 width=80) (actual time=0.273..1.306 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
88. 0.226 0.226 ↓ 1.1 1,488 1

Bitmap Index Scan on countdata_raw201312_pkey (cost=0.00..32.64 rows=1,350 width=0) (actual time=0.226..0.226 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
89. 1.078 1.320 ↑ 1.7 744 1

Bitmap Heap Scan on countdata_raw201401 cr_43 (cost=33.06..4,949.92 rows=1,294 width=80) (actual time=0.291..1.320 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
90. 0.242 0.242 ↓ 1.1 1,488 1

Bitmap Index Scan on countdata_raw201401_pkey (cost=0.00..32.73 rows=1,294 width=0) (actual time=0.242..0.242 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
91. 0.925 1.127 ↑ 1.8 672 1

Bitmap Heap Scan on countdata_raw201402 cr_44 (cost=29.75..4,670.80 rows=1,223 width=80) (actual time=0.246..1.127 rows=672 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
92. 0.202 0.202 ↓ 1.1 1,344 1

Bitmap Index Scan on countdata_raw201402_pkey (cost=0.00..29.45 rows=1,223 width=0) (actual time=0.202..0.202 rows=1,344 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
93. 1.094 1.320 ↑ 1.7 742 1

Bitmap Heap Scan on countdata_raw201403 cr_45 (cost=32.14..4,923.80 rows=1,285 width=80) (actual time=0.274..1.320 rows=742 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
94. 0.226 0.226 ↓ 1.2 1,485 1

Bitmap Index Scan on countdata_raw201403_pkey (cost=0.00..31.82 rows=1,285 width=0) (actual time=0.226..0.226 rows=1,485 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
95. 0.991 1.220 ↑ 1.9 720 1

Bitmap Heap Scan on countdata_raw201404 cr_46 (cost=32.91..5,143.67 rows=1,345 width=80) (actual time=0.285..1.220 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
96. 0.229 0.229 ↓ 1.1 1,440 1

Bitmap Index Scan on countdata_raw201404_pkey (cost=0.00..32.57 rows=1,345 width=0) (actual time=0.229..0.229 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
97. 1.011 1.233 ↑ 1.7 744 1

Bitmap Heap Scan on countdata_raw201405 cr_47 (cost=33.02..4,957.78 rows=1,291 width=80) (actual time=0.270..1.233 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
98. 0.222 0.222 ↓ 1.2 1,488 1

Bitmap Index Scan on countdata_raw201405_pkey (cost=0.00..32.70 rows=1,291 width=0) (actual time=0.222..0.222 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
99. 1.064 1.304 ↑ 1.9 720 1

Bitmap Heap Scan on countdata_raw201406 cr_48 (cost=34.05..5,259.27 rows=1,372 width=80) (actual time=0.288..1.304 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
100. 0.240 0.240 ↓ 1.0 1,440 1

Bitmap Index Scan on countdata_raw201406_pkey (cost=0.00..33.71 rows=1,372 width=0) (actual time=0.240..0.240 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
101. 1.031 1.256 ↑ 1.9 744 1

Bitmap Heap Scan on countdata_raw201407 cr_49 (cost=35.22..5,379.40 rows=1,401 width=80) (actual time=0.275..1.256 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
102. 0.225 0.225 ↓ 1.1 1,488 1

Bitmap Index Scan on countdata_raw201407_pkey (cost=0.00..34.87 rows=1,401 width=0) (actual time=0.225..0.225 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
103. 1.071 1.293 ↑ 1.8 744 1

Bitmap Heap Scan on countdata_raw201408 cr_50 (cost=34.74..5,244.88 rows=1,363 width=80) (actual time=0.268..1.293 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
104. 0.222 0.222 ↓ 1.1 1,488 1

Bitmap Index Scan on countdata_raw201408_pkey (cost=0.00..34.40 rows=1,363 width=0) (actual time=0.222..0.222 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
105. 1.026 1.253 ↑ 2.0 720 1

Bitmap Heap Scan on countdata_raw201409 cr_51 (cost=35.99..5,606.13 rows=1,461 width=80) (actual time=0.276..1.253 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
106. 0.227 0.227 ↑ 1.0 1,440 1

Bitmap Index Scan on countdata_raw201409_pkey (cost=0.00..35.62 rows=1,461 width=0) (actual time=0.227..0.227 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
107. 1.027 1.254 ↑ 2.0 745 1

Bitmap Heap Scan on countdata_raw201410 cr_52 (cost=36.28..5,698.40 rows=1,484 width=80) (actual time=0.277..1.254 rows=745 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
108. 0.227 0.227 ↓ 1.0 1,489 1

Bitmap Index Scan on countdata_raw201410_pkey (cost=0.00..35.91 rows=1,484 width=0) (actual time=0.227..0.227 rows=1,489 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
109. 1.077 1.299 ↑ 2.0 720 1

Bitmap Heap Scan on countdata_raw201411 cr_53 (cost=35.96..5,597.73 rows=1,459 width=80) (actual time=0.270..1.299 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
110. 0.222 0.222 ↑ 1.0 1,440 1

Bitmap Index Scan on countdata_raw201411_pkey (cost=0.00..35.60 rows=1,459 width=0) (actual time=0.222..0.222 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
111. 1.029 1.266 ↑ 1.9 744 1

Bitmap Heap Scan on countdata_raw201412 cr_54 (cost=35.40..5,447.04 rows=1,415 width=80) (actual time=0.289..1.266 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
112. 0.237 0.237 ↓ 1.1 1,488 1

Bitmap Index Scan on countdata_raw201412_pkey (cost=0.00..35.05 rows=1,415 width=0) (actual time=0.237..0.237 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
113. 1.034 1.254 ↑ 2.0 744 1

Bitmap Heap Scan on countdata_raw201501 cr_55 (cost=36.66..5,813.12 rows=1,514 width=80) (actual time=0.269..1.254 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
114. 0.220 0.220 ↑ 1.0 1,488 1

Bitmap Index Scan on countdata_raw201501_pkey (cost=0.00..36.29 rows=1,514 width=0) (actual time=0.220..0.220 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
115. 0.983 1.214 ↑ 2.0 672 1

Bitmap Heap Scan on countdata_raw201502 cr_56 (cost=33.11..5,226.32 rows=1,361 width=80) (actual time=0.279..1.214 rows=672 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
116. 0.231 0.231 ↑ 1.0 1,344 1

Bitmap Index Scan on countdata_raw201502_pkey (cost=0.00..32.77 rows=1,361 width=0) (actual time=0.231..0.231 rows=1,344 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
117. 1.028 1.246 ↑ 1.9 742 1

Bitmap Heap Scan on countdata_raw201503 cr_57 (cost=35.32..5,427.75 rows=1,409 width=80) (actual time=0.264..1.246 rows=742 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
118. 0.218 0.218 ↓ 1.1 1,485 1

Bitmap Index Scan on countdata_raw201503_pkey (cost=0.00..34.97 rows=1,409 width=0) (actual time=0.218..0.218 rows=1,485 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
119. 1.034 1.252 ↑ 1.9 720 1

Bitmap Heap Scan on countdata_raw201504 cr_58 (cost=35.13..5,370.42 rows=1,394 width=80) (actual time=0.264..1.252 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
120. 0.218 0.218 ↓ 1.0 1,440 1

Bitmap Index Scan on countdata_raw201504_pkey (cost=0.00..34.79 rows=1,394 width=0) (actual time=0.218..0.218 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
121. 1.062 1.278 ↑ 2.0 744 1

Bitmap Heap Scan on countdata_raw201505 cr_59 (cost=36.95..5,680.81 rows=1,474 width=80) (actual time=0.265..1.278 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
122. 0.216 0.216 ↓ 1.0 1,488 1

Bitmap Index Scan on countdata_raw201505_pkey (cost=0.00..36.59 rows=1,474 width=0) (actual time=0.216..0.216 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
123. 1.095 1.328 ↑ 1.7 795 1

Bitmap Heap Scan on countdata_raw201506 cr_60 (cost=33.98..5,272.58 rows=1,366 width=80) (actual time=0.282..1.328 rows=795 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=12
124. 0.233 0.233 ↓ 1.2 1,590 1

Bitmap Index Scan on countdata_raw201506_pkey (cost=0.00..33.64 rows=1,366 width=0) (actual time=0.233..0.233 rows=1,590 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
125. 1.117 1.340 ↑ 2.0 744 1

Bitmap Heap Scan on countdata_raw201507 cr_61 (cost=36.98..5,695.11 rows=1,476 width=80) (actual time=0.272..1.340 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
126. 0.223 0.223 ↓ 1.0 1,488 1

Bitmap Index Scan on countdata_raw201507_pkey (cost=0.00..36.61 rows=1,476 width=0) (actual time=0.223..0.223 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
127. 1.043 1.275 ↑ 2.0 744 1

Bitmap Heap Scan on countdata_raw201508 cr_62 (cost=37.30..5,793.47 rows=1,501 width=80) (actual time=0.282..1.275 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
128. 0.232 0.232 ↑ 1.0 1,488 1

Bitmap Index Scan on countdata_raw201508_pkey (cost=0.00..36.92 rows=1,501 width=0) (actual time=0.232..0.232 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
129. 0.999 1.213 ↑ 2.0 720 1

Bitmap Heap Scan on countdata_raw201509 cr_63 (cost=35.76..5,572.71 rows=1,443 width=80) (actual time=0.260..1.213 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
130. 0.214 0.214 ↑ 1.0 1,440 1

Bitmap Index Scan on countdata_raw201509_pkey (cost=0.00..35.40 rows=1,443 width=0) (actual time=0.214..0.214 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
131. 1.081 1.335 ↑ 2.1 745 1

Bitmap Heap Scan on countdata_raw201510 cr_64 (cost=39.09..6,090.32 rows=1,579 width=80) (actual time=0.303..1.335 rows=745 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
132. 0.254 0.254 ↑ 1.1 1,489 1

Bitmap Index Scan on countdata_raw201510_pkey (cost=0.00..38.70 rows=1,579 width=0) (actual time=0.254..0.254 rows=1,489 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
133. 1.001 1.216 ↑ 2.2 720 1

Bitmap Heap Scan on countdata_raw201511 cr_65 (cost=38.56..6,163.50 rows=1,600 width=80) (actual time=0.260..1.216 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
134. 0.215 0.215 ↑ 1.1 1,440 1

Bitmap Index Scan on countdata_raw201511_pkey (cost=0.00..38.16 rows=1,600 width=0) (actual time=0.215..0.215 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
135. 1.061 1.275 ↑ 2.1 744 1

Bitmap Heap Scan on countdata_raw201512 cr_66 (cost=37.89..5,976.25 rows=1,547 width=80) (actual time=0.261..1.275 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
136. 0.214 0.214 ↑ 1.0 1,488 1

Bitmap Index Scan on countdata_raw201512_pkey (cost=0.00..37.50 rows=1,547 width=0) (actual time=0.214..0.214 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
137. 1.095 1.324 ↑ 2.3 744 1

Bitmap Heap Scan on countdata_raw201601 cr_67 (cost=40.41..6,477.82 rows=1,682 width=80) (actual time=0.276..1.324 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
138. 0.229 0.229 ↑ 1.1 1,488 1

Bitmap Index Scan on countdata_raw201601_pkey (cost=0.00..39.99 rows=1,682 width=0) (actual time=0.229..0.229 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
139. 0.986 1.200 ↑ 2.2 696 1

Bitmap Heap Scan on countdata_raw201602 cr_68 (cost=37.32..6,029.06 rows=1,565 width=80) (actual time=0.263..1.200 rows=696 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
140. 0.214 0.214 ↑ 1.1 1,392 1

Bitmap Index Scan on countdata_raw201602_pkey (cost=0.00..36.92 rows=1,565 width=0) (actual time=0.214..0.214 rows=1,392 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
141. 1.102 1.315 ↑ 2.3 742 1

Bitmap Heap Scan on countdata_raw201603 cr_69 (cost=40.65..6,553.96 rows=1,701 width=80) (actual time=0.266..1.315 rows=742 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
142. 0.213 0.213 ↑ 1.1 1,485 1

Bitmap Index Scan on countdata_raw201603_pkey (cost=0.00..40.23 rows=1,701 width=0) (actual time=0.213..0.213 rows=1,485 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
143. 0.992 1.215 ↑ 2.2 720 1

Bitmap Heap Scan on countdata_raw201604 cr_70 (cost=38.66..6,201.58 rows=1,608 width=80) (actual time=0.270..1.215 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
144. 0.223 0.223 ↑ 1.1 1,440 1

Bitmap Index Scan on countdata_raw201604_pkey (cost=0.00..38.26 rows=1,608 width=0) (actual time=0.223..0.223 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
145. 1.052 1.278 ↑ 2.2 744 1

Bitmap Heap Scan on countdata_raw201605 cr_71 (cost=39.83..6,316.83 rows=1,637 width=80) (actual time=0.276..1.278 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
146. 0.226 0.226 ↑ 1.1 1,488 1

Bitmap Index Scan on countdata_raw201605_pkey (cost=0.00..39.43 rows=1,637 width=0) (actual time=0.226..0.226 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
147. 1.027 1.141 ↑ 2.1 720 1

Bitmap Heap Scan on countdata_raw201606 cr_72 (cost=37.72..5,932.90 rows=1,534 width=80) (actual time=0.125..1.141 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
148. 0.114 0.114 ↑ 2.1 720 1

Bitmap Index Scan on countdata_raw201606_pkey (cost=0.00..37.34 rows=1,534 width=0) (actual time=0.114..0.114 rows=720 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
149. 1.058 1.170 ↑ 2.1 744 1

Bitmap Heap Scan on countdata_raw201607 cr_73 (cost=39.22..6,149.25 rows=1,589 width=80) (actual time=0.123..1.170 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
150. 0.112 0.112 ↑ 2.1 744 1

Bitmap Index Scan on countdata_raw201607_pkey (cost=0.00..38.83 rows=1,589 width=0) (actual time=0.112..0.112 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
151. 1.154 1.371 ↑ 2.2 744 1

Bitmap Heap Scan on countdata_raw201608 cr_74 (cost=40.29..6,462.75 rows=1,673 width=80) (actual time=0.228..1.371 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
152. 0.217 0.217 ↑ 1.1 1,488 1

Bitmap Index Scan on countdata_raw201608_pkey (cost=0.00..39.88 rows=1,673 width=0) (actual time=0.217..0.217 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
153. 1.074 1.315 ↑ 2.3 720 1

Bitmap Heap Scan on countdata_raw201609 cr_75 (cost=38.97..6,302.13 rows=1,632 width=80) (actual time=0.291..1.315 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
154. 0.241 0.241 ↑ 1.1 1,440 1

Bitmap Index Scan on countdata_raw201609_pkey (cost=0.00..38.56 rows=1,632 width=0) (actual time=0.241..0.241 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
155. 1.041 1.254 ↑ 2.3 745 1

Bitmap Heap Scan on countdata_raw201610 cr_76 (cost=40.74..6,594.92 rows=1,708 width=80) (actual time=0.228..1.254 rows=745 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
156. 0.213 0.213 ↑ 1.1 1,489 1

Bitmap Index Scan on countdata_raw201610_pkey (cost=0.00..40.31 rows=1,708 width=0) (actual time=0.213..0.213 rows=1,489 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
157. 1.183 1.399 ↑ 2.3 720 1

Bitmap Heap Scan on countdata_raw201611 cr_77 (cost=40.28..6,454.02 rows=1,672 width=80) (actual time=0.259..1.399 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
158. 0.216 0.216 ↑ 1.2 1,440 1

Bitmap Index Scan on countdata_raw201611_pkey (cost=0.00..39.86 rows=1,672 width=0) (actual time=0.216..0.216 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
159. 1.030 1.253 ↑ 2.3 744 1

Bitmap Heap Scan on countdata_raw201612 cr_78 (cost=41.87..6,694.04 rows=1,734 width=80) (actual time=0.269..1.253 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
160. 0.223 0.223 ↑ 1.2 1,488 1

Bitmap Index Scan on countdata_raw201612_pkey (cost=0.00..41.44 rows=1,734 width=0) (actual time=0.223..0.223 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
161. 1.126 1.349 ↑ 2.3 744 1

Bitmap Heap Scan on countdata_raw201701 cr_79 (cost=42.00..6,731.92 rows=1,744 width=80) (actual time=0.275..1.349 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
162. 0.223 0.223 ↑ 1.2 1,488 1

Bitmap Index Scan on countdata_raw201701_pkey (cost=0.00..41.56 rows=1,744 width=0) (actual time=0.223..0.223 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
163. 1.096 1.329 ↑ 2.4 672 1

Bitmap Heap Scan on countdata_raw201702 cr_80 (cost=38.50..6,155.66 rows=1,595 width=80) (actual time=0.281..1.329 rows=672 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
164. 0.233 0.233 ↑ 1.2 1,344 1

Bitmap Index Scan on countdata_raw201702_pkey (cost=0.00..38.10 rows=1,595 width=0) (actual time=0.233..0.233 rows=1,344 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
165. 1.039 1.270 ↑ 2.3 742 1

Bitmap Heap Scan on countdata_raw201703 cr_81 (cost=41.62..6,622.60 rows=1,714 width=80) (actual time=0.278..1.270 rows=742 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
166. 0.231 0.231 ↑ 1.2 1,485 1

Bitmap Index Scan on countdata_raw201703_pkey (cost=0.00..41.19 rows=1,714 width=0) (actual time=0.231..0.231 rows=1,485 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
167. 1.204 1.424 ↑ 2.4 720 1

Bitmap Heap Scan on countdata_raw201704 cr_82 (cost=41.49..6,577.84 rows=1,704 width=80) (actual time=0.275..1.424 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=10
168. 0.220 0.220 ↑ 1.2 1,440 1

Bitmap Index Scan on countdata_raw201704_pkey (cost=0.00..41.06 rows=1,704 width=0) (actual time=0.220..0.220 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
169. 1.028 1.261 ↑ 2.3 744 1

Bitmap Heap Scan on countdata_raw201705 cr_83 (cost=41.82..6,687.24 rows=1,730 width=80) (actual time=0.283..1.261 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
170. 0.233 0.233 ↑ 1.2 1,488 1

Bitmap Index Scan on countdata_raw201705_pkey (cost=0.00..41.39 rows=1,730 width=0) (actual time=0.233..0.233 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
171. 1.042 1.255 ↑ 2.3 720 1

Bitmap Heap Scan on countdata_raw201706 cr_84 (cost=40.45..6,513.39 rows=1,685 width=80) (actual time=0.257..1.255 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
172. 0.213 0.213 ↑ 1.2 1,440 1

Bitmap Index Scan on countdata_raw201706_pkey (cost=0.00..40.03 rows=1,685 width=0) (actual time=0.213..0.213 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
173. 1.146 1.399 ↑ 2.3 744 1

Bitmap Heap Scan on countdata_raw201707 cr_85 (cost=41.82..6,692.88 rows=1,730 width=80) (actual time=0.305..1.399 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
174. 0.253 0.253 ↑ 1.2 1,488 1

Bitmap Index Scan on countdata_raw201707_pkey (cost=0.00..41.39 rows=1,730 width=0) (actual time=0.253..0.253 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
175. 1.032 1.257 ↑ 2.4 744 1

Bitmap Heap Scan on countdata_raw201708 cr_86 (cost=43.10..6,836.60 rows=1,768 width=80) (actual time=0.274..1.257 rows=744 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
176. 0.225 0.225 ↑ 1.2 1,488 1

Bitmap Index Scan on countdata_raw201708_pkey (cost=0.00..42.66 rows=1,768 width=0) (actual time=0.225..0.225 rows=1,488 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
177. 1.064 1.284 ↑ 2.4 720 1

Bitmap Heap Scan on countdata_raw201709 cr_87 (cost=41.64..6,636.10 rows=1,716 width=80) (actual time=0.274..1.284 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
178. 0.220 0.220 ↑ 1.2 1,440 1

Bitmap Index Scan on countdata_raw201709_pkey (cost=0.00..41.21 rows=1,716 width=0) (actual time=0.220..0.220 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
179. 1.052 1.284 ↑ 2.3 745 1

Bitmap Heap Scan on countdata_raw201710 cr_88 (cost=41.99..6,743.24 rows=1,743 width=80) (actual time=0.280..1.284 rows=745 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
180. 0.232 0.232 ↑ 1.2 1,489 1

Bitmap Index Scan on countdata_raw201710_pkey (cost=0.00..41.55 rows=1,743 width=0) (actual time=0.232..0.232 rows=1,489 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
181. 0.995 1.210 ↑ 2.4 720 1

Bitmap Heap Scan on countdata_raw201711 cr_89 (cost=41.50..6,599.27 rows=1,705 width=80) (actual time=0.261..1.210 rows=720 loops=1)

  • Recheck Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=11
182. 0.215 0.215 ↑ 1.2 1,440 1

Bitmap Index Scan on countdata_raw201711_pkey (cost=0.00..41.08 rows=1,705 width=0) (actual time=0.215..0.215 rows=1,440 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
183. 1.405 1.405 ↑ 2.4 744 1

Index Scan using countdata_raw201712_pkey on countdata_raw201712 cr_90 (cost=0.56..1,876.54 rows=1,752 width=80) (actual time=0.024..1.405 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
184. 1.274 1.274 ↑ 2.4 744 1

Index Scan using countdata_raw201801_pkey on countdata_raw201801 cr_91 (cost=0.56..1,912.86 rows=1,785 width=80) (actual time=0.019..1.274 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
185. 1.135 1.135 ↑ 2.4 672 1

Index Scan using countdata_raw201802_pkey on countdata_raw201802 cr_92 (cost=0.56..1,731.44 rows=1,615 width=80) (actual time=0.021..1.135 rows=672 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
186. 1.262 1.262 ↑ 2.4 742 1

Index Scan using countdata_raw201803_pkey on countdata_raw201803 cr_93 (cost=0.56..1,905.62 rows=1,778 width=80) (actual time=0.020..1.262 rows=742 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
187. 1.138 1.138 ↑ 2.4 720 1

Index Scan using countdata_raw201804_pkey on countdata_raw201804 cr_94 (cost=0.56..1,825.11 rows=1,702 width=80) (actual time=0.020..1.138 rows=720 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
188. 1.359 1.359 ↑ 2.4 744 1

Index Scan using countdata_raw201805_pkey on countdata_raw201805 cr_95 (cost=0.56..1,952.34 rows=1,822 width=80) (actual time=0.019..1.359 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
189. 1.208 1.208 ↑ 2.4 720 1

Index Scan using countdata_raw201806_pkey on countdata_raw201806 cr_96 (cost=0.56..1,882.26 rows=1,756 width=80) (actual time=0.022..1.208 rows=720 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
190. 1.187 1.187 ↑ 2.3 744 1

Index Scan using countdata_raw201807_pkey on countdata_raw201807 cr_97 (cost=0.56..1,869.46 rows=1,743 width=80) (actual time=0.022..1.187 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
191. 1.243 1.243 ↑ 2.5 744 1

Index Scan using countdata_raw201808_pkey on countdata_raw201808 cr_98 (cost=0.56..1,963.84 rows=1,832 width=80) (actual time=0.019..1.243 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
192. 1.165 1.165 ↑ 2.5 720 1

Index Scan using countdata_raw201809_pkey on countdata_raw201809 cr_99 (cost=0.56..1,901.62 rows=1,774 width=80) (actual time=0.032..1.165 rows=720 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
193. 1.211 1.211 ↑ 2.4 745 1

Index Scan using countdata_raw201810_pkey on countdata_raw201810 cr_100 (cost=0.56..1,905.72 rows=1,778 width=80) (actual time=0.018..1.211 rows=745 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
194. 1.340 1.340 ↑ 2.5 720 1

Index Scan using countdata_raw201811_pkey on countdata_raw201811 cr_101 (cost=0.56..1,909.60 rows=1,784 width=80) (actual time=0.024..1.340 rows=720 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
195. 1.180 1.180 ↑ 2.4 744 1

Index Scan using countdata_raw201812_pkey on countdata_raw201812 cr_102 (cost=0.56..1,915.86 rows=1,787 width=80) (actual time=0.021..1.180 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
196. 1.238 1.238 ↑ 2.4 744 1

Index Scan using countdata_raw201901_pkey on countdata_raw201901 cr_103 (cost=0.56..1,943.40 rows=1,814 width=80) (actual time=0.019..1.238 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
197. 1.112 1.112 ↑ 2.5 672 1

Index Scan using countdata_raw201902_pkey on countdata_raw201902 cr_104 (cost=0.56..1,781.68 rows=1,669 width=80) (actual time=0.020..1.112 rows=672 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
198. 1.179 1.179 ↑ 2.5 742 1

Index Scan using countdata_raw201903_pkey on countdata_raw201903 cr_105 (cost=0.56..1,945.93 rows=1,818 width=80) (actual time=0.019..1.179 rows=742 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
199. 1.293 1.293 ↑ 2.5 720 1

Index Scan using countdata_raw201904_pkey on countdata_raw201904 cr_106 (cost=0.56..1,895.60 rows=1,772 width=80) (actual time=0.020..1.293 rows=720 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
200. 1.261 1.261 ↑ 2.5 744 1

Index Scan using countdata_raw201905_pkey on countdata_raw201905 cr_107 (cost=0.56..2,002.56 rows=1,870 width=80) (actual time=0.021..1.261 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
201. 1.141 1.141 ↑ 2.5 720 1

Index Scan using countdata_raw201906_pkey on countdata_raw201906 cr_108 (cost=0.56..1,932.26 rows=1,804 width=80) (actual time=0.019..1.141 rows=720 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
202. 1.278 1.278 ↑ 2.5 744 1

Index Scan using countdata_raw201907_pkey on countdata_raw201907 cr_109 (cost=0.56..1,993.86 rows=1,868 width=80) (actual time=0.020..1.278 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
203. 1.172 1.172 ↑ 2.5 744 1

Index Scan using countdata_raw201908_pkey on countdata_raw201908 cr_110 (cost=0.56..1,955.96 rows=1,825 width=80) (actual time=0.019..1.172 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
204. 1.217 1.217 ↑ 2.5 720 1

Index Scan using countdata_raw201909_pkey on countdata_raw201909 cr_111 (cost=0.56..1,896.32 rows=1,769 width=80) (actual time=0.019..1.217 rows=720 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
205. 1.395 1.395 ↑ 2.4 745 1

Index Scan using countdata_raw201910_pkey on countdata_raw201910 cr_112 (cost=0.56..1,950.69 rows=1,820 width=80) (actual time=0.023..1.395 rows=745 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
206. 1.141 1.141 ↑ 2.4 720 1

Index Scan using countdata_raw201911_pkey on countdata_raw201911 cr_113 (cost=0.56..1,867.35 rows=1,742 width=80) (actual time=0.019..1.141 rows=720 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
207. 1.234 1.234 ↑ 2.5 744 1

Index Scan using countdata_raw201912_pkey on countdata_raw201912 cr_114 (cost=0.56..1,955.42 rows=1,826 width=80) (actual time=0.021..1.234 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
208. 1.235 1.235 ↑ 2.4 744 1

Index Scan using countdata_raw202001_pkey on countdata_raw202001 cr_115 (cost=0.56..1,939.83 rows=1,811 width=80) (actual time=0.020..1.235 rows=744 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
209. 0.938 0.938 ↑ 2.5 594 1

Index Scan using countdata_raw202002_pkey on countdata_raw202002 cr_116 (cost=0.56..1,605.71 rows=1,497 width=80) (actual time=0.019..0.938 rows=594 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
210. 0.056 0.056 ↑ 15.5 24 1

Index Scan using countdata_raw202003_pkey on countdata_raw202003 cr_117 (cost=0.56..400.91 rows=373 width=80) (actual time=0.018..0.056 rows=24 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
211. 0.004 0.004 ↓ 0.0 0 1

Index Scan using countdata_raw202004_pkey on countdata_raw202004 cr_118 (cost=0.15..2.01 rows=1 width=80) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
212. 0.004 0.004 ↓ 0.0 0 1

Index Scan using countdata_raw202005_pkey on countdata_raw202005 cr_119 (cost=0.15..2.01 rows=1 width=80) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
213. 0.003 0.003 ↓ 0.0 0 1

Index Scan using countdata_raw202006_pkey on countdata_raw202006 cr_120 (cost=0.15..2.01 rows=1 width=80) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
214. 0.006 0.006 ↓ 0.0 0 1

Index Scan using countdata_raw202007_pkey on countdata_raw202007 cr_121 (cost=0.27..1.57 rows=1 width=80) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
215. 0.007 0.007 ↓ 0.0 0 1

Index Scan using countdata_raw202008_pkey on countdata_raw202008 cr_122 (cost=0.28..1.58 rows=1 width=80) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
216. 0.004 0.004 ↓ 0.0 0 1

Index Scan using countdata_raw202009_pkey on countdata_raw202009 cr_123 (cost=0.15..2.01 rows=1 width=80) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
217. 0.004 0.004 ↓ 0.0 0 1

Index Scan using countdata_raw202010_pkey on countdata_raw202010 cr_124 (cost=0.15..2.01 rows=1 width=80) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
218. 0.004 0.004 ↓ 0.0 0 1

Index Scan using countdata_raw202011_pkey on countdata_raw202011 cr_125 (cost=0.15..2.01 rows=1 width=80) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
219. 0.004 0.004 ↓ 0.0 0 1

Index Scan using countdata_raw202012_pkey on countdata_raw202012 cr_126 (cost=0.15..2.01 rows=1 width=80) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
220. 0.004 0.004 ↓ 0.0 0 1

Index Scan using countdata_raw202101_pkey on countdata_raw202101 cr_127 (cost=0.15..2.01 rows=1 width=80) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
221. 0.003 0.003 ↓ 0.0 0 1

Index Scan using countdata_raw202102_pkey on countdata_raw202102 cr_128 (cost=0.15..2.01 rows=1 width=80) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
222. 0.004 0.004 ↓ 0.0 0 1

Index Scan using countdata_raw202103_pkey on countdata_raw202103 cr_129 (cost=0.15..2.01 rows=1 width=80) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
223. 0.003 0.003 ↓ 0.0 0 1

Index Scan using countdata_raw202104_pkey on countdata_raw202104 cr_130 (cost=0.15..2.01 rows=1 width=80) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
224. 0.005 0.005 ↓ 0.0 0 1

Index Scan using countdata_raw202105_pkey on countdata_raw202105 cr_131 (cost=0.15..2.01 rows=1 width=80) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
225. 0.003 0.003 ↓ 0.0 0 1

Index Scan using countdata_raw202106_pkey on countdata_raw202106 cr_132 (cost=0.15..2.01 rows=1 width=80) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
226. 0.003 0.003 ↓ 0.0 0 1

Index Scan using countdata_raw202107_pkey on countdata_raw202107 cr_133 (cost=0.15..2.01 rows=1 width=80) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
227. 0.005 0.005 ↓ 0.0 0 1

Index Scan using countdata_raw202108_pkey on countdata_raw202108 cr_134 (cost=0.28..1.58 rows=1 width=80) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
228. 0.003 0.003 ↓ 0.0 0 1

Index Scan using countdata_raw202109_pkey on countdata_raw202109 cr_135 (cost=0.15..2.01 rows=1 width=80) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
229. 0.003 0.003 ↓ 0.0 0 1

Index Scan using countdata_raw202110_pkey on countdata_raw202110 cr_136 (cost=0.15..2.01 rows=1 width=80) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
230. 0.004 0.004 ↓ 0.0 0 1

Index Scan using countdata_raw202111_pkey on countdata_raw202111 cr_137 (cost=0.15..2.01 rows=1 width=80) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
231. 0.007 0.007 ↓ 0.0 0 1

Index Scan using countdata_raw202112_pkey on countdata_raw202112 cr_138 (cost=0.15..2.01 rows=1 width=80) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
232. 0.010 0.010 ↓ 0.0 0 1

Index Scan using countdata_raw_default_pkey on countdata_raw_default cr_139 (cost=0.42..5.29 rows=1 width=80) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (((counter_serial)::text = 'ECO10064036'::text) AND (channel = '1'::smallint) AND (date_time >= '2010-06-24 00:00:00'::timestamp without time zone))
Execution time : 7,408.726 ms