explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IoKv : New:

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,338.372 ↓ 0.0 0 1

Subquery Scan on MissingUsage (cost=23,015.36..23,015.42 rows=1 width=140) (actual time=1,338.352..1,338.372 rows=0 loops=1)

  • Filter: (("MissingUsage"."DaysWithoutUsage" > 0) AND ("MissingUsage"."RowNumber" = 1))
2. 0.004 1,338.370 ↓ 0.0 0 1

WindowAgg (cost=23,015.36..23,015.40 rows=1 width=160) (actual time=1,338.350..1,338.370 rows=0 loops=1)

3. 0.024 1,338.366 ↓ 0.0 0 1

Sort (cost=23,015.36..23,015.37 rows=1 width=148) (actual time=1,338.347..1,338.366 rows=0 loops=1)

  • Sort Key: "IR"."MeterId", "EV"."CreatedEpoch" DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.002 1,338.342 ↓ 0.0 0 1

Nested Loop Left Join (cost=19,500.91..23,015.35 rows=1 width=148) (actual time=1,338.323..1,338.342 rows=0 loops=1)

5. 21.076 1,338.340 ↓ 0.0 0 1

Subquery Scan on IR (cost=19,500.62..23,000.58 rows=1 width=99) (actual time=1,338.321..1,338.340 rows=0 loops=1)

  • Filter: (("IR"."DataErrorEventTypeId" IS NOT NULL) AND ("IR"."RegisterRowNumber" = 1))
  • Rows Removed by Filter: 144,040
6. 443.735 1,317.264 ↓ 1.6 144,040 1

WindowAgg (cost=19,500.62..21,906.85 rows=87,499 width=111) (actual time=816.458..1,317.264 rows=144,040 loops=1)

7. 559.875 873.529 ↓ 1.6 144,040 1

Sort (cost=19,500.62..19,719.37 rows=87,499 width=79) (actual time=816.439..873.529 rows=144,040 loops=1)

  • Sort Key: "A"."ReferenceId", "UA"."ReferenceId", "R"."ReadEpoch" DESC
  • Sort Method: external merge Disk: 14,304kB
8. 47.662 313.654 ↓ 1.6 144,040 1

Merge Join (cost=11.23..12,318.28 rows=87,499 width=79) (actual time=0.403..313.654 rows=144,040 loops=1)

  • Merge Cond: ("SPF"."AccountId" = "A"."Id")
9. 40.838 265.810 ↓ 1.6 144,040 1

Nested Loop (cost=10.94..16,720.47 rows=89,626 width=66) (actual time=0.380..265.810 rows=144,040 loops=1)

10. 0.258 3.300 ↓ 1.3 229 1

Nested Loop (cost=10.67..136.35 rows=180 width=66) (actual time=0.353..3.300 rows=229 loops=1)

  • Join Filter: ("UA"."MeterTypeId" = "MT"."Id")
  • Rows Removed by Join Filter: 125
11. 0.448 2.813 ↓ 1.3 229 1

Nested Loop (cost=10.67..130.82 rows=180 width=56) (actual time=0.335..2.813 rows=229 loops=1)

12. 0.471 1.449 ↓ 1.3 229 1

Merge Join (cost=10.38..55.04 rows=180 width=36) (actual time=0.318..1.449 rows=229 loops=1)

  • Merge Cond: ("SPF"."AccountId" = "AP"."AccountId")
13. 0.582 0.582 ↑ 41.8 322 1

Index Only Scan using "ServicePointFlow_AccountId_MeterId_idx" on "ServicePointFlow" "SPF" (cost=0.29..1,485.75 rows=13,468 width=16) (actual time=0.035..0.582 rows=322 loops=1)

  • Heap Fetches: 322
14. 0.241 0.396 ↓ 1.8 236 1

Sort (cost=10.10..10.43 rows=134 width=20) (actual time=0.259..0.396 rows=236 loops=1)

  • Sort Key: "AP"."AccountId
  • Sort Method: quicksort Memory: 35kB
15. 0.155 0.155 ↑ 1.0 134 1

Seq Scan on "AccountProgram" "AP" (cost=0.00..5.36 rows=134 width=20) (actual time=0.020..0.155 rows=134 loops=1)

  • Filter: (("DeletedEpoch" IS NULL) AND ("ProgramType" = 'Prepay'::programtype))
  • Rows Removed by Filter: 55
