explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FaXm

Settings
# exclusive inclusive rows x rows loops node
1. 4.050 13,660.254 ↓ 122.5 245 1

Nested Loop Left Join (cost=1.71..21,221.39 rows=2 width=243) (actual time=10.677..13,660.254 rows=245 loops=1)

2. 52.495 13,651.059 ↓ 122.5 245 1

Nested Loop Left Join (cost=1.29..21,220.48 rows=2 width=227) (actual time=10.646..13,651.059 rows=245 loops=1)

  • Join Filter: (rez.sirketid = gecemus.sirketid)
3. 64.803 331.844 ↓ 111.0 111 1

Nested Loop Left Join (cost=0.86..3,666.89 rows=1 width=223) (actual time=1.114..331.844 rows=111 loops=1)

  • Join Filter: ((rez.sirketid = acen.sirketid) AND (gece.acentaid = acen.id))
  • Rows Removed by Join Filter: 71928
4. 0.809 194.891 ↓ 111.0 111 1

Nested Loop Left Join (cost=0.86..3,642.04 rows=1 width=205) (actual time=1.013..194.891 rows=111 loops=1)

  • Join Filter: (rez.sirketid = konum.sirketid)
5. 72.803 192.750 ↓ 111.0 111 1

Nested Loop Left Join (cost=0.71..3,641.74 rows=1 width=141) (actual time=1.001..192.750 rows=111 loops=1)

  • Join Filter: ((rez.sirketid = oda.sirketid) AND (gece.odaid = oda.id))
  • Rows Removed by Join Filter: 81585
6. 0.506 37.141 ↓ 111.0 111 1

Nested Loop Left Join (cost=0.71..3,613.50 rows=1 width=136) (actual time=0.062..37.141 rows=111 loops=1)

7. 1.457 35.081 ↓ 111.0 111 1

Nested Loop (cost=0.42..3,606.07 rows=1 width=96) (actual time=0.057..35.081 rows=111 loops=1)

8. 30.960 30.960 ↓ 1.0 111 1

Seq Scan on rez (cost=0.00..2,696.65 rows=108 width=48) (actual time=0.022..30.960 rows=111 loops=1)

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

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

  • Index Cond: ((sirketid = 1) AND (rezid = rez.id) AND (gun = '2017-01-26 00:00:00'::timestamp without time zone))
10. 1.554 1.554 ↑ 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.011..0.014 rows=1 loops=111)

  • Index Cond: (rez.voucherid = id)
  • Filter: ((sirketid = 1) AND (rez.sirketid = sirketid))
11. 82.806 82.806 ↑ 1.0 736 111

Seq Scan on oda (cost=0.00..17.20 rows=736 width=13) (actual time=0.007..0.746 rows=736 loops=111)

  • Filter: (sirketid = 1)
12. 1.332 1.332 ↑ 1.0 1 111

Index Scan using PK_public.odakonum on odakonum konum (cost=0.15..0.29 rows=1 width=72) (actual time=0.009..0.012 rows=1 loops=111)

  • Index Cond: (gece.odakonumid = id)
  • Filter: (sirketid = 1)
13. 72.150 72.150 ↑ 1.0 649 111

Seq Scan on acenta acen (cost=0.00..15.11 rows=649 width=26) (actual time=0.007..0.650 rows=649 loops=111)

  • Filter: (sirketid = 1)
14. 13,266.720 13,266.720 ↑ 1.5 2 111

Index Only Scan using gecelememusteri_SirketKod on gecelememusteri gecemus (cost=0.43..17,553.55 rows=3 width=16) (actual time=9.747..119.520 rows=2 loops=111)

  • Index Cond: ((sirketid = 1) AND (gecelemeid = gece.id))
  • Heap Fetches: 245
15. 5.145 5.145 ↑ 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.020..0.021 rows=1 loops=245)

  • Index Cond: (gecemus.musteriid = id)