explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C5kJ

Settings
# exclusive inclusive rows x rows loops node
1. 89.443 426.150 ↑ 401.9 1,327 1

Aggregate (cost=68,744.93..74,078.22 rows=533,329 width=4) (actual time=422.083..426.15 rows=1,327 loops=1)

  • Buffers: shared hit=430430
2. 59.444 336.707 ↑ 1.3 397,659 1

Nested Loop (cost=7.39..67,411.6 rows=533,329 width=4) (actual time=0.206..336.707 rows=397,659 loops=1)

  • Buffers: shared hit=430430
3. 3.521 25.627 ↓ 9.7 11,438 1

Nested Loop (cost=6.82..13,330.93 rows=1,179 width=4) (actual time=0.197..25.627 rows=11,438 loops=1)

  • Buffers: shared hit=17426
4. 1.686 1.802 ↓ 5.4 1,269 1

Bitmap Heap Scan on Strassenabschnitt Strassenabschnitt (cost=6.25..876.83 rows=235 width=4) (actual time=0.182..1.802 rows=1,269 loops=1)

  • Buffers: shared hit=633
5. 0.116 0.116 ↓ 5.4 1,269 1

Bitmap Index Scan on "IX_Strassenabschnitt_PoID_StID_HnMin_HnMax" (cost=0..6.19 rows=235 width=0) (actual time=0.116..0.116 rows=1,269 loops=1)

  • Index Cond: ("Strassenabschnitt"."Postort_ID" = 15802)
  • Buffers: shared hit=8
6. 20.304 20.304 ↑ 1.3 9 1,269

Index Scan using "IX_Strassenabschnitt_Gebiet_StrAbID_gs_gb" on Strassenabschnitt_Gebiet Strassenabschnitt_Gebiet (cost=0.57..52.88 rows=12 width=8) (actual time=0.007..0.016 rows=9 loops=1,269)

  • Index Cond: (("Strassenabschnitt_Gebiet"."Strassenabschnitt_ID" = "Strassenabschnitt"."ID") AND ("Strassenabschnitt_Gebiet".gueltig_seit <= CURRENT_DATE) AND ("Strassenabschnitt_Gebiet".gueltig_bis >= CURRENT_DATE))
  • Buffers: shared hit=16793
7. 251.636 251.636 ↑ 12.9 35 11,438

Index Scan using "IX_Preisregelung_GID_TID_gs_gb" on Preisregelung Preisregelung (cost=0.57..41.34 rows=453 width=8) (actual time=0.004..0.022 rows=35 loops=11,438)

  • Index Cond: (("Preisregelung"."Gebiet_ID" = "Strassenabschnitt_Gebiet"."Gebiet_ID") AND ("Preisregelung".gueltig_seit <= CURRENT_DATE) AND ("Preisregelung".gueltig_bis >= CURRENT_DATE))
  • Buffers: shared hit=413004