explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FyD1

Settings
# exclusive inclusive rows x rows loops node
1. 0.728 24,368.727 ↑ 67.8 344 1

Unique (cost=5,319,675.56..5,321,949.06 rows=23,318 width=374) (actual time=24,367.983..24,368.727 rows=344 loops=1)

2. 4.015 24,367.999 ↑ 33.6 694 1

Sort (cost=5,319,675.56..5,319,733.85 rows=23,318 width=374) (actual time=24,367.981..24,367.999 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,351.767 24,363.984 ↑ 33.6 694 1

Hash Join (cost=4,942,463.84..5,313,997.43 rows=23,318 width=374) (actual time=21,592.519..24,363.984 rows=694 loops=1)

  • Hash Cond: ("Preisregelung_BerechnungsmethodeTyp"."Preisregelung_ID" = "Preisregelung"."ID")
4. 1,447.516 1,447.516 ↑ 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.018..1,447.516 rows=10,755,017 loops=1)

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

Hash (cost=4,941,576.67..4,941,576.67 rows=24,014 width=174) (actual time=21,564.701..21,564.701 rows=702 loops=1)

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

Hash Join (cost=1,968,253.35..4,941,576.67 rows=24,014 width=174) (actual time=19,568.324..21,562.765 rows=702 loops=1)

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

Hash Left Join (cost=1,967,447.59..4,940,260.28 rows=24,043 width=188) (actual time=19,562.564..21,556.187 rows=702 loops=1)

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

Hash Left Join (cost=1,967,424.15..4,939,933.57 rows=24,043 width=183) (actual time=19,562.116..21,555.023 rows=702 loops=1)

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

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

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

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

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

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

  • Hash Cond: ("Preisstaffel"."ID" = "Preisstaffel_Zeitstufe"."Preisstaffel_ID")
12. 0.292 10,086.782 ↑ 32.4 860 1

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

13. 0.211 10,077.808 ↑ 53.4 2,894 1

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

14. 0.361 10,072.197 ↑ 39.1 900 1

Hash Left Join (cost=994,225.64..1,382,032.25 rows=35,183 width=120) (actual time=8,955.166..10,072.197 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,486.210 10,068.354 ↑ 120.3 902 1

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

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

17. 2.943 6,320.499 ↑ 120.3 902 1

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

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

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

  • Hash Cond: ("Preisregelung_Preisgarantie"."Preisregelung_ID" = "Preisregelung"."ID")
19. 866.651 866.651 ↓ 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.009..866.651 rows=8,731,341 loops=1)

20. 2.232 3,738.517 ↑ 120.3 902 1

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

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

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

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

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

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

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

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

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

25. 0.282 1,930.150 ↑ 1.5 978 1

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
27. 1.586 1,903.584 ↑ 1.9 326 3

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

28. 325.189 1,901.994 ↑ 1.9 326 3

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

  • Hash Cond: ("Strassenabschnitt_Gebiet"."Strassenabschnitt_ID" = "Strassenabschnitt"."ID")
29. 1,361.706 1,361.706 ↑ 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.114..1,361.706 rows=5,222,634 loops=3)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Seq Scan on "Tarif" (cost=1,178.08..1,627.17 rows=4,194 width=31) (actual time=18.072..24.402 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 (forSeq Scan)

40. 1.704 16.629 ↓ 1.0 3,147 1

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

  • Hash Cond: ("Tarif_Merkmal_1"."Tarif_ID" = "Tarif_1"."ID")
41. 8.206 8.206 ↓ 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.008..8.206 rows=3,156 loops=1)

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

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

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

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

44. 1.275 2.669 ↑ 1.0 7,923 1

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

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

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

46. 0.047 0.142 ↑ 1.4 394 1

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

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

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

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

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

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

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

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 33
50. 5.400 5.400 ↑ 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.004..0.006 rows=3 loops=900)

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

Index Scan using "Preisstaffel_pkey" on "Preisstaffel" (cost=0.57..7.28 rows=1 width=25) (actual time=0.003..0.003 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. 554.302 992.355 ↓ 1.0 3,882,583 1

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

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

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

54. 0.444 0.816 ↓ 1.0 3,143 1

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

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

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

56. 1.668 16.854 ↑ 1.1 13,414 1

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

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

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

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

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

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

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

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

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

  • Filter: (("Prozent_Oeko" >= '0'::numeric) AND (gueltig_seit <= CURRENT_DATE))
  • Rows Removed by Filter: 21
61. 626.634 8,097.701 ↓ 4.1 2,834,957 1

Hash (cost=831,299.67..831,299.67 rows=687,012 width=17) (actual time=8,097.701..8,097.701 rows=2,834,957 loops=1)

  • Buckets: 65536 (originally 65536) Batches: 64 (originally 16) Memory Usage: 3585kB
62. 655.352 7,471.067 ↓ 4.1 2,834,957 1

Gather (cost=96,705.27..831,299.67 rows=687,012 width=17) (actual time=333.935..7,471.067 rows=2,834,957 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
63. 2,077.304 6,815.715 ↓ 3.3 944,986 3

Hash Join (cost=95,705.27..761,598.47 rows=286,255 width=17) (actual time=372.911..6,815.715 rows=944,986 loops=3)

  • Hash Cond: ("Preisregelung_Aufschlag_AufschlagDetail"."Aufschlag_ID" = "Aufschlag"."ID")
64. 1,435.404 4,401.775 ↓ 4.0 8,972,926 3

Hash Join (cost=3,785.56..621,386.32 rows=2,230,689 width=8) (actual time=35.778..4,401.775 rows=8,972,926 loops=3)

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

Parallel Seq Scan on "Preisregelung_Aufschlag_AufschlagDetail" (cost=0.00..548,514.57 rows=12,688,721 width=12) (actual time=0.070..2,931.226 rows=10,167,047 loops=3)

  • Filter: (gueltig_seit <= CURRENT_DATE)
  • Rows Removed by Filter: 9459
66. 1.265 35.145 ↓ 1.0 10,415 3

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

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

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

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

Seq Scan on "AufschlagDetail" (cost=0.00..2,090.78 rows=60,778 width=4) (actual time=0.115..9.808 rows=60,814 loops=3)

69. 2.126 16.242 ↓ 1.0 10,415 3

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

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

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

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

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

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

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

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

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

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

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

75. 1.691 5.637 ↑ 1.0 16,265 1

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

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

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

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