explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sRR : Old:

Settings
# exclusive inclusive rows x rows loops node
1. 0.407 798.829 ↑ 2.7 223 1

Subquery Scan on MissingUsage (cost=49,946.34..53,853.30 rows=601 width=140) (actual time=794.953..798.829 rows=223 loops=1)

  • Filter: ("MissingUsage"."RowNumber" = 1)
  • Rows Removed by Filter: 2,814
2. 3.107 798.422 ↑ 39.6 3,037 1

WindowAgg (cost=49,946.34..52,350.62 rows=120,214 width=160) (actual time=794.950..798.422 rows=3,037 loops=1)

3. 2.190 795.315 ↑ 39.6 3,037 1

Sort (cost=49,946.34..50,246.88 rows=120,214 width=152) (actual time=794.941..795.315 rows=3,037 loops=1)

  • Sort Key: sq."MeterId", "EV"."CreatedEpoch" DESC
  • Sort Method: quicksort Memory: 886kB
4. 2.233 793.125 ↑ 39.6 3,037 1

Merge Right Join (cost=28,153.36..30,762.64 rows=120,214 width=152) (actual time=789.062..793.125 rows=3,037 loops=1)

  • Merge Cond: ("EV"."MeterId" = sq."MeterId")
5. 1.573 1.573 ↑ 2.1 5,221 1

Index Scan using "Event_MeterId" on "Event" "EV" (cost=0.29..778.42 rows=11,174 width=57) (actual time=0.043..1.573 rows=5,221 loops=1)

6. 0.630 789.319 ↑ 9.6 3,031 1

Sort (cost=28,153.07..28,225.99 rows=29,166 width=103) (actual time=788.978..789.319 rows=3,031 loops=1)

  • Sort Key: sq."MeterId
  • Sort Method: quicksort Memory: 56kB
7. 0.132 788.689 ↑ 130.8 223 1

Subquery Scan on sq (cost=19,500.62..25,990.12 rows=29,166 width=103) (actual time=656.301..788.689 rows=223 loops=1)

8. 96.578 788.557 ↑ 130.8 223 1

GroupAggregate (cost=19,500.62..25,698.46 rows=29,166 width=119) (actual time=656.300..788.557 rows=223 loops=1)

  • Group Key: "A"."ReferenceId", "UA"."Id", "MT"."Name", "A"."Name", "AP"."Balance", "A"."UtilityId", "AP"."ProgramType", "R"."MeterId
  • Filter: ((date_part('day'::text, (timezone('America/Chicago'::text, CURRENT_TIMESTAMP) - timezone('America/Chicago'::text, to_timestamp((max("R"."ReadEpoch"))::double precision)))))::integer > 0)
9. 323.602 691.979 ↓ 1.6 144,040 1

Sort (cost=19,500.62..19,719.37 rows=87,499 width=83) (actual time=655.813..691.979 rows=144,040 loops=1)

  • Sort Key: "A"."ReferenceId", "UA"."Id", "MT"."Name", "A"."Name", "AP"."Balance
  • Sort Method: external merge Disk: 15,096kB
10. 55.323 368.377 ↓ 1.6 144,040 1

Merge Join (cost=11.23..12,318.28 rows=87,499 width=83) (actual time=0.226..368.377 rows=144,040 loops=1)

  • Merge Cond: ("SPF"."AccountId" = "A"."Id")
11. 45.249 312.832 ↓ 1.6 144,040 1

Nested Loop (cost=10.94..16,720.47 rows=89,626 width=70) (actual time=0.214..312.832 rows=144,040 loops=1)

12. 0.477 4.462 ↓ 1.3 229 1

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

  • Join Filter: ("UA"."MeterTypeId" = "MT"."Id")
  • Rows Removed by Join Filter: 125
13. 0.757 3.756 ↓ 1.3 229 1

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

14. 0.661 1.854 ↓ 1.3 229 1

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

  • Merge Cond: ("SPF"."AccountId" = "AP"."AccountId")
15. 0.839 0.839 ↑ 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.018..0.839 rows=322 loops=1)

  • Heap Fetches: 322
16. 0.265 0.354 ↓ 1.8 236 1

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

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

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

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

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

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

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

20. 0.005 0.005 ↑ 1.0 2 1

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

21. 29.312 263.121 ↑ 1.9 629 229

Append (cost=0.28..80.18 rows=1,195 width=12) (actual time=0.084..1.149 rows=629 loops=229)

