explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EaaO : Optimization for: plan #hkeO

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 8.896 39.337 ↑ 2.7 61,429 1

Sort (cost=507,814.27..508,228.04 rows=165,508 width=64) (actual time=35.895..39.337 rows=61,429 loops=1)

  • Sort Key: cr.date_time
  • Sort Method: quicksort Memory: 10,175kB
  • Functions: 280
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 31.584 ms, Inlining 0.000 ms, Optimization 0.000 ms, Emission 0.000 ms, Total 31.584 ms
2. 3.645 30.441 ↑ 2.7 61,429 1

Append (cost=5.11..493,467.58 rows=165,508 width=64) (actual time=0.535..30.441 rows=61,429 loops=1)

3. 0.002 0.025 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201006 cr (cost=5.11..687.46 rows=179 width=65) (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.023 0.023 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201006_pkey (cost=0.00..5.07 rows=179 width=0) (actual time=0.023..0.023 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.015 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201007 cr_1 (cost=20.74..2,991.29 rows=830 width=65) (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))
6. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201007_pkey (cost=0.00..20.53 rows=830 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))
7. 0.000 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201008 cr_2 (cost=21.63..3,024.71 rows=837 width=65) (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,926.50 rows=808 width=65) (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.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201010 cr_4 (cost=23.40..3,291.40 rows=913 width=65) (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))
12. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201010_pkey (cost=0.00..23.17 rows=913 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))
13. 0.000 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201011 cr_5 (cost=22.15..3,172.13 rows=878 width=65) (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))
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.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201012 cr_6 (cost=23.28..3,288.18 rows=904 width=64) (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))
16. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201012_pkey (cost=0.00..23.05 rows=904 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))
17. 0.001 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201101 cr_7 (cost=24.40..3,613.82 rows=992 width=64) (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.012 0.012 ↓ 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.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))
19. 0.001 0.015 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201102 cr_8 (cost=22.43..3,284.92 rows=900 width=64) (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))
20. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201102_pkey (cost=0.00..22.20 rows=900 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))
21. 0.000 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201103 cr_9 (cost=24.48..3,645.67 rows=998 width=64) (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.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201104 cr_10 (cost=24.33..3,606.01 rows=986 width=64) (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))
24. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201104_pkey (cost=0.00..24.08 rows=986 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))
25. 0.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201105 cr_11 (cost=25.77..3,793.39 rows=1,036 width=64) (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.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201105_pkey (cost=0.00..25.51 rows=1,036 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))
27. 0.000 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201106 cr_12 (cost=25.50..3,942.64 rows=1,078 width=64) (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.001 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201107 cr_13 (cost=25.86..3,840.13 rows=1,043 width=64) (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.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201107_pkey (cost=0.00..25.60 rows=1,043 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))
31. 0.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201108 cr_14 (cost=27.46..4,281.99 rows=1,169 width=64) (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,644.87 rows=984 width=64) (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.000 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201110 cr_16 (cost=24.18..3,608.57 rows=974 width=64) (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))
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.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201111 cr_17 (cost=24.01..3,556.84 rows=961 width=64) (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))
38. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201111_pkey (cost=0.00..23.77 rows=961 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))
39. 0.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201112 cr_18 (cost=24.52..3,703.99 rows=1,001 width=64) (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.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201112_pkey (cost=0.00..24.27 rows=1,001 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))
41. 0.001 0.016 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201201 cr_19 (cost=23.95..3,547.22 rows=956 width=64) (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.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201201_pkey (cost=0.00..23.71 rows=956 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))
43. 0.000 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201202 cr_20 (cost=24.65..3,744.36 rows=1,011 width=64) (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))
44. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201202_pkey (cost=0.00..24.40 rows=1,011 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))
45. 0.001 0.015 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201203 cr_21 (cost=26.06..3,935.22 rows=1,059 width=64) (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,907.69 rows=1,052 width=64) (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.000 0.011 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201205 cr_23 (cost=26.28..4,006.56 rows=1,076 width=64) (actual time=0.011..0.011 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.000 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201206 cr_24 (cost=26.11..3,960.56 rows=1,063 width=64) (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))
52. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201206_pkey (cost=0.00..25.85 rows=1,063 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))
53. 0.000 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201207 cr_25 (cost=27.77..4,210.12 rows=1,130 width=64) (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))
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.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201208 cr_26 (cost=26.84..4,174.87 rows=1,120 width=64) (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.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201208_pkey (cost=0.00..26.56 rows=1,120 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))
57. 0.000 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201209 cr_27 (cost=26.60..4,107.20 rows=1,101 width=64) (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))
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,945.92 rows=1,052 width=64) (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.000 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201211 cr_29 (cost=25.69..3,868.16 rows=1,030 width=64) (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))
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.013 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201212 cr_30 (cost=27.34..4,123.73 rows=1,097 width=64) (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))
64. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201212_pkey (cost=0.00..27.07 rows=1,097 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))
65. 0.000 0.036 ↓ 0.0 0 1

