explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lVvb

Settings
# exclusive inclusive rows x rows loops node
1. 0.096 0.578 ↓ 15.0 30 1

Nested Loop Left Join (cost=1.56..42.52 rows=2 width=309) (actual time=0.098..0.578 rows=30 loops=1)

2. 0.064 0.362 ↓ 15.0 30 1

Nested Loop Left Join (cost=1.15..41.61 rows=2 width=268) (actual time=0.088..0.362 rows=30 loops=1)

3. 0.034 0.148 ↓ 15.0 15 1

Nested Loop Left Join (cost=0.72..25.44 rows=1 width=239) (actual time=0.075..0.148 rows=15 loops=1)

  • Join Filter: (geceleme.rezid = rez.id)
4. 0.018 0.066 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.29..10.65 rows=1 width=178) (actual time=0.061..0.066 rows=1 loops=1)

  • Join Filter: (rezozellik.ozellikid = ozellik.id)
  • Rows Removed by Join Filter: 14
5. 0.007 0.036 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.29..9.33 rows=1 width=86) (actual time=0.032..0.036 rows=1 loops=1)

  • Join Filter: (rezozellik.rezid = rez.id)
6. 0.016 0.016 ↑ 1.0 1 1

Index Scan using "PK_public.rez" on rez (cost=0.29..8.31 rows=1 width=57) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (id = 76461)
7. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on rezozellik (cost=0.00..1.01 rows=1 width=29) (actual time=0.012..0.013 rows=0 loops=1)

  • Filter: (rezid = 76461)
  • Rows Removed by Filter: 1
8. 0.012 0.012 ↑ 1.0 14 1

Seq Scan on ozellik (cost=0.00..1.14 rows=14 width=92) (actual time=0.003..0.012 rows=14 loops=1)

9. 0.048 0.048 ↑ 2.3 15 1

Index Scan using mamisil on geceleme (cost=0.42..14.37 rows=34 width=61) (actual time=0.011..0.048 rows=15 loops=1)

  • Index Cond: (rezid = 76461)
10. 0.150 0.150 ↑ 1.5 2 15

Index Scan using mamisil2 on gecelememusteri (cost=0.43..16.14 rows=3 width=29) (actual time=0.007..0.010 rows=2 loops=15)

  • Index Cond: (gecelemeid = geceleme.id)
11. 0.120 0.120 ↑ 1.0 1 30

Index Scan using "PK_public.musteri" on musteri (cost=0.42..0.44 rows=1 width=41) (actual time=0.003..0.004 rows=1 loops=30)

  • Index Cond: (gecelememusteri.musteriid = id)