explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a735

Settings
# exclusive inclusive rows x rows loops node
1. 1.018 39,765.585 ↑ 61.4 401 1

Unique (cost=6,241,395.67..6,243,796.21 rows=24,621 width=374) (actual time=39,764.537..39,765.585 rows=401 loops=1)

2. 6.640 39,764.567 ↑ 29.7 830 1

Sort (cost=6,241,395.67..6,241,457.22 rows=24,621 width=374) (actual time=39,764.536..39,764.567 rows=830 loops=1)

  • Sort Key: "Tarif"."ID", "Tarif"."Name_aktuell", "Marktrolle"."Name_aktuell", "Marktrolle"."ID", "Marktrolle"."enet_MT_Nr_alt", "Preisstaffel"."ID", "Preisstaffel"."Von_kWh", "Preisstaffel"."Bis_kWh", "Preisstaffel"."GP", "Preisstaffel"."AP", "Messpreis"."Wert", "TarifDetail"."MM_GP_enthaelt_MP", "PreisLimit"."Hoechstpreis", "PreisLimit"."Hoechstpreis_NT", "PreisLimit"."Hoechstpreis_GP", "Preisregelung"."Preisstand", "Preisstaffel_Zeitstufe"."MM_HT", "Preisstaffel_Zeitstufe"."MM_NT", (("Gebiet"."GebietTyp_ID" = ANY ('{8,80}'::integer[]))), (("Tarif"."TarifTyp_ID" = ANY ('{2,3}'::integer[]))), "TarifDetail"."Erstlaufzeit_Datum", "TarifDetail"."Erstlaufzeit", "TarifDetail"."Kuendigungsfrist", "TarifDetail"."Verlaengerungslaufzeit_Datum", "TarifDetail"."Verlaengerungslaufzeit", "TarifDetail"."MM_Fixpreis", "Preisgarantie"."Preisgarantie_Laufzeit", "Preisgarantie"."Preisgarantie_bis", "Preisgarantie"."PreisgarantieTyp_ID", (((("Preisstaffel"."AP" * '3500'::numeric) + "Preisstaffel"."GP") + (((1 - ("TarifDetail"."MM_GP_enthaelt_MP")::integer))::numeric * COALESCE("Messpreis"."Wert", '0'::numeric)))), "Tarif_Energiemixgruppe"."Prozent_Oeko", "*SELECT* 1"."Aufschl_AP_Abs", "*SELECT* 1"."Aufschl_GP_Abs", "*SELECT* 1"."Aufschl_AP_Proz", "*SELECT* 1"."Aufschl_GP_Proz", "*SELECT* 1"."Aufschl_Ges_Proz", "*SELECT* 1"."Aufschl_Ges_Abs", (("Tarif_Merkmal"."Merkmal_ID" = 11))
  • Sort Method: quicksort Memory: 244kB
3. 2.161 39,757.927 ↑ 29.7 830 1

Hash Left Join (cost=5,240,022.60..6,235,389.36 rows=24,621 width=374) (actual time=23,064.371..39,757.927 rows=830 loops=1)

  • Hash Cond: ("Preisregelung_Preisgarantie"."Preisgarantie_ID" = "Preisgarantie"."ID")
4. 1,437.430 39,755.555 ↑ 29.7 830 1

Hash Right Join (cost=5,239,999.17..6,234,439.84 rows=24,621 width=340) (actual time=23,064.139..39,755.555 rows=830 loops=1)

  • Hash Cond: ("*SELECT* 1"."Preisregelung_ID" = "Preisregelung"."ID")
5. 377.268 23,050.707 ↓ 1.4 8,405,515 1

Append (cost=795,219.03..1,440,310.95 rows=5,966,768 width=196) (actual time=7,701.998..23,050.707 rows=8,405,515 loops=1)

6. 169.221 17,884.013 ↓ 4.7 2,109,376 1

Subquery Scan on *SELECT* 1 (cost=795,219.03..912,127.69 rows=446,795 width=196) (actual time=7,701.997..17,884.013 rows=2,109,376 loops=1)

