explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 25Ba

Settings
# exclusive inclusive rows x rows loops node
1. 6.880 27.472 ↓ 122.5 245 1

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

  • Workers Planned: 1
  • Workers Launched: 1
2. 1.114 20.592 ↓ 122.0 122 2

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

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

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

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

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

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

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

6. 0.708 16.732 ↓ 122.0 122 2

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

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

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

8. 0.564 15.553 ↓ 56.0 56 2

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

9. 14.982 14.982 ↑ 1.1 56 2

Parallel Seq Scan on rez (cost=0.00..2,065.56 rows=64 width=48) (actual time=0.022..14.982 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.004..0.005 rows=1 loops=111)

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

Index Scan using mamisil2 on gecelememusteri gecemus (cost=0.43..15.53 rows=3 width=16) (actual time=0.005..0.008 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.005 0.005 ↑ 1.0 1 245

Index Scan using PK_public.oda on oda (cost=0.28..0.42 rows=1 width=13) (actual time=0.004..0.005 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)