explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1tOj

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Group (cost=108,104,023.69..108,128,727.70 rows=1,097,956 width=44) (actual rows= loops=)

  • Group Key: nmi.nmi_id, nmi.network_tariff_type_cd, (date_part('month'::text, timezone('AEST'::text, mconr.start_timestamptz_ts))), (date_part('year'::text, timezone('AEST'::text, mconr.start_timestamptz_ts)))
2. 0.000 0.000 ↓ 0.0

Sort (cost=108,104,023.69..108,106,768.58 rows=1,097,956 width=33) (actual rows= loops=)

  • Sort Key: nmi.nmi_id, nmi.network_tariff_type_cd, (date_part('month'::text, timezone('AEST'::text, mconr.start_timestamptz_ts))), (date_part('year'::text, timezone('AEST'::text, mconr.start_timestamptz_ts)))
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=893,312.99..107,993,863.63 rows=1,097,956 width=33) (actual rows= loops=)

  • Hash Cond: (mconr.meter_id = m.meter_id)
  • Join Filter: ((mconr.start_timestamptz_ts >= m.effective_from_ts) AND (mconr.start_timestamptz_ts <= m.effective_to_ts) AND (mconr.start_timestamptz_ts >= nmi.effective_from_ts) AND (mconr.start_timestamptz_ts <= nmi.effective_to_ts))
4. 0.000 0.000 ↓ 0.0

