explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3gBI

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 1,169.734 ↑ 3.1 407 1

Append (cost=28,243.81..39,678.70 rows=1,261 width=1,156) (actual time=1,028.110..1,169.734 rows=407 loops=1)

2. 0.238 1,167.947 ↑ 3.1 407 1

Subquery Scan on "*SELECT* 1" (cost=28,243.81..39,046.21 rows=1,259 width=1,033) (actual time=1,028.109..1,167.947 rows=407 loops=1)

3. 46.031 1,167.709 ↑ 3.1 407 1

Gather (cost=28,243.81..38,999.00 rows=1,259 width=749) (actual time=1,028.104..1,167.709 rows=407 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 26.767 1,121.678 ↑ 3.9 136 3 / 3

Hash Left Join (cost=27,243.81..37,851.08 rows=525 width=749) (actual time=997.607..1,121.678 rows=136 loops=3)

  • Hash Cond: ((gece.id = rezfiy.geceleme_id) AND (gece.rezid = rezfiy.rez_id))
5. 0.092 125.265 ↑ 3.9 136 3 / 3

Hash Left Join (cost=96.10..10,683.67 rows=525 width=453) (actual time=1.596..125.265 rows=136 loops=3)

  • Hash Cond: ((gece.sirketid = pans.sirketid) AND (gece.pansiyonid = pans.id))
6. 0.095 125.161 ↑ 3.9 136 3 / 3

Hash Left Join (cost=95.03..10,678.32 rows=525 width=393) (actual time=1.573..125.161 rows=136 loops=3)

  • Hash Cond: ((gece.sirketid = fiykonum.sirketid) AND (gece.fiyatkonumid = fiykonum.id))
7. 0.099 125.051 ↑ 3.9 136 3 / 3

Hash Left Join (cost=93.91..10,673.74 rows=525 width=329) (actual time=1.543..125.051 rows=136 loops=3)

  • Hash Cond: ((gece.sirketid = acen.sirketid) AND (gece.acentaid = acen.id))
8. 0.090 124.857 ↑ 3.9 136 3 / 3

Hash Left Join (cost=87.17..10,664.22 rows=525 width=308) (actual time=1.434..124.857 rows=136 loops=3)

  • Hash Cond: ((gece.sirketid = konum.sirketid) AND (gece.odakonumid = konum.id))
9. 0.116 124.749 ↑ 3.9 136 3 / 3

Hash Left Join (cost=86.05..10,659.62 rows=525 width=244) (actual time=1.403..124.749 rows=136 loops=3)

  • Hash Cond: ((gece.sirketid = oda.sirketid) AND (gece.odaid = oda.id))
10. 0.089 123.677 ↑ 3.9 136 3 / 3

Hash Left Join (cost=5.74..10,576.56 rows=525 width=239) (actual time=0.432..123.677 rows=136 loops=3)

  • Hash Cond: ((gece.sirketid = odeme.sirketid) AND (geceek.odemeid = odeme.id))
11. 0.098 123.572 ↑ 3.9 136 3 / 3

Hash Left Join (cost=4.65..10,571.65 rows=525 width=175) (actual time=0.404..123.572 rows=136 loops=3)

  • Hash Cond: ((gece.sirketid = pazar.sirketid) AND (geceek.pazarid = pazar.id))
12. 0.076 123.453 ↑ 3.9 136 3 / 3

Nested Loop Left Join (cost=3.54..10,566.97 rows=525 width=111) (actual time=0.366..123.453 rows=136 loops=3)

13. 0.134 121.885 ↑ 3.9 136 3 / 3

Hash Left Join (cost=3.12..7,614.44 rows=525 width=103) (actual time=0.333..121.885 rows=136 loops=3)

  • Hash Cond: ((rez.sirketid = ulke.sirketid) AND (rezek.ulkeid = ulke.id))
14. 0.152 121.712 ↑ 3.9 136 3 / 3

Nested Loop Left Join (cost=0.57..7,609.05 rows=525 width=96) (actual time=0.254..121.712 rows=136 loops=3)

15. 0.095 121.289 ↑ 3.9 136 3 / 3

Nested Loop (cost=0.29..7,417.21 rows=525 width=92) (actual time=0.225..121.289 rows=136 loops=3)

16. 120.535 120.535 ↑ 3.4 165 3 / 3

Parallel Seq Scan on geceleme gece (cost=0.00..6,496.89 rows=558 width=72) (actual time=0.199..120.535 rows=165 loops=3)

  • Filter: ((NOT silinmis) AND (gun <> '1900-01-01 00:00:00'::timestamp without time zone) AND (sirketid = 1) AND ((gun)::date = '2019-04-10'::date))
  • Rows Removed by Filter: 99,711
17. 0.659 0.659 ↑ 1.0 1 494 / 3

Index Scan using ""PK_public.rez"" on rez (cost=0.29..1.65 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=494)

  • Index Cond: (id = gece.rezid)
  • Filter: ((NOT silinmis) AND (sirketid = 1) AND (turu = 1))
  • Rows Removed by Filter: 0
18. 0.271 0.271 ↑ 1.0 1 407 / 3

Index Scan using ""rezdetayek_IX_id"" on rezdetayek rezek (cost=0.29..0.37 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=407)

  • Index Cond: (rez.id = id)
  • Filter: (NOT silinmis)
19. 0.017 0.039 ↑ 1.0 56 3 / 3

Hash (cost=1.70..1.70 rows=56 width=19) (actual time=0.039..0.039 rows=56 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
20. 0.022 0.022 ↑ 1.0 56 3 / 3

Seq Scan on ulke (cost=0.00..1.70 rows=56 width=19) (actual time=0.012..0.022 rows=56 loops=3)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
21. 1.492 1.492 ↑ 1.0 1 407 / 3

Index Scan using ""gecelemedetayek_IX_id"" on gecelemedetayek geceek (cost=0.42..5.62 rows=1 width=12) (actual time=0.011..0.011 rows=1 loops=407)

  • Index Cond: (gece.id = id)
  • Filter: (NOT silinmis)
22. 0.008 0.021 ↓ 8.0 8 3 / 3

Hash (cost=1.10..1.10 rows=1 width=72) (actual time=0.021..0.021 rows=8 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
23. 0.013 0.013 ↓ 8.0 8 3 / 3

Seq Scan on pazar (cost=0.00..1.10 rows=1 width=72) (actual time=0.012..0.013 rows=8 loops=3)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
24. 0.004 0.016 ↓ 6.0 6 3 / 3

Hash (cost=1.07..1.07 rows=1 width=72) (actual time=0.016..0.016 rows=6 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
25. 0.012 0.012 ↓ 6.0 6 3 / 3

Seq Scan on odeme (cost=0.00..1.07 rows=1 width=72) (actual time=0.010..0.012 rows=6 loops=3)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
26. 0.376 0.956 ↑ 1.0 1,902 3 / 3

Hash (cost=51.78..51.78 rows=1,902 width=13) (actual time=0.956..0.956 rows=1,902 loops=3)

  • Buckets: 2,048 Batches: 1 Memory Usage: 106kB
27. 0.580 0.580 ↑ 1.0 1,902 3 / 3

Seq Scan on oda (cost=0.00..51.78 rows=1,902 width=13) (actual time=0.010..0.580 rows=1,902 loops=3)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
28. 0.005 0.018 ↓ 9.0 9 3 / 3

Hash (cost=1.11..1.11 rows=1 width=72) (actual time=0.018..0.018 rows=9 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
29. 0.013 0.013 ↓ 9.0 9 3 / 3

Seq Scan on odakonum konum (cost=0.00..1.11 rows=1 width=72) (actual time=0.011..0.013 rows=9 loops=3)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
30. 0.046 0.095 ↑ 1.0 172 3 / 3

Hash (cost=4.15..4.15 rows=172 width=29) (actual time=0.095..0.095 rows=172 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
31. 0.049 0.049 ↑ 1.0 172 3 / 3

Seq Scan on acenta acen (cost=0.00..4.15 rows=172 width=29) (actual time=0.010..0.049 rows=172 loops=3)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
32. 0.005 0.015 ↓ 9.0 9 3 / 3

Hash (cost=1.11..1.11 rows=1 width=72) (actual time=0.015..0.015 rows=9 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
33. 0.010 0.010 ↓ 9.0 9 3 / 3

Seq Scan on fiyatkonum fiykonum (cost=0.00..1.11 rows=1 width=72) (actual time=0.008..0.010 rows=9 loops=3)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
34. 0.004 0.012 ↓ 4.0 4 3 / 3

Hash (cost=1.05..1.05 rows=1 width=72) (actual time=0.012..0.012 rows=4 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
35. 0.008 0.008 ↓ 4.0 4 3 / 3

Seq Scan on pansiyon pans (cost=0.00..1.05 rows=1 width=72) (actual time=0.007..0.008 rows=4 loops=3)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
36. 1.441 969.646 ↓ 3,873.0 3,873 3 / 3

Hash (cost=27,147.69..27,147.69 rows=1 width=188) (actual time=969.646..969.646 rows=3,873 loops=3)

  • Buckets: 4,096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 456kB
37. 0.425 968.205 ↓ 3,873.0 3,873 3 / 3

Subquery Scan on rezfiy (cost=27,147.44..27,147.69 rows=1 width=188) (actual time=874.009..968.205 rows=3,873 loops=3)

38. 93.559 967.780 ↓ 3,873.0 3,873 3 / 3

GroupAggregate (cost=27,147.44..27,147.68 rows=1 width=196) (actual time=874.008..967.780 rows=3,873 loops=3)

  • Group Key: g.id, r.id, krate.dovizid, dov.adi
39. 2.504 874.221 ↓ 3,875.0 3,875 3 / 3

Sort (cost=27,147.44..27,147.45 rows=1 width=88) (actual time=873.965..874.221 rows=3,875 loops=3)

  • Sort Key: g.id, r.id, krate.dovizid, dov.adi
  • Sort Method: quicksort Memory: 641kB
40. 16.561 871.717 ↓ 3,875.0 3,875 3 / 3

Merge Join (cost=22,517.46..27,147.43 rows=1 width=88) (actual time=24.848..871.717 rows=3,875 loops=3)

  • Merge Cond: (r.cintarih = kur.tarih)
  • Join Filter: ((dep.sirketid = g.sirketid) AND (kur.dovizid = krate.dovizid) AND (dep.id = hrk.depkodid))
  • Rows Removed by Join Filter: 27,181
41. 3.462 842.034 ↓ 13.0 3,883 3 / 3

Nested Loop (cost=2.41..197,761.05 rows=299 width=112) (actual time=13.054..842.034 rows=3,883 loops=3)

42. 15.190 803.625 ↓ 13.0 3,883 3 / 3

Nested Loop (cost=2.12..197,668.15 rows=299 width=112) (actual time=13.032..803.625 rows=3,883 loops=3)

  • Join Filter: ((g.sirketid = hrk.sirketid) AND (g.gun = hrk.tarih))
  • Rows Removed by Join Filter: 39,648
43. 43.703 625.727 ↑ 3.9 3,874 3 / 3

Nested Loop (cost=1.70..175,780.25 rows=15,232 width=88) (actual time=12.996..625.727 rows=3,874 loops=3)

  • Join Filter: (dov.id = krate.dovizid)
  • Rows Removed by Join Filter: 27,119
44. 46.860 488.229 ↑ 4.0 31,265 3 / 3

Nested Loop (cost=1.42..137,710.29 rows=123,651 width=88) (actual time=12.571..488.229 rows=31,265 loops=3)

45. 21.515 171.589 ↑ 4.6 38,540 3 / 3

Nested Loop (cost=1.00..41,039.39 rows=177,736 width=84) (actual time=12.544..171.589 rows=38,540 loops=3)

46. 0.756 43.214 ↑ 5.0 3,562 3 / 3

Nested Loop (cost=0.57..12,875.50 rows=17,737 width=64) (actual time=12.522..43.214 rows=3,562 loops=3)

  • Join Filter: (r.sirketid = dov.sirketid)
47. 0.260 42.012 ↑ 39.8 446 3 / 3

Nested Loop (cost=0.57..10,745.96 rows=17,737 width=24) (actual time=12.499..42.012 rows=446 loops=3)

48. 13.208 13.208 ↑ 51.8 446 3 / 3

Index Scan using ""rez_RezCinIndex"" on rez r (cost=0.29..2,230.28 rows=23,099 width=12) (actual time=1.362..13.208 rows=446 loops=3)

  • Filter: ((NOT silinmis) AND (tipi <> 3))
  • Rows Removed by Filter: 3,647
49. 28.544 28.544 ↑ 1.0 1 1,338 / 3

Index Scan using ""folio_IX_rezid"" on folio fol (cost=0.29..0.36 rows=1 width=12) (actual time=0.064..0.064 rows=1 loops=1,338)

  • Index Cond: (rezid = r.id)
  • Filter: ((NOT silinmis) AND (tipi = 1) AND (r.sirketid = sirketid))
  • Rows Removed by Filter: 0
50. 0.429 0.446 ↑ 1.0 8 1,338 / 3

Materialize (cost=0.00..1.12 rows=8 width=40) (actual time=0.000..0.001 rows=8 loops=1,338)

51. 0.017 0.017 ↑ 1.0 8 3 / 3

Seq Scan on doviz dov (cost=0.00..1.08 rows=8 width=40) (actual time=0.014..0.017 rows=8 loops=3)

52. 106.860 106.860 ↑ 1.0 11 10,686 / 3

Index Scan using ""geceleme_GecelemeRezId"" on geceleme g (cost=0.42..1.48 rows=11 width=20) (actual time=0.021..0.030 rows=11 loops=10,686)

  • Index Cond: (rezid = r.id)
  • Filter: (r.sirketid = sirketid)
53. 269.780 269.780 ↑ 1.0 1 115,620 / 3

Index Scan using ""hesayr_Geceindex"" on hesayr hes (cost=0.42..0.53 rows=1 width=8) (actual time=0.005..0.007 rows=1 loops=115,620)

  • Index Cond: (gecelemeid = g.id)
  • Filter: ((rateid IS NOT NULL) AND (NOT silinmis))
  • Rows Removed by Filter: 1
54. 93.795 93.795 ↑ 1.0 1 93,795 / 3

Index Scan using ""PK_public.rate"" on rate krate (cost=0.28..0.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=93,795)

  • Index Cond: (id = hes.rateid)
  • Filter: (NOT silinmis)
  • Rows Removed by Filter: 0
55. 162.708 162.708 ↓ 1.2 11 11,622 / 3

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk (cost=0.42..1.30 rows=9 width=36) (actual time=0.010..0.042 rows=11 loops=11,622)

  • Index Cond: (folioid = fol.id)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (islemtipi <> 11) AND (islemtipi <> 12) AND (fol.sirketid = sirketid))
56. 34.947 34.947 ↑ 1.0 1 11,649 / 3

Index Scan using ""rezdetayek_IX_id"" on rezdetayek rek (cost=0.29..0.31 rows=1 width=12) (actual time=0.009..0.009 rows=1 loops=11,649)

  • Index Cond: (id = g.rezid)
  • Filter: (NOT silinmis)
57. 1.703 13.122 ↓ 1,506.0 31,626 3 / 3

Sort (cost=27.36..27.42 rows=21 width=32) (actual time=11.684..13.122 rows=31,626 loops=3)

  • Sort Key: kur.tarih
  • Sort Method: quicksort Memory: 129kB
58. 11.207 11.419 ↓ 48.8 1,024 3 / 3

Hash Join (cost=1.61..26.90 rows=21 width=32) (actual time=0.049..11.419 rows=1,024 loops=3)

  • Hash Cond: (kur.sirketid = dep.sirketid)
59. 0.192 0.192 ↑ 1.0 1,024 3 / 3

Seq Scan on kur (cost=0.00..21.24 rows=1,024 width=24) (actual time=0.015..0.192 rows=1,024 loops=3)

  • Filter: (NOT silinmis)
60. 0.004 0.020 ↑ 1.0 1 3 / 3

Hash (cost=1.60..1.60 rows=1 width=8) (actual time=0.020..0.020 rows=1 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
61. 0.016 0.016 ↑ 1.0 1 3 / 3

Seq Scan on depkod dep (cost=0.00..1.60 rows=1 width=8) (actual time=0.011..0.016 rows=1 loops=3)

  • Filter: ((NOT silinmis) AND (departmantipi = 1))
  • Rows Removed by Filter: 47
62. 0.001 1.070 ↓ 0.0 0 1

Subquery Scan on grupkalan (cost=183.87..184.01 rows=1 width=1,060) (actual time=1.070..1.070 rows=0 loops=1)

63. 0.001 1.069 ↓ 0.0 0 1

GroupAggregate (cost=183.87..183.98 rows=1 width=789) (actual time=1.069..1.069 rows=0 loops=1)

  • Group Key: gece_1.id, tbil.id, bilacen.id, r_1.id, fbilkonum.id, odabilkonum.id, pans_1.id, ulke_1.id, pazar_1.id, odeme_1.id, (CASE WHEN (gece_2.gun <> max(r_2.couttarih)) THEN 1 ELSE 0 END), (CASE WHEN (gece_2.gun = max(r_2.cintarih)) THEN 1 ELSE 0 END), (CASE WHEN (gece_2.gun = max(r_2.couttarih)) THEN 1 ELSE 0 END)
64. 0.019 1.068 ↓ 0.0 0 1

Sort (cost=183.87..183.87 rows=1 width=509) (actual time=1.068..1.068 rows=0 loops=1)

  • Sort Key: gece_1.id, tbil.id, bilacen.id, r_1.id, fbilkonum.id, odabilkonum.id, pans_1.id, ulke_1.id, pazar_1.id, odeme_1.id, (CASE WHEN (gece_2.gun <> max(r_2.couttarih)) THEN 1 ELSE 0 END), (CASE WHEN (gece_2.gun = max(r_2.cintarih)) THEN 1 ELSE 0 END), (CASE WHEN (gece_2.gun = max(r_2.couttarih)) THEN 1 ELSE 0 END)
  • Sort Method: quicksort Memory: 25kB
65. 0.001 1.049 ↓ 0.0 0 1

Nested Loop Left Join (cost=40.03..183.86 rows=1 width=509) (actual time=1.049..1.049 rows=0 loops=1)

  • Join Filter: ((tbil.id = tbil_1.id) AND (r_1.id = grupr.id) AND (gece_1.gun = gece_2.gun) AND (fiybilkonum.id = fkonum.id))
66. 0.000 1.048 ↓ 0.0 0 1

Nested Loop (cost=3.09..146.84 rows=1 width=461) (actual time=1.048..1.048 rows=0 loops=1)

67. 0.000 1.048 ↓ 0.0 0 1

Nested Loop (cost=2.96..146.68 rows=1 width=397) (actual time=1.048..1.048 rows=0 loops=1)

  • Join Filter: (fiybil.fiyatkonumid = fiybilkonum.id)
68. 0.001 1.048 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.96..145.54 rows=1 width=397) (actual time=1.047..1.048 rows=0 loops=1)

  • Join Filter: (r_1.sirketid = ulke_1.sirketid)
69. 0.000 1.047 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.82..145.37 rows=1 width=390) (actual time=1.047..1.047 rows=0 loops=1)

  • Join Filter: (bilgece.sirketid = odeme_1.sirketid)
70. 0.001 1.047 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.68..145.21 rows=1 width=330) (actual time=1.047..1.047 rows=0 loops=1)

  • Join Filter: (bilgece.sirketid = pazar_1.sirketid)
71. 0.000 1.046 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.55..145.05 rows=1 width=266) (actual time=1.046..1.046 rows=0 loops=1)

  • Join Filter: ((bilgece.pansiyonid = pans_1.id) AND (bilgece.sirketid = pans_1.sirketid))
72. 0.000 1.046 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.55..143.98 rows=1 width=202) (actual time=1.046..1.046 rows=0 loops=1)

73. 0.001 1.046 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.13..143.16 rows=1 width=198) (actual time=1.046..1.046 rows=0 loops=1)

74. 0.000 1.045 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.84..142.52 rows=1 width=194) (actual time=1.045..1.045 rows=0 loops=1)

75. 0.001 1.045 ↓ 0.0 0 1

Nested Loop (cost=1.70..142.35 rows=1 width=173) (actual time=1.045..1.045 rows=0 loops=1)

  • Join Filter: ((bil.id = gece_1.bilbordid) AND (bil.sirketid = gece_1.sirketid) AND (r_1.id = gece_1.rezid))
76. 0.000 1.044 ↓ 0.0 0 1

Nested Loop (cost=1.27..141.00 rows=1 width=157) (actual time=1.044..1.044 rows=0 loops=1)

77. 0.001 1.044 ↓ 0.0 0 1

Nested Loop (cost=0.99..140.65 rows=1 width=149) (actual time=1.044..1.044 rows=0 loops=1)

78. 0.000 1.043 ↓ 0.0 0 1

Nested Loop (cost=0.57..136.69 rows=1 width=125) (actual time=1.043..1.043 rows=0 loops=1)

  • Join Filter: (fbilkonum.id = bil.forecastkonumid)
79. 0.001 1.043 ↓ 0.0 0 1

Nested Loop (cost=0.29..136.32 rows=1 width=121) (actual time=1.043..1.043 rows=0 loops=1)

  • Join Filter: (r_1.sirketid = fbilkonum.sirketid)
80. 0.000 1.042 ↓ 0.0 0 1

Nested Loop (cost=0.29..135.18 rows=1 width=49) (actual time=1.042..1.042 rows=0 loops=1)

81. 1.042 1.042 ↓ 0.0 0 1

Seq Scan on tumbilbord tbil (cost=0.00..126.86 rows=1 width=25) (actual time=1.042..1.042 rows=0 loops=1)

  • Filter: ((NOT silinmis) AND (bilbordkaynak = 3))
  • Rows Removed by Filter: 5,429
82. 0.000 0.000 ↓ 0.0 0

Index Scan using ""rez_IX_tumbilbordid"" on rez r_1 (cost=0.29..8.31 rows=1 width=24) (never executed)

  • Index Cond: (tumbilbordid = tbil.id)
  • Filter: ((NOT silinmis) AND (tipi = 3) AND (tbil.sirketid = sirketid))
83. 0.000 0.000 ↓ 0.0 0

Seq Scan on fiyatkonum fbilkonum (cost=0.00..1.09 rows=4 width=72) (never executed)

  • Filter: (NOT silinmis)
84. 0.000 0.000 ↓ 0.0 0

Index Scan using ""bilbord_SirketKod"" on bilbord bil (cost=0.28..0.35 rows=1 width=16) (never executed)

  • Index Cond: ((sirketid = r_1.sirketid) AND (tumbilbordid = r_1.tumbilbordid))
  • Filter: (NOT silinmis)
85. 0.000 0.000 ↓ 0.0 0

Index Scan using ""geceleme_GecelemeRezId"" on geceleme bilgece (cost=0.42..3.95 rows=1 width=24) (never executed)

  • Index Cond: (rezid = r_1.id)
  • Filter: ((NOT silinmis) AND (gun = '1900-01-01 00:00:00'::timestamp without time zone))
86. 0.000 0.000 ↓ 0.0 0

Index Scan using ""bilbordfiyatkonum_IX_bilbordid"" on bilbordfiyatkonum fiybil (cost=0.28..0.34 rows=1 width=8) (never executed)

  • Index Cond: (bilbordid = bil.id)
  • Filter: (NOT silinmis)
87. 0.000 0.000 ↓ 0.0 0

Index Scan using ""geceleme_GecelemeRezId"" on geceleme gece_1 (cost=0.42..1.34 rows=1 width=52) (never executed)

  • Index Cond: (rezid = bilgece.rezid)
  • Filter: ((bilbordid IS NOT NULL) AND (NOT silinmis) AND (gun <> '1900-01-01 00:00:00'::timestamp without time zone) AND ((gun)::date = '2019-04-10'::date))
88. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.acenta"" on acenta bilacen (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (bilgece.acentaid = id)
  • Filter: (NOT silinmis)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using ""rezdetayek_IX_id"" on rezdetayek rezek_1 (cost=0.29..0.64 rows=1 width=8) (never executed)

  • Index Cond: (r_1.id = id)
  • Filter: (NOT silinmis)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using ""gecelemedetayek_IX_id"" on gecelemedetayek geceek_1 (cost=0.42..0.82 rows=1 width=12) (never executed)

  • Index Cond: (bilgece.id = id)
  • Filter: (NOT silinmis)
91. 0.000 0.000 ↓ 0.0 0

Seq Scan on pansiyon pans_1 (cost=0.00..1.04 rows=2 width=72) (never executed)

  • Filter: (NOT silinmis)
92. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.pazar"" on pazar pazar_1 (cost=0.13..0.15 rows=1 width=72) (never executed)

  • Index Cond: (geceek_1.pazarid = id)
  • Filter: (NOT silinmis)
93. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.odeme"" on odeme odeme_1 (cost=0.13..0.15 rows=1 width=72) (never executed)

  • Index Cond: (geceek_1.odemeid = id)
  • Filter: (NOT silinmis)
94. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.ulke"" on ulke ulke_1 (cost=0.14..0.16 rows=1 width=19) (never executed)

  • Index Cond: (rezek_1.ulkeid = id)
  • Filter: (NOT silinmis)
95. 0.000 0.000 ↓ 0.0 0

Seq Scan on fiyatkonum fiybilkonum (cost=0.00..1.09 rows=4 width=4) (never executed)

  • Filter: (NOT silinmis)
96. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.odakonum"" on odakonum odabilkonum (cost=0.14..0.15 rows=1 width=68) (never executed)

  • Index Cond: (id = bilgece.odakonumid)
  • Filter: (NOT silinmis)
97. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=36.93..36.99 rows=1 width=72) (never executed)

  • Group Key: tbil_1.id, grupr.id, gece_2.gun, fkonum.id
98. 0.000 0.000 ↓ 0.0 0

Sort (cost=36.93..36.94 rows=1 width=48) (never executed)

  • Sort Key: tbil_1.id, grupr.id, gece_2.gun, fkonum.id
99. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..36.92 rows=1 width=48) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..36.76 rows=1 width=64) (never executed)

  • Join Filter: (gece_2.sirketid = tbil_1.sirketid)
101. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.00..36.38 rows=1 width=60) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.63 rows=1 width=28) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Index Scan using ""rez_IX_gruprezid"" on rez r_2 (cost=0.29..8.31 rows=1 width=20) (never executed)

  • Index Cond: (gruprezid > 0)
  • Filter: ((NOT silinmis) AND (tipi <> 3))
104. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.rez"" on rez grupr (cost=0.29..8.31 rows=1 width=12) (never executed)

  • Index Cond: (id = r_2.gruprezid)
  • Filter: ((NOT silinmis) AND (tipi = 3) AND (r_2.sirketid = sirketid))
105. 0.000 0.000 ↓ 0.0 0

Index Scan using ""geceleme_GecelemeRezId"" on geceleme gece_2 (cost=0.42..19.67 rows=9 width=40) (never executed)

  • Index Cond: (rezid = r_2.id)
  • Filter: ((bilbordid IS NULL) AND (NOT silinmis) AND (gun <> '1900-01-01 00:00:00'::timestamp without time zone) AND (r_2.sirketid = sirketid))
106. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.tumbilbord"" on tumbilbord tbil_1 (cost=0.28..0.36 rows=1 width=8) (never executed)

  • Index Cond: (id = grupr.tumbilbordid)
  • Filter: ((NOT silinmis) AND (grupr.sirketid = sirketid))
