explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NzQC

Settings
# exclusive inclusive rows x rows loops node
1. 14.118 96.951 ↑ 566.8 941 1

Aggregate (cost=68,744.93..74,078.22 rows=533,329 width=4) (actual time=93.383..96.951 rows=941 loops=1)

  • Buffers: shared hit=102057
2. 8.369 82.833 ↑ 9.2 57,819 1

Nested Loop (cost=7.39..67,411.6 rows=533,329 width=4) (actual time=0.273..82.833 rows=57,819 loops=1)

  • Buffers: shared hit=102057
3. 1.591 15.024 ↓ 6.3 7,430 1

Nested Loop (cost=6.82..13,330.93 rows=1,179 width=4) (actual time=0.183..15.024 rows=7,430 loops=1)

  • Buffers: shared hit=11727
4. 1.111 1.226 ↓ 4.0 939 1

Bitmap Heap Scan on Strassenabschnitt Strassenabschnitt (cost=6.25..876.83 rows=235 width=4) (actual time=0.167..1.226 rows=939 loops=1)

  • Buffers: shared hit=475
5. 0.115 0.115 ↓ 4.0 939 1

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

  • Index Cond: ("Strassenabschnitt"."Postort_ID" = 11938)
  • Buffers: shared hit=7
6. 12.207 12.207 ↑ 1.5 8 939

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.005..0.013 rows=8 loops=939)

  • 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=11252
7. 59.440 59.440 ↑ 56.6 8 7,430

Index Scan using "IX_Preisregelung_GID_TID_gs_gb" on Preisregelung Preisregelung (cost=0.57..41.34 rows=453 width=8) (actual time=0.003..0.008 rows=8 loops=7,430)

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