explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kFPV

Settings
# exclusive inclusive rows x rows loops node
1. 3.112 6,628.471 ↓ 122.5 245 1

Nested Loop Left Join (cost=1.71..16,855.69 rows=2 width=243) (actual time=5.848..6,628.471 rows=245 loops=1)

2. 1.629 6,620.949 ↓ 122.5 245 1

Nested Loop Left Join (cost=1.29..16,854.78 rows=2 width=227) (actual time=5.826..6,620.949 rows=245 loops=1)

3. 57.790 303.753 ↓ 111.0 111 1

Nested Loop Left Join (cost=0.86..3,666.89 rows=1 width=219) (actual time=1.111..303.753 rows=111 loops=1)

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

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

5. 66.581 175.006 ↓ 111.0 111 1

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

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

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

7. 1.378 29.762 ↓ 111.0 111 1

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

8. 26.053 26.053 ↓ 1.0 111 1

Seq Scan on rez (cost=0.00..2,696.65 rows=108 width=48) (actual time=0.022..26.053 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.331 2.331 ↑ 1.0 1 111

Index Scan using geceleme_SirketKod on geceleme gece (cost=0.42..8.41 rows=1 width=56) (actual time=0.019..0.021 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.701 76.701 ↑ 1.0 736 111

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

  • Filter: (sirketid = 1)
12. 1.221 1.221 ↑ 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.008..0.011 rows=1 loops=111)

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

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

  • Filter: (sirketid = 1)
14. 6,315.567 6,315.567 ↑ 1.5 2 111

Index Only Scan using gecelememusteri_SirketKod on gecelememusteri gecemus (cost=0.43..13,187.87 rows=3 width=12) (actual time=4.881..56.897 rows=2 loops=111)

  • Index Cond: (gecelemeid = gece.id)
  • Heap Fetches: 245
15. 4.410 4.410 ↑ 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.017..0.018 rows=1 loops=245)

  • Index Cond: (gecemus.musteriid = id)