explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7HYK

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 5,804.916 ↑ 3.1 407 1

Append (cost=35,656.06..47,098.00 rows=1,262 width=1,156) (actual time=5,790.955..5,804.916 rows=407 loops=1)

2. 11.351 5,803.222 ↑ 3.1 407 1

Subquery Scan on "*SELECT* 1" (cost=35,656.06..46,467.65 rows=1,260 width=1,033) (actual time=5,790.955..5,803.222 rows=407 loops=1)

3. 0.504 5,791.871 ↑ 3.1 407 1

Hash Left Join (cost=35,656.06..46,420.40 rows=1,260 width=749) (actual time=5,790.951..5,791.871 rows=407 loops=1)

  • Hash Cond: ((gece.id = rezfiy.geceleme_id) AND (gece.rezid = rezfiy.rez_id))
4. 0.000 4.607 ↑ 3.1 407 1

Gather (cost=1,096.10..11,813.17 rows=1,260 width=453) (actual time=4.163..4.607 rows=407 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.090 214.452 ↑ 3.9 136 3 / 3

Hash Left Join (cost=96.10..10,687.17 rows=525 width=453) (actual time=1.795..214.452 rows=136 loops=3)

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

Hash Left Join (cost=95.03..10,681.82 rows=525 width=393) (actual time=1.775..214.352 rows=136 loops=3)

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

Hash Left Join (cost=93.91..10,677.24 rows=525 width=329) (actual time=1.741..214.241 rows=136 loops=3)

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

Hash Left Join (cost=87.17..10,667.71 rows=525 width=308) (actual time=1.621..214.043 rows=136 loops=3)

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

Hash Left Join (cost=86.05..10,663.12 rows=525 width=244) (actual time=1.586..213.928 rows=136 loops=3)

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

Hash Left Join (cost=5.74..10,580.06 rows=525 width=239) (actual time=0.662..212.910 rows=136 loops=3)

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

Hash Left Join (cost=4.65..10,575.15 rows=525 width=175) (actual time=0.636..212.811 rows=136 loops=3)

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

Nested Loop Left Join (cost=3.54..10,570.47 rows=525 width=111) (actual time=0.606..212.691 rows=136 loops=3)

13. 0.216 211.100 ↑ 3.9 136 3 / 3

Hash Left Join (cost=3.12..7,618.41 rows=525 width=103) (actual time=0.561..211.100 rows=136 loops=3)

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

Nested Loop Left Join (cost=0.57..7,613.01 rows=525 width=96) (actual time=0.405..210.845 rows=136 loops=3)

15. 0.185 209.963 ↑ 3.9 136 3 / 3

Nested Loop (cost=0.29..7,421.18 rows=525 width=92) (actual time=0.377..209.963 rows=136 loops=3)

16. 209.119 209.119 ↑ 3.4 165 3 / 3

Parallel Seq Scan on geceleme gece (cost=0.00..6,499.75 rows=558 width=72) (actual time=0.347..209.119 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,745
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.814 0.814 ↑ 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.006..0.006 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.004 0.018 ↓ 8.0 8 3 / 3

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

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

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

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

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

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

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

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

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

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

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

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

Hash (cost=1.11..1.11 rows=1 width=72) (actual time=0.020..0.020 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.052 0.107 ↑ 1.0 172 3 / 3

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

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

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

  • Filter: ((NOT silinmis) AND (sirketid = 1))
32. 0.006 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
33. 0.012 0.012 ↓ 9.0 9 3 / 3

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

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

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

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

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

  • Filter: ((NOT silinmis) AND (sirketid = 1))
36. 5.919 5,786.760 ↓ 15,793.0 15,793 1

Hash (cost=34,559.95..34,559.95 rows=1 width=188) (actual time=5,786.760..5,786.760 rows=15,793 loops=1)

  • Buckets: 16,384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1,855kB
37. 1.709 5,780.841 ↓ 15,793.0 15,793 1

Subquery Scan on rezfiy (cost=34,559.82..34,559.95 rows=1 width=188) (actual time=5,603.431..5,780.841 rows=15,793 loops=1)

38. 174.722 5,779.132 ↓ 15,793.0 15,793 1

Finalize GroupAggregate (cost=34,559.82..34,559.94 rows=1 width=196) (actual time=5,603.430..5,779.132 rows=15,793 loops=1)

  • Group Key: g.id, r.id, krate.dovizid, dov.adi
39. 27.832 5,604.410 ↓ 7,896.5 15,793 1

Sort (cost=34,559.82..34,559.83 rows=2 width=68) (actual time=5,603.407..5,604.410 rows=15,793 loops=1)

  • Sort Key: g.id, r.id, krate.dovizid, dov.adi
  • Sort Method: quicksort Memory: 2,605kB
40. 132.008 5,576.578 ↓ 7,896.5 15,793 1

Gather (cost=34,559.54..34,559.81 rows=2 width=68) (actual time=5,472.490..5,576.578 rows=15,793 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
41. 2.702 5,444.570 ↓ 5,264.0 5,264 3 / 3

Partial GroupAggregate (cost=33,559.54..33,559.61 rows=1 width=68) (actual time=5,441.584..5,444.570 rows=5,264 loops=3)

  • Group Key: g.id, r.id, krate.dovizid, dov.adi
42. 13.916 5,441.868 ↓ 5,265.0 5,265 3 / 3

Sort (cost=33,559.54..33,559.55 rows=1 width=88) (actual time=5,441.573..5,441.868 rows=5,265 loops=3)

  • Sort Key: g.id, r.id, krate.dovizid, dov.adi
  • Sort Method: quicksort Memory: 896kB
43. 62.431 5,427.952 ↓ 5,265.0 5,265 3 / 3

Nested Loop (cost=33,558.47..33,559.53 rows=1 width=88) (actual time=4,980.033..5,427.952 rows=5,265 loops=3)

  • Join Filter: (g.sirketid = kur.sirketid)
44. 62.782 5,091.285 ↓ 68,559.0 68,559 3 / 3

Merge Join (cost=33,558.19..33,559.15 rows=1 width=112) (actual time=4,979.958..5,091.285 rows=68,559 loops=3)

  • Merge Cond: ((g.sirketid = dep.sirketid) AND (hrk.depkodid = dep.id))
45. 450.652 5,028.453 ↓ 548.5 68,560 3 / 3

Sort (cost=33,556.58..33,556.89 rows=125 width=112) (actual time=4,979.903..5,028.453 rows=68,560 loops=3)

  • Sort Key: g.sirketid, hrk.depkodid
  • Sort Method: external sort Disk: 8,000kB
46. 78.872 4,577.801 ↓ 548.5 68,561 3 / 3

Nested Loop (cost=14,519.16..33,552.23 rows=125 width=112) (actual time=811.913..4,577.801 rows=68,561 loops=3)

47. 360.563 4,156.122 ↓ 548.5 68,561 3 / 3

Nested Loop (cost=14,518.87..33,513.39 rows=125 width=112) (actual time=811.895..4,156.122 rows=68,561 loops=3)

  • Join Filter: ((g.sirketid = hrk.sirketid) AND (g.gun = hrk.tarih))
  • Rows Removed by Join Filter: 617,374
48. 192.786 1,601.692 ↓ 10.8 68,558 3 / 3

Hash Join (cost=14,518.45..24,378.05 rows=6,358 width=88) (actual time=811.810..1,601.692 rows=68,558 loops=3)

  • Hash Cond: ((g.rezid = r.id) AND (g.sirketid = r.sirketid))
49. 86.821 1,209.714 ↓ 6.4 68,558 3 / 3

Hash Join (cost=12,542.70..22,261.56 rows=10,717 width=64) (actual time=612.456..1,209.714 rows=68,558 loops=3)

  • Hash Cond: ((g.sirketid = dov.sirketid) AND (krate.dovizid = dov.id))
50. 345.418 1,122.870 ↑ 1.3 68,558 3 / 3

Hash Join (cost=12,541.50..21,793.83 rows=85,737 width=24) (actual time=612.416..1,122.870 rows=68,558 loops=3)

  • Hash Cond: (hes.gecelemeid = g.id)
51. 67.619 165.973 ↑ 1.3 68,571 3 / 3

Hash Join (cost=38.57..6,638.84 rows=85,737 width=8) (actual time=0.464..165.973 rows=68,571 loops=3)

  • Hash Cond: (hes.rateid = krate.id)
52. 97.921 97.921 ↑ 1.3 69,193 3 / 3

Parallel Seq Scan on hesayr hes (cost=0.00..6,371.49 rows=87,001 width=8) (actual time=0.018..97.921 rows=69,193 loops=3)

  • Filter: ((rateid IS NOT NULL) AND (NOT silinmis))
  • Rows Removed by Filter: 83,006
53. 0.158 0.433 ↑ 1.0 1,085 3 / 3

Hash (cost=25.01..25.01 rows=1,085 width=8) (actual time=0.433..0.433 rows=1,085 loops=3)

  • Buckets: 2,048 Batches: 1 Memory Usage: 59kB
54. 0.275 0.275 ↑ 1.0 1,085 3 / 3

Seq Scan on rate krate (cost=0.00..25.01 rows=1,085 width=8) (actual time=0.011..0.275 rows=1,085 loops=3)

  • Filter: (NOT silinmis)
  • Rows Removed by Filter: 16
55. 284.751 611.479 ↑ 1.0 299,730 3 / 3

Hash (cost=6,999.30..6,999.30 rows=299,730 width=20) (actual time=611.479..611.479 rows=299,730 loops=3)

  • Buckets: 65,536 Batches: 8 Memory Usage: 2,551kB
56. 326.728 326.728 ↑ 1.0 299,730 3 / 3

Seq Scan on geceleme g (cost=0.00..6,999.30 rows=299,730 width=20) (actual time=0.013..326.728 rows=299,730 loops=3)

57. 0.006 0.023 ↑ 1.0 8 3 / 3

Hash (cost=1.08..1.08 rows=8 width=40) (actual time=0.023..0.023 rows=8 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
58. 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.015..0.017 rows=8 loops=3)

59. 26.080 199.192 ↓ 1.3 22,965 3 / 3

Hash (cost=1,709.63..1,709.63 rows=17,742 width=24) (actual time=199.192..199.192 rows=22,965 loops=3)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,512kB
60. 48.857 173.112 ↓ 1.3 22,965 3 / 3

Hash Join (cost=1,085.38..1,709.63 rows=17,742 width=24) (actual time=55.767..173.112 rows=22,965 loops=3)

  • Hash Cond: ((fol.rezid = r.id) AND (fol.sirketid = r.sirketid))
61. 68.653 68.653 ↑ 1.0 22,965 3 / 3

Seq Scan on folio fol (cost=0.00..503.66 rows=22,965 width=12) (actual time=0.018..68.653 rows=22,965 loops=3)

  • Filter: ((NOT silinmis) AND (tipi = 1))
  • Rows Removed by Filter: 48
62. 44.610 55.602 ↑ 1.0 22,965 3 / 3

Hash (cost=738.83..738.83 rows=23,104 width=12) (actual time=55.602..55.602 rows=22,965 loops=3)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,243kB
63. 10.992 10.992 ↑ 1.0 22,965 3 / 3

Seq Scan on rez r (cost=0.00..738.83 rows=23,104 width=12) (actual time=0.015..10.992 rows=22,965 loops=3)

  • Filter: ((NOT silinmis) AND (tipi <> 3))
  • Rows Removed by Filter: 6,941
64. 2,193.867 2,193.867 ↓ 1.1 10 205,675 / 3

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk (cost=0.42..1.30 rows=9 width=36) (actual time=0.009..0.032 rows=10 loops=205,675)

  • Index Cond: (folioid = fol.id)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (islemtipi <> 11) AND (islemtipi <> 12) AND (fol.sirketid = sirketid))
65. 342.807 342.807 ↑ 1.0 1 205,684 / 3

Index Scan using ""rezdetayek_IX_id"" on rezdetayek rek (cost=0.29..0.31 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=205,684)

  • Index Cond: (id = g.rezid)
  • Filter: (NOT silinmis)
66. 0.012 0.050 ↑ 1.0 1 3 / 3

Sort (cost=1.61..1.61 rows=1 width=8) (actual time=0.049..0.050 rows=1 loops=3)

  • Sort Key: dep.sirketid, dep.id
  • Sort Method: quicksort Memory: 25kB
67. 0.038 0.038 ↑ 1.0 1 3 / 3

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

  • Filter: ((NOT silinmis) AND (departmantipi = 1))
  • Rows Removed by Filter: 47
68. 274.236 274.236 ↓ 0.0 0 205,677 / 3

Index Scan using ""kur_SirketKod"" on kur (cost=0.28..0.37 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=205,677)

  • Index Cond: ((sirketid = r.sirketid) AND (tarih = r.cintarih) AND (dovizid = krate.dovizid))
  • Filter: (NOT silinmis)
69. 0.001 1.002 ↓ 0.0 0 1

Subquery Scan on grupkalan (cost=183.98..184.12 rows=1 width=1,060) (actual time=1.002..1.002 rows=0 loops=1)

70. 0.001 1.001 ↓ 0.0 0 1

GroupAggregate (cost=183.98..184.09 rows=1 width=789) (actual time=1.001..1.001 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)
71. 0.016 1.000 ↓ 0.0 0 1

Sort (cost=183.98..183.99 rows=1 width=509) (actual time=1.000..1.000 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
72. 0.000 0.984 ↓ 0.0 0 1

Nested Loop Left Join (cost=40.14..183.97 rows=1 width=509) (actual time=0.984..0.984 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))
73. 0.001 0.984 ↓ 0.0 0 1

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

74. 0.000 0.983 ↓ 0.0 0 1

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

  • Join Filter: (fiybil.fiyatkonumid = fiybilkonum.id)
75. 0.000 0.983 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.96..145.55 rows=1 width=397) (actual time=0.983..0.983 rows=0 loops=1)

  • Join Filter: (r_1.sirketid = ulke_1.sirketid)
76. 0.001 0.983 ↓ 0.0 0 1

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

  • Join Filter: (bilgece.sirketid = odeme_1.sirketid)
77. 0.000 0.982 ↓ 0.0 0 1

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

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

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

  • Join Filter: ((bilgece.pansiyonid = pans_1.id) AND (bilgece.sirketid = pans_1.sirketid))
79. 0.001 0.982 ↓ 0.0 0 1

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

80. 0.000 0.981 ↓ 0.0 0 1

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

81. 0.000 0.981 ↓ 0.0 0 1

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

82. 0.001 0.981 ↓ 0.0 0 1

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

  • Join Filter: ((bil.id = gece_1.bilbordid) AND (bil.sirketid = gece_1.sirketid) AND (r_1.id = gece_1.rezid))
83. 0.001 0.980 ↓ 0.0 0 1

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

84. 0.000 0.979 ↓ 0.0 0 1

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

85. 0.000 0.979 ↓ 0.0 0 1

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

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

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

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

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

88. 0.978 0.978 ↓ 0.0 0 1

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

  • Filter: ((NOT silinmis) AND (bilbordkaynak = 3))
  • Rows Removed by Filter: 5,429
89. 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))
90. 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)
91. 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)
92. 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))
93. 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)
94. 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))
95. 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)
96. 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)
97. 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)
98. 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)
99. 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)
100. 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)
101. 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)
102. 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)
103. 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)
104. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=37.04..37.10 rows=1 width=72) (never executed)

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

