explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EoLI

Settings
# exclusive inclusive rows x rows loops node
1. 0.983 24,092.139 ↑ 67.8 344 1

Unique (cost=5,350,635.43..5,352,908.93 rows=23,318 width=374) (actual time=24,091.126..24,092.139 rows=344 loops=1)

2. 5.987 24,091.156 ↑ 33.6 694 1

Sort (cost=5,350,635.43..5,350,693.72 rows=23,318 width=374) (actual time=24,091.124..24,091.156 rows=694 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", (CASE WHEN (("Aufschlag"."Einheit_ID" = 2) AND ("Aufschlag"."AufschlagBezug_ID" = 1)) THEN "Aufschlag"."Wert" ELSE '0'::numeric END), (CASE WHEN (("Aufschlag"."Einheit_ID" = 1) AND ("Aufschlag"."AufschlagBezug_ID" = ANY ('{2,3}'::integer[]))) THEN "Aufschlag"."Wert" ELSE '0'::numeric END), ((CASE WHEN (("Aufschlag"."Einheit_ID" = 3) AND ("Aufschlag"."AufschlagBezug_ID" = 1)) THEN "Aufschlag"."Wert" ELSE '0'::numeric END / 100.0)), ((CASE WHEN (("Aufschlag"."Einheit_ID" = 3) AND ("Aufschlag"."AufschlagBezug_ID" = 2)) THEN "Aufschlag"."Wert" ELSE '0'::numeric END / 100.0)), ((CASE WHEN (("Aufschlag"."Einheit_ID" = 3) AND ("Aufschlag"."AufschlagBezug_ID" = ANY ('{3,4}'::integer[]))) THEN "Aufschlag"."Wert" ELSE '0'::numeric END / 100.0)), (CASE WHEN (("Aufschlag"."Einheit_ID" = 1) AND ("Aufschlag"."AufschlagBezug_ID" <> ALL ('{1,2,3}'::integer[]))) THEN "Aufschlag"."Wert" ELSE '0'::numeric END), (("Tarif_Merkmal"."Merkmal_ID" = 11))
  • Sort Method: quicksort Memory: 209kB
3. 1,337.160 24,085.169 ↑ 33.6 694 1

Hash Join (cost=4,973,423.71..5,344,957.30 rows=23,318 width=374) (actual time=21,318.153..24,085.169 rows=694 loops=1)

  • Hash Cond: ("Preisregelung_BerechnungsmethodeTyp"."Preisregelung_ID" = "Preisregelung"."ID")
4. 1,459.480 1,459.480 ↑ 1.0 10,755,017 1

Seq Scan on "Preisregelung_BerechnungsmethodeTyp" (cost=0.00..244,567.09 rows=10,781,281 width=4) (actual time=0.030..1,459.480 rows=10,755,017 loops=1)

  • Filter: ("BerechnungsmethodeTyp_ID" = ANY ('{0,2}'::integer[]))
  • Rows Removed by Filter: 320262
5. 1.908 21,288.529 ↑ 34.2 702 1

Hash (cost=4,972,536.53..4,972,536.53 rows=24,014 width=174) (actual time=21,288.529..21,288.529 rows=702 loops=1)

  • Buckets: 32768 Batches: 2 Memory Usage: 319kB
6. 0.854 21,286.621 ↑ 34.2 702 1

Hash Join (cost=1,998,625.55..4,972,536.53 rows=24,014 width=174) (actual time=19,238.709..21,286.621 rows=702 loops=1)

  • Hash Cond: ("Tarif"."ID" = "Tarif_Merkmal"."Tarif_ID")
7. 0.659 21,280.169 ↑ 34.2 702 1

Hash Left Join (cost=1,997,819.79..4,971,220.15 rows=24,043 width=188) (actual time=19,233.013..21,280.169 rows=702 loops=1)

  • Hash Cond: ("Preisregelung_Preisgarantie"."Preisgarantie_ID" = "Preisgarantie"."ID")
8. 1,275.583 21,279.070 ↑ 34.2 702 1

Hash Left Join (cost=1,997,796.35..4,970,893.44 rows=24,043 width=183) (actual time=19,232.549..21,279.070 rows=702 loops=1)

  • Hash Cond: ("Preisregelung"."ID" = "Preisregelung_Aufschlag_AufschlagDetail"."Preisregelung_ID")
9. 0.940 12,053.433 ↑ 37.0 650 1

Hash Join (cost=1,123,510.83..4,087,288.77 rows=24,043 width=170) (actual time=10,121.438..12,053.433 rows=650 loops=1)

  • Hash Cond: ("Tarif"."ID" = "Tarif_Energiemixgruppe"."Tarif_ID")
10. 0.591 12,035.767 ↑ 32.4 860 1

Hash Left Join (cost=1,121,573.36..4,084,975.15 rows=27,851 width=159) (actual time=10,104.652..12,035.767 rows=860 loops=1)

  • Hash Cond: ("Preisregelung_PreisLimit"."PreisLimit_ID" = "PreisLimit"."ID")
11. 1,141.624 12,032.748 ↑ 32.4 860 1

Hash Left Join (cost=1,121,478.74..4,084,528.98 rows=27,851 width=151) (actual time=10,102.137..12,032.748 rows=860 loops=1)

  • Hash Cond: ("Preisstaffel"."ID" = "Preisstaffel_Zeitstufe"."Preisstaffel_ID")
12. 0.000 9,960.267 ↑ 32.4 860 1

Nested Loop (cost=994,226.78..3,940,697.09 rows=27,851 width=149) (actual time=8,891.478..9,960.267 rows=860 loops=1)

13. 0.816 9,948.976 ↑ 53.4 2,894 1

Nested Loop (cost=994,226.21..2,814,988.02 rows=154,647 width=128) (actual time=8,891.461..9,948.976 rows=2,894 loops=1)

14. 0.399 9,941.860 ↑ 39.1 900 1

Hash Left Join (cost=994,225.64..1,382,032.25 rows=35,183 width=120) (actual time=8,891.427..9,941.860 rows=900 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
15. 2,459.955 9,938.211 ↑ 120.3 902 1

Hash Right Join (cost=993,911.59..1,372,518.79 rows=108,553 width=119) (actual time=8,888.098..9,938.211 rows=902 loops=1)

  • Hash Cond: ("Preisregelung_Messpreisgruppe"."Preisregelung_ID" = "Preisregelung"."ID")
16. 1,319.243 1,319.243 ↑ 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.020..1,319.243 rows=12,884,638 loops=1)

17. 2.794 6,159.013 ↑ 120.3 902 1

Hash (cost=990,645.68..990,645.68 rows=108,553 width=115) (actual time=6,159.013..6,159.013 rows=902 loops=1)

  • Buckets: 32768 Batches: 8 Memory Usage: 272kB
18. 1,713.804 6,156.219 ↑ 120.3 902 1

Hash Right Join (cost=716,856.81..990,645.68 rows=108,553 width=115) (actual time=3,576.334..6,156.219 rows=902 loops=1)

  • Hash Cond: ("Preisregelung_Preisgarantie"."Preisregelung_ID" = "Preisregelung"."ID")
19. 878.650 878.650 ↓ 1.0 8,731,341 1

Seq Scan on "Preisregelung_Preisgarantie" (cost=0.00..172,919.68 rows=8,494,468 width=8) (actual time=0.010..878.650 rows=8,731,341 loops=1)

20. 2.720 3,563.765 ↑ 120.3 902 1

Hash (cost=713,696.90..713,696.90 rows=108,553 width=111) (actual time=3,563.765..3,563.765 rows=902 loops=1)

  • Buckets: 32768 Batches: 8 Memory Usage: 272kB
21. 0.442 3,561.045 ↑ 120.3 902 1

Hash Left Join (cost=385,115.58..713,696.90 rows=108,553 width=111) (actual time=1,803.092..3,561.045 rows=902 loops=1)

  • Hash Cond: ("Preisregelung"."ID" = "Preisregelung_PreisLimit"."Preisregelung_ID")
22. 0.979 3,560.190 ↑ 120.3 902 1

Hash Join (cost=385,096.95..712,999.76 rows=108,553 width=107) (actual time=1,802.651..3,560.190 rows=902 loops=1)

  • Hash Cond: ("Preisregelung"."Tarif_ID" = "Tarif"."ID")
23. 660.506 3,533.960 ↑ 200.4 2,090 1

Hash Join (cost=382,299.97..707,546.23 rows=418,939 width=14) (actual time=1,777.364..3,533.960 rows=2,090 loops=1)

  • Hash Cond: ("Preisregelung"."Gebiet_ID" = "Gebiet"."ID")
24. 1,106.736 1,106.736 ↑ 1.0 10,698,372 1

Seq Scan on "Preisregelung" (cost=0.00..283,825.53 rows=10,874,753 width=16) (actual time=0.039..1,106.736 rows=10,698,372 loops=1)

25. 0.249 1,766.718 ↑ 1.5 978 1

Hash (cost=382,281.33..382,281.33 rows=1,491 width=10) (actual time=1,766.718..1,766.718 rows=978 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 59kB
26. 25.384 1,766.469 ↑ 1.5 978 1

Gather (cost=58,291.98..382,281.33 rows=1,491 width=10) (actual time=198.154..1,766.469 rows=978 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
27. 1.221 1,741.085 ↑ 1.9 326 3

Nested Loop (cost=57,291.98..381,132.23 rows=621 width=10) (actual time=206.557..1,741.085 rows=326 loops=3)

28. 296.679 1,739.861 ↑ 1.9 326 3

Hash Join (cost=57,291.56..376,836.71 rows=621 width=4) (actual time=206.523..1,739.861 rows=326 loops=3)

  • Hash Cond: ("Strassenabschnitt_Gebiet"."Strassenabschnitt_ID" = "Strassenabschnitt"."ID")
29. 1,240.199 1,240.199 ↑ 1.3 5,222,634 3

Parallel Seq Scan on "Strassenabschnitt_Gebiet" (cost=0.00..234,877.91 rows=6,706,318 width=8) (actual time=0.104..1,240.199 rows=5,222,634 loops=3)

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 7443
30. 0.094 202.983 ↓ 1.3 318 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
31. 202.889 202.889 ↓ 1.3 318 3

Seq Scan on "Strassenabschnitt" (cost=0.00..57,288.53 rows=243 width=4) (actual time=0.689..202.889 rows=318 loops=3)

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

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

  • Index Cond: ("ID" = "Strassenabschnitt_Gebiet"."Gebiet_ID")
33. 1.938 25.251 ↓ 1.4 5,930 1

Hash (cost=2,744.03..2,744.03 rows=4,236 width=93) (actual time=25.251..25.251 rows=5,930 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 827kB
34. 3.235 23.313 ↓ 1.4 5,930 1

Hash Join (cost=2,030.81..2,744.03 rows=4,236 width=93) (actual time=16.296..23.313 rows=5,930 loops=1)

  • Hash Cond: ("TarifDetail"."Tarif_ID" = "Tarif"."ID")
35. 3.827 3.827 ↑ 1.1 16,272 1

Seq Scan on "TarifDetail" (cost=0.00..604.34 rows=17,741 width=27) (actual time=0.011..3.827 rows=16,272 loops=1)

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 57
36. 1.470 16.251 ↓ 1.4 5,929 1

Hash (cost=1,978.38..1,978.38 rows=4,194 width=66) (actual time=16.251..16.251 rows=5,929 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 650kB
37. 1.408 14.781 ↓ 1.4 5,929 1

Hash Join (cost=1,476.35..1,978.38 rows=4,194 width=66) (actual time=10.113..14.781 rows=5,929 loops=1)

  • Hash Cond: ("Tarif"."Marktrolle_ID" = "Marktrolle"."ID")
38. 3.919 10.792 ↓ 1.4 5,940 1

Seq Scan on "Tarif" (cost=1,178.08..1,627.17 rows=4,194 width=31) (actual time=7.494..10.792 rows=5,940 loops=1)

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

SubPlan (for Seq Scan)

40. 0.805 6.873 ↓ 1.0 3,147 1

Hash Join (cost=530.83..1,170.45 rows=3,053 width=4) (actual time=3.207..6.873 rows=3,147 loops=1)

  • Hash Cond: ("Tarif_Merkmal_1"."Tarif_ID" = "Tarif_1"."ID")
41. 2.936 2.936 ↓ 1.0 3,156 1

Seq Scan on "Tarif_Merkmal" "Tarif_Merkmal_1" (cost=0.00..600.94 rows=3,064 width=4) (actual time=0.009..2.936 rows=3,156 loops=1)

  • Filter: ("Merkmal_ID" = ANY ('{3,2}'::integer[]))
  • Rows Removed by Filter: 26866
42. 1.486 3.132 ↑ 1.0 16,235 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 699kB
43. 1.646 1.646 ↑ 1.0 16,235 1

Seq Scan on "Tarif" "Tarif_1" (cost=0.00..326.48 rows=16,348 width=4) (actual time=0.004..1.646 rows=16,235 loops=1)

44. 1.292 2.581 ↑ 1.0 7,923 1

Hash (cost=199.23..199.23 rows=7,923 width=39) (actual time=2.581..2.581 rows=7,923 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 633kB
45. 1.289 1.289 ↑ 1.0 7,923 1

Seq Scan on "Marktrolle" (cost=0.00..199.23 rows=7,923 width=39) (actual time=0.008..1.289 rows=7,923 loops=1)

46. 0.128 0.413 ↑ 1.4 394 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
47. 0.285 0.285 ↑ 1.4 394 1

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

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 3
48. 1.103 3.250 ↑ 1.0 8,375 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 586kB
49. 2.147 2.147 ↑ 1.0 8,375 1

Seq Scan on "Messpreis" (cost=0.00..207.66 rows=8,511 width=19) (actual time=0.016..2.147 rows=8,375 loops=1)

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 33
50. 6.300 6.300 ↑ 3.7 3 900

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

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

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

  • Index Cond: ("ID" = "Preisregelung_Preisstaffel"."Preisstaffel_ID")
  • Filter: ((3500 >= "Von_kWh") AND (3500 <= "Bis_kWh"))
  • Rows Removed by Filter: 1
52. 510.349 930.857 ↓ 1.0 3,882,577 1

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

  • Buckets: 131072 Batches: 64 Memory Usage: 3398kB
53. 420.508 420.508 ↓ 1.0 3,882,577 1

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

54. 1.367 2.428 ↓ 1.0 3,143 1

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

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

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

56. 1.659 16.726 ↑ 1.1 13,414 1

Hash (cost=1,761.05..1,761.05 rows=14,114 width=11) (actual time=16.726..16.726 rows=13,414 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 720kB
57. 3.407 15.067 ↑ 1.1 13,414 1

Hash Join (cost=640.00..1,761.05 rows=14,114 width=11) (actual time=6.716..15.067 rows=13,414 loops=1)

  • Hash Cond: ("Tarif_KundengruppeTyp"."Tarif_ID" = "Tarif_Energiemixgruppe"."Tarif_ID")
58. 5.074 5.074 ↑ 1.1 13,424 1

Seq Scan on "Tarif_KundengruppeTyp" (cost=0.00..909.35 rows=14,112 width=4) (actual time=0.015..5.074 rows=13,424 loops=1)

  • Filter: ("KundengruppeTyp_ID" = ANY ('{2,5}'::integer[]))
  • Rows Removed by Filter: 30209
59. 1.804 6.586 ↑ 1.0 16,273 1

Hash (cost=432.57..432.57 rows=16,594 width=7) (actual time=6.586..6.586 rows=16,273 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 911kB
60. 4.782 4.782 ↑ 1.0 16,273 1

Seq Scan on "Tarif_Energiemixgruppe" (cost=0.00..432.57 rows=16,594 width=7) (actual time=0.019..4.782 rows=16,273 loops=1)

  • Filter: (("Prozent_Oeko" >= '0'::numeric) AND (gueltig_seit <= CURRENT_DATE))
  • Rows Removed by Filter: 21
61. 613.189 7,950.054 ↓ 3.8 2,834,957 1

Hash (cost=860,680.64..860,680.64 rows=741,030 width=17) (actual time=7,950.054..7,950.054 rows=2,834,957 loops=1)

  • Buckets: 65536 (originally 65536) Batches: 64 (originally 16) Memory Usage: 3585kB
62. 618.049 7,336.865 ↓ 3.8 2,834,957 1

Gather (cost=96,705.27..860,680.64 rows=741,030 width=17) (actual time=325.782..7,336.865 rows=2,834,957 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
63. 2,040.245 6,718.816 ↓ 3.1 944,986 3

Hash Join (cost=95,705.27..785,577.64 rows=308,762 width=17) (actual time=383.267..6,718.816 rows=944,986 loops=3)

  • Hash Cond: ("Preisregelung_Aufschlag_AufschlagDetail"."Aufschlag_ID" = "Aufschlag"."ID")
64. 1,424.694 4,329.669 ↓ 3.7 8,972,926 3

Hash Join (cost=3,785.56..641,781.14 rows=2,406,083 width=8) (actual time=33.853..4,329.669 rows=8,972,926 loops=3)

  • Hash Cond: ("Preisregelung_Aufschlag_AufschlagDetail"."AufschlagDetail_ID" = "AufschlagDetail"."ID")
65. 2,871.552 2,871.552 ↑ 1.3 10,167,047 3

Parallel Seq Scan on "Preisregelung_Aufschlag_AufschlagDetail" (cost=0.00..563,477.30 rows=13,686,408 width=12) (actual time=0.046..2,871.552 rows=10,167,047 loops=3)

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 2584
66. 1.185 33.423 ↓ 1.0 10,415 3

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

  • Buckets: 16384 Batches: 1 Memory Usage: 535kB
67. 7.601 32.238 ↓ 1.0 10,415 3

Hash Join (cost=1,235.11..3,656.81 rows=10,300 width=8) (actual time=14.882..32.238 rows=10,415 loops=3)

  • Hash Cond: ("AufschlagDetail"."ID" = "AufschlagDetail_Kategorie"."AufschlagDetail_ID")
68. 9.909 9.909 ↓ 1.0 60,813 3

Seq Scan on "AufschlagDetail" (cost=0.00..2,090.78 rows=60,778 width=4) (actual time=0.073..9.909 rows=60,813 loops=3)

69. 1.852 14.728 ↓ 1.0 10,415 3

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

  • Buckets: 16384 Batches: 1 Memory Usage: 495kB
70. 12.876 12.876 ↓ 1.0 10,415 3

Seq Scan on "AufschlagDetail_Kategorie" (cost=0.00..1,106.36 rows=10,300 width=4) (actual time=0.139..12.876 rows=10,415 loops=3)

  • Filter: ("Kategorie_ID" = ANY ('{5,6}'::integer[]))
  • Rows Removed by Filter: 48204
71. 19.764 348.902 ↑ 4.4 105,768 3

Hash (cost=83,455.02..83,455.02 rows=461,015 width=17) (actual time=348.902..348.902 rows=105,768 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 1167kB
72. 329.138 329.138 ↑ 4.4 105,768 3

Seq Scan on "Aufschlag" (cost=0.00..83,455.02 rows=461,015 width=17) (actual time=0.430..329.138 rows=105,768 loops=3)

  • Filter: ((3500 >= "von_kWh") AND (3500 <= "bis_kWh"))
  • Rows Removed by Filter: 3486253
73. 0.199 0.440 ↓ 1.0 785 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
74. 0.241 0.241 ↓ 1.0 785 1

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

75. 1.620 5.598 ↑ 1.0 16,265 1

Hash (cost=600.94..600.94 rows=16,386 width=6) (actual time=5.598..5.598 rows=16,265 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 892kB
76. 3.978 3.978 ↑ 1.0 16,265 1

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

  • Filter: ("Merkmal_ID" = ANY ('{1,11}'::integer[]))
  • Rows Removed by Filter: 13757
Planning time : 33.638 ms