explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lJ04

Settings
# exclusive inclusive rows x rows loops node
1. 0.152 58.385 ↓ 15.0 30 1

Nested Loop Left Join (cost=2.41..56.05 rows=2 width=185) (actual time=13.890..58.385 rows=30 loops=1)

2. 0.140 55.053 ↓ 15.0 30 1

Nested Loop Left Join (cost=1.99..55.14 rows=2 width=169) (actual time=13.870..55.053 rows=30 loops=1)

  • Join Filter: (rez.sirketid = gecemus.sirketid)
3. 0.079 39.538 ↓ 15.0 15 1

Nested Loop Left Join (cost=1.56..38.98 rows=1 width=165) (actual time=12.165..39.538 rows=15 loops=1)

  • Join Filter: (rez.sirketid = acen.sirketid)
4. 0.296 39.339 ↓ 15.0 15 1

Nested Loop Left Join (cost=1.28..33.17 rows=1 width=147) (actual time=12.139..39.339 rows=15 loops=1)

  • Join Filter: ((gece.odakonumid = konum.id) AND (rez.sirketid = konum.sirketid))
  • Rows Removed by Join Filter: 240
5. 0.126 38.803 ↓ 15.0 15 1

Nested Loop Left Join (cost=1.28..31.75 rows=1 width=141) (actual time=12.122..38.803 rows=15 loops=1)

  • Join Filter: (rez.sirketid = oda.sirketid)
6. 0.074 38.512 ↓ 15.0 15 1

Nested Loop Left Join (cost=1.01..26.44 rows=1 width=136) (actual time=12.083..38.512 rows=15 loops=1)

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

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

8. 4.673 4.673 ↑ 1.0 1 1

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

  • Index Cond: (id = 76461)
9. 0.737 0.737 ↑ 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.735..0.737 rows=1 loops=1)

  • Index Cond: (rez.voucherid = id)
  • Filter: (rez.sirketid = sirketid)
10. 33.013 33.013 ↓ 1.9 15 1

Index Scan using ramsil on geceleme gece (cost=0.42..9.69 rows=8 width=56) (actual time=6.655..33.013 rows=15 loops=1)

  • Index Cond: (rezid = 76461)
11. 0.165 0.165 ↑ 1.0 1 15

Index Scan using PK_public.oda on oda (cost=0.28..5.29 rows=1 width=13) (actual time=0.010..0.011 rows=1 loops=15)

  • Index Cond: (gece.odaid = id)
12. 0.240 0.240 ↑ 1.0 17 15

Seq Scan on odakonum konum (cost=0.00..1.17 rows=17 width=14) (actual time=0.003..0.016 rows=17 loops=15)

13. 0.120 0.120 ↑ 1.0 1 15

Index Scan using PK_public.acenta on acenta acen (cost=0.28..5.79 rows=1 width=26) (actual time=0.006..0.008 rows=1 loops=15)

  • Index Cond: (gece.acentaid = id)
14. 15.375 15.375 ↑ 1.5 2 15

Index Scan using mamisil2 on gecelememusteri gecemus (cost=0.43..16.13 rows=3 width=16) (actual time=0.973..1.025 rows=2 loops=15)

  • Index Cond: (gece.id = gecelemeid)
15. 3.180 3.180 ↑ 1.0 1 30

Index Scan using PK_public.musteri on musteri mus (cost=0.42..0.44 rows=1 width=20) (actual time=0.104..0.106 rows=1 loops=30)

  • Index Cond: (gecemus.musteriid = id)