107. 0.000 0.000 ↓ 0.0 0

Index Scan using ""fiyatkonum_SirketKod"" on fiyatkonum fkonum (cost=0.14..0.16 rows=1 width=8) (never executed)

  • Index Cond: (sirketid = gece_2.sirketid)
  • Filter: ((NOT silinmis) AND (gece_2.fiyatkonumid = id))
108. 0.001 0.675 ↓ 0.0 0 1

Subquery Scan on bilbordkalan (cost=448.35..448.46 rows=1 width=1,113) (actual time=0.675..0.675 rows=0 loops=1)

109. 0.001 0.674 ↓ 0.0 0 1

GroupAggregate (cost=448.35..448.44 rows=1 width=610) (actual time=0.674..0.674 rows=0 loops=1)

  • Group Key: tbil_2.id, acen_1.id, gece_3.id, fbilkonum_1.id, odakonum.id, (CASE WHEN (gece_4.gun <> max(r_3.couttarih)) THEN 1 ELSE 0 END)
110. 0.009 0.673 ↓ 0.0 0 1

Sort (cost=448.35..448.35 rows=1 width=266) (actual time=0.673..0.673 rows=0 loops=1)

  • Sort Key: tbil_2.id, acen_1.id, gece_3.id, fbilkonum_1.id, odakonum.id, (CASE WHEN (gece_4.gun <> max(r_3.couttarih)) THEN 1 ELSE 0 END)
  • Sort Method: quicksort Memory: 25kB