Bitmap Heap Scan on countdata_raw201301 cr_31 (cost=27.18..4,079.92 rows=1,084 width=64) (actual time=0.036..0.036 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.036 0.036 ↓ 0.0 0 1

Bitmap Index Scan on countdata_raw201301_pkey (cost=0.00..26.91 rows=1,084 width=0) (actual time=0.036..0.036 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. 0.022 0.065 ↑ 14.2 70 1

Bitmap Heap Scan on countdata_raw201302 cr_32 (cost=25.24..3,746.09 rows=995 width=64) (actual time=0.060..0.065 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.043 0.043 ↑ 5.1 194 1

Bitmap Index Scan on countdata_raw201302_pkey (cost=0.00..25.00 rows=995 width=0) (actual time=0.043..0.043 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. 0.162 0.488 ↑ 1.6 743 1

Bitmap Heap Scan on countdata_raw201303 cr_33 (cost=29.45..4,495.83 rows=1,199 width=64) (actual time=0.410..0.488 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.326 0.326 ↓ 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.326..0.326 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. 0.152 0.463 ↑ 1.6 720 1

Bitmap Heap Scan on countdata_raw201304 cr_34 (cost=28.95..4,356.60 rows=1,160 width=64) (actual time=0.387..0.463 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.311 0.311 ↓ 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.311..0.311 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. 0.147 0.461 ↑ 1.6 744 1

Bitmap Heap Scan on countdata_raw201305 cr_35 (cost=29.51..4,517.94 rows=1,204 width=64) (actual time=0.387..0.461 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.314 0.314 ↓ 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.314..0.314 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. 0.152 0.457 ↑ 1.6 720 1

Bitmap Heap Scan on countdata_raw201306 cr_36 (cost=29.17..4,427.27 rows=1,177 width=64) (actual time=0.381..0.457 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.305 0.305 ↓ 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.305..0.305 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. 0.155 0.467 ↑ 1.7 744 1

Bitmap Heap Scan on countdata_raw201307 cr_37 (cost=30.80..4,678.09 rows=1,242 width=64) (actual time=0.388..0.467 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.312 0.312 ↓ 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.312..0.312 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. 0.162 0.474 ↑ 1.8 744 1

Bitmap Heap Scan on countdata_raw201308 cr_38 (cost=31.62..4,914.99 rows=1,307 width=64) (actual time=0.394..0.474 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.312 0.312 ↓ 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.312..0.312 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. 0.152 0.456 ↑ 1.8 720 1

Bitmap Heap Scan on countdata_raw201309 cr_39 (cost=31.04..4,753.60 rows=1,261 width=64) (actual time=0.380..0.456 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.304 0.304 ↓ 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.304..0.304 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. 0.159 0.475 ↑ 1.7 745 1

Bitmap Heap Scan on countdata_raw201310 cr_40 (cost=31.79..4,756.29 rows=1,257 width=64) (actual time=0.395..0.475 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.316 0.316 ↓ 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.316..0.316 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. 0.126 0.349 ↑ 1.7 720 1

Bitmap Heap Scan on countdata_raw201311 cr_41 (cost=31.32..4,616.86 rows=1,220 width=64) (actual time=0.266..0.349 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.223 0.223 ↓ 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.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))
87. 0.119 0.357 ↑ 1.8 744 1

Bitmap Heap Scan on countdata_raw201312 cr_42 (cost=32.97..5,100.56 rows=1,350 width=64) (actual time=0.280..0.357 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.238 0.238 ↓ 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.238..0.238 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. 0.122 0.346 ↑ 1.7 744 1

Bitmap Heap Scan on countdata_raw201401 cr_43 (cost=33.06..4,898.16 rows=1,294 width=64) (actual time=0.267..0.346 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.224 0.224 ↓ 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.224..0.224 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.106 0.304 ↑ 1.8 672 1

Bitmap Heap Scan on countdata_raw201402 cr_44 (cost=29.75..4,621.88 rows=1,223 width=64) (actual time=0.235..0.304 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.198 0.198 ↓ 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.198..0.198 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. 0.119 0.340 ↑ 1.7 742 1

Bitmap Heap Scan on countdata_raw201403 cr_45 (cost=32.14..4,872.40 rows=1,285 width=64) (actual time=0.261..0.340 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.221 0.221 ↓ 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.221..0.221 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.111 0.329 ↑ 1.9 720 1

Bitmap Heap Scan on countdata_raw201404 cr_46 (cost=32.91..5,089.87 rows=1,345 width=64) (actual time=0.257..0.329 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.218 0.218 ↓ 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.217..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))
97. 0.120 0.341 ↑ 1.7 744 1

Bitmap Heap Scan on countdata_raw201405 cr_47 (cost=33.02..4,906.14 rows=1,291 width=64) (actual time=0.265..0.341 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.221 0.221 ↓ 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.221..0.221 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. 0.139 0.352 ↑ 1.9 720 1

Bitmap Heap Scan on countdata_raw201406 cr_48 (cost=34.05..5,204.39 rows=1,372 width=64) (actual time=0.275..0.352 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.213 0.213 ↓ 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.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))
101. 0.126 0.356 ↑ 1.9 744 1

Bitmap Heap Scan on countdata_raw201407 cr_49 (cost=35.22..5,323.36 rows=1,401 width=64) (actual time=0.277..0.356 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.230 0.230 ↓ 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.230..0.230 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. 0.125 0.354 ↑ 1.8 744 1

Bitmap Heap Scan on countdata_raw201408 cr_50 (cost=34.74..5,190.36 rows=1,363 width=64) (actual time=0.271..0.354 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.229 0.229 ↓ 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.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))
105. 0.117 0.344 ↑ 2.0 720 1

Bitmap Heap Scan on countdata_raw201409 cr_51 (cost=35.99..5,547.69 rows=1,461 width=64) (actual time=0.267..0.344 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. 0.125 0.348 ↑ 2.0 745 1

Bitmap Heap Scan on countdata_raw201410 cr_52 (cost=36.28..5,639.04 rows=1,484 width=64) (actual time=0.268..0.348 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.223 0.223 ↓ 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.223..0.223 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. 0.120 0.338 ↑ 2.0 720 1

Bitmap Heap Scan on countdata_raw201411 cr_53 (cost=35.96..5,539.37 rows=1,459 width=64) (actual time=0.262..0.338 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.218 0.218 ↑ 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.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))
111. 0.121 0.345 ↑ 1.9 744 1

Bitmap Heap Scan on countdata_raw201412 cr_54 (cost=35.40..5,390.44 rows=1,415 width=64) (actual time=0.267..0.345 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.224 0.224 ↓ 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.224..0.224 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. 0.119 0.338 ↑ 2.0 744 1

Bitmap Heap Scan on countdata_raw201501 cr_55 (cost=36.66..5,752.56 rows=1,514 width=64) (actual time=0.262..0.338 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.219 0.219 ↑ 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.219..0.219 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.108 0.307 ↑ 2.0 672 1

Bitmap Heap Scan on countdata_raw201502 cr_56 (cost=33.11..5,171.88 rows=1,361 width=64) (actual time=0.239..0.307 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.199 0.199 ↑ 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.199..0.199 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. 0.136 0.354 ↑ 1.9 742 1

Bitmap Heap Scan on countdata_raw201503 cr_57 (cost=35.32..5,371.39 rows=1,409 width=64) (actual time=0.276..0.354 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. 0.116 0.338 ↑ 1.9 720 1

Bitmap Heap Scan on countdata_raw201504 cr_58 (cost=35.13..5,314.66 rows=1,394 width=64) (actual time=0.265..0.338 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.222 0.222 ↓ 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.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))
121. 0.125 0.342 ↑ 2.0 744 1

Bitmap Heap Scan on countdata_raw201505 cr_59 (cost=36.95..5,621.85 rows=1,474 width=64) (actual time=0.259..0.342 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.217 0.217 ↓ 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.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))
123. 0.121 0.365 ↑ 1.7 795 1

Bitmap Heap Scan on countdata_raw201506 cr_60 (cost=33.98..5,217.94 rows=1,366 width=64) (actual time=0.285..0.365 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.244 0.244 ↓ 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.244..0.244 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. 0.115 0.332 ↑ 2.0 744 1

Bitmap Heap Scan on countdata_raw201507 cr_61 (cost=36.98..5,636.07 rows=1,476 width=64) (actual time=0.256..0.332 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.217 0.217 ↓ 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.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))
127. 0.119 0.340 ↑ 2.0 744 1

Bitmap Heap Scan on countdata_raw201508 cr_62 (cost=37.30..5,733.43 rows=1,501 width=64) (actual time=0.262..0.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
128. 0.221 0.221 ↑ 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.221..0.221 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.111 0.324 ↑ 2.0 720 1

Bitmap Heap Scan on countdata_raw201509 cr_63 (cost=35.76..5,514.99 rows=1,443 width=64) (actual time=0.251..0.324 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.213 0.213 ↑ 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.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))
131. 0.117 0.336 ↑ 2.1 745 1

Bitmap Heap Scan on countdata_raw201510 cr_64 (cost=39.09..6,027.16 rows=1,579 width=64) (actual time=0.262..0.336 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.219 0.219 ↑ 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.219..0.219 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. 0.115 0.328 ↑ 2.2 720 1

Bitmap Heap Scan on countdata_raw201511 cr_65 (cost=38.56..6,099.50 rows=1,600 width=64) (actual time=0.253..0.328 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.213 0.213 ↑ 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.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))
135. 0.139 0.350 ↑ 2.1 744 1

Bitmap Heap Scan on countdata_raw201512 cr_66 (cost=37.89..5,914.37 rows=1,547 width=64) (actual time=0.250..0.350 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.211 0.211 ↑ 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.211..0.211 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. 0.121 0.347 ↑ 2.3 744 1

Bitmap Heap Scan on countdata_raw201601 cr_67 (cost=40.41..6,410.54 rows=1,682 width=64) (actual time=0.269..0.347 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.226 0.226 ↑ 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.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))
139. 0.113 0.322 ↑ 2.2 696 1

Bitmap Heap Scan on countdata_raw201602 cr_68 (cost=37.32..5,966.46 rows=1,565 width=64) (actual time=0.249..0.322 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.209 0.209 ↑ 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.209..0.209 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. 0.114 0.341 ↑ 2.3 742 1

Bitmap Heap Scan on countdata_raw201603 cr_69 (cost=40.65..6,485.92 rows=1,701 width=64) (actual time=0.266..0.341 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.227 0.227 ↑ 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.227..0.227 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.113 0.315 ↑ 2.2 720 1

Bitmap Heap Scan on countdata_raw201604 cr_70 (cost=38.66..6,137.26 rows=1,608 width=64) (actual time=0.242..0.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
144. 0.202 0.202 ↑ 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.202..0.202 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. 0.115 0.336 ↑ 2.2 744 1

Bitmap Heap Scan on countdata_raw201605 cr_71 (cost=39.83..6,251.35 rows=1,637 width=64) (actual time=0.263..0.336 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.221 0.221 ↑ 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.221..0.221 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. 0.079 0.188 ↑ 2.1 720 1

Bitmap Heap Scan on countdata_raw201606 cr_72 (cost=37.72..5,871.54 rows=1,534 width=64) (actual time=0.115..0.188 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.109 0.109 ↑ 2.1 720 1

Bitmap Index Scan on countdata_raw201606_pkey (cost=0.00..37.34 rows=1,534 width=0) (actual time=0.109..0.109 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. 0.079 0.188 ↑ 2.1 744 1

Bitmap Heap Scan on countdata_raw201607 cr_73 (cost=39.22..6,085.69 rows=1,589 width=64) (actual time=0.114..0.188 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.109 0.109 ↑ 2.1 744 1

Bitmap Index Scan on countdata_raw201607_pkey (cost=0.00..38.83 rows=1,589 width=0) (actual time=0.109..0.109 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. 0.116 0.323 ↑ 2.2 744 1

Bitmap Heap Scan on countdata_raw201608 cr_74 (cost=40.29..6,395.83 rows=1,673 width=64) (actual time=0.213..0.323 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.207 0.207 ↑ 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.207..0.207 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. 0.117 0.327 ↑ 2.3 720 1

Bitmap Heap Scan on countdata_raw201609 cr_75 (cost=38.97..6,236.85 rows=1,632 width=64) (actual time=0.250..0.327 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.210 0.210 ↑ 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.210..0.210 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. 0.137 0.352 ↑ 2.3 745 1

Bitmap Heap Scan on countdata_raw201610 cr_76 (cost=40.74..6,526.60 rows=1,708 width=64) (actual time=0.220..0.352 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.215 0.215 ↑ 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.215..0.215 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. 0.122 0.345 ↑ 2.3 720 1

Bitmap Heap Scan on countdata_raw201611 cr_77 (cost=40.28..6,387.14 rows=1,672 width=64) (actual time=0.263..0.345 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.223 0.223 ↑ 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.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))
159. 0.133 0.359 ↑ 2.3 744 1

Bitmap Heap Scan on countdata_raw201612 cr_78 (cost=41.87..6,624.68 rows=1,734 width=64) (actual time=0.266..0.359 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.226 0.226 ↑ 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.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))
161. 0.121 0.340 ↑ 2.3 744 1

Bitmap Heap Scan on countdata_raw201701 cr_79 (cost=42.00..6,662.16 rows=1,744 width=64) (actual time=0.263..0.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
162. 0.219 0.219 ↑ 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.219..0.219 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. 0.106 0.306 ↑ 2.4 672 1

Bitmap Heap Scan on countdata_raw201702 cr_80 (cost=38.50..6,091.86 rows=1,595 width=64) (actual time=0.237..0.306 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.200 0.200 ↑ 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.200..0.200 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. 0.117 0.332 ↑ 2.3 742 1

Bitmap Heap Scan on countdata_raw201703 cr_81 (cost=41.62..6,554.04 rows=1,714 width=64) (actual time=0.255..0.332 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.215 0.215 ↑ 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.215..0.215 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. 0.113 0.326 ↑ 2.4 720 1

Bitmap Heap Scan on countdata_raw201704 cr_82 (cost=41.49..6,509.68 rows=1,704 width=64) (actual time=0.255..0.326 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.213 0.213 ↑ 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.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))
169. 0.116 0.334 ↑ 2.3 744 1

Bitmap Heap Scan on countdata_raw201705 cr_83 (cost=41.82..6,618.04 rows=1,730 width=64) (actual time=0.260..0.334 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.218 0.218 ↑ 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.218..0.218 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. 0.116 0.328 ↑ 2.3 720 1

Bitmap Heap Scan on countdata_raw201706 cr_84 (cost=40.45..6,445.99 rows=1,685 width=64) (actual time=0.252..0.328 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.212 0.212 ↑ 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.212..0.212 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. 0.143 0.359 ↑ 2.3 744 1

Bitmap Heap Scan on countdata_raw201707 cr_85 (cost=41.82..6,623.68 rows=1,730 width=64) (actual time=0.278..0.359 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.216 0.216 ↑ 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.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))
175. 0.125 0.356 ↑ 2.4 744 1

Bitmap Heap Scan on countdata_raw201708 cr_86 (cost=43.10..6,765.88 rows=1,768 width=64) (actual time=0.274..0.356 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.231 0.231 ↑ 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.231..0.231 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. 0.121 0.346 ↑ 2.4 720 1

Bitmap Heap Scan on countdata_raw201709 cr_87 (cost=41.64..6,567.46 rows=1,716 width=64) (actual time=0.267..0.346 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.225 0.225 ↑ 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.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))
179. 0.117 0.351 ↑ 2.3 745 1

Bitmap Heap Scan on countdata_raw201710 cr_88 (cost=41.99..6,673.52 rows=1,743 width=64) (actual time=0.275..0.351 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.234 0.234 ↑ 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.234..0.234 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.114 0.323 ↑ 2.4 720 1

Bitmap Heap Scan on countdata_raw201711 cr_89 (cost=41.50..6,531.07 rows=1,705 width=64) (actual time=0.249..0.323 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.209 0.209 ↑ 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.209..0.209 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. 0.231 0.231 ↑ 2.4 744 1

Index Scan using countdata_raw201712_pkey on countdata_raw201712 cr_90 (cost=0.56..1,806.46 rows=1,752 width=64) (actual time=0.017..0.231 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. 0.228 0.228 ↑ 2.4 744 1

Index Scan using countdata_raw201801_pkey on countdata_raw201801 cr_91 (cost=0.56..1,841.46 rows=1,785 width=64) (actual time=0.015..0.228 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. 0.209 0.209 ↑ 2.4 672 1

Index Scan using countdata_raw201802_pkey on countdata_raw201802 cr_92 (cost=0.56..1,666.84 rows=1,615 width=64) (actual time=0.016..0.209 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. 0.227 0.227 ↑ 2.4 742 1

Index Scan using countdata_raw201803_pkey on countdata_raw201803 cr_93 (cost=0.56..1,834.50 rows=1,778 width=64) (actual time=0.014..0.227 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. 0.219 0.219 ↑ 2.4 720 1

Index Scan using countdata_raw201804_pkey on countdata_raw201804 cr_94 (cost=0.56..1,757.03 rows=1,702 width=64) (actual time=0.014..0.219 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. 0.225 0.225 ↑ 2.4 744 1

Index Scan using countdata_raw201805_pkey on countdata_raw201805 cr_95 (cost=0.56..1,879.46 rows=1,822 width=64) (actual time=0.014..0.225 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. 0.250 0.250 ↑ 2.4 720 1

Index Scan using countdata_raw201806_pkey on countdata_raw201806 cr_96 (cost=0.56..1,812.02 rows=1,756 width=64) (actual time=0.019..0.250 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. 0.241 0.241 ↑ 2.3 744 1

Index Scan using countdata_raw201807_pkey on countdata_raw201807 cr_97 (cost=0.56..1,799.74 rows=1,743 width=64) (actual time=0.017..0.241 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. 0.237 0.237 ↑ 2.5 744 1

Index Scan using countdata_raw201808_pkey on countdata_raw201808 cr_98 (cost=0.56..1,890.56 rows=1,832 width=64) (actual time=0.015..0.237 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. 0.236 0.236 ↑ 2.5 720 1

Index Scan using countdata_raw201809_pkey on countdata_raw201809 cr_99 (cost=0.56..1,830.66 rows=1,774 width=64) (actual time=0.015..0.236 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. 0.236 0.236 ↑ 2.4 745 1

Index Scan using countdata_raw201810_pkey on countdata_raw201810 cr_100 (cost=0.56..1,834.60 rows=1,778 width=64) (actual time=0.019..0.236 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. 0.219 0.219 ↑ 2.5 720 1

Index Scan using countdata_raw201811_pkey on countdata_raw201811 cr_101 (cost=0.56..1,838.24 rows=1,784 width=64) (actual time=0.015..0.219 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. 0.224 0.224 ↑ 2.4 744 1

Index Scan using countdata_raw201812_pkey on countdata_raw201812 cr_102 (cost=0.56..1,844.38 rows=1,787 width=64) (actual time=0.016..0.224 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. 0.222 0.222 ↑ 2.4 744 1

Index Scan using countdata_raw201901_pkey on countdata_raw201901 cr_103 (cost=0.56..1,870.84 rows=1,814 width=64) (actual time=0.014..0.222 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. 0.201 0.201 ↑ 2.5 672 1

Index Scan using countdata_raw201902_pkey on countdata_raw201902 cr_104 (cost=0.56..1,714.92 rows=1,669 width=64) (actual time=0.017..0.201 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. 0.227 0.227 ↑ 2.5 742 1

Index Scan using countdata_raw201903_pkey on countdata_raw201903 cr_105 (cost=0.56..1,873.21 rows=1,818 width=64) (actual time=0.014..0.227 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. 0.221 0.221 ↑ 2.5 720 1

Index Scan using countdata_raw201904_pkey on countdata_raw201904 cr_106 (cost=0.56..1,824.72 rows=1,772 width=64) (actual time=0.016..0.221 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. 0.228 0.228 ↑ 2.5 744 1

Index Scan using countdata_raw201905_pkey on countdata_raw201905 cr_107 (cost=0.56..1,927.76 rows=1,870 width=64) (actual time=0.014..0.228 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. 0.236 0.236 ↑ 2.5 720 1

Index Scan using countdata_raw201906_pkey on countdata_raw201906 cr_108 (cost=0.56..1,860.10 rows=1,804 width=64) (actual time=0.016..0.236 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. 0.242 0.242 ↑ 2.5 744 1

Index Scan using countdata_raw201907_pkey on countdata_raw201907 cr_109 (cost=0.56..1,919.14 rows=1,868 width=64) (actual time=0.016..0.242 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. 0.238 0.238 ↑ 2.5 744 1

Index Scan using countdata_raw201908_pkey on countdata_raw201908 cr_110 (cost=0.56..1,882.96 rows=1,825 width=64) (actual time=0.015..0.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))
204. 0.236 0.236 ↑ 2.5 720 1

Index Scan using countdata_raw201909_pkey on countdata_raw201909 cr_111 (cost=0.56..1,825.56 rows=1,769 width=64) (actual time=0.015..0.236 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. 0.230 0.230 ↑ 2.4 745 1

Index Scan using countdata_raw201910_pkey on countdata_raw201910 cr_112 (cost=0.56..1,877.89 rows=1,820 width=64) (actual time=0.015..0.230 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. 0.216 0.216 ↑ 2.4 720 1

Index Scan using countdata_raw201911_pkey on countdata_raw201911 cr_113 (cost=0.56..1,797.67 rows=1,742 width=64) (actual time=0.015..0.216 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. 0.232 0.232 ↑ 2.5 744 1

Index Scan using countdata_raw201912_pkey on countdata_raw201912 cr_114 (cost=0.56..1,882.38 rows=1,826 width=64) (actual time=0.020..0.232 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. 0.232 0.232 ↑ 2.4 744 1

Index Scan using countdata_raw202001_pkey on countdata_raw202001 cr_115 (cost=0.56..1,867.39 rows=1,811 width=64) (actual time=0.013..0.232 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.183 0.183 ↑ 2.5 594 1

Index Scan using countdata_raw202002_pkey on countdata_raw202002 cr_116 (cost=0.56..1,545.83 rows=1,497 width=64) (actual time=0.013..0.183 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.021 0.021 ↑ 15.5 24 1

Index Scan using countdata_raw202003_pkey on countdata_raw202003 cr_117 (cost=0.56..385.99 rows=373 width=64) (actual time=0.015..0.021 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..1.97 rows=1 width=100) (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.002 0.002 ↓ 0.0 0 1

Index Scan using countdata_raw202005_pkey on countdata_raw202005 cr_119 (cost=0.15..1.97 rows=1 width=100) (actual time=0.002..0.002 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.006 0.006 ↓ 0.0 0 1

Index Scan using countdata_raw202006_pkey on countdata_raw202006 cr_120 (cost=0.15..1.97 rows=1 width=100) (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))
214. 0.005 0.005 ↓ 0.0 0 1

Index Scan using countdata_raw202007_pkey on countdata_raw202007 cr_121 (cost=0.27..1.53 rows=1 width=64) (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))
215. 0.005 0.005 ↓ 0.0 0 1

Index Scan using countdata_raw202008_pkey on countdata_raw202008 cr_122 (cost=0.28..1.54 rows=1 width=64) (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))
216. 0.003 0.003 ↓ 0.0 0 1

Index Scan using countdata_raw202009_pkey on countdata_raw202009 cr_123 (cost=0.15..1.97 rows=1 width=100) (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))
217. 0.002 0.002 ↓ 0.0 0 1

Index Scan using countdata_raw202010_pkey on countdata_raw202010 cr_124 (cost=0.15..1.97 rows=1 width=100) (actual time=0.002..0.002 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.002 0.002 ↓ 0.0 0 1

Index Scan using countdata_raw202011_pkey on countdata_raw202011 cr_125 (cost=0.15..1.97 rows=1 width=100) (actual time=0.002..0.002 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.006 0.006 ↓ 0.0 0 1

Index Scan using countdata_raw202012_pkey on countdata_raw202012 cr_126 (cost=0.15..1.97 rows=1 width=100) (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))
220. 0.003 0.003 ↓ 0.0 0 1

Index Scan using countdata_raw202101_pkey on countdata_raw202101 cr_127 (cost=0.15..1.97 rows=1 width=100) (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))
221. 0.002 0.002 ↓ 0.0 0 1

Index Scan using countdata_raw202102_pkey on countdata_raw202102 cr_128 (cost=0.15..1.97 rows=1 width=100) (actual time=0.002..0.002 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.002 0.002 ↓ 0.0 0 1

Index Scan using countdata_raw202103_pkey on countdata_raw202103 cr_129 (cost=0.15..1.97 rows=1 width=100) (actual time=0.002..0.002 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..1.97 rows=1 width=100) (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.002 0.002 ↓ 0.0 0 1

Index Scan using countdata_raw202105_pkey on countdata_raw202105 cr_131 (cost=0.15..1.97 rows=1 width=100) (actual time=0.002..0.002 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..1.97 rows=1 width=100) (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.002 0.002 ↓ 0.0 0 1

Index Scan using countdata_raw202107_pkey on countdata_raw202107 cr_133 (cost=0.15..1.97 rows=1 width=100) (actual time=0.002..0.002 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.54 rows=1 width=64) (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.002 0.002 ↓ 0.0 0 1

Index Scan using countdata_raw202109_pkey on countdata_raw202109 cr_135 (cost=0.15..1.97 rows=1 width=100) (actual time=0.002..0.002 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..1.97 rows=1 width=100) (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.003 0.003 ↓ 0.0 0 1

Index Scan using countdata_raw202111_pkey on countdata_raw202111 cr_137 (cost=0.15..1.97 rows=1 width=100) (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))
231. 0.002 0.002 ↓ 0.0 0 1

Index Scan using countdata_raw202112_pkey on countdata_raw202112 cr_138 (cost=0.15..1.97 rows=1 width=100) (actual time=0.002..0.002 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.009 0.009 ↓ 0.0 0 1

Index Scan using countdata_raw_default_pkey on countdata_raw_default cr_139 (cost=0.42..5.25 rows=1 width=64) (actual time=0.009..0.009 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 : 91.436 ms