Append (cost=0.00..104,953,436.01 rows=47,659,462 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading mconr (cost=0.00..0.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
6. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_01 mconr_1 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
7. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_02 mconr_2 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
8. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_03 mconr_3 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
9. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_04 mconr_4 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
10. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_05 mconr_5 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
11. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_06 mconr_6 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
12. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_07 mconr_7 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
13. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_08 mconr_8 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
14. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_09 mconr_9 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
15. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_10 mconr_10 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
16. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_11 mconr_11 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
17. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_12 mconr_12 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
18. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_13 mconr_13 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
19. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_14 mconr_14 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
20. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_15 mconr_15 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
21. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_16 mconr_16 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
22. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_17 mconr_17 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
23. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_18 mconr_18 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
24. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_19 mconr_19 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
25. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_20 mconr_20 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
26. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_21 mconr_21 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
27. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_22 mconr_22 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
28. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_23 mconr_23 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
29. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_24 mconr_24 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
30. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_25 mconr_25 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
31. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_26 mconr_26 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
32. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_27 mconr_27 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
33. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_28 mconr_28 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
34. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_29 mconr_29 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
35. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_30 mconr_30 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
36. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_07_31 mconr_31 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
37. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_01 mconr_32 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
38. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_02 mconr_33 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
39. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_03 mconr_34 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
40. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_04 mconr_35 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
41. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_05 mconr_36 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
42. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_06 mconr_37 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
43. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_07 mconr_38 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
44. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_08 mconr_39 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
45. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_09 mconr_40 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
46. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_10 mconr_41 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
47. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_11 mconr_42 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
48. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_12 mconr_43 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
49. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_13 mconr_44 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
50. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_14 mconr_45 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
51. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_15 mconr_46 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
52. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_16 mconr_47 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
53. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_17 mconr_48 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
54. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_18 mconr_49 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
55. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_19 mconr_50 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
56. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_20 mconr_51 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
57. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_21 mconr_52 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
58. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_22 mconr_53 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
59. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_23 mconr_54 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
60. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_24 mconr_55 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
61. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_25 mconr_56 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
62. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_26 mconr_57 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
63. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_27 mconr_58 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
64. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_28 mconr_59 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
65. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_29 mconr_60 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
66. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_30 mconr_61 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
67. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_08_31 mconr_62 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
68. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_01 mconr_63 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
69. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_02 mconr_64 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
70. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_03 mconr_65 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
71. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_04 mconr_66 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
72. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_05 mconr_67 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
73. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_06 mconr_68 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
74. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_07 mconr_69 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
75. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_08 mconr_70 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
76. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_09 mconr_71 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
77. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_10 mconr_72 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
78. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_11 mconr_73 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
79. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_12 mconr_74 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
80. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_13 mconr_75 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
81. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_14 mconr_76 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
82. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_15 mconr_77 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
83. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_16 mconr_78 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
84. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_17 mconr_79 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
85. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_18 mconr_80 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
86. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_19 mconr_81 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
87. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_20 mconr_82 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
88. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_21 mconr_83 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
89. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_22 mconr_84 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
90. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_23 mconr_85 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
91. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_24 mconr_86 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
92. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_25 mconr_87 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
93. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_26 mconr_88 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
94. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_27 mconr_89 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
95. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_28 mconr_90 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
96. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_29 mconr_91 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
97. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_09_30 mconr_92 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
98. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_01 mconr_93 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
99. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_02 mconr_94 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
100. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_03 mconr_95 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
101. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_04 mconr_96 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
102. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_05 mconr_97 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
103. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_06 mconr_98 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
104. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_07 mconr_99 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
105. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_08 mconr_100 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
106. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_09 mconr_101 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
107. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_10 mconr_102 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
108. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_11 mconr_103 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
109. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_12 mconr_104 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
110. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_13 mconr_105 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
111. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_14 mconr_106 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
112. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_15 mconr_107 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
113. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_16 mconr_108 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
114. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_17 mconr_109 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
115. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_18 mconr_110 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
116. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_19 mconr_111 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
117. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_20 mconr_112 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
118. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_21 mconr_113 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
119. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_22 mconr_114 (cost=0.00..1,334,431.23 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
120. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_23 mconr_115 (cost=0.00..1,334,683.30 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
121. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_24 mconr_116 (cost=0.00..1,334,755.40 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
122. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_25 mconr_117 (cost=0.00..1,332,533.08 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
123. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_26 mconr_118 (cost=0.00..1,334,558.22 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
124. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_27 mconr_119 (cost=0.00..1,334,963.77 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
125. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_28 mconr_120 (cost=0.00..1,334,815.18 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
126. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_29 mconr_121 (cost=0.00..1,335,239.70 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
127. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_30 mconr_122 (cost=0.00..1,335,288.46 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
128. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_10_31 mconr_123 (cost=0.00..1,335,267.90 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
129. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_01 mconr_124 (cost=0.00..1,334,977.42 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
130. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_02 mconr_125 (cost=0.00..1,335,171.08 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
131. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_03 mconr_126 (cost=0.00..1,335,483.18 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
132. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_04 mconr_127 (cost=0.00..1,335,310.22 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
133. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_05 mconr_128 (cost=0.00..1,335,189.69 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
134. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_06 mconr_129 (cost=0.00..1,334,898.44 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
135. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_07 mconr_130 (cost=0.00..1,335,837.77 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
136. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_08 mconr_131 (cost=0.00..1,335,630.40 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
137. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_09 mconr_132 (cost=0.00..1,335,374.45 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
138. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_10 mconr_133 (cost=0.00..1,335,574.30 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
139. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_11 mconr_134 (cost=0.00..1,335,501.17 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
140. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_12 mconr_135 (cost=0.00..1,335,111.36 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
141. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_13 mconr_136 (cost=0.00..1,331,931.79 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
142. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_14 mconr_137 (cost=0.00..1,332,232.41 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
143. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_15 mconr_138 (cost=0.00..1,332,624.43 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
144. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_16 mconr_139 (cost=0.00..1,332,328.51 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
145. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_17 mconr_140 (cost=0.00..1,332,498.35 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
146. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_18 mconr_141 (cost=0.00..1,327,837.46 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
147. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_19 mconr_142 (cost=0.00..1,332,510.73 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
148. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_20 mconr_143 (cost=0.00..1,332,146.30 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
149. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_21 mconr_144 (cost=0.00..1,333,012.09 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
150. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_22 mconr_145 (cost=0.00..1,330,685.14 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
151. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_23 mconr_146 (cost=0.00..1,332,515.23 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
152. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_24 mconr_147 (cost=0.00..1,332,831.31 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
153. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_25 mconr_148 (cost=0.00..1,332,848.75 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
154. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_26 mconr_149 (cost=0.00..1,334,527.62 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
155. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_27 mconr_150 (cost=0.00..1,335,696.05 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
156. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_28 mconr_151 (cost=0.00..1,335,902.92 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
157. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_29 mconr_152 (cost=0.00..1,335,974.18 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
158. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_11_30 mconr_153 (cost=0.00..1,336,068.99 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
159. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_01 mconr_154 (cost=0.00..1,336,402.85 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
160. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_02 mconr_155 (cost=0.00..1,336,420.79 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
161. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_03 mconr_156 (cost=0.00..1,329,841.10 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
162. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_04 mconr_157 (cost=0.00..1,331,444.99 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
163. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_05 mconr_158 (cost=0.00..1,334,088.21 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
164. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_06 mconr_159 (cost=0.00..1,335,317.94 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
165. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_07 mconr_160 (cost=0.00..1,336,929.76 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
166. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_08 mconr_161 (cost=0.00..1,336,478.96 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
167. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_09 mconr_162 (cost=0.00..1,336,342.60 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
168. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_10 mconr_163 (cost=0.00..1,335,231.26 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
169. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_11 mconr_164 (cost=0.00..1,336,770.47 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
170. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_12 mconr_165 (cost=0.00..1,336,926.71 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
171. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_13 mconr_166 (cost=0.00..1,336,439.50 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
172. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_14 mconr_167 (cost=0.00..1,336,653.18 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
173. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_15 mconr_168 (cost=0.00..1,336,963.76 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
174. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_16 mconr_169 (cost=0.00..1,337,034.35 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
175. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_17 mconr_170 (cost=0.00..1,336,918.44 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
176. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_18 mconr_171 (cost=0.00..1,336,268.16 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
177. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_19 mconr_172 (cost=0.00..1,336,516.09 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
178. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_20 mconr_173 (cost=0.00..1,337,094.90 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
179. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_21 mconr_174 (cost=0.00..1,336,750.01 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
180. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_22 mconr_175 (cost=0.00..1,336,899.68 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
181. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_23 mconr_176 (cost=0.00..1,336,981.86 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
182. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_24 mconr_177 (cost=0.00..1,336,563.99 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
183. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_25 mconr_178 (cost=0.00..1,337,016.75 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
184. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_26 mconr_179 (cost=0.00..1,337,037.36 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
185. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_27 mconr_180 (cost=0.00..1,337,272.26 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
186. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_28 mconr_181 (cost=0.00..1,337,296.44 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
187. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_29 mconr_182 (cost=0.00..1,336,461.70 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
188. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_30 mconr_183 (cost=0.00..1,336,822.27 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
189. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2018_12_31 mconr_184 (cost=0.00..1,337,080.72 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
190. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_01 mconr_185 (cost=0.00..1,337,363.84 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
191. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_02 mconr_186 (cost=0.00..1,337,067.62 rows=4,705 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
192. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_03 mconr_187 (cost=0.00..1,337,179.21 rows=5,789 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
193. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_04 mconr_188 (cost=0.00..1,337,232.72 rows=7,947 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
194. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_05 mconr_189 (cost=0.00..1,337,102.71 rows=526,663 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
195. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_06 mconr_190 (cost=0.00..1,337,085.59 rows=576,177 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
196. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_07 mconr_191 (cost=0.00..1,324,388.20 rows=28,081,465 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
197. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_08 mconr_192 (cost=0.00..815,982.76 rows=18,456,500 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
198. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_09 mconr_193 (cost=0.00..126.58 rows=8 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
199. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_10 mconr_194 (cost=0.00..57.75 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
200. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_11 mconr_195 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
201. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_12 mconr_196 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
202. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_13 mconr_197 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
203. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_14 mconr_198 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
204. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_15 mconr_199 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
205. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_16 mconr_200 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
206. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_17 mconr_201 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
207. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_18 mconr_202 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
208. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_19 mconr_203 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
209. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_20 mconr_204 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
210. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_21 mconr_205 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
211. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_22 mconr_206 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
212. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_23 mconr_207 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
213. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_24 mconr_208 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
214. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_25 mconr_209 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
215. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_26 mconr_210 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
216. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_27 mconr_211 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
217. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_28 mconr_212 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
218. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_29 mconr_213 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
219. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_30 mconr_214 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
220. 0.000 0.000 ↓ 0.0

Seq Scan on csmt_meter_consumption_reading_2019_01_31 mconr_215 (cost=0.00..21.00 rows=1 width=16) (actual rows= loops=)

  • Filter: ((changed_on_ts < current_date) AND ((active_consumption_kwh < '0'::numeric) OR (active_consumption_kwh > '0'::numeric)) AND (changed_on_ts >= (current_date - '1 day'::interval day)))
221. 0.000 0.000 ↓ 0.0

Hash (cost=838,717.36..838,717.36 rows=4,367,651 width=57) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

Merge Join (cost=228,625.52..838,717.36 rows=4,367,651 width=57) (actual rows= loops=)

  • Merge Cond: (m.national_metering_identifier_id = nmi.national_metering_identifier_id)
223. 0.000 0.000 ↓ 0.0

Merge Append (cost=228,579.31..325,375.18 rows=2,340,599 width=32) (actual rows= loops=)

  • Sort Key: m.national_metering_identifier_id
224. 0.000 0.000 ↓ 0.0

Index Scan using asgp_meter_national_metering_identifier_id_idx on asgp_meter m (cost=0.42..63,560.36 rows=749,217 width=32) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Sort (cost=228,578.88..232,557.33 rows=1,591,382 width=32) (actual rows= loops=)

  • Sort Key: m_1.national_metering_identifier_id
226. 0.000 0.000 ↓ 0.0

Seq Scan on asgp_meter_hist m_1 (cost=0.00..64,651.82 rows=1,591,382 width=32) (actual rows= loops=)

227. 0.000 0.000 ↓ 0.0

Materialize (cost=0.86..457,915.04 rows=4,264,237 width=41) (actual rows= loops=)

228. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.86..447,254.45 rows=4,264,237 width=41) (actual rows= loops=)

  • Sort Key: nmi.national_metering_identifier_id
229. 0.000 0.000 ↓ 0.0

Index Scan using tphr_national_metering_identifier_pk on tphr_national_metering_identifier nmi (cost=0.42..71,497.55 rows=786,370 width=41) (actual rows= loops=)

  • Filter: (((nmi_id)::text !~ '^(?:VERT.*|VMT6.*|VTBT.*|VHTS.*|VRW2.*|VCBT.*|VRT6.*|VRW6.*|VSVT.*|VTST.*)$'::text) AND ((network_tariff_type_cd)::text !~ '^(?:EE.*)$'::text) AND ((nmi_id)::text <> ALL ('{VMT2WBW43X,VMT2WBW67X,VMT2WBW68X,VMT2WSH36X,VMT2WT21XX,VMT2WT39XX,VMT2WVR126,VMT2WVR20X,VMT2WVR38X}'::text[])))
230. 0.000 0.000 ↓ 0.0

Index Scan using tphr_national_metering_identifier_hist_pk on tphr_national_metering_identifier_hist nmi_1 (cost=0.43..322,453.92 rows=3,477,867 width=41) (actual rows= loops=)

  • Filter: (((nmi_id)::text !~ '^(?:VERT.*|VMT6.*|VTBT.*|VHTS.*|VRW2.*|VCBT.*|VRT6.*|VRW6.*|VSVT.*|VTST.*)$'::text) AND ((network_tariff_type_cd)::text !~ '^(?:EE.*)$'::text) AND ((nmi_id)::text <> ALL ('{VMT2WBW43X,VMT2WBW67X,VMT2WBW68X,VMT2WSH36X,VMT2WT21XX,VMT2WT39XX,VMT2WVR126,VMT2WVR20X,VMT2WVR38X}'::text[])))