111. 0.001 0.664 ↓ 0.0 0 1

Nested Loop Left Join (cost=302.28..448.34 rows=1 width=266) (actual time=0.664..0.664 rows=0 loops=1)

  • Join Filter: ((tbil_2.id = tbil_3.id) AND (gece_3.gun = gece_4.gun) AND (fiybilkonum_1.id = fkonum_1.id))
112. 0.000 0.663 ↓ 0.0 0 1

Nested Loop (cost=1.27..147.19 rows=1 width=226) (actual time=0.663..0.663 rows=0 loops=1)

  • Join Filter: (tbil_2.defacentaid = acen_1.id)
113. 0.000 0.663 ↓ 0.0 0 1

Nested Loop (cost=1.12..141.88 rows=1 width=221) (actual time=0.663..0.663 rows=0 loops=1)

114. 0.001 0.663 ↓ 0.0 0 1

Nested Loop (cost=0.99..141.71 rows=1 width=221) (actual time=0.663..0.663 rows=0 loops=1)

  • Join Filter: (gece_3.odakonumid = odakonum.id)
115. 0.000 0.662 ↓ 0.0 0 1

Nested Loop (cost=0.99..140.57 rows=1 width=157) (actual time=0.662..0.662 rows=0 loops=1)

  • Join Filter: ((bil_1.id = gece_3.bilbordid) AND (bil_1.sirketid = gece_3.sirketid))
