explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MhJD

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 3.903 11,479.393 ↓ 122.5 245 1

Nested Loop Left Join (cost=1.71..25,587.07 rows=2 width=243) (actual time=9.430..11,479.393 rows=245 loops=1)

2. 1.919 11,470.835 ↓ 122.5 245 1

Nested Loop Left Join (cost=1.29..25,586.16 rows=2 width=227) (actual time=9.402..11,470.835 rows=245 loops=1)

3. 59.790 308.532 ↓ 111.0 111 1

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

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

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

5. 68.215 178.794 ↓ 111.0 111 1

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

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

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

7. 1.550 31.528 ↓ 111.0 111 1

Nested Loop (cost=0.42..3,606.07 rows=1 width=100) (actual time=0.051..31.528 rows=111 loops=1)

8. 27.425 27.425 ↓ 1.0 111 1

Seq Scan on rez (cost=0.00..2,696.65 rows=108 width=48) (actual time=0.024..27.425 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.553 2.553 ↑ 1.0 1 111

Index Scan using geceleme_SirketKod on geceleme gece (cost=0.42..8.41 rows=1 width=56) (actual time=0.021..0.023 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.443 1.443 ↑ 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.013 rows=1 loops=111)

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

Seq Scan on oda (cost=0.00..17.20 rows=736 width=13) (actual time=0.006..0.692 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) AND (gece.sirketid = sirketid))
13. 67.821 67.821 ↑ 1.0 649 111

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

  • Filter: (sirketid = 1)
14. 11,160.384 11,160.384 ↑ 1.5 2 111

Index Only Scan using gecelememusteri_SirketKod on gecelememusteri gecemus (cost=0.43..21,919.24 rows=3 width=16) (actual time=8.808..100.544 rows=2 loops=111)

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

  • Index Cond: (gecemus.musteriid = id)