7. 6,222.312 17,714.792 ↓ 4.7 2,109,376 1

Finalize GroupAggregate (cost=795,219.03..907,659.74 rows=446,795 width=196) (actual time=7,701.994..17,714.792 rows=2,109,376 loops=1)

  • Group Key: "Preisregelung_Aufschlag_AufschlagDetail"."Preisregelung_ID"
8. 0.000 11,492.480 ↓ 4.9 2,587,273 1

Gather Merge (cost=795,219.03..876,033.83 rows=526,310 width=196) (actual time=7,701.941..11,492.480 rows=2,587,273 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 12,789.438 36,434.955 ↓ 3.3 862,424 3

Partial GroupAggregate (cost=794,219.00..814,284.57 rows=263,155 width=196) (actual time=7,666.345..12,144.985 rows=862,424 loops=3)

  • Group Key: "Preisregelung_Aufschlag_AufschlagDetail"."Preisregelung_ID"
10. 1,895.361 23,645.517 ↓ 3.6 958,636 3

Sort (cost=794,219.00..794,876.89 rows=263,155 width=17) (actual time=7,666.300..7,881.839 rows=958,636 loops=3)

  • Sort Key: "Preisregelung_Aufschlag_AufschlagDetail"."Preisregelung_ID"
  • Sort Method: external merge Disk: 24384kB
11. 6,408.945 21,750.156 ↓ 3.6 958,636 3

Hash Join (cost=95,702.24..765,130.75 rows=263,155 width=17) (actual time=395.855..7,250.052 rows=958,636 loops=3)

  • Hash Cond: ("Preisregelung_Aufschlag_AufschlagDetail"."Aufschlag_ID" = "Aufschlag"."ID")
12. 4,439.637 14,269.050 ↓ 4.6 9,357,072 3

Hash Join (cost=3,785.56..628,600.19 rows=2,050,684 width=8) (actual time=38.011..4,756.350 rows=9,357,072 loops=3)

  • Hash Cond: ("Preisregelung_Aufschlag_AufschlagDetail"."AufschlagDetail_ID" = "AufschlagDetail"."ID")
13. 9,716.361 9,716.361 ↑ 1.1 10,551,191 3

Parallel Seq Scan on "Preisregelung_Aufschlag_AufschlagDetail" (cost=0.00..561,303.34 rows=11,664,808 width=12) (actual time=0.187..3,238.787 rows=10,551,191 loops=3)

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 1682038
14. 4.494 113.052 ↓ 1.0 10,414 3

Hash (cost=3,656.81..3,656.81 rows=10,300 width=8) (actual time=37.684..37.684 rows=10,414 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 535kB
15. 27.720 108.558 ↓ 1.0 10,414 3

Hash Join (cost=1,235.11..3,656.81 rows=10,300 width=8) (actual time=16.175..36.186 rows=10,414 loops=3)

  • Hash Cond: ("AufschlagDetail"."ID" = "AufschlagDetail_Kategorie"."AufschlagDetail_ID")
16. 32.781 32.781 ↓ 1.0 60,810 3

Seq Scan on "AufschlagDetail" (cost=0.00..2,090.78 rows=60,778 width=4) (actual time=0.084..10.927 rows=60,810 loops=3)

17. 6.132 48.057 ↓ 1.0 10,414 3

Hash (cost=1,106.36..1,106.36 rows=10,300 width=4) (actual time=16.019..16.019 rows=10,414 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 495kB
18. 41.925 41.925 ↓ 1.0 10,414 3

Seq Scan on "AufschlagDetail_Kategorie" (cost=0.00..1,106.36 rows=10,300 width=4) (actual time=0.104..13.975 rows=10,414 loops=3)

  • Filter: ("Kategorie_ID" = ANY ('{5,6}'::integer[]))
  • Rows Removed by Filter: 48202
19. 65.796 1,072.161 ↑ 4.4 105,759 3

Hash (cost=83,452.20..83,452.20 rows=460,999 width=17) (actual time=357.387..357.387 rows=105,759 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 1167kB
20. 1,006.365 1,006.365 ↑ 4.4 105,759 3

Seq Scan on "Aufschlag" (cost=0.00..83,452.20 rows=460,999 width=17) (actual time=0.480..335.455 rows=105,759 loops=3)

  • Filter: ((3500 >= "von_kWh") AND (3500 <= "bis_kWh"))
  • Rows Removed by Filter: 3486228
21. 483.808 4,789.426 ↓ 1.1 6,296,139 1

Subquery Scan on *SELECT* 2 (cost=513.08..528,183.26 rows=5,519,973 width=196) (actual time=7.155..4,789.426 rows=6,296,139 loops=1)

22. 1,393.597 4,305.618 ↓ 1.1 6,296,139 1

Hash Join (cost=513.08..472,983.53 rows=5,519,973 width=196) (actual time=7.153..4,305.618 rows=6,296,139 loops=1)

  • Hash Cond: ("Preisregelung_1"."Tarif_ID" = "Tarif_1"."ID")
23. 2,905.084 2,905.084 ↓ 1.0 10,768,872 1

Seq Scan on "Preisregelung" "Preisregelung_1" (cost=0.00..336,669.10 rows=10,757,005 width=8) (actual time=0.050..2,905.084 rows=10,768,872 loops=1)

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 3868
24. 1.894 6.937 ↑ 1.2 7,041 1

Hash (cost=408.22..408.22 rows=8,389 width=4) (actual time=6.937..6.937 rows=7,041 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 376kB
25. 5.043 5.043 ↑ 1.2 7,041 1

Seq Scan on "Tarif" "Tarif_1" (cost=0.00..408.22 rows=8,389 width=4) (actual time=0.017..5.043 rows=7,041 loops=1)

  • Filter: (("EnergieTyp_ID" = 1) AND ("TarifArt_ID" = 1))
  • Rows Removed by Filter: 9199
26. 1.104 15,267.418 ↑ 37.2 662 1

Hash (cost=4,443,943.38..4,443,943.38 rows=24,621 width=152) (actual time=15,267.418..15,267.418 rows=662 loops=1)

  • Buckets: 32768 Batches: 2 Memory Usage: 311kB
27. 1,315.346 15,266.314 ↑ 37.2 662 1

Hash Join (cost=4,073,900.28..4,443,943.38 rows=24,621 width=152) (actual time=12,522.835..15,266.314 rows=662 loops=1)

  • Hash Cond: ("Preisregelung_BerechnungsmethodeTyp"."Preisregelung_ID" = "Preisregelung"."ID")
28. 1,450.662 1,450.662 ↓ 1.0 10,829,964 1

Seq Scan on "Preisregelung_BerechnungsmethodeTyp" (cost=0.00..244,567.09 rows=10,781,281 width=4) (actual time=0.016..1,450.662 rows=10,829,964 loops=1)

  • Filter: ("BerechnungsmethodeTyp_ID" = ANY ('{0,2}'::integer[]))
  • Rows Removed by Filter: 320262
29. 1.199 12,500.306 ↑ 37.8 670 1

Hash (cost=4,073,013.33..4,073,013.33 rows=25,356 width=156) (actual time=12,500.306..12,500.306 rows=670 loops=1)

  • Buckets: 32768 Batches: 2 Memory Usage: 314kB
30. 0.826 12,499.107 ↑ 37.8 670 1

Hash Join (cost=1,122,640.59..4,073,013.33 rows=25,356 width=156) (actual time=10,641.937..12,499.107 rows=670 loops=1)

  • Hash Cond: ("Tarif"."ID" = "Tarif_Energiemixgruppe"."Tarif_ID")
31. 0.487 12,473.846 ↑ 33.4 880 1

Hash Left Join (cost=1,119,706.71..4,069,685.38 rows=29,409 width=159) (actual time=10,617.442..12,473.846 rows=880 loops=1)

  • Hash Cond: ("Preisregelung_PreisLimit"."PreisLimit_ID" = "PreisLimit"."ID")
32. 1,053.667 12,470.827 ↑ 33.4 880 1

Hash Left Join (cost=1,119,612.08..4,069,219.54 rows=29,409 width=151) (actual time=10,614.845..12,470.827 rows=880 loops=1)

  • Hash Cond: ("Preisstaffel"."ID" = "Preisstaffel_Zeitstufe"."Preisstaffel_ID")
33. 0.000 10,455.836 ↑ 33.4 880 1

Nested Loop (cost=992,360.12..3,925,309.56 rows=29,409 width=149) (actual time=9,382.716..10,455.836 rows=880 loops=1)

34. 0.535 10,444.378 ↑ 55.5 2,940 1

Nested Loop (cost=992,359.55..2,766,491.62 rows=163,299 width=128) (actual time=9,382.703..10,444.378 rows=2,940 loops=1)

35. 0.392 10,437.459 ↑ 38.2 912 1

Hash Left Join (cost=992,358.99..1,380,053.13 rows=34,860 width=120) (actual time=9,382.680..10,437.459 rows=912 loops=1)

  • Hash Cond: ("Preisregelung_Messpreisgruppe"."Messpreisgruppe_ID" = "Messpreis"."Messpreisgruppe_ID")
  • Filter: ((("Messpreis"."MesspreisTyp_ID" = 1) OR ("Messpreis"."MesspreisTyp_ID" IS NULL)) AND (("Messpreis"."Von_Kwh" IS NULL) OR ((3500 >= "Messpreis"."Von_Kwh") AND (3500 <= "Messpreis"."Bis_Kwh"))))
  • Rows Removed by Filter: 66
36. 2,581.663 10,433.847 ↑ 117.7 914 1

Hash Right Join (cost=992,044.94..1,370,624.16 rows=107,556 width=119) (actual time=9,379.384..10,433.847 rows=914 loops=1)

  • Hash Cond: ("Preisregelung_Messpreisgruppe"."Preisregelung_ID" = "Preisregelung"."ID")
37. 1,450.574 1,450.574 ↑ 1.0 12,884,638 1

Seq Scan on "Preisregelung_Messpreisgruppe" (cost=0.00..220,126.94 rows=13,447,394 width=8) (actual time=0.019..1,450.574 rows=12,884,638 loops=1)

38. 2.519 6,401.610 ↑ 117.7 914 1

Hash (cost=988,809.49..988,809.49 rows=107,556 width=115) (actual time=6,401.610..6,401.610 rows=914 loops=1)

  • Buckets: 32768 Batches: 8 Memory Usage: 272kB
39. 1,667.862 6,399.091 ↑ 117.7 914 1

Hash Right Join (cost=715,037.45..988,809.49 rows=107,556 width=115) (actual time=3,848.386..6,399.091 rows=914 loops=1)

  • Hash Cond: ("Preisregelung_Preisgarantie"."Preisregelung_ID" = "Preisregelung"."ID")
40. 894.941 894.941 ↓ 1.0 8,804,465 1

Seq Scan on "Preisregelung_Preisgarantie" (cost=0.00..172,919.68 rows=8,494,468 width=8) (actual time=0.018..894.941 rows=8,804,465 loops=1)

41. 3.198 3,836.288 ↑ 117.7 914 1

Hash (cost=711,907.00..711,907.00 rows=107,556 width=111) (actual time=3,836.288..3,836.288 rows=914 loops=1)

  • Buckets: 32768 Batches: 8 Memory Usage: 272kB
42. 0.504 3,833.090 ↑ 117.7 914 1

Hash Left Join (cost=384,764.57..711,907.00 rows=107,556 width=111) (actual time=1,886.253..3,833.090 rows=914 loops=1)

  • Hash Cond: ("Preisregelung"."ID" = "Preisregelung_PreisLimit"."Preisregelung_ID")
43. 1.158 3,832.127 ↑ 117.7 914 1

Hash Join (cost=384,745.94..711,216.10 rows=107,556 width=107) (actual time=1,885.769..3,832.127 rows=914 loops=1)

  • Hash Cond: ("Preisregelung"."Tarif_ID" = "Tarif"."ID")
44. 721.431 3,806.837 ↑ 197.7 2,100 1

Hash Join (cost=381,944.50..705,782.51 rows=415,091 width=14) (actual time=1,861.606..3,806.837 rows=2,100 loops=1)

  • Hash Cond: ("Preisregelung"."Gebiet_ID" = "Gebiet"."ID")
45. 1,234.371 1,234.371 ↑ 1.0 10,772,740 1

Seq Scan on "Preisregelung" (cost=0.00..282,805.40 rows=10,772,740 width=16) (actual time=0.010..1,234.371 rows=10,772,740 loops=1)

46. 0.282 1,851.035 ↑ 1.5 978 1

Hash (cost=381,925.85..381,925.85 rows=1,492 width=10) (actual time=1,851.035..1,851.035 rows=978 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 59kB
47. 23.337 1,850.753 ↑ 1.5 978 1

Gather (cost=58,249.91..381,925.85 rows=1,492 width=10) (actual time=197.397..1,850.753 rows=978 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
48. 1.252 1,827.416 ↑ 1.9 326 3

Nested Loop (cost=57,249.91..380,776.65 rows=622 width=10) (actual time=223.099..1,827.416 rows=326 loops=3)

49. 310.573 1,826.161 ↑ 1.9 326 3

Hash Join (cost=57,249.49..376,626.69 rows=622 width=4) (actual time=223.064..1,826.161 rows=326 loops=3)

  • Hash Cond: ("Strassenabschnitt_Gebiet"."Strassenabschnitt_ID" = "Strassenabschnitt"."ID")
50. 1,300.612 1,300.612 ↑ 1.3 5,222,620 3

Parallel Seq Scan on "Strassenabschnitt_Gebiet" (cost=0.00..234,755.41 rows=6,702,719 width=8) (actual time=0.184..1,300.612 rows=5,222,620 loops=3)

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 7443
51. 0.103 214.976 ↓ 1.3 318 3

Hash (cost=57,246.45..57,246.45 rows=243 width=4) (actual time=214.976..214.976 rows=318 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
52. 214.873 214.873 ↓ 1.3 318 3

Seq Scan on "Strassenabschnitt" (cost=0.00..57,246.45 rows=243 width=4) (actual time=1.113..214.873 rows=318 loops=3)

  • Filter: ("Postort_ID" = 8760)
  • Rows Removed by Filter: 2584880
53. 0.003 0.003 ↑ 1.0 1 978

Index Scan using "Gebiet_pkey" on "Gebiet" (cost=0.42..6.67 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=978)

  • Index Cond: ("ID" = "Strassenabschnitt_Gebiet"."Gebiet_ID")
54. 1.886 24.132 ↓ 1.4 5,936 1

Hash (cost=2,748.49..2,748.49 rows=4,236 width=93) (actual time=24.132..24.132 rows=5,936 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 828kB
55. 3.106 22.246 ↓ 1.4 5,936 1

Hash Join (cost=2,035.26..2,748.49 rows=4,236 width=93) (actual time=15.429..22.246 rows=5,936 loops=1)

  • Hash Cond: ("TarifDetail"."Tarif_ID" = "Tarif"."ID")
56. 3.754 3.754 ↑ 1.1 16,281 1

Seq Scan on "TarifDetail" (cost=0.00..604.34 rows=17,740 width=27) (actual time=0.011..3.754 rows=16,281 loops=1)

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 51
57. 1.410 15.386 ↓ 1.4 5,934 1

Hash (cost=1,982.84..1,982.84 rows=4,194 width=66) (actual time=15.386..15.386 rows=5,934 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 651kB
58. 1.301 13.976 ↓ 1.4 5,934 1

Hash Join (cost=1,480.81..1,982.84 rows=4,194 width=66) (actual time=9.524..13.976 rows=5,934 loops=1)

  • Hash Cond: ("Tarif"."Marktrolle_ID" = "Marktrolle"."ID")
59. 3.745 10.241 ↓ 1.4 5,945 1

Seq Scan on "Tarif" (cost=1,178.08..1,627.17 rows=4,194 width=31) (actual time=7.064..10.241 rows=5,945 loops=1)

  • Filter: (("EnergieTyp_ID" = ANY ('{1,100}'::integer[])) AND (NOT (hashed SubPlan 1)) AND ("TarifArt_ID" = 1))
  • Rows Removed by Filter: 10295
60.          

SubPlan (forSeq Scan)

61. 0.711 6.496 ↓ 1.0 3,148 1

Hash Join (cost=530.83..1,170.45 rows=3,053 width=4) (actual time=3.044..6.496 rows=3,148 loops=1)

  • Hash Cond: ("Tarif_Merkmal_1"."Tarif_ID" = "Tarif_2"."ID")
62. 2.806 2.806 ↓ 1.0 3,157 1

Seq Scan on "Tarif_Merkmal" "Tarif_Merkmal_1" (cost=0.00..600.94 rows=3,064 width=4) (actual time=0.006..2.806 rows=3,157 loops=1)

  • Filter: ("Merkmal_ID" = ANY ('{3,2}'::integer[]))
  • Rows Removed by Filter: 26873
63. 1.408 2.979 ↑ 1.0 16,240 1

Hash (cost=326.48..326.48 rows=16,348 width=4) (actual time=2.979..2.979 rows=16,240 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 699kB
64. 1.571 1.571 ↑ 1.0 16,240 1

Seq Scan on "Tarif" "Tarif_2" (cost=0.00..326.48 rows=16,348 width=4) (actual time=0.004..1.571 rows=16,240 loops=1)

65. 1.245 2.434 ↑ 1.0 7,922 1

Hash (cost=201.21..201.21 rows=8,121 width=39) (actual time=2.434..2.434 rows=7,922 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 633kB
66. 1.189 1.189 ↑ 1.0 7,922 1

Seq Scan on "Marktrolle" (cost=0.00..201.21 rows=8,121 width=39) (actual time=0.006..1.189 rows=7,922 loops=1)

67. 0.168 0.459 ↑ 1.4 394 1

Hash (cost=11.98..11.98 rows=532 width=8) (actual time=0.459..0.459 rows=394 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
68. 0.291 0.291 ↑ 1.4 394 1

Seq Scan on "Preisregelung_PreisLimit" (cost=0.00..11.98 rows=532 width=8) (actual time=0.027..0.291 rows=394 loops=1)

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 3
69. 1.076 3.220 ↑ 1.0 8,372 1

Hash (cost=207.66..207.66 rows=8,511 width=19) (actual time=3.220..3.220 rows=8,372 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 586kB
70. 2.144 2.144 ↑ 1.0 8,372 1

Seq Scan on "Messpreis" (cost=0.00..207.66 rows=8,511 width=19) (actual time=0.015..2.144 rows=8,372 loops=1)

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 33
71. 6.384 6.384 ↑ 3.7 3 912

Index Scan using "idx_Preisregelung_Preisstaffel" on "Preisregelung_Preisstaffel" (cost=0.56..39.66 rows=11 width=8) (actual time=0.005..0.007 rows=3 loops=912)

  • Index Cond: ("Preisregelung_ID" = "Preisregelung"."ID")
  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 0
72. 11.760 11.760 ↓ 0.0 0 2,940

Index Scan using "Preisstaffel_pkey" on "Preisstaffel" (cost=0.57..7.10 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=2,940)

  • Index Cond: ("ID" = "Preisregelung_Preisstaffel"."Preisstaffel_ID")
  • Filter: ((3500 >= "Von_kWh") AND (3500 <= "Bis_kWh"))
  • Rows Removed by Filter: 1
73. 529.685 961.324 ↓ 1.0 3,882,573 1

Hash (cost=63,554.87..63,554.87 rows=3,882,487 width=6) (actual time=961.324..961.324 rows=3,882,573 loops=1)

  • Buckets: 131072 Batches: 64 Memory Usage: 3398kB
74. 431.639 431.639 ↓ 1.0 3,882,573 1

Seq Scan on "Preisstaffel_Zeitstufe" (cost=0.00..63,554.87 rows=3,882,487 width=6) (actual time=0.012..431.639 rows=3,882,573 loops=1)

75. 1.401 2.532 ↓ 1.0 3,143 1

Hash (cost=55.39..55.39 rows=3,139 width=16) (actual time=2.532..2.532 rows=3,143 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 192kB
76. 1.131 1.131 ↓ 1.0 3,143 1

Seq Scan on "PreisLimit" (cost=0.00..55.39 rows=3,139 width=16) (actual time=0.021..1.131 rows=3,143 loops=1)

77. 1.848 24.435 ↑ 1.0 13,402 1

Hash (cost=2,759.67..2,759.67 rows=13,937 width=17) (actual time=24.435..24.435 rows=13,402 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 824kB
78. 3.141 22.587 ↑ 1.0 13,402 1

Hash Join (cost=1,937.43..2,759.67 rows=13,937 width=17) (actual time=16.039..22.587 rows=13,402 loops=1)

  • Hash Cond: ("Tarif_Merkmal"."Tarif_ID" = "Tarif_Energiemixgruppe"."Tarif_ID")
79. 3.464 3.464 ↑ 1.0 16,270 1

Seq Scan on "Tarif_Merkmal" (cost=0.00..600.94 rows=16,386 width=6) (actual time=0.009..3.464 rows=16,270 loops=1)

  • Filter: ("Merkmal_ID" = ANY ('{1,11}'::integer[]))
  • Rows Removed by Filter: 13760
80. 1.571 15.982 ↑ 1.1 13,419 1

Hash (cost=1,761.02..1,761.02 rows=14,113 width=11) (actual time=15.982..15.982 rows=13,419 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 720kB
81. 3.051 14.411 ↑ 1.1 13,419 1

Hash Join (cost=639.98..1,761.02 rows=14,113 width=11) (actual time=6.612..14.411 rows=13,419 loops=1)

  • Hash Cond: ("Tarif_KundengruppeTyp"."Tarif_ID" = "Tarif_Energiemixgruppe"."Tarif_ID")
82. 4.865 4.865 ↑ 1.1 13,428 1

Seq Scan on "Tarif_KundengruppeTyp" (cost=0.00..909.35 rows=14,112 width=4) (actual time=0.008..4.865 rows=13,428 loops=1)

  • Filter: ("KundengruppeTyp_ID" = ANY ('{2,5}'::integer[]))
  • Rows Removed by Filter: 30221
83. 1.818 6.495 ↑ 1.0 16,278 1

Hash (cost=432.57..432.57 rows=16,593 width=7) (actual time=6.495..6.495 rows=16,278 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 911kB
84. 4.677 4.677 ↑ 1.0 16,278 1

Seq Scan on "Tarif_Energiemixgruppe" (cost=0.00..432.57 rows=16,593 width=7) (actual time=0.010..4.677 rows=16,278 loops=1)

  • Filter: (("Prozent_Oeko" >= '0'::numeric) AND (gueltig_seit <= CURRENT_DATE))
  • Rows Removed by Filter: 20
85. 0.085 0.211 ↓ 1.0 785 1

Hash (cost=13.75..13.75 rows=775 width=13) (actual time=0.211..0.211 rows=785 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
86. 0.126 0.126 ↓ 1.0 785 1

Seq Scan on "Preisgarantie" (cost=0.00..13.75 rows=775 width=13) (actual time=0.016..0.126 rows=785 loops=1)

Planning time : 36.405 ms
Execution time : 39,776.866 ms