explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 92Gq

Settings
# exclusive inclusive rows x rows loops node
1. 23.044 9,615.238 ↑ 1.1 237,386 1

Append (cost=40,766.99..89,800.16 rows=252,197 width=1,152) (actual time=7,521.227..9,615.238 rows=237,386 loops=1)

2. 196.402 9,590.598 ↑ 1.1 237,386 1

Subquery Scan on *SELECT* 1 (cost=40,766.99..89,057.49 rows=252,195 width=1,029) (actual time=7,521.226..9,590.598 rows=237,386 loops=1)

3. 639.905 9,394.196 ↑ 1.1 237,386 1

Hash Left Join (cost=40,766.99..80,230.67 rows=252,195 width=749) (actual time=7,521.221..9,394.196 rows=237,386 loops=1)

  • Hash Cond: ((gece.id = rezfiy.geceleme_id) AND (gece.rezid = rezfiy.rez_id))
4. 96.506 1,411.191 ↑ 1.1 237,386 1

Hash Left Join (cost=13,271.71..45,800.02 rows=252,195 width=453) (actual time=177.544..1,411.191 rows=237,386 loops=1)

  • Hash Cond: ((gece.sirketid = pans.sirketid) AND (gece.pansiyonid = pans.id))
5. 89.970 1,314.671 ↑ 1.1 237,386 1

Hash Left Join (cost=13,259.04..44,459.19 rows=252,195 width=393) (actual time=177.518..1,314.671 rows=237,386 loops=1)

  • Hash Cond: ((gece.sirketid = fiykonum.sirketid) AND (gece.fiyatkonumid = fiykonum.id))
6. 100.891 1,224.686 ↑ 1.1 237,386 1

Hash Left Join (cost=13,247.73..43,119.46 rows=252,195 width=329) (actual time=177.490..1,224.686 rows=237,386 loops=1)

  • Hash Cond: ((gece.sirketid = acen.sirketid) AND (gece.acentaid = acen.id))
7. 87.400 1,123.686 ↑ 1.1 237,386 1

Hash Left Join (cost=13,236.00..41,766.51 rows=252,195 width=308) (actual time=177.362..1,123.686 rows=237,386 loops=1)

  • Hash Cond: ((gece.sirketid = konum.sirketid) AND (gece.odakonumid = konum.id))
8. 69.796 1,036.262 ↑ 1.1 237,386 1

Hash Left Join (cost=13,224.69..40,426.03 rows=252,195 width=244) (actual time=177.316..1,036.262 rows=237,386 loops=1)

  • Hash Cond: ((gece.sirketid = oda.sirketid) AND (gece.odaid = oda.id))
9. 87.658 965.341 ↑ 1.1 237,386 1

Hash Left Join (cost=13,121.38..38,998.66 rows=252,195 width=239) (actual time=176.172..965.341 rows=237,386 loops=1)

  • Hash Cond: ((gece.sirketid = odeme.sirketid) AND (geceek.odemeid = odeme.id))
10. 80.404 877.661 ↑ 1.1 237,386 1

Hash Left Join (cost=13,110.07..37,658.58 rows=252,195 width=175) (actual time=176.137..877.661 rows=237,386 loops=1)

  • Hash Cond: ((gece.sirketid = pazar.sirketid) AND (geceek.pazarid = pazar.id))
11. 82.854 797.230 ↑ 1.1 237,386 1

Hash Left Join (cost=13,098.76..36,318.56 rows=252,195 width=111) (actual time=176.094..797.230 rows=237,386 loops=1)

  • Hash Cond: ((rez.sirketid = ulke.sirketid) AND (rezek.ulkeid = ulke.id))
12. 86.433 714.338 ↑ 1.1 237,386 1

Hash Left Join (cost=13,096.22..34,946.71 rows=252,195 width=104) (actual time=176.036..714.338 rows=237,386 loops=1)

  • Hash Cond: (rez.id = rezek.id)
13. 94.709 594.759 ↑ 1.1 237,386 1

Hash Join (cost=11,620.49..32,808.88 rows=252,195 width=100) (actual time=142.664..594.759 rows=237,386 loops=1)

  • Hash Cond: (gece.rezid = rez.id)