116. 0.000 0.662 ↓ 0.0 0 1

Nested Loop (cost=0.56..136.67 rows=1 width=117) (actual time=0.662..0.662 rows=0 loops=1)

117. 0.001 0.662 ↓ 0.0 0 1

Nested Loop (cost=0.28..136.32 rows=1 width=109) (actual time=0.662..0.662 rows=0 loops=1)

  • Join Filter: ((fbilkonum_1.sirketid = bil_1.sirketid) AND (fbilkonum_1.id = bil_1.forecastkonumid))
118. 0.000 0.661 ↓ 0.0 0 1

Nested Loop (cost=0.00..128.00 rows=1 width=101) (actual time=0.661..0.661 rows=0 loops=1)

  • Join Filter: (fbilkonum_1.sirketid = tbil_2.sirketid)
119. 0.661 0.661 ↓ 0.0 0 1

Seq Scan on tumbilbord tbil_2 (cost=0.00..126.86 rows=1 width=29) (actual time=0.661..0.661 rows=0 loops=1)

  • Filter: ((NOT silinmis) AND (bilbordkaynak = 1))
  • Rows Removed by Filter: 5,429
120. 0.000 0.000 ↓ 0.0 0

Seq Scan on fiyatkonum fbilkonum_1 (cost=0.00..1.09 rows=4 width=72) (never executed)

  • Filter: (NOT silinmis)
