explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qtiv

Settings
# exclusive inclusive rows x rows loops node
1. 6.987 35.190 ↓ 129.5 259 1

Gather (cost=1,002.26..3,688.38 rows=2 width=243) (actual time=1.564..35.190 rows=259 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 0.944 28.203 ↓ 130.0 130 2

Nested Loop Left Join (cost=2.26..2,688.18 rows=1 width=243) (actual time=0.207..28.203 rows=130 loops=2)

  • Join Filter: (rez.sirketid = acen.sirketid)
3. 0.836 27.255 ↓ 130.0 130 2

Nested Loop Left Join (cost=1.99..2,687.75 rows=1 width=229) (actual time=0.182..27.255 rows=130 loops=2)

  • Join Filter: (rez.sirketid = konum.sirketid)
4. 0.935 26.416 ↓ 130.0 130 2

Nested Loop Left Join (cost=1.84..2,687.45 rows=1 width=165) (actual time=0.167..26.416 rows=130 loops=2)

  • Join Filter: (rez.sirketid = oda.sirketid)
5. 0.989 25.477 ↓ 130.0 130 2

Nested Loop Left Join (cost=1.56..2,687.02 rows=1 width=160) (actual time=0.144..25.477 rows=130 loops=2)

6. 0.763 24.483 ↓ 130.0 130 2

Nested Loop Left Join (cost=1.14..2,686.57 rows=1 width=144) (actual time=0.123..24.483 rows=130 loops=2)

  • Join Filter: (rez.sirketid = gecemus.sirketid)
7. 0.508 23.712 ↓ 60.0 60 2

Nested Loop Left Join (cost=0.71..2,670.99 rows=1 width=136) (actual time=0.093..23.712 rows=60 loops=2)

8. 8.712 23.199 ↓ 60.0 60 2

Nested Loop (cost=0.42..2,663.70 rows=1 width=96) (actual time=0.074..23.199 rows=60 loops=2)

9. 14.344 14.344 ↑ 1.2 60 2

Parallel Seq Scan on rez (cost=0.00..2,065.56 rows=71 width=48) (actual time=0.032..14.344 rows=60 loops=2)

  • Filter: ((sirketid = 1) AND (cintarih = '2017-01-26 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 51028
10. 0.143 0.143 ↑ 1.0 1 121

Index Scan using geceleme_SirketKod on geceleme gece (cost=0.42..8.41 rows=1 width=56) (actual time=0.142..0.143 rows=1 loops=121)

  • 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 121

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

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

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

  • Index Cond: (gece.id = gecelemeid)
  • Filter: (sirketid = 1)
13. 0.005 0.005 ↑ 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.004..0.005 rows=1 loops=259)

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

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

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

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

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

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

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