explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YHvA

Settings
# exclusive inclusive rows x rows loops node
1. 0.172 24.012 ↑ 1.0 1 1

Aggregate (cost=104.59..104.61 rows=1 width=32) (actual time=24.012..24.012 rows=1 loops=1)

2. 0.017 23.840 ↓ 20.0 20 1

Subquery Scan on sub1 (cost=104.57..104.59 rows=1 width=58) (actual time=23.828..23.840 rows=20 loops=1)

3. 0.098 23.823 ↓ 20.0 20 1

Sort (cost=104.57..104.58 rows=1 width=34) (actual time=23.821..23.823 rows=20 loops=1)

  • Sort Key: h.szakag, c.rovid_nev
  • Sort Method: quicksort Memory: 26kB
4. 0.456 23.725 ↓ 20.0 20 1

Nested Loop (cost=4.49..104.56 rows=1 width=34) (actual time=1.252..23.725 rows=20 loops=1)

  • Join Filter: (h.halozat = ht.halozat)
5. 0.710 21.118 ↓ 717.0 717 1

Nested Loop (cost=4.20..96.70 rows=1 width=42) (actual time=0.104..21.118 rows=717 loops=1)

  • Join Filter: (h.halozat = hsl.halozat)
6. 3.574 17.536 ↓ 718.0 718 1

Nested Loop (cost=3.92..88.38 rows=1 width=40) (actual time=0.078..17.536 rows=718 loops=1)

7. 0.732 4.791 ↓ 1,019.0 1,019 1

Nested Loop (cost=0.28..74.27 rows=1 width=34) (actual time=0.039..4.791 rows=1,019 loops=1)

8. 0.849 0.849 ↓ 178.3 1,070 1

Seq Scan on halozat h (cost=0.00..28.45 rows=6 width=11) (actual time=0.019..0.849 rows=1,070 loops=1)

  • Filter: ((megnyitva IS NOT NULL) AND (upper(ervenyes) IS NULL))
  • Rows Removed by Filter: 168
9. 3.210 3.210 ↑ 1.0 1 1,070

Index Scan using pk_ceg on ceg c (cost=0.28..7.63 rows=1 width=31) (actual time=0.003..0.003 rows=1 loops=1,070)

  • Index Cond: (ceg = h.uzemelteto)
  • Filter: (tanusitvany IS NOT NULL)
  • Rows Removed by Filter: 0
10. 5.095 9.171 ↑ 1.0 1 1,019

Bitmap Heap Scan on halozat_service hs (cost=3.64..14.11 rows=1 width=6) (actual time=0.008..0.009 rows=1 loops=1,019)

  • Recheck Cond: (halozat = h.halozat)
  • Filter: ((url IS NOT NULL) AND ellenorzes_eredmeny AND (upper(ervenyes) IS NULL) AND (servicetipus = 'M'::bpchar))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=1,909
11. 4.076 4.076 ↑ 1.5 2 1,019

Bitmap Index Scan on pk_halozat_gisservice (cost=0.00..3.64 rows=3 width=0) (actual time=0.004..0.004 rows=2 loops=1,019)

  • Index Cond: (halozat = h.halozat)
12. 2.872 2.872 ↑ 1.0 1 718

Index Scan using pk_halozat_service_layers on halozat_service_layers hsl (cost=0.28..8.30 rows=1 width=6) (actual time=0.004..0.004 rows=1 loops=718)

  • Index Cond: ((halozat = hs.halozat) AND (service = hs.service))
  • Filter: (upper(ervenyes) IS NULL)
13. 2.151 2.151 ↓ 0.0 0 717

Index Scan using pk_halozat_telepules on halozat_telepules ht (cost=0.29..7.85 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=717)

  • Index Cond: ((halozat = hsl.halozat) AND (telepules = 3,336))
  • Filter: (erintett_metszeni AND (upper(ervenyes) IS NULL))
  • Rows Removed by Filter: 0
Planning time : 2.267 ms
Execution time : 24.176 ms