121. 0.000 0.000 ↓ 0.0 0

Index Scan using ""bilbord_SirketKod"" on bilbord bil_1 (cost=0.28..8.30 rows=1 width=16) (never executed)

  • Index Cond: ((sirketid = tbil_2.sirketid) AND (tumbilbordid = tbil_2.id))
  • Filter: (NOT silinmis)
122. 0.000 0.000 ↓ 0.0 0

Index Scan using ""bilbordfiyatkonum_IX_bilbordid"" on bilbordfiyatkonum fiybil_1 (cost=0.28..0.34 rows=1 width=8) (never executed)

  • Index Cond: (bilbordid = bil_1.id)
  • Filter: (NOT silinmis)
123. 0.000 0.000 ↓ 0.0 0

Index Scan using ""geceleme_GecelemeTumBilbordId"" on geceleme gece_3 (cost=0.42..3.89 rows=1 width=52) (never executed)

  • Index Cond: (bilbordid = fiybil_1.bilbordid)
  • Filter: ((NOT silinmis) AND (gun <> '1900-01-01 00:00:00'::timestamp without time zone) AND ((gun)::date = '2019-04-10'::date))
124. 0.000 0.000 ↓ 0.0 0

Seq Scan on odakonum (cost=0.00..1.09 rows=4 width=68) (never executed)

  • Filter: (NOT silinmis)
125. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.fiyatkonum"" on fiyatkonum fiybilkonum_1 (cost=0.14..0.15 rows=1 width=4) (never executed)

  • Index Cond: (id = fiybil_1.fiyatkonumid)
  • Filter: (NOT silinmis)
126. 0.000 0.000 ↓ 0.0 0

Index Scan using ""acenta_SirketKod"" on acenta acen_1 (cost=0.14..3.17 rows=172 width=29) (never executed)

  • Index Cond: (sirketid = gece_3.sirketid)
  • Filter: (NOT silinmis)
127. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=301.01..301.09 rows=2 width=92) (never executed)

  • Group Key: tbil_3.id, gece_4.gun, fkonum_1.id
128. 0.000 0.000 ↓ 0.0 0

Sort (cost=301.01..301.02 rows=2 width=72) (never executed)

  • Sort Key: tbil_3.id, gece_4.gun, fkonum_1.id
129. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=128.74..301.00 rows=2 width=72) (never executed)

  • Join Filter: (acen_2.sirketid = r_3.sirketid)
130. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=128.45..300.35 rows=2 width=88) (never executed)

  • Hash Cond: ((acen_2.sirketid = fkonum_1.sirketid) AND (gece_4.fiyatkonumid = fkonum_1.id))
131. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=127.30..298.93 rows=49 width=52) (never executed)

132. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=126.88..131.50 rows=1 width=16) (never executed)

  • Hash Cond: ((acen_2.sirketid = tbil_3.sirketid) AND (acen_2.tumbilbordid = tbil_3.id))
133. 0.000 0.000 ↓ 0.0 0

Seq Scan on acenta acen_2 (cost=0.00..3.72 rows=172 width=12) (never executed)

  • Filter: (NOT silinmis)
134. 0.000 0.000 ↓ 0.0 0

Hash (cost=126.86..126.86 rows=1 width=8) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Seq Scan on tumbilbord tbil_3 (cost=0.00..126.86 rows=1 width=8) (never executed)

  • Filter: ((NOT silinmis) AND (bilbordkaynak = 1))
136. 0.000 0.000 ↓ 0.0 0

Index Scan using ""geceleme_IX_acentaid"" on geceleme gece_4 (cost=0.42..150.33 rows=1,710 width=44) (never executed)

  • Index Cond: (acentaid = acen_2.id)
  • Filter: ((NOT silinmis) AND (gun <> '1900-01-01 00:00:00'::timestamp without time zone) AND (acen_2.sirketid = sirketid))
137. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.09..1.09 rows=4 width=40) (never executed)

138. 0.000 0.000 ↓ 0.0 0

Seq Scan on fiyatkonum fkonum_1 (cost=0.00..1.09 rows=4 width=40) (never executed)

  • Filter: (NOT silinmis)
139. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.rez"" on rez r_3 (cost=0.29..0.32 rows=1 width=12) (never executed)

  • Index Cond: (id = gece_4.rezid)
  • Filter: ((NOT silinmis) AND (tipi <> 3) AND (gece_4.sirketid = sirketid))