explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OSAN

Settings
# exclusive inclusive rows x rows loops node
1. 267.824 270.402 ↑ 1.0 1 1

Gather (cost=2,224.48..2,231.34 rows=1 width=16) (actual time=260.727..270.402 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.017 2.578 ↑ 1.0 1 1 / 2

Limit (cost=1,224.48..1,231.24 rows=1 width=16) (actual time=5.123..5.156 rows=1 loops=1)

3. 0.011 2.561 ↑ 4,036.0 1 1 / 2

Merge Append (cost=1,224.48..28,526.44 rows=4,036 width=16) (actual time=5.121..5.121 rows=1 loops=1)

  • Sort Key: mp.readdate DESC
  • Subplans Removed: 3,504
4. 0.028 0.028 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190805_meteringrecord_readdate_idx on metering_point_20190805 mp (cost=0.42..37.76 rows=1 width=16) (actual time=0.055..0.055 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
5. 0.021 0.021 ↑ 3.0 1 1 / 2

Index Scan Backward using metering_point_20190806_meteringrecord_readdate_idx on metering_point_20190806 mp_1 (cost=0.42..127.32 rows=3 width=16) (actual time=0.041..0.041 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
6. 0.020 0.020 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190807_meteringrecord_readdate_idx on metering_point_20190807 mp_2 (cost=0.42..37.76 rows=1 width=16) (actual time=0.040..0.040 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
7. 0.021 0.021 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190808_meteringrecord_readdate_idx on metering_point_20190808 mp_3 (cost=0.42..37.76 rows=1 width=16) (actual time=0.041..0.041 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
8. 0.018 0.018 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190809_meteringrecord_readdate_idx on metering_point_20190809 mp_4 (cost=0.42..37.76 rows=1 width=16) (actual time=0.037..0.037 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
9. 0.017 0.017 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20190810_meteringrecord_readdate_idx on metering_point_20190810 mp_5 (cost=0.42..167.03 rows=5 width=16) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
10. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190811_meteringrecord_readdate_idx on metering_point_20190811 mp_6 (cost=0.42..146.61 rows=4 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
11. 0.019 0.019 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190812_meteringrecord_readdate_idx on metering_point_20190812 mp_7 (cost=0.42..134.12 rows=4 width=16) (actual time=0.038..0.038 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
12. 0.018 0.018 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190813_meteringrecord_readdate_idx on metering_point_20190813 mp_8 (cost=0.42..37.76 rows=1 width=16) (actual time=0.035..0.036 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
13. 0.020 0.020 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190814_meteringrecord_readdate_idx on metering_point_20190814 mp_9 (cost=0.42..134.12 rows=4 width=16) (actual time=0.040..0.040 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
14. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190815_meteringrecord_readdate_idx on metering_point_20190815 mp_10 (cost=0.42..37.76 rows=1 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
15. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190816_meteringrecord_readdate_idx on metering_point_20190816 mp_11 (cost=0.42..140.91 rows=4 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
16. 0.018 0.018 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190817_meteringrecord_readdate_idx on metering_point_20190817 mp_12 (cost=0.42..37.76 rows=1 width=16) (actual time=0.037..0.037 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
17. 0.017 0.017 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190818_meteringrecord_readdate_idx on metering_point_20190818 mp_13 (cost=0.42..160.23 rows=4 width=16) (actual time=0.034..0.034 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
18. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190819_meteringrecord_readdate_idx on metering_point_20190819 mp_14 (cost=0.42..37.76 rows=1 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
19. 0.018 0.018 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190820_meteringrecord_readdate_idx on metering_point_20190820 mp_15 (cost=0.42..134.12 rows=4 width=16) (actual time=0.037..0.037 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
20. 0.017 0.017 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190821_meteringrecord_readdate_idx on metering_point_20190821 mp_16 (cost=0.42..37.76 rows=1 width=16) (actual time=0.034..0.034 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
21. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190822_meteringrecord_readdate_idx on metering_point_20190822 mp_17 (cost=0.42..140.91 rows=4 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
22. 0.014 0.014 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20190823_meteringrecord_readdate_idx on metering_point_20190823 mp_18 (cost=0.42..167.03 rows=5 width=16) (actual time=0.027..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
23. 0.015 0.015 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20190824_meteringrecord_readdate_idx on metering_point_20190824 mp_19 (cost=0.42..173.85 rows=5 width=16) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
24. 0.015 0.015 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190825_meteringrecord_readdate_idx on metering_point_20190825 mp_20 (cost=0.42..37.76 rows=1 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
25. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190826_meteringrecord_readdate_idx on metering_point_20190826 mp_21 (cost=0.42..154.54 rows=4 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
26. 0.016 0.016 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20190827_meteringrecord_readdate_idx on metering_point_20190827 mp_22 (cost=0.42..173.85 rows=5 width=16) (actual time=0.032..0.032 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
27. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190828_meteringrecord_readdate_idx on metering_point_20190828 mp_23 (cost=0.42..140.91 rows=4 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
28. 0.011 0.011 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20190829_meteringrecord_readdate_idx on metering_point_20190829 mp_24 (cost=0.42..180.65 rows=5 width=16) (actual time=0.022..0.023 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
29. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190830_meteringrecord_readdate_idx on metering_point_20190830 mp_25 (cost=0.42..134.11 rows=4 width=16) (actual time=0.027..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
30. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190831_meteringrecord_readdate_idx on metering_point_20190831 mp_26 (cost=0.42..37.76 rows=1 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
31. 0.015 0.015 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20190901_meteringrecord_readdate_idx on metering_point_20190901 mp_27 (cost=0.42..173.85 rows=5 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
32. 0.011 0.011 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190902_meteringrecord_readdate_idx on metering_point_20190902 mp_28 (cost=0.42..37.76 rows=1 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
33. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190903_meteringrecord_readdate_idx on metering_point_20190903 mp_29 (cost=0.42..140.91 rows=4 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
34. 0.011 0.011 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190904_meteringrecord_readdate_idx on metering_point_20190904 mp_30 (cost=0.42..154.53 rows=4 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
35. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190905_meteringrecord_readdate_idx on metering_point_20190905 mp_31 (cost=0.42..146.61 rows=4 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
36. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190906_meteringrecord_readdate_idx on metering_point_20190906 mp_32 (cost=0.42..160.23 rows=4 width=16) (actual time=0.028..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
37. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190907_meteringrecord_readdate_idx on metering_point_20190907 mp_33 (cost=0.42..160.22 rows=4 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
38. 0.011 0.011 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20190908_meteringrecord_readdate_idx on metering_point_20190908 mp_34 (cost=0.42..172.72 rows=5 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
39. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190909_meteringrecord_readdate_idx on metering_point_20190909 mp_35 (cost=0.42..37.76 rows=1 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
40. 0.015 0.015 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190910_meteringrecord_readdate_idx on metering_point_20190910 mp_36 (cost=0.42..37.76 rows=1 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
41. 0.015 0.015 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190911_meteringrecord_readdate_idx on metering_point_20190911 mp_37 (cost=0.42..37.76 rows=1 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
42. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190912_meteringrecord_readdate_idx on metering_point_20190912 mp_38 (cost=0.42..37.76 rows=1 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
43. 0.017 0.017 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190913_meteringrecord_readdate_idx on metering_point_20190913 mp_39 (cost=0.42..37.76 rows=1 width=16) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
44. 0.014 0.014 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20190914_meteringrecord_readdate_idx on metering_point_20190914 mp_40 (cost=0.42..180.65 rows=5 width=16) (actual time=0.027..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
45. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190915_meteringrecord_readdate_idx on metering_point_20190915 mp_41 (cost=0.42..160.23 rows=4 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
46. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190916_meteringrecord_readdate_idx on metering_point_20190916 mp_42 (cost=0.42..154.54 rows=4 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
47. 0.013 0.013 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20190917_meteringrecord_readdate_idx on metering_point_20190917 mp_43 (cost=0.42..186.34 rows=5 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
48. 0.011 0.011 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190918_meteringrecord_readdate_idx on metering_point_20190918 mp_44 (cost=0.42..140.91 rows=4 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
49. 0.016 0.016 ↑ 3.0 1 1 / 2

Index Scan Backward using metering_point_20190919_meteringrecord_readdate_idx on metering_point_20190919 mp_45 (cost=0.42..126.18 rows=3 width=16) (actual time=0.032..0.032 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
50. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190920_meteringrecord_readdate_idx on metering_point_20190920 mp_46 (cost=0.42..140.91 rows=4 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
51. 0.012 0.012 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190921_meteringrecord_readdate_idx on metering_point_20190921 mp_47 (cost=0.42..153.40 rows=4 width=16) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
52. 0.012 0.012 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20190922_meteringrecord_readdate_idx on metering_point_20190922 mp_48 (cost=0.42..37.76 rows=1 width=16) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
53. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190923_meteringrecord_readdate_idx on metering_point_20190923 mp_49 (cost=0.42..134.11 rows=4 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
54. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190924_meteringrecord_readdate_idx on metering_point_20190924 mp_50 (cost=0.42..153.40 rows=4 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
55. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190925_meteringrecord_readdate_idx on metering_point_20190925 mp_51 (cost=0.42..153.39 rows=4 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
56. 0.011 0.011 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20190926_meteringrecord_readdate_idx on metering_point_20190926 mp_52 (cost=0.42..167.03 rows=5 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
57. 0.015 0.015 ↑ 6.0 1 1 / 2

Index Scan Backward using metering_point_20190927_meteringrecord_readdate_idx on metering_point_20190927 mp_53 (cost=0.42..206.76 rows=6 width=16) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
58. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190928_meteringrecord_readdate_idx on metering_point_20190928 mp_54 (cost=0.42..153.40 rows=4 width=16) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
59. 0.012 0.012 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20190929_meteringrecord_readdate_idx on metering_point_20190929 mp_55 (cost=0.42..180.65 rows=5 width=16) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
60. 0.017 0.017 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20190930_meteringrecord_readdate_idx on metering_point_20190930 mp_56 (cost=0.42..160.23 rows=4 width=16) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
61. 0.014 0.014 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191001_meteringrecord_readdate_idx on metering_point_20191001 mp_57 (cost=0.42..37.76 rows=1 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
62. 0.013 0.013 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191002_meteringrecord_readdate_idx on metering_point_20191002 mp_58 (cost=0.42..199.95 rows=5 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
63. 0.015 0.015 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191003_meteringrecord_readdate_idx on metering_point_20191003 mp_59 (cost=0.42..186.34 rows=5 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
64. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191004_meteringrecord_readdate_idx on metering_point_20191004 mp_60 (cost=0.42..146.61 rows=4 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
65. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191005_meteringrecord_readdate_idx on metering_point_20191005 mp_61 (cost=0.42..154.54 rows=4 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
66. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191006_meteringrecord_readdate_idx on metering_point_20191006 mp_62 (cost=0.42..37.76 rows=1 width=16) (actual time=0.024..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
67. 0.011 0.011 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191007_meteringrecord_readdate_idx on metering_point_20191007 mp_63 (cost=0.42..37.76 rows=1 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
68. 0.013 0.013 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191008_meteringrecord_readdate_idx on metering_point_20191008 mp_64 (cost=0.42..193.14 rows=5 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
69. 0.014 0.014 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191009_meteringrecord_readdate_idx on metering_point_20191009 mp_65 (cost=0.42..37.76 rows=1 width=16) (actual time=0.027..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
70. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191010_meteringrecord_readdate_idx on metering_point_20191010 mp_66 (cost=0.42..134.12 rows=4 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
71. 0.015 0.015 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191011_meteringrecord_readdate_idx on metering_point_20191011 mp_67 (cost=0.42..167.03 rows=5 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
72. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191012_meteringrecord_readdate_idx on metering_point_20191012 mp_68 (cost=0.42..153.40 rows=4 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
73. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191013_meteringrecord_readdate_idx on metering_point_20191013 mp_69 (cost=0.42..134.12 rows=4 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
74. 0.011 0.011 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191014_meteringrecord_readdate_idx on metering_point_20191014 mp_70 (cost=0.42..167.02 rows=5 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
75. 0.017 0.017 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191015_meteringrecord_readdate_idx on metering_point_20191015 mp_71 (cost=0.42..160.23 rows=4 width=16) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
76. 0.015 0.015 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191016_meteringrecord_readdate_idx on metering_point_20191016 mp_72 (cost=0.42..180.65 rows=5 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
77. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191017_meteringrecord_readdate_idx on metering_point_20191017 mp_73 (cost=0.42..146.61 rows=4 width=16) (actual time=0.029..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
78. 0.011 0.011 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191018_meteringrecord_readdate_idx on metering_point_20191018 mp_74 (cost=0.42..153.40 rows=4 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
79. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191019_meteringrecord_readdate_idx on metering_point_20191019 mp_75 (cost=0.42..37.76 rows=1 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
80. 0.018 0.018 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191020_meteringrecord_readdate_idx on metering_point_20191020 mp_76 (cost=0.42..37.76 rows=1 width=16) (actual time=0.036..0.036 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
81. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191021_meteringrecord_readdate_idx on metering_point_20191021 mp_77 (cost=0.42..153.40 rows=4 width=16) (actual time=0.025..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
82. 0.013 0.013 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191022_meteringrecord_readdate_idx on metering_point_20191022 mp_78 (cost=0.42..172.72 rows=5 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
83. 0.014 0.014 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191023_meteringrecord_readdate_idx on metering_point_20191023 mp_79 (cost=0.42..37.76 rows=1 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
84. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191024_meteringrecord_readdate_idx on metering_point_20191024 mp_80 (cost=0.42..160.23 rows=4 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
85. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191025_meteringrecord_readdate_idx on metering_point_20191025 mp_81 (cost=0.42..37.76 rows=1 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
86. 0.013 0.013 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191026_meteringrecord_readdate_idx on metering_point_20191026 mp_82 (cost=0.42..180.65 rows=5 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
87. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191027_meteringrecord_readdate_idx on metering_point_20191027 mp_83 (cost=0.42..160.23 rows=4 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
88. 0.011 0.011 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191028_meteringrecord_readdate_idx on metering_point_20191028 mp_84 (cost=0.42..134.12 rows=4 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
89. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191029_meteringrecord_readdate_idx on metering_point_20191029 mp_85 (cost=0.42..146.61 rows=4 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
90. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191030_meteringrecord_readdate_idx on metering_point_20191030 mp_86 (cost=0.42..37.76 rows=1 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
91. 0.014 0.014 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191031_meteringrecord_readdate_idx on metering_point_20191031 mp_87 (cost=0.42..186.34 rows=5 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
92. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191101_meteringrecord_readdate_idx on metering_point_20191101 mp_88 (cost=0.42..146.61 rows=4 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
93. 0.012 0.012 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191102_meteringrecord_readdate_idx on metering_point_20191102 mp_89 (cost=0.42..140.91 rows=4 width=16) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
94. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191103_meteringrecord_readdate_idx on metering_point_20191103 mp_90 (cost=0.42..38.89 rows=1 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
95. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191104_meteringrecord_readdate_idx on metering_point_20191104 mp_91 (cost=0.42..134.12 rows=4 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
96. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191105_meteringrecord_readdate_idx on metering_point_20191105 mp_92 (cost=0.42..146.61 rows=4 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
97. 0.015 0.015 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191106_meteringrecord_readdate_idx on metering_point_20191106 mp_93 (cost=0.42..172.72 rows=5 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
98. 0.012 0.012 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191107_meteringrecord_readdate_idx on metering_point_20191107 mp_94 (cost=0.42..146.61 rows=4 width=16) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
99. 0.015 0.015 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191108_meteringrecord_readdate_idx on metering_point_20191108 mp_95 (cost=0.42..37.76 rows=1 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
100. 0.017 0.017 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191109_meteringrecord_readdate_idx on metering_point_20191109 mp_96 (cost=0.42..37.76 rows=1 width=16) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
101. 0.013 0.013 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191110_meteringrecord_readdate_idx on metering_point_20191110 mp_97 (cost=0.42..172.72 rows=5 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
102. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191111_meteringrecord_readdate_idx on metering_point_20191111 mp_98 (cost=0.42..160.23 rows=4 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
103. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191112_meteringrecord_readdate_idx on metering_point_20191112 mp_99 (cost=0.42..37.76 rows=1 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
104. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191113_meteringrecord_readdate_idx on metering_point_20191113 mp_100 (cost=0.42..134.12 rows=4 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
105. 0.016 0.016 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191114_meteringrecord_readdate_idx on metering_point_20191114 mp_101 (cost=0.42..134.11 rows=4 width=16) (actual time=0.032..0.032 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
106. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191115_meteringrecord_readdate_idx on metering_point_20191115 mp_102 (cost=0.42..37.76 rows=1 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
107. 0.013 0.013 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191116_meteringrecord_readdate_idx on metering_point_20191116 mp_103 (cost=0.42..167.02 rows=5 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
108. 0.012 0.012 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191117_meteringrecord_readdate_idx on metering_point_20191117 mp_104 (cost=0.42..37.76 rows=1 width=16) (actual time=0.023..0.024 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
109. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191118_meteringrecord_readdate_idx on metering_point_20191118 mp_105 (cost=0.42..146.61 rows=4 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
110. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191119_meteringrecord_readdate_idx on metering_point_20191119 mp_106 (cost=0.42..37.76 rows=1 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
111. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191120_meteringrecord_readdate_idx on metering_point_20191120 mp_107 (cost=0.42..140.91 rows=4 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
112. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191121_meteringrecord_readdate_idx on metering_point_20191121 mp_108 (cost=0.42..37.76 rows=1 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
113. 0.018 0.018 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191122_meteringrecord_readdate_idx on metering_point_20191122 mp_109 (cost=0.42..37.76 rows=1 width=16) (actual time=0.036..0.036 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
114. 0.012 0.012 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191123_meteringrecord_readdate_idx on metering_point_20191123 mp_110 (cost=0.42..160.23 rows=4 width=16) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
115. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191124_meteringrecord_readdate_idx on metering_point_20191124 mp_111 (cost=0.42..37.76 rows=1 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
116. 0.011 0.011 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191125_meteringrecord_readdate_idx on metering_point_20191125 mp_112 (cost=0.42..146.60 rows=4 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
117. 0.015 0.015 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191126_meteringrecord_readdate_idx on metering_point_20191126 mp_113 (cost=0.42..37.76 rows=1 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
118. 0.014 0.014 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191127_meteringrecord_readdate_idx on metering_point_20191127 mp_114 (cost=0.42..37.76 rows=1 width=16) (actual time=0.027..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
119. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191128_meteringrecord_readdate_idx on metering_point_20191128 mp_115 (cost=0.42..134.11 rows=4 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
120. 0.011 0.011 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191129_meteringrecord_readdate_idx on metering_point_20191129 mp_116 (cost=0.42..154.53 rows=4 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
121. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191130_meteringrecord_readdate_idx on metering_point_20191130 mp_117 (cost=0.42..37.76 rows=1 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
122. 0.011 0.011 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191201_meteringrecord_readdate_idx on metering_point_20191201 mp_118 (cost=0.42..37.76 rows=1 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
123. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191202_meteringrecord_readdate_idx on metering_point_20191202 mp_119 (cost=0.42..146.61 rows=4 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
124. 0.011 0.011 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191203_meteringrecord_readdate_idx on metering_point_20191203 mp_120 (cost=0.42..146.61 rows=4 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
125. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191204_meteringrecord_readdate_idx on metering_point_20191204 mp_121 (cost=0.42..146.60 rows=4 width=16) (actual time=0.024..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
126. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191205_meteringrecord_readdate_idx on metering_point_20191205 mp_122 (cost=0.42..37.76 rows=1 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
127. 0.014 0.014 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191206_meteringrecord_readdate_idx on metering_point_20191206 mp_123 (cost=0.42..37.76 rows=1 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
128. 0.015 0.015 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191207_meteringrecord_readdate_idx on metering_point_20191207 mp_124 (cost=0.42..37.76 rows=1 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
129. 0.014 0.014 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191208_meteringrecord_readdate_idx on metering_point_20191208 mp_125 (cost=0.42..37.76 rows=1 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
130. 0.011 0.011 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191209_meteringrecord_readdate_idx on metering_point_20191209 mp_126 (cost=0.42..134.12 rows=4 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
131. 0.015 0.015 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191210_meteringrecord_readdate_idx on metering_point_20191210 mp_127 (cost=0.42..180.65 rows=5 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
132. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191211_meteringrecord_readdate_idx on metering_point_20191211 mp_128 (cost=0.42..37.76 rows=1 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
133. 0.015 0.015 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191212_meteringrecord_readdate_idx on metering_point_20191212 mp_129 (cost=0.42..37.76 rows=1 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
134. 0.011 0.011 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191213_meteringrecord_readdate_idx on metering_point_20191213 mp_130 (cost=0.42..37.76 rows=1 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
135. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191214_meteringrecord_readdate_idx on metering_point_20191214 mp_131 (cost=0.42..160.23 rows=4 width=16) (actual time=0.029..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
136. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191215_meteringrecord_readdate_idx on metering_point_20191215 mp_132 (cost=0.42..37.76 rows=1 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
137. 0.017 0.017 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191216_meteringrecord_readdate_idx on metering_point_20191216 mp_133 (cost=0.42..37.76 rows=1 width=16) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
138. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191217_meteringrecord_readdate_idx on metering_point_20191217 mp_134 (cost=0.42..37.76 rows=1 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
139. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191218_meteringrecord_readdate_idx on metering_point_20191218 mp_135 (cost=0.42..37.76 rows=1 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
140. 0.011 0.011 ↑ 3.0 1 1 / 2

Index Scan Backward using metering_point_20191219_meteringrecord_readdate_idx on metering_point_20191219 mp_136 (cost=0.42..126.19 rows=3 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
141. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191220_meteringrecord_readdate_idx on metering_point_20191220 mp_137 (cost=0.42..160.23 rows=4 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
142. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191221_meteringrecord_readdate_idx on metering_point_20191221 mp_138 (cost=0.42..140.91 rows=4 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
143. 0.015 0.015 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191222_meteringrecord_readdate_idx on metering_point_20191222 mp_139 (cost=0.42..37.76 rows=1 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
144. 0.011 0.011 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191223_meteringrecord_readdate_idx on metering_point_20191223 mp_140 (cost=0.42..134.12 rows=4 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
145. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191224_meteringrecord_readdate_idx on metering_point_20191224 mp_141 (cost=0.42..134.11 rows=4 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
146. 0.013 0.013 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191225_meteringrecord_readdate_idx on metering_point_20191225 mp_142 (cost=0.42..146.61 rows=4 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
147. 0.013 0.013 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20191226_meteringrecord_readdate_idx on metering_point_20191226 mp_143 (cost=0.42..199.96 rows=5 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
148. 0.011 0.011 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191227_meteringrecord_readdate_idx on metering_point_20191227 mp_144 (cost=0.42..134.12 rows=4 width=16) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
149. 0.014 0.014 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20191228_meteringrecord_readdate_idx on metering_point_20191228 mp_145 (cost=0.42..37.76 rows=1 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
150. 0.011 0.011 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191229_meteringrecord_readdate_idx on metering_point_20191229 mp_146 (cost=0.42..134.12 rows=4 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
151. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191230_meteringrecord_readdate_idx on metering_point_20191230 mp_147 (cost=0.42..154.54 rows=4 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
152. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20191231_meteringrecord_readdate_idx on metering_point_20191231 mp_148 (cost=0.42..147.74 rows=4 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
153. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200101_meteringrecord_readdate_idx on metering_point_20200101 mp_149 (cost=0.42..37.76 rows=1 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
154. 0.015 0.015 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200102_meteringrecord_readdate_idx on metering_point_20200102 mp_150 (cost=0.42..37.76 rows=1 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
155. 0.013 0.013 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20200103_meteringrecord_readdate_idx on metering_point_20200103 mp_151 (cost=0.42..173.85 rows=5 width=16) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
156. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200104_meteringrecord_readdate_idx on metering_point_20200104 mp_152 (cost=0.42..37.76 rows=1 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
157. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200105_meteringrecord_readdate_idx on metering_point_20200105 mp_153 (cost=0.42..37.76 rows=1 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
158. 0.015 0.015 ↑ 5.0 1 1 / 2

Index Scan Backward using metering_point_20200106_meteringrecord_readdate_idx on metering_point_20200106 mp_154 (cost=0.42..167.02 rows=5 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
159. 0.014 0.014 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200107_meteringrecord_readdate_idx on metering_point_20200107 mp_155 (cost=0.42..37.76 rows=1 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
160. 0.013 0.013 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200108_meteringrecord_readdate_idx on metering_point_20200108 mp_156 (cost=0.42..37.76 rows=1 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
161. 0.013 0.013 ↑ 3.0 1 1 / 2

Index Scan Backward using metering_point_20200109_meteringrecord_readdate_idx on metering_point_20200109 mp_157 (cost=0.42..127.31 rows=3 width=16) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
162. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20200110_meteringrecord_readdate_idx on metering_point_20200110 mp_158 (cost=0.42..140.91 rows=4 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
163. 0.015 0.015 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20200111_meteringrecord_readdate_idx on metering_point_20200111 mp_159 (cost=0.42..154.53 rows=4 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
164. 0.012 0.012 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200112_meteringrecord_readdate_idx on metering_point_20200112 mp_160 (cost=0.42..37.76 rows=1 width=16) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
165. 0.014 0.014 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20200113_meteringrecord_readdate_idx on metering_point_20200113 mp_161 (cost=0.42..134.12 rows=4 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
166. 0.014 0.014 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200114_meteringrecord_readdate_idx on metering_point_20200114 mp_162 (cost=0.42..37.76 rows=1 width=16) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
167. 0.014 0.014 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200115_meteringrecord_readdate_idx on metering_point_20200115 mp_163 (cost=0.42..37.76 rows=1 width=16) (actual time=0.027..0.028 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
168. 0.018 0.018 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200116_meteringrecord_readdate_idx on metering_point_20200116 mp_164 (cost=0.42..37.76 rows=1 width=16) (actual time=0.035..0.035 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
169. 0.018 0.018 ↑ 4.0 1 1 / 2

Index Scan Backward using metering_point_20200117_meteringrecord_readdate_idx on metering_point_20200117 mp_165 (cost=0.42..146.61 rows=4 width=16) (actual time=0.036..0.036 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
170. 0.011 0.011 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200118_meteringrecord_readdate_idx on metering_point_20200118 mp_166 (cost=0.42..37.76 rows=1 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
171. 0.018 0.018 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200119_meteringrecord_readdate_idx on metering_point_20200119 mp_167 (cost=0.42..37.76 rows=1 width=16) (actual time=0.035..0.035 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
172. 0.011 0.011 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200120_meteringrecord_readdate_idx on metering_point_20200120 mp_168 (cost=0.42..66.07 rows=2 width=16) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
173. 0.011 0.011 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200121_meteringrecord_readdate_idx on metering_point_20200121 mp_169 (cost=0.42..66.07 rows=2 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
174. 0.011 0.011 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200122_meteringrecord_readdate_idx on metering_point_20200122 mp_170 (cost=0.42..66.07 rows=2 width=16) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
175. 0.010 0.010 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200123_meteringrecord_readdate_idx on metering_point_20200123 mp_171 (cost=0.42..66.07 rows=2 width=16) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
176. 0.009 0.009 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200124_meteringrecord_readdate_idx on metering_point_20200124 mp_172 (cost=0.42..66.07 rows=2 width=16) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
177. 0.012 0.012 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200125_meteringrecord_readdate_idx on metering_point_20200125 mp_173 (cost=0.42..66.07 rows=2 width=16) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
178. 0.009 0.009 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200126_meteringrecord_readdate_idx on metering_point_20200126 mp_174 (cost=0.42..66.07 rows=2 width=16) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
179. 0.015 0.015 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200127_meteringrecord_readdate_idx on metering_point_20200127 mp_175 (cost=0.42..64.94 rows=2 width=16) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
180. 0.009 0.009 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200128_meteringrecord_readdate_idx on metering_point_20200128 mp_176 (cost=0.42..64.94 rows=2 width=16) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
181. 0.010 0.010 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200129_meteringrecord_readdate_idx on metering_point_20200129 mp_177 (cost=0.42..64.94 rows=2 width=16) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
182. 0.005 0.005 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200130_meteringrecord_readdate_idx on metering_point_20200130 mp_178 (cost=0.42..64.94 rows=2 width=16) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
183. 0.012 0.012 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200131_meteringrecord_readdate_idx on metering_point_20200131 mp_179 (cost=0.42..64.94 rows=2 width=16) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
184. 0.009 0.009 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200201_meteringrecord_readdate_idx on metering_point_20200201 mp_180 (cost=0.42..66.07 rows=2 width=16) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
185. 0.009 0.009 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200202_meteringrecord_readdate_idx on metering_point_20200202 mp_181 (cost=0.42..66.07 rows=2 width=16) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
186. 0.009 0.009 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200203_meteringrecord_readdate_idx on metering_point_20200203 mp_182 (cost=0.42..66.07 rows=2 width=16) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
187. 0.018 0.018 ↑ 2.0 1 1 / 2

Index Scan Backward using metering_point_20200204_meteringrecord_readdate_idx on metering_point_20200204 mp_183 (cost=0.42..66.07 rows=2 width=16) (actual time=0.036..0.036 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
188. 0.027 0.027 ↑ 1.0 1 1 / 2

Index Scan Backward using metering_point_20200205_meteringrecord_readdate_idx on metering_point_20200205 mp_184 (cost=0.42..4.92 rows=1 width=16) (actual time=0.054..0.054 rows=1 loops=1)

  • Index Cond: ((meteringrecord = '2000000016861'::bigint) AND (readdate >= '2019-08-05 00:00:00'::timestamp without time zone) AND (readdate <= '2020-02-05 00:00:00-06'::timestamp with time zone))
  • Filter: ((meteringsource % '10000'::bigint) = ANY ('{1005,1010,1015,1020,1030,1060}'::bigint[]))
  • Rows Removed by Filter: 3