explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GgOW

Settings
# exclusive inclusive rows x rows loops node
1. 0.842 7.807 ↓ 129.5 259 1

Nested Loop Left Join (cost=29.30..78.39 rows=2 width=243) (actual time=0.498..7.807 rows=259 loops=1)

2. 0.625 5.929 ↓ 129.5 259 1

Nested Loop Left Join (cost=28.88..77.48 rows=2 width=227) (actual time=0.486..5.929 rows=259 loops=1)

  • Join Filter: (rez.sirketid = gecemus.sirketid)
3. 0.446 4.578 ↓ 121.0 121 1

Nested Loop Left Join (cost=28.45..61.92 rows=1 width=223) (actual time=0.473..4.578 rows=121 loops=1)

  • Join Filter: (rez.sirketid = acen.sirketid)
4. 0.380 3.769 ↓ 121.0 121 1

Nested Loop Left Join (cost=28.18..61.49 rows=1 width=205) (actual time=0.466..3.769 rows=121 loops=1)

  • Join Filter: (rez.sirketid = konum.sirketid)
5. 0.337 3.026 ↓ 121.0 121 1

Nested Loop Left Join (cost=28.03..61.19 rows=1 width=141) (actual time=0.458..3.026 rows=121 loops=1)

  • Join Filter: (rez.sirketid = oda.sirketid)
6. 0.366 2.205 ↓ 121.0 121 1

Nested Loop Left Join (cost=27.75..60.77 rows=1 width=136) (actual time=0.448..2.205 rows=121 loops=1)

7. 0.523 1.355 ↓ 121.0 121 1

Hash Join (cost=27.46..53.47 rows=1 width=96) (actual time=0.441..1.355 rows=121 loops=1)

  • Hash Cond: ((gece.sirketid = rez.sirketid) AND (gece.rezid = rez.id))
8. 0.457 0.457 ↓ 1.1 420 1

Index Scan using geceleme_gun_idx on geceleme gece (cost=0.42..23.43 rows=400 width=56) (actual time=0.048..0.457 rows=420 loops=1)

  • Index Cond: (gun = '2017-01-26 00:00:00'::timestamp without time zone)
9. 0.122 0.375 ↑ 1.0 121 1

Hash (cost=25.22..25.22 rows=121 width=48) (actual time=0.375..0.375 rows=121 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
10. 0.253 0.253 ↑ 1.0 121 1

Index Scan using rez_cin_idx on rez (cost=0.29..25.22 rows=121 width=48) (actual time=0.053..0.253 rows=121 loops=1)

  • Index Cond: (cintarih = '2017-01-26 00:00:00'::timestamp without time zone)
11. 0.484 0.484 ↑ 1.0 1 121

Index Scan using PK_public.voucher on voucher vouc (cost=0.29..7.29 rows=1 width=48) (actual time=0.003..0.004 rows=1 loops=121)

  • Index Cond: (rez.voucherid = id)
  • Filter: (rez.sirketid = sirketid)
12. 0.484 0.484 ↑ 1.0 1 121

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

  • Index Cond: (gece.odaid = id)
13. 0.363 0.363 ↑ 1.0 1 121

Index Scan using PK_public.odakonum on odakonum konum (cost=0.15..0.29 rows=1 width=72) (actual time=0.002..0.003 rows=1 loops=121)

  • Index Cond: (gece.odakonumid = id)
14. 0.363 0.363 ↑ 1.0 1 121

Index Scan using PK_public.acenta on acenta acen (cost=0.28..0.41 rows=1 width=26) (actual time=0.002..0.003 rows=1 loops=121)

  • Index Cond: (gece.acentaid = id)
15. 0.726 0.726 ↑ 1.5 2 121

Index Scan using mamisil2 on gecelememusteri gecemus (cost=0.43..15.53 rows=3 width=16) (actual time=0.003..0.006 rows=2 loops=121)

  • Index Cond: (gece.id = gecelemeid)
16. 1.036 1.036 ↑ 1.0 1 259

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=259)

  • Index Cond: (gecemus.musteriid = id)