14. 247.832 483.732 ↓ 1.0 269,397 1

Hash Left Join (cost=9,849.27..30,334.09 rows=267,987 width=80) (actual time=126.273..483.732 rows=269,397 loops=1)

  • Hash Cond: (gece.id = geceek.id)
15. 110.185 110.185 ↓ 1.0 269,397 1

Seq Scan on geceleme gece (cost=0.00..12,114.35 rows=267,987 width=72) (actual time=0.016..110.185 rows=269,397 loops=1)

  • Filter: ((NOT silinmis) AND (gun <> '1900-01-01 00:00:00'::timestamp without time zone) AND (sirketid = 1))
  • Rows Removed by Filter: 30,230
16. 63.005 125.715 ↓ 1.0 283,560 1

Hash (cost=4,920.23..4,920.23 rows=283,523 width=12) (actual time=125.715..125.715 rows=283,560 loops=1)

  • Buckets: 131,072 Batches: 8 Memory Usage: 2,546kB
17. 62.710 62.710 ↓ 1.0 283,560 1

Seq Scan on gecelemedetayek geceek (cost=0.00..4,920.23 rows=283,523 width=12) (actual time=0.012..62.710 rows=283,560 loops=1)

  • Filter: (NOT silinmis)
18. 5.769 16.318 ↓ 1.0 28,139 1

Hash (cost=1,419.50..1,419.50 rows=28,138 width=20) (actual time=16.318..16.318 rows=28,139 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,685kB
19. 10.549 10.549 ↓ 1.0 28,139 1

Seq Scan on rez (cost=0.00..1,419.50 rows=28,138 width=20) (actual time=0.013..10.549 rows=28,139 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1) AND (turu = 1))
  • Rows Removed by Filter: 1,762
20. 17.482 33.146 ↓ 1.0 29,900 1