Sort (cost=37.04..37.05 rows=1 width=48) (never executed)

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

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

107. 0.000 0.000 ↓ 0.0 0

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

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

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

109. 0.000 0.000 ↓ 0.0 0

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

110. 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))
111. 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))
112. 0.000 0.000 ↓ 0.0 0

Index Scan using ""geceleme_GecelemeRezId"" on geceleme gece_2 (cost=0.42..19.78 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))
113. 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))
114. 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))
115. 0.001 0.662 ↓ 0.0 0 1

Subquery Scan on bilbordkalan (cost=446.10..446.21 rows=1 width=1,113) (actual time=0.662..0.662 rows=0 loops=1)

116. 0.000 0.661 ↓ 0.0 0 1

GroupAggregate (cost=446.10..446.19 rows=1 width=610) (actual time=0.661..0.661 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)
117. 0.005 0.661 ↓ 0.0 0 1

Sort (cost=446.10..446.10 rows=1 width=266) (actual time=0.661..0.661 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
118. 0.000 0.656 ↓ 0.0 0 1

Nested Loop Left Join (cost=300.03..446.09 rows=1 width=266) (actual time=0.656..0.656 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))
119. 0.001 0.656 ↓ 0.0 0 1

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

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

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

121. 0.001 0.655 ↓ 0.0 0 1

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

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

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

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

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

124. 0.001 0.654 ↓ 0.0 0 1

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

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

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

  • Join Filter: (fbilkonum_1.sirketid = tbil_2.sirketid)
126. 0.653 0.653 ↓ 0.0 0 1

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

  • Filter: ((NOT silinmis) AND (bilbordkaynak = 1))
  • Rows Removed by Filter: 5,429
127. 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)
128. 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)
129. 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)
130. 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))
131. 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)
132. 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)
133. 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)
134. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=298.76..298.84 rows=2 width=92) (never executed)

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

Sort (cost=298.76..298.77 rows=2 width=72) (never executed)

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

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

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

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

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

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

139. 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))
140. 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)
141. 0.000 0.000 ↓ 0.0 0

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

142. 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))
143. 0.000 0.000 ↓ 0.0 0

Index Scan using ""geceleme_IX_acentaid"" on geceleme gece_4 (cost=0.42..148.74 rows=1,644 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))
144. 0.000 0.000 ↓ 0.0 0

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

145. 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)
146. 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))