explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Qj

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 0.277 ↓ 4.0 8 1

Nested Loop Left Join (cost=2.55..58.82 rows=2 width=243) (actual time=0.092..0.277 rows=8 loops=1)

2. 0.022 0.216 ↓ 4.0 8 1

Nested Loop Left Join (cost=2.13..57.92 rows=2 width=227) (actual time=0.082..0.216 rows=8 loops=1)

  • Join Filter: (rez.sirketid = gecemus.sirketid)
3. 0.013 0.158 ↓ 4.0 4 1

Nested Loop Left Join (cost=1.71..41.74 rows=1 width=223) (actual time=0.072..0.158 rows=4 loops=1)

  • Join Filter: (rez.sirketid = acen.sirketid)
4. 0.011 0.129 ↓ 4.0 4 1

Nested Loop Left Join (cost=1.43..35.93 rows=1 width=205) (actual time=0.064..0.129 rows=4 loops=1)

  • Join Filter: (rez.sirketid = konum.sirketid)
5. 0.016 0.102 ↓ 4.0 4 1

Nested Loop Left Join (cost=1.28..31.75 rows=1 width=141) (actual time=0.056..0.102 rows=4 loops=1)

  • Join Filter: (rez.sirketid = oda.sirketid)
6. 0.012 0.070 ↓ 4.0 4 1

Nested Loop Left Join (cost=1.01..26.45 rows=1 width=136) (actual time=0.048..0.070 rows=4 loops=1)

  • Join Filter: ((rez.id = gece.rezid) AND (rez.sirketid = gece.sirketid))
7. 0.007 0.037 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.58..16.63 rows=1 width=88) (actual time=0.033..0.037 rows=1 loops=1)

8. 0.016 0.016 ↑ 1.0 1 1

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

  • Index Cond: (id = 85331)
9. 0.014 0.014 ↑ 1.0 1 1

Index Scan using PK_public.voucher on voucher vouc (cost=0.29..8.31 rows=1 width=48) (actual time=0.012..0.014 rows=1 loops=1)

  • Index Cond: (rez.voucherid = id)
  • Filter: (rez.sirketid = sirketid)
10. 0.021 0.021 ↑ 2.0 4 1

Index Scan using ramsil on geceleme gece (cost=0.42..9.70 rows=8 width=56) (actual time=0.011..0.021 rows=4 loops=1)

  • Index Cond: (rezid = 85331)
11. 0.016 0.016 ↑ 1.0 1 4

Index Scan using PK_public.oda on oda (cost=0.28..5.29 rows=1 width=13) (actual time=0.003..0.004 rows=1 loops=4)

  • Index Cond: (gece.odaid = id)
12. 0.016 0.016 ↑ 1.0 1 4

Index Scan using PK_public.odakonum on odakonum konum (cost=0.15..4.17 rows=1 width=72) (actual time=0.002..0.004 rows=1 loops=4)

  • Index Cond: (gece.odakonumid = id)
13. 0.016 0.016 ↑ 1.0 1 4

Index Scan using PK_public.acenta on acenta acen (cost=0.28..5.79 rows=1 width=26) (actual time=0.003..0.004 rows=1 loops=4)

  • Index Cond: (gece.acentaid = id)
14. 0.036 0.036 ↑ 1.5 2 4

Index Scan using mamisil2 on gecelememusteri gecemus (cost=0.43..16.14 rows=3 width=16) (actual time=0.007..0.009 rows=2 loops=4)

  • Index Cond: (gece.id = gecelemeid)
15. 0.032 0.032 ↑ 1.0 1 8

Index Scan using PK_public.musteri on musteri mus (cost=0.42..0.44 rows=1 width=20) (actual time=0.003..0.004 rows=1 loops=8)

  • Index Cond: (gecemus.musteriid = id)