Hash (cost=1,101.99..1,101.99 rows=29,899 width=8) (actual time=33.146..33.146 rows=29,900 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,404kB
21. 15.664 15.664 ↓ 1.0 29,900 1

Seq Scan on rezdetayek rezek (cost=0.00..1,101.99 rows=29,899 width=8) (actual time=0.013..15.664 rows=29,900 loops=1)

  • Filter: (NOT silinmis)
22. 0.017 0.038 ↑ 1.0 56 1

Hash (cost=1.70..1.70 rows=56 width=19) (actual time=0.038..0.038 rows=56 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
23. 0.021 0.021 ↑ 1.0 56 1

Seq Scan on ulke (cost=0.00..1.70 rows=56 width=19) (actual time=0.010..0.021 rows=56 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
24. 0.005 0.027 ↓ 4.0 8 1

Hash (cost=11.28..11.28 rows=2 width=72) (actual time=0.027..0.027 rows=8 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
25. 0.008 0.022 ↓ 4.0 8 1

Bitmap Heap Scan on pazar (cost=4.17..11.28 rows=2 width=72) (actual time=0.020..0.022 rows=8 loops=1)

  • Recheck Cond: (sirketid = 1)
  • Filter: (NOT silinmis)
  • Heap Blocks: exact=1
26. 0.014 0.014 ↓ 2.7 8 1

Bitmap Index Scan on "pazar_SirketKod" (cost=0.00..4.17 rows=3 width=0) (actual time=0.014..0.014 rows=8 loops=1)

  • Index Cond: (sirketid = 1)
27. 0.006 0.022 ↓ 3.0 6 1

Hash (cost=11.28..11.28 rows=2 width=72) (actual time=0.022..0.022 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
28. 0.010 0.016 ↓ 3.0 6 1

Bitmap Heap Scan on odeme (cost=4.17..11.28 rows=2 width=72) (actual time=0.014..0.016 rows=6 loops=1)

  • Recheck Cond: (sirketid = 1)
  • Filter: (NOT silinmis)
  • Heap Blocks: exact=1
29. 0.006 0.006 ↓ 2.0 6 1

Bitmap Index Scan on "odeme_SirketKod" (cost=0.00..4.17 rows=3 width=0) (actual time=0.006..0.006 rows=6 loops=1)

  • Index Cond: (sirketid = 1)
30. 0.420 1.125 ↑ 1.0 1,902 1

Hash (cost=74.78..74.78 rows=1,902 width=13) (actual time=1.125..1.125 rows=1,902 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 106kB
31. 0.705 0.705 ↑ 1.0 1,902 1

Seq Scan on oda (cost=0.00..74.78 rows=1,902 width=13) (actual time=0.013..0.705 rows=1,902 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
32. 0.007 0.024 ↓ 4.5 9 1

Hash (cost=11.28..11.28 rows=2 width=72) (actual time=0.024..0.024 rows=9 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
33. 0.008 0.017 ↓ 4.5 9 1

Bitmap Heap Scan on odakonum konum (cost=4.17..11.28 rows=2 width=72) (actual time=0.015..0.017 rows=9 loops=1)

  • Recheck Cond: (sirketid = 1)
  • Filter: (NOT silinmis)
  • Heap Blocks: exact=1
34. 0.009 0.009 ↓ 3.0 9 1

Bitmap Index Scan on "odakonum_SirketKod" (cost=0.00..4.17 rows=3 width=0) (actual time=0.009..0.009 rows=9 loops=1)

  • Index Cond: (sirketid = 1)
35. 0.044 0.109 ↑ 1.0 172 1

Hash (cost=9.15..9.15 rows=172 width=29) (actual time=0.109..0.109 rows=172 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
36. 0.065 0.065 ↑ 1.0 172 1

Seq Scan on acenta acen (cost=0.00..9.15 rows=172 width=29) (actual time=0.006..0.065 rows=172 loops=1)

  • Filter: ((NOT silinmis) AND (sirketid = 1))
37. 0.005 0.015 ↓ 4.5 9 1

Hash (cost=11.28..11.28 rows=2 width=72) (actual time=0.015..0.015 rows=9 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
38. 0.006 0.010 ↓ 4.5 9 1

Bitmap Heap Scan on fiyatkonum fiykonum (cost=4.17..11.28 rows=2 width=72) (actual time=0.008..0.010 rows=9 loops=1)

  • Recheck Cond: (sirketid = 1)
  • Filter: (NOT silinmis)
  • Heap Blocks: exact=1
39. 0.004 0.004 ↓ 3.0 9 1

Bitmap Index Scan on "fiyatkonum_SirketKod" (cost=0.00..4.17 rows=3 width=0) (actual time=0.004..0.004 rows=9 loops=1)

  • Index Cond: (sirketid = 1)
40. 0.005 0.014 ↓ 2.0 4 1

Hash (cost=12.64..12.64 rows=2 width=72) (actual time=0.014..0.014 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
41. 0.005 0.009 ↓ 2.0 4 1

Bitmap Heap Scan on pansiyon pans (cost=4.18..12.64 rows=2 width=72) (actual time=0.008..0.009 rows=4 loops=1)

  • Recheck Cond: (sirketid = 1)
  • Filter: (NOT silinmis)
  • Heap Blocks: exact=1
42. 0.004 0.004 ↑ 1.0 4 1

Bitmap Index Scan on "pansiyon_SirketKod" (cost=0.00..4.18 rows=4 width=0) (actual time=0.004..0.004 rows=4 loops=1)

  • Index Cond: (sirketid = 1)
43. 86.833 7,343.100 ↓ 205,674.0 205,674 1

Hash (cost=27,495.27..27,495.27 rows=1 width=188) (actual time=7,343.100..7,343.100 rows=205,674 loops=1)

  • Buckets: 65,536 (originally 1024) Batches: 8 (originally 1) Memory Usage: 3,585kB
44. 23.141 7,256.267 ↓ 205,674.0 205,674 1

Subquery Scan on rezfiy (cost=27,495.14..27,495.27 rows=1 width=188) (actual time=6,057.638..7,256.267 rows=205,674 loops=1)

45. 1,145.675 7,233.126 ↓ 205,674.0 205,674 1

Finalize GroupAggregate (cost=27,495.14..27,495.26 rows=1 width=196) (actual time=6,057.637..7,233.126 rows=205,674 loops=1)

  • Group Key: g.id, r.id, krate.dovizid, dov.adi
46. 143.955 6,087.451 ↓ 102,837.0 205,674 1

Sort (cost=27,495.14..27,495.14 rows=2 width=68) (actual time=6,057.609..6,087.451 rows=205,674 loops=1)

  • Sort Key: g.id, r.id, krate.dovizid, dov.adi
  • Sort Method: external merge Disk: 13,320kB
47. 314.505 5,943.496 ↓ 102,837.0 205,674 1

Gather (cost=27,494.86..27,495.13 rows=2 width=68) (actual time=5,699.199..5,943.496 rows=205,674 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
48. 39.573 5,628.991 ↓ 68,558.0 68,558 3 / 3

Partial GroupAggregate (cost=26,494.86..26,494.93 rows=1 width=68) (actual time=5,578.136..5,628.991 rows=68,558 loops=3)

  • Group Key: g.id, r.id, krate.dovizid, dov.adi
49. 152.830 5,589.418 ↓ 68,559.0 68,559 3 / 3

Sort (cost=26,494.86..26,494.86 rows=1 width=88) (actual time=5,578.120..5,589.418 rows=68,559 loops=3)

  • Sort Key: g.id, r.id, krate.dovizid, dov.adi
  • Sort Method: external merge Disk: 5,704kB
50. 71.214 5,436.588 ↓ 68,559.0 68,559 3 / 3

Nested Loop Left Join (cost=26,494.70..26,494.85 rows=1 width=88) (actual time=5,057.025..5,436.588 rows=68,559 loops=3)

51. 58.844 5,159.698 ↓ 68,559.0 68,559 3 / 3

Merge Join (cost=26,494.42..26,494.49 rows=1 width=88) (actual time=5,056.974..5,159.698 rows=68,559 loops=3)

  • Merge Cond: ((g.sirketid = dep.sirketid) AND (hrk.depkodid = dep.id))
52. 351.822 5,100.809 ↓ 13,712.0 68,560 3 / 3

Sort (cost=26,492.81..26,492.83 rows=5 width=108) (actual time=5,056.923..5,100.809 rows=68,560 loops=3)

  • Sort Key: g.sirketid, hrk.depkodid
  • Sort Method: external sort Disk: 7,904kB
53. 140.820 4,748.987 ↓ 13,712.2 68,561 3 / 3

Nested Loop (cost=16,185.16..26,492.75 rows=5 width=108) (actual time=542.805..4,748.987 rows=68,561 loops=3)

54. 316.128 4,333.923 ↓ 13,712.2 68,561 3 / 3

Nested Loop (cost=16,184.87..26,491.16 rows=5 width=108) (actual time=542.780..4,333.923 rows=68,561 loops=3)

  • Join Filter: ((g.sirketid = hrk.sirketid) AND (g.gun = hrk.tarih))
  • Rows Removed by Join Filter: 617,363
55. 107.911 1,961.055 ↓ 266.8 68,558 3 / 3

Nested Loop (cost=16,184.45..26,114.52 rows=257 width=84) (actual time=542.737..1,961.055 rows=68,558 loops=3)

56. 110.060 1,441.796 ↓ 205.9 68,558 3 / 3

Nested Loop (cost=16,184.17..26,006.47 rows=333 width=72) (actual time=542.713..1,441.796 rows=68,558 loops=3)

57. 94.395 920.388 ↓ 159.1 68,558 3 / 3

Hash Join (cost=16,183.88..25,861.33 rows=431 width=60) (actual time=542.679..920.388 rows=68,558 loops=3)

  • Hash Cond: ((g.sirketid = dov.sirketid) AND (hes.rateid = krate.id))
58. 200.098 817.769 ↑ 1.2 69,180 3 / 3

Hash Join (cost=16,117.52..25,146.61 rows=86,187 width=24) (actual time=534.406..817.769 rows=69,180 loops=3)

  • Hash Cond: (hes.gecelemeid = g.id)
59. 83.772 83.772 ↑ 1.2 69,193 3 / 3

Parallel Seq Scan on hesayr hes (cost=0.00..6,372.85 rows=86,187 width=8) (actual time=0.025..83.772 rows=69,193 loops=3)

  • Filter: ((rateid IS NOT NULL) AND (NOT silinmis))
  • Rows Removed by Filter: 83,006
60. 282.688 533.899 ↓ 1.0 299,627 3 / 3

Hash (cost=10,616.23..10,616.23 rows=299,623 width=20) (actual time=533.899..533.899 rows=299,627 loops=3)

  • Buckets: 65,536 Batches: 8 Memory Usage: 2,550kB
61. 251.211 251.211 ↓ 1.0 299,627 3 / 3

Seq Scan on geceleme g (cost=0.00..10,616.23 rows=299,623 width=20) (actual time=0.015..251.211 rows=299,627 loops=3)

62. 0.278 8.224 ↑ 1.0 1,085 3 / 3

Hash (cost=49.85..49.85 rows=1,101 width=44) (actual time=8.224..8.224 rows=1,085 loops=3)

  • Buckets: 2,048 Batches: 1 Memory Usage: 84kB
63. 0.299 7.946 ↑ 1.0 1,085 3 / 3

Hash Join (cost=21.93..49.85 rows=1,101 width=44) (actual time=0.065..7.946 rows=1,085 loops=3)

  • Hash Cond: (krate.dovizid = dov.id)
64. 7.625 7.625 ↑ 1.0 1,085 3 / 3

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

  • Filter: (NOT silinmis)
  • Rows Removed by Filter: 16
65. 0.007 0.022 ↑ 66.2 8 3 / 3

Hash (cost=15.30..15.30 rows=530 width=40) (actual time=0.022..0.022 rows=8 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
66. 0.015 0.015 ↑ 66.2 8 3 / 3

Seq Scan on doviz dov (cost=0.00..15.30 rows=530 width=40) (actual time=0.013..0.015 rows=8 loops=3)

67. 411.348 411.348 ↑ 1.0 1 205,674 / 3

Index Scan using "PK_public.rez" on rez r (cost=0.29..0.33 rows=1 width=12) (actual time=0.006..0.006 rows=1 loops=205,674)

  • Index Cond: (id = g.rezid)
  • Filter: ((NOT silinmis) AND (tipi <> 3) AND (g.sirketid = sirketid))
68. 411.348 411.348 ↑ 1.0 1 205,674 / 3

Index Scan using "folio_IX_rezid" on folio fol (cost=0.29..0.31 rows=1 width=12) (actual time=0.005..0.006 rows=1 loops=205,674)

  • Index Cond: (rezid = g.rezid)
  • Filter: ((NOT silinmis) AND (tipi = 1) AND (g.sirketid = sirketid))
  • Rows Removed by Filter: 0
69. 2,056.740 2,056.740 ↓ 1.1 10 205,674 / 3

Index Scan using "hrk_FolioIdIdxmauel" on hrk (cost=0.42..1.33 rows=9 width=36) (actual time=0.007..0.030 rows=10 loops=205,674)

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

Index Scan using "rezdetayek_IX_id" on rezdetayek rek (cost=0.29..0.32 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=205,683)

  • Index Cond: (id = g.rezid)
  • Filter: (NOT silinmis)
71. 0.012 0.045 ↑ 2.0 1 3 / 3

Sort (cost=1.61..1.61 rows=2 width=8) (actual time=0.044..0.045 rows=1 loops=3)

  • Sort Key: dep.sirketid, dep.id
  • Sort Method: quicksort Memory: 25kB
72. 0.033 0.033 ↑ 2.0 1 3 / 3

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

  • Filter: ((NOT silinmis) AND (departmantipi = 1))
  • Rows Removed by Filter: 47
73. 205.676 205.676 ↓ 0.0 0 205,676 / 3

Index Scan using "kur_SirketKod" on kur (cost=0.28..0.36 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=205,676)

  • Index Cond: ((hrk.sirketid = sirketid) AND (r.cintarih = tarih) AND (krate.dovizid = dovizid))
  • Filter: (NOT silinmis)
74. 0.000 0.929 ↓ 0.0 0 1

Subquery Scan on grupkalan (cost=183.39..183.53 rows=1 width=1,056) (actual time=0.929..0.929 rows=0 loops=1)

75. 0.002 0.929 ↓ 0.0 0 1

GroupAggregate (cost=183.39..183.50 rows=1 width=781) (actual time=0.929..0.929 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)
76. 0.015 0.927 ↓ 0.0 0 1

Sort (cost=183.39..183.40 rows=1 width=501) (actual time=0.927..0.927 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)
  • Sort Method: quicksort Memory: 25kB
77. 0.000 0.912 ↓ 0.0 0 1

Nested Loop Left Join (cost=40.21..183.38 rows=1 width=501) (actual time=0.912..0.912 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))
78. 0.001 0.912 ↓ 0.0 0 1

Nested Loop (cost=3.72..146.82 rows=1 width=461) (actual time=0.912..0.912 rows=0 loops=1)

79. 0.000 0.911 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.57..146.65 rows=1 width=397) (actual time=0.911..0.911 rows=0 loops=1)

80. 0.001 0.911 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.42..146.47 rows=1 width=337) (actual time=0.911..0.911 rows=0 loops=1)

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

Nested Loop Left Join (cost=3.27..146.29 rows=1 width=273) (actual time=0.910..0.910 rows=0 loops=1)

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

Nested Loop Left Join (cost=3.12..146.11 rows=1 width=209) (actual time=0.910..0.910 rows=0 loops=1)

83. 0.001 0.910 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.69..145.29 rows=1 width=205) (actual time=0.910..0.910 rows=0 loops=1)

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

Nested Loop Left Join (cost=2.55..145.12 rows=1 width=198) (actual time=0.909..0.909 rows=0 loops=1)

85. 0.000 0.909 ↓ 0.0 0 1

Nested Loop (cost=2.27..144.00 rows=1 width=194) (actual time=0.909..0.909 rows=0 loops=1)

86. 0.001 0.909 ↓ 0.0 0 1

Nested Loop (cost=2.12..143.83 rows=1 width=194) (actual time=0.909..0.909 rows=0 loops=1)

87. 0.000 0.908 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.83..143.51 rows=1 width=198) (actual time=0.908..0.908 rows=0 loops=1)

88. 0.001 0.908 ↓ 0.0 0 1

Nested Loop (cost=1.56..143.22 rows=1 width=177) (actual time=0.908..0.908 rows=0 loops=1)

89. 0.000 0.907 ↓ 0.0 0 1

Nested Loop (cost=1.14..140.60 rows=1 width=161) (actual time=0.907..0.907 rows=0 loops=1)

  • Join Filter: (r_1.id = gece_1.rezid)
90. 0.000 0.907 ↓ 0.0 0 1

Nested Loop (cost=0.72..135.74 rows=1 width=125) (actual time=0.907..0.907 rows=0 loops=1)

91. 0.001 0.907 ↓ 0.0 0 1

Nested Loop (cost=0.57..135.55 rows=1 width=57) (actual time=0.907..0.907 rows=0 loops=1)

92. 0.000 0.906 ↓ 0.0 0 1

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

93. 0.906 0.906 ↓ 0.0 0 1

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

  • Filter: ((NOT silinmis) AND (bilbordkaynak = 3))
  • Rows Removed by Filter: 5,429
94. 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))
95. 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)
96. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_public.fiyatkonum" on fiyatkonum fbilkonum (cost=0.15..0.18 rows=1 width=72) (never executed)

  • Index Cond: (id = bil.forecastkonumid)
  • Filter: ((NOT silinmis) AND (bil.sirketid = sirketid))
97. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

  • Index Cond: (bilbordid = gece_1.bilbordid)
  • Filter: (NOT silinmis)
101. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (r_1.id = id)
  • Filter: (NOT silinmis)
103. 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)
104. 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)
105. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using "PK_public.pansiyon" on pansiyon pans_1 (cost=0.15..0.17 rows=1 width=72) (never executed)

  • Index Cond: (bilgece.pansiyonid = id)
  • Filter: ((NOT silinmis) AND (bilgece.sirketid = sirketid))
108. 0.000 0.000 ↓ 0.0 0

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

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

GroupAggregate (cost=36.49..36.53 rows=1 width=64) (never executed)

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

Sort (cost=36.49..36.49 rows=1 width=44) (never executed)

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

Nested Loop (cost=1.43..36.48 rows=1 width=44) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..36.30 rows=1 width=60) (never executed)

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

Nested Loop (cost=1.00..35.92 rows=1 width=56) (never executed)

114. 0.000 0.000 ↓ 0.0 0

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

115. 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=16) (never executed)

  • Index Cond: (gruprezid > 0)
  • Filter: ((NOT silinmis) AND (tipi <> 3))
116. 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))
117. 0.000 0.000 ↓ 0.0 0