16. 0.916 0.916 ↑ 1.0 1 229

Index Scan using "UtilityAsset_pkey" on "UtilityAsset" "UA" (cost=0.29..0.42 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=229)

  • Index Cond: ("Id" = "SPF"."MeterId")
17. 0.221 0.229 ↑ 1.0 2 229

Materialize (cost=0.00..1.03 rows=2 width=18) (actual time=0.000..0.001 rows=2 loops=229)

18. 0.008 0.008 ↑ 1.0 2 1

Seq Scan on "MeterType" "MT" (cost=0.00..1.02 rows=2 width=18) (actual time=0.008..0.008 rows=2 loops=1)

19. 26.335 221.672 ↑ 1.9 629 229

Append (cost=0.28..80.18 rows=1,195 width=16) (actual time=0.062..0.968 rows=629 loops=229)

20. 0.916 0.916 ↑ 22.0 1 229

Index Scan using "Register_p2017_07_MeterId_idx" on "Register_p2017_07" "R" (cost=0.28..0.78 rows=22 width=16) (actual time=0.003..0.004 rows=1 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
21. 0.916 0.916 ↑ 26.0 1 229

Index Scan using "Register_p2017_08_MeterId_idx" on "Register_p2017_08" "R_1" (cost=0.28..0.87 rows=26 width=16) (actual time=0.003..0.004 rows=1 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
22. 1.145 1.145 ↑ 24.0 1 229

Index Scan using "Register_p2017_09_MeterId_idx" on "Register_p2017_09" "R_2" (cost=0.28..0.83 rows=24 width=16) (actual time=0.004..0.005 rows=1 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
23. 1.374 1.374 ↑ 14.5 2 229

Index Scan using "Register_p2017_10_MeterId_idx" on "Register_p2017_10" "R_3" (cost=0.28..0.94 rows=29 width=16) (actual time=0.003..0.006 rows=2 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
24. 1.603 1.603 ↑ 9.0 3 229

Index Scan using "Register_p2017_11_MeterId_idx" on "Register_p2017_11" "R_4" (cost=0.28..0.92 rows=27 width=16) (actual time=0.004..0.007 rows=3 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
25. 1.603 1.603 ↑ 8.7 3 229

Index Scan using "Register_p2017_12_MeterId_idx" on "Register_p2017_12" "R_5" (cost=0.28..0.92 rows=26 width=16) (actual time=0.003..0.007 rows=3 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
26. 1.603 1.603 ↑ 7.3 3 229

Index Scan using "Register_p2018_01_MeterId_idx" on "Register_p2018_01" "R_6" (cost=0.28..0.88 rows=22 width=16) (actual time=0.003..0.007 rows=3 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
27. 1.603 1.603 ↑ 6.2 4 229

Index Scan using "Register_p2018_02_MeterId_idx" on "Register_p2018_02" "R_7" (cost=0.28..0.90 rows=25 width=16) (actual time=0.003..0.007 rows=4 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
28. 2.061 2.061 ↑ 5.4 5 229

Index Scan using "Register_p2018_03_MeterId_idx" on "Register_p2018_03" "R_8" (cost=0.28..0.93 rows=27 width=16) (actual time=0.004..0.009 rows=5 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
29. 1.832 1.832 ↑ 4.5 6 229

Index Scan using "Register_p2018_04_MeterId_idx" on "Register_p2018_04" "R_9" (cost=0.28..0.93 rows=27 width=16) (actual time=0.003..0.008 rows=6 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
30. 2.290 2.290 ↑ 4.0 7 229

Index Scan using "Register_p2018_05_MeterId_idx" on "Register_p2018_05" "R_10" (cost=0.28..0.95 rows=28 width=16) (actual time=0.004..0.010 rows=7 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
31. 2.519 2.519 ↑ 3.5 8 229

Index Scan using "Register_p2018_06_MeterId_idx" on "Register_p2018_06" "R_11" (cost=0.28..0.96 rows=28 width=16) (actual time=0.004..0.011 rows=8 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
32. 2.977 2.977 ↑ 3.2 9 229

Index Scan using "Register_p2018_07_MeterId_idx" on "Register_p2018_07" "R_12" (cost=0.28..0.98 rows=29 width=16) (actual time=0.004..0.013 rows=9 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
33. 2.977 2.977 ↑ 3.0 9 229

Index Scan using "Register_p2018_08_MeterId_idx" on "Register_p2018_08" "R_13" (cost=0.28..0.96 rows=27 width=16) (actual time=0.004..0.013 rows=9 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
34. 3.206 3.206 ↑ 2.8 10 229

Index Scan using "Register_p2018_09_MeterId_idx" on "Register_p2018_09" "R_14" (cost=0.28..0.96 rows=28 width=16) (actual time=0.004..0.014 rows=10 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
35. 3.206 3.206 ↑ 2.6 11 229

Index Scan using "Register_p2018_10_MeterId_idx" on "Register_p2018_10" "R_15" (cost=0.28..0.99 rows=29 width=16) (actual time=0.004..0.014 rows=11 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
36. 3.206 3.206 ↑ 2.5 11 229

Index Scan using "Register_p2018_11_MeterId_idx" on "Register_p2018_11" "R_16" (cost=0.28..0.96 rows=28 width=16) (actual time=0.004..0.014 rows=11 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
37. 4.351 4.351 ↑ 2.2 13 229

Index Scan using "Register_p2018_12_MeterId_idx" on "Register_p2018_12" "R_17" (cost=0.28..0.99 rows=29 width=16) (actual time=0.004..0.019 rows=13 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
38. 7.099 7.099 ↑ 1.3 24 229

Index Scan using "Register_p2019_01_MeterId_idx" on "Register_p2019_01" "R_18" (cost=0.42..2.69 rows=31 width=16) (actual time=0.007..0.031 rows=24 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
39. 6.412 6.412 ↑ 1.2 23 229

Index Scan using "Register_p2019_02_MeterId_idx" on "Register_p2019_02" "R_19" (cost=0.42..2.47 rows=27 width=16) (actual time=0.007..0.028 rows=23 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
40. 7.099 7.099 ↑ 1.2 26 229

Index Scan using "Register_p2019_03_MeterId_idx" on "Register_p2019_03" "R_20" (cost=0.42..2.71 rows=30 width=16) (actual time=0.006..0.031 rows=26 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
41. 6.870 6.870 ↑ 1.2 25 229

Index Scan using "Register_p2019_04_MeterId_idx" on "Register_p2019_04" "R_21" (cost=0.42..2.69 rows=29 width=16) (actual time=0.006..0.030 rows=25 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
42. 7.557 7.557 ↑ 1.2 26 229

Index Scan using "Register_p2019_05_MeterId_idx" on "Register_p2019_05" "R_22" (cost=0.42..2.79 rows=31 width=16) (actual time=0.007..0.033 rows=26 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
43. 7.786 7.786 ↑ 1.2 26 229

Index Scan using "Register_p2019_06_MeterId_idx" on "Register_p2019_06" "R_23" (cost=0.42..2.72 rows=30 width=16) (actual time=0.009..0.034 rows=26 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
44. 7.786 7.786 ↑ 1.1 27 229

Index Scan using "Register_p2019_07_MeterId_idx" on "Register_p2019_07" "R_24" (cost=0.42..2.80 rows=31 width=16) (actual time=0.007..0.034 rows=27 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
45. 7.786 7.786 ↑ 1.2 26 229

Index Scan using "Register_p2019_08_MeterId_idx" on "Register_p2019_08" "R_25" (cost=0.42..2.72 rows=30 width=16) (actual time=0.007..0.034 rows=26 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
46. 6.870 6.870 ↑ 1.1 24 229

Index Scan using "Register_p2019_09_MeterId_idx" on "Register_p2019_09" "R_26" (cost=0.42..2.49 rows=27 width=16) (actual time=0.006..0.030 rows=24 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 2
47. 7.786 7.786 ↑ 1.2 26 229

Index Scan using "Register_p2019_10_MeterId_idx" on "Register_p2019_10" "R_27" (cost=0.42..2.71 rows=30 width=16) (actual time=0.007..0.034 rows=26 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
48. 7.328 7.328 ↑ 1.1 25 229

Index Scan using "Register_p2019_11_MeterId_idx" on "Register_p2019_11" "R_28" (cost=0.42..2.58 rows=28 width=16) (actual time=0.006..0.032 rows=25 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 2
49. 7.786 7.786 ↑ 1.1 28 229

Index Scan using "Register_p2019_12_MeterId_idx" on "Register_p2019_12" "R_29" (cost=0.42..2.77 rows=30 width=16) (actual time=0.007..0.034 rows=28 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
50. 8.015 8.015 ↑ 1.1 28 229

Index Scan using "Register_p2020_01_MeterId_idx" on "Register_p2020_01" "R_30" (cost=0.42..2.81 rows=31 width=16) (actual time=0.007..0.035 rows=28 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 2
51. 9.160 9.160 ↑ 1.1 27 229

Index Scan using "Register_p2020_02_MeterId_idx" on "Register_p2020_02" "R_31" (cost=0.42..2.66 rows=29 width=16) (actual time=0.007..0.040 rows=27 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
52. 9.847 9.847 ↑ 1.1 29 229

Index Scan using "Register_p2020_03_MeterId_idx" on "Register_p2020_03" "R_32" (cost=0.42..2.83 rows=31 width=16) (actual time=0.007..0.043 rows=29 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
53. 9.160 9.160 ↑ 1.1 28 229

Index Scan using "Register_p2020_04_MeterId_idx" on "Register_p2020_04" "R_33" (cost=0.42..2.75 rows=30 width=16) (actual time=0.007..0.040 rows=28 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
54. 9.389 9.389 ↑ 1.1 29 229

Index Scan using "Register_p2020_05_MeterId_idx" on "Register_p2020_05" "R_34" (cost=0.42..2.83 rows=31 width=16) (actual time=0.007..0.041 rows=29 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
55. 9.618 9.618 ↑ 1.1 28 229

Index Scan using "Register_p2020_06_MeterId_idx" on "Register_p2020_06" "R_35" (cost=0.42..2.75 rows=30 width=16) (actual time=0.007..0.042 rows=28 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
56. 5.496 5.496 ↑ 1.1 25 229

Index Scan using "Register_p2020_07_MeterId_idx" on "Register_p2020_07" "R_36" (cost=0.42..2.55 rows=27 width=16) (actual time=0.007..0.024 rows=25 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 5
57. 5.267 5.267 ↑ 1.0 21 229

Index Scan using "Register_p2020_08_MeterId_idx" on "Register_p2020_08" "R_37" (cost=0.42..2.13 rows=22 width=16) (actual time=0.009..0.023 rows=21 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 2
58. 0.458 0.458 ↓ 0.0 0 229

Index Scan using "Register_p2020_09_MeterId_idx" on "Register_p2020_09" "R_38" (cost=0.15..0.24 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
59. 0.229 0.229 ↓ 0.0 0 229

Index Scan using "Register_p2020_10_MeterId_idx" on "Register_p2020_10" "R_39" (cost=0.15..0.24 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
60. 0.229 0.229 ↓ 0.0 0 229

Index Scan using "Register_p2020_11_MeterId_idx" on "Register_p2020_11" "R_40" (cost=0.15..0.24 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
61. 0.229 0.229 ↓ 0.0 0 229

Index Scan using "Register_p2020_12_MeterId_idx" on "Register_p2020_12" "R_41" (cost=0.15..0.24 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
62. 0.687 0.687 ↓ 0.0 0 229

Index Scan using "Register_default_MeterId_idx" on "Register_default" "R_42" (cost=0.28..3.12 rows=125 width=16) (actual time=0.003..0.003 rows=0 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
63. 0.182 0.182 ↑ 36.3 187 1

Index Scan using "Account_pkey" on "Account" "A" (cost=0.28..511.17 rows=6,783 width=37) (actual time=0.016..0.182 rows=187 loops=1)

  • Filter: ("UtilityId" = 1)
64. 0.000 0.000 ↓ 0.0 0

Index Scan using "Event_MeterId" on "Event" "EV" (cost=0.29..14.73 rows=4 width=57) (never executed)

  • Index Cond: ("MeterId" = "IR"."MeterId")
Planning time : 34.826 ms
Execution time : 1,343.944 ms