explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WLEP

Settings
# exclusive inclusive rows x rows loops node
1. 32.359 924.681 ↓ 625.8 2,503 1

Nested Loop Left Join (cost=0.28..924.46 rows=4 width=819) (actual time=0.720..924.681 rows=2,503 loops=1)

  • Join Filter: (kgazb.kod = g.alt_zemin_birimi_id)
  • Rows Removed by Join Filter: 10022
2. 26.393 877.304 ↓ 625.8 2,503 1

Nested Loop Left Join (cost=0.28..923.07 rows=4 width=755) (actual time=0.693..877.304 rows=2,503 loops=1)

  • Join Filter: (kgaz.kod = g.alt_zemin_id)
  • Rows Removed by Join Filter: 12522
3. 49.322 833.390 ↓ 625.8 2,503 1

Nested Loop Left Join (cost=0.28..921.63 rows=4 width=691) (actual time=0.646..833.390 rows=2,503 loops=1)

  • Join Filter: (kgr.kod = g.renk_id)
  • Rows Removed by Join Filter: 32541
4. 145.117 746.523 ↓ 625.8 2,503 1

Nested Loop Left Join (cost=0.28..919.62 rows=4 width=627) (actual time=0.607..746.523 rows=2,503 loops=1)

  • Join Filter: (kgmtad.kod = g.malzeme_turu_alt_detay_id)
  • Rows Removed by Join Filter: 120153
5. 25.744 473.753 ↓ 625.8 2,503 1

Nested Loop Left Join (cost=0.28..915.06 rows=4 width=563) (actual time=0.381..473.753 rows=2,503 loops=1)

  • Join Filter: (kgmt.kod = g.malzeme_turu_id)
  • Rows Removed by Join Filter: 12516
6. 36.439 430.488 ↓ 625.8 2,503 1

Nested Loop Left Join (cost=0.28..913.63 rows=4 width=499) (actual time=0.368..430.488 rows=2,503 loops=1)

  • Join Filter: (kgt.kod = g.tur_id)
  • Rows Removed by Join Filter: 20025
7. 17.803 366.516 ↓ 625.8 2,503 1

Nested Loop Left Join (cost=0.28..911.98 rows=4 width=435) (actual time=0.299..366.516 rows=2,503 loops=1)

8. 323.683 323.683 ↓ 625.8 2,503 1

Seq Scan on geopark g (cost=0.00..882.75 rows=4 width=408) (actual time=0.277..323.683 rows=2,503 loops=1)

  • Filter: ((geometrytype(poly) = 'POLYGON'::text) AND st_isvalid(poly))
  • Rows Removed by Filter: 179
9. 25.030 25.030 ↑ 1.0 1 2,503

Index Scan using "PIX1569713859" on geopark_sinir gs (cost=0.28..7.29 rows=1 width=35) (actual time=0.008..0.010 rows=1 loops=2,503)

  • Index Cond: (objectid = g.geoparksinir_id)
10. 27.516 27.533 ↑ 1.0 9 2,503

Materialize (cost=0.00..1.14 rows=9 width=72) (actual time=0.001..0.011 rows=9 loops=2,503)

11. 0.017 0.017 ↑ 1.0 9 1

Seq Scan on kod_geopark_tur kgt (cost=0.00..1.09 rows=9 width=72) (actual time=0.006..0.017 rows=9 loops=1)

12. 17.512 17.521 ↑ 1.0 6 2,503

Materialize (cost=0.00..1.09 rows=6 width=72) (actual time=0.001..0.007 rows=6 loops=2,503)

13. 0.009 0.009 ↑ 1.0 6 1

Seq Scan on kod_geopark_malzeme_turu kgmt (cost=0.00..1.06 rows=6 width=72) (actual time=0.003..0.009 rows=6 loops=1)

14. 127.591 127.653 ↑ 1.0 49 2,503

Materialize (cost=0.00..1.73 rows=49 width=72) (actual time=0.001..0.051 rows=49 loops=2,503)

15. 0.062 0.062 ↑ 1.0 49 1

Seq Scan on kod_geopark_malzeme_turu_alt_detay kgmtad (cost=0.00..1.49 rows=49 width=72) (actual time=0.004..0.062 rows=49 loops=1)

16. 37.528 37.545 ↑ 1.0 14 2,503

Materialize (cost=0.00..1.21 rows=14 width=72) (actual time=0.001..0.015 rows=14 loops=2,503)

17. 0.017 0.017 ↑ 1.0 14 1

Seq Scan on kod_geopark_renk kgr (cost=0.00..1.14 rows=14 width=72) (actual time=0.003..0.017 rows=14 loops=1)

18. 17.511 17.521 ↑ 1.0 6 2,503

Materialize (cost=0.00..1.09 rows=6 width=72) (actual time=0.001..0.007 rows=6 loops=2,503)

19. 0.010 0.010 ↑ 1.0 6 1

Seq Scan on kod_geopark_alt_zemin kgaz (cost=0.00..1.06 rows=6 width=72) (actual time=0.004..0.010 rows=6 loops=1)

20. 15.010 15.018 ↑ 1.0 5 2,503

Materialize (cost=0.00..1.07 rows=5 width=72) (actual time=0.001..0.006 rows=5 loops=2,503)

21. 0.008 0.008 ↑ 1.0 5 1

Seq Scan on kod_geopark_alt_zemin_birimi kgazb (cost=0.00..1.05 rows=5 width=72) (actual time=0.003..0.008 rows=5 loops=1)