explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s6y

Settings
# exclusive inclusive rows x rows loops node
1. 7.309 27.712 ↓ 122.5 245 1

Gather (cost=1,002.26..3,629.29 rows=2 width=243) (actual time=1.550..27.712 rows=245 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 0.901 20.403 ↓ 122.0 122 2

Nested Loop Left Join (cost=2.26..2,629.09 rows=1 width=243) (actual time=0.504..20.403 rows=122 loops=2)

  • Join Filter: (rez.sirketid = acen.sirketid)
3. 0.793 19.498 ↓ 122.0 122 2

Nested Loop Left Join (cost=1.99..2,628.66 rows=1 width=229) (actual time=0.477..19.498 rows=122 loops=2)

  • Join Filter: (rez.sirketid = konum.sirketid)
4. 0.936 18.702 ↓ 122.0 122 2

Nested Loop Left Join (cost=1.84..2,628.36 rows=1 width=165) (actual time=0.464..18.702 rows=122 loops=2)

  • Join Filter: (rez.sirketid = oda.sirketid)
5. 0.965 17.762 ↓ 122.0 122 2

Nested Loop Left Join (cost=1.56..2,627.93 rows=1 width=160) (actual time=0.447..17.762 rows=122 loops=2)

6. 0.868 16.792 ↓ 122.0 122 2

Nested Loop Left Join (cost=1.14..2,627.48 rows=1 width=144) (actual time=0.419..16.792 rows=122 loops=2)

  • Join Filter: (rez.sirketid = gecemus.sirketid)
7. 0.487 15.913 ↓ 56.0 56 2

Nested Loop Left Join (cost=0.71..2,611.91 rows=1 width=136) (actual time=0.366..15.913 rows=56 loops=2)

8. 0.602 15.421 ↓ 56.0 56 2

Nested Loop (cost=0.42..2,604.47 rows=1 width=96) (actual time=0.344..15.421 rows=56 loops=2)

9. 14.812 14.812 ↑ 1.1 56 2

Parallel Seq Scan on rez (cost=0.00..2,065.56 rows=64 width=48) (actual time=0.298..14.812 rows=56 loops=2)

  • Filter: ((NOT silinmis) AND (sirketid = 1) AND (cintarih = '2017-01-26 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 51033
10. 0.007 0.007 ↑ 1.0 1 111

Index Scan using geceleme_SirketKod on geceleme gece (cost=0.42..8.41 rows=1 width=56) (actual time=0.006..0.007 rows=1 loops=111)

  • Index Cond: ((sirketid = 1) AND (rezid = rez.id) AND (gun = '2017-01-26 00:00:00'::timestamp without time zone))
11. 0.005 0.005 ↑ 1.0 1 111

Index Scan using PK_public.voucher on voucher vouc (cost=0.29..7.42 rows=1 width=48) (actual time=0.005..0.005 rows=1 loops=111)

  • Index Cond: (rez.voucherid = id)
  • Filter: ((sirketid = 1) AND (rez.sirketid = sirketid))
12. 0.011 0.011 ↑ 1.5 2 111

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

  • Index Cond: (gece.id = gecelemeid)
  • Filter: (sirketid = 1)
13. 0.005 0.005 ↑ 1.0 1 245

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

  • Index Cond: (gecemus.musteriid = id)
14. 0.004 0.004 ↑ 1.0 1 245

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

  • Index Cond: (gece.odaid = id)
  • Filter: (sirketid = 1)
15. 0.003 0.003 ↑ 1.0 1 245

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

  • Index Cond: (gece.odakonumid = id)
  • Filter: (sirketid = 1)
16. 0.004 0.004 ↑ 1.0 1 245

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

  • Index Cond: (gece.acentaid = id)
  • Filter: (sirketid = 1)