22. 1.145 1.145 ↑ 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=12) (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.145 1.145 ↑ 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=12) (actual time=0.004..0.005 rows=1 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
24. 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=12) (actual time=0.004..0.005 rows=1 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
25. 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=12) (actual time=0.004..0.006 rows=2 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
26. 1.374 1.374 ↑ 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=12) (actual time=0.004..0.006 rows=3 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
27. 1.832 1.832 ↑ 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=12) (actual time=0.004..0.008 rows=3 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
28. 1.832 1.832 ↑ 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=12) (actual time=0.004..0.008 rows=3 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 ↑ 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=12) (actual time=0.004..0.008 rows=4 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 ↑ 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=12) (actual time=0.005..0.010 rows=5 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 ↑ 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=12) (actual time=0.005..0.011 rows=6 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
32. 2.748 2.748 ↑ 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=12) (actual time=0.004..0.012 rows=7 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
33. 3.206 3.206 ↑ 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=12) (actual time=0.005..0.014 rows=8 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
34. 3.206 3.206 ↑ 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=12) (actual time=0.005..0.014 rows=9 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
35. 3.664 3.664 ↑ 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=12) (actual time=0.005..0.016 rows=9 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
36. 3.664 3.664 ↑ 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=12) (actual time=0.005..0.016 rows=10 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
37. 3.664 3.664 ↑ 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=12) (actual time=0.005..0.016 rows=11 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
38. 3.893 3.893 ↑ 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=12) (actual time=0.005..0.017 rows=11 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
39. 4.809 4.809 ↑ 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=12) (actual time=0.006..0.021 rows=13 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
40. 7.557 7.557 ↑ 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=12) (actual time=0.008..0.033 rows=24 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
41. 7.328 7.328 ↑ 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=12) (actual time=0.008..0.032 rows=23 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
42. 8.473 8.473 ↑ 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=12) (actual time=0.009..0.037 rows=26 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
43. 8.244 8.244 ↑ 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=12) (actual time=0.009..0.036 rows=25 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
44. 8.702 8.702 ↑ 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=12) (actual time=0.009..0.038 rows=26 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
45. 8.473 8.473 ↑ 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=12) (actual time=0.009..0.037 rows=26 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
46. 8.931 8.931 ↑ 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=12) (actual time=0.010..0.039 rows=27 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 0
47. 8.931 8.931 ↑ 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=12) (actual time=0.009..0.039 rows=26 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
48. 8.473 8.473 ↑ 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=12) (actual time=0.009..0.037 rows=24 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 2
49. 9.160 9.160 ↑ 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=12) (actual time=0.009..0.040 rows=26 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
50. 8.931 8.931 ↑ 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=12) (actual time=0.009..0.039 rows=25 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 2
51. 9.847 9.847 ↑ 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=12) (actual time=0.009..0.043 rows=28 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
52. 10.534 10.534 ↑ 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=12) (actual time=0.010..0.046 rows=28 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 2
53. 11.221 11.221 ↑ 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=12) (actual time=0.009..0.049 rows=27 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
54. 12.137 12.137 ↑ 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=12) (actual time=0.010..0.053 rows=29 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
55. 11.679 11.679 ↑ 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=12) (actual time=0.010..0.051 rows=28 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
56. 11.908 11.908 ↑ 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=12) (actual time=0.009..0.052 rows=29 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
57. 12.137 12.137 ↑ 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=12) (actual time=0.010..0.053 rows=28 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 1
58. 6.641 6.641 ↑ 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=12) (actual time=0.009..0.029 rows=25 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 5
59. 6.183 6.183 ↑ 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=12) (actual time=0.012..0.027 rows=21 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
  • Rows Removed by Filter: 2
60. 0.687 0.687 ↓ 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=12) (actual time=0.003..0.003 rows=0 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
61. 0.458 0.458 ↓ 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=12) (actual time=0.002..0.002 rows=0 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
62. 0.458 0.458 ↓ 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=12) (actual time=0.002..0.002 rows=0 loops=229)

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
63. 0.458 0.458 ↓ 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=12) (actual time=0.002..0.002 rows=0 loops=229)

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

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

  • Index Cond: ("MeterId" = "UA"."Id")
  • Filter: (("SourceType" <> 'FutureEstimate'::registersourcetype) AND ("ScheduleType" = 'Daily'::scheduletype))
65. 0.222 0.222 ↑ 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.008..0.222 rows=187 loops=1)

  • Filter: ("UtilityId" = 1)
Planning time : 21.340 ms
Execution time : 803.794 ms