Index Scan using "geceleme_GecelemeRezId" on geceleme gece_2 (cost=0.42..19.20 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))
118. 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))
119. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_public.fiyatkonum" on fiyatkonum fkonum (cost=0.15..0.17 rows=1 width=8) (never executed)

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

Subquery Scan on bilbordkalan (cost=559.02..559.12 rows=1 width=1,109) (actual time=0.667..0.667 rows=0 loops=1)

121. 0.001 0.666 ↓ 0.0 0 1

GroupAggregate (cost=559.02..559.11 rows=1 width=546) (actual time=0.666..0.666 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)
122. 0.005 0.665 ↓ 0.0 0 1

Sort (cost=559.02..559.02 rows=1 width=266) (actual time=0.665..0.665 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
123. 0.001 0.660 ↓ 0.0 0 1

Nested Loop Left Join (cost=413.74..559.01 rows=1 width=266) (actual time=0.660..0.660 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))
124. 0.000 0.659 ↓ 0.0 0 1

Nested Loop (cost=1.71..146.91 rows=1 width=226) (actual time=0.659..0.659 rows=0 loops=1)

125. 0.001 0.659 ↓ 0.0 0 1

Nested Loop (cost=1.56..146.74 rows=1 width=162) (actual time=0.659..0.659 rows=0 loops=1)

126. 0.000 0.658 ↓ 0.0 0 1

Nested Loop (cost=1.41..146.56 rows=1 width=162) (actual time=0.658..0.658 rows=0 loops=1)

127. 0.000 0.658 ↓ 0.0 0 1

Nested Loop (cost=1.12..146.25 rows=1 width=166) (actual time=0.658..0.658 rows=0 loops=1)

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

Nested Loop (cost=0.85..140.82 rows=1 width=161) (actual time=0.658..0.658 rows=0 loops=1)

129. 0.001 0.658 ↓ 0.0 0 1

Nested Loop (cost=0.43..135.36 rows=1 width=109) (actual time=0.657..0.658 rows=0 loops=1)

130. 0.000 0.657 ↓ 0.0 0 1

Nested Loop (cost=0.28..135.17 rows=1 width=41) (actual time=0.657..0.657 rows=0 loops=1)

131. 0.657 0.657 ↓ 0.0 0 1

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

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

Index Scan using "PK_public.fiyatkonum" on fiyatkonum fbilkonum_1 (cost=0.15..0.18 rows=1 width=72) (never executed)

  • Index Cond: (id = bil_1.forecastkonumid)
  • Filter: ((NOT silinmis) AND (bil_1.sirketid = sirketid))
134. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

GroupAggregate (cost=412.03..412.07 rows=1 width=92) (never executed)

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

Sort (cost=412.03..412.04 rows=1 width=72) (never executed)

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

Nested Loop (cost=1.13..412.02 rows=1 width=72) (never executed)

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

Nested Loop (cost=0.84..411.68 rows=1 width=88) (never executed)

  • Join Filter: (acen_2.sirketid = fkonum_1.sirketid)
143. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.69..402.73 rows=49 width=52) (never executed)

144. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.27..135.16 rows=1 width=16) (never executed)

145. 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))
146. 0.000 0.000 ↓ 0.0 0

Index Scan using "acenta_IX_tumbilbordid" on acenta acen_2 (cost=0.27..8.29 rows=1 width=12) (never executed)

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

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

Index Scan using "PK_public.fiyatkonum" on fiyatkonum fkonum_1 (cost=0.15..0.17 rows=1 width=40) (never executed)

  • Index Cond: (id = gece_4.fiyatkonumid)
  • Filter: ((NOT silinmis) AND (gece_4.sirketid = sirketid))
149. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = gece_4.rezid)
  • Filter: ((NOT silinmis) AND (tipi <> 3) AND (gece_4.sirketid = sirketid))
Planning time : 305.947 ms
Execution time : 9,630.882 ms