explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YgtH

Settings
# exclusive inclusive rows x rows loops node
1. 0.948 553.540 ↓ 1.4 71 1

Sort (cost=17,340.03..17,340.16 rows=52 width=2,456) (actual time=553.537..553.540 rows=71 loops=1)

  • Sort Key: ""UnionAll3"".""C2"", ""UnionAll3"".""C3"", ""UnionAll3"".""C4"", ""UnionAll3"".""C5"", ""UnionAll3"".""C6"", ""UnionAll3"".""C7"", ""UnionAll3"".""C9"", ""UnionAll3"".""C24"", ""UnionAll3"".""C45"", ""UnionAll3"".""C1"", ""UnionAll3"".""C84"", ""UnionAll3"".""C98"", ""UnionAll3"".""C107"", ""UnionAll3"".""C125"", ""UnionAll3"".""C126"", ""UnionAll3"".""C142"", ""UnionAll3"".""C160"", ""UnionAll3"".""C175"", ""UnionAll3"".""C185"", ""UnionAll3"".""C200"", ""UnionAll3"".""C201"", ""UnionAll3"".""C213"", ""UnionAll3"".""C223"", ""UnionAll3"".""C243"", ""UnionAll3"".""C252"", ""UnionAll3"".""C272"
  • Sort Method: quicksort Memory: 79kB
2. 0.011 552.592 ↓ 1.4 71 1

Append (cost=34.17..17,338.55 rows=52 width=2,456) (actual time=0.345..552.592 rows=71 loops=1)

3. 0.082 552.303 ↑ 1.0 48 1

Subquery Scan on "UnionAll3" (cost=34.17..17,303.53 rows=50 width=2,462) (actual time=0.345..552.303 rows=48 loops=1)

4. 0.009 552.221 ↑ 1.0 48 1

Append (cost=34.17..17,303.03 rows=50 width=2,462) (actual time=0.343..552.221 rows=48 loops=1)

5. 0.009 551.636 ↑ 1.1 37 1

Append (cost=34.17..17,253.74 rows=41 width=2,113) (actual time=0.343..551.636 rows=37 loops=1)

6. 0.027 0.343 ↑ 3.0 1 1

Hash Right Join (cost=34.17..38.29 rows=3 width=2,272) (actual time=0.342..0.343 rows=1 loops=1)

  • Hash Cond: (""Extent10"".rezid = ""Alias1"".id)
7. 0.052 0.125 ↓ 1.0 129 1

Hash Join (cost=1.99..5.61 rows=126 width=75) (actual time=0.061..0.125 rows=129 loops=1)

  • Hash Cond: (""Extent10"".ozellikid = ""Extent11"".id)
8. 0.032 0.032 ↓ 1.0 129 1

Seq Scan on rezozellik ""Extent10"" (cost=0.00..3.26 rows=126 width=33) (actual time=0.008..0.032 rows=129 loops=1)

9. 0.018 0.041 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=42) (actual time=0.041..0.041 rows=44 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
10. 0.023 0.023 ↑ 1.0 44 1

Seq Scan on ozellik ""Extent11"" (cost=0.00..1.44 rows=44 width=42) (actual time=0.006..0.023 rows=44 loops=1)

11. 0.007 0.191 ↑ 1.0 1 1

Hash (cost=32.16..32.16 rows=1 width=278) (actual time=0.191..0.191 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.001 0.184 ↑ 1.0 1 1

Subquery Scan on "Alias1" (cost=3.31..32.16 rows=1 width=278) (actual time=0.181..0.184 rows=1 loops=1)

13. 0.004 0.183 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.181..0.183 rows=1 loops=1)

14. 0.002 0.179 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.31..32.15 rows=1 width=278) (actual time=0.179..0.179 rows=1 loops=1)

  • Join Filter: (""Extent1"".tumbilbordid = ""Extent8"".id)
  • Rows Removed by Join Filter: 10
15. 0.002 0.114 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..28.41 rows=1 width=246) (actual time=0.114..0.114 rows=1 loops=1)

  • Join Filter: (""Extent5"".id = ""Extent6"".id)
  • Rows Removed by Join Filter: 10
16. 0.001 0.108 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..27.18 rows=1 width=242) (actual time=0.108..0.108 rows=1 loops=1)

  • Join Filter: (""Extent1"".tumbilbordid = ""Extent5"".id)
  • Rows Removed by Join Filter: 15
17. 0.001 0.099 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..25.95 rows=1 width=194) (actual time=0.099..0.099 rows=1 loops=1)

  • Join Filter: (""Extent1"".id = ""Extent4"".id)
18. 0.001 0.084 ↑ 1.0 1 1

Nested Loop (cost=0.57..17.64 rows=1 width=142) (actual time=0.084..0.084 rows=1 loops=1)

  • Join Filter: (""Extent1"".sirketid = ""Extent3"".id)
19. 0.002 0.076 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=70) (actual time=0.076..0.076 rows=1 loops=1)

  • Join Filter: (""Extent1"".id = ""Extent2"".id)
20. 0.040 0.040 ↑ 1.0 1 1

Index Scan using ""PK_public.rez"" on rez ""Extent1"" (cost=0.29..8.30 rows=1 width=66) (actual time=0.040..0.040 rows=1 loops=1)

  • Index Cond: (id = 2897631)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
21. 0.034 0.034 ↑ 1.0 1 1

Index Only Scan using ""rezdetayek_IX_id"" on rezdetayek ""Extent2"" (cost=0.29..8.30 rows=1 width=4) (actual time=0.034..0.034 rows=1 loops=1)

  • Index Cond: (id = 2897631)
  • Heap Fetches: 0
22. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on sirket ""Extent3"" (cost=0.00..1.01 rows=1 width=72) (actual time=0.007..0.007 rows=1 loops=1)

23. 0.014 0.014 ↑ 1.0 1 1

Index Scan using ""rezdetayek_IX_id"" on rezdetayek ""Extent4"" (cost=0.29..8.30 rows=1 width=52) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (id = 2897631)
24. 0.008 0.008 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent5"" (cost=0.00..1.10 rows=10 width=48) (actual time=0.004..0.008 rows=15 loops=1)

25. 0.004 0.004 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent6"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.003..0.004 rows=10 loops=1)

26. 0.014 0.063 ↑ 1.0 10 1

Hash Left Join (cost=2.45..3.62 rows=10 width=32) (actual time=0.057..0.063 rows=10 loops=1)

  • Hash Cond: (""Extent8"".id = ""Extent9"".id)
27. 0.017 0.041 ↑ 1.0 10 1

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.037..0.041 rows=10 loops=1)

  • Hash Cond: (""Extent7"".id = ""Extent8"".id)
28. 0.003 0.003 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent7"" (cost=0.00..1.10 rows=10 width=24) (actual time=0.002..0.003 rows=10 loops=1)

29. 0.017 0.021 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.021..0.021 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 0.004 0.004 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent8"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.002..0.004 rows=15 loops=1)

31. 0.004 0.008 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.008..0.008 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
32. 0.004 0.004 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent9"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.003..0.004 rows=10 loops=1)

33. 0.000 0.131 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.88..66.73 rows=17 width=2,326) (actual time=0.131..0.131 rows=0 loops=1)

34. 0.001 0.131 ↓ 0.0 0 1

Nested Loop (cost=3.59..59.70 rows=8 width=347) (actual time=0.131..0.131 rows=0 loops=1)

35. 0.003 0.114 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.111..0.114 rows=1 loops=1)

36. 0.002 0.111 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.31..32.15 rows=1 width=278) (actual time=0.111..0.111 rows=1 loops=1)

  • Join Filter: (""Extent12"".tumbilbordid = ""Extent19"".id)
  • Rows Removed by Join Filter: 10
37. 0.001 0.046 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..28.41 rows=1 width=246) (actual time=0.046..0.046 rows=1 loops=1)

  • Join Filter: (""Extent16"".id = ""Extent17"".id)
  • Rows Removed by Join Filter: 10
38. 0.001 0.040 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..27.18 rows=1 width=242) (actual time=0.040..0.040 rows=1 loops=1)

  • Join Filter: (""Extent12"".tumbilbordid = ""Extent16"".id)
  • Rows Removed by Join Filter: 15
39. 0.002 0.033 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..25.95 rows=1 width=194) (actual time=0.033..0.033 rows=1 loops=1)

  • Join Filter: (""Extent12"".id = ""Extent15"".id)
40. 0.000 0.025 ↑ 1.0 1 1

Nested Loop (cost=0.57..17.64 rows=1 width=142) (actual time=0.025..0.025 rows=1 loops=1)

  • Join Filter: (""Extent12"".sirketid = ""Extent14"".id)
41. 0.001 0.022 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=70) (actual time=0.022..0.022 rows=1 loops=1)

  • Join Filter: (""Extent12"".id = ""Extent13"".id)
42. 0.012 0.012 ↑ 1.0 1 1

Index Scan using ""PK_public.rez"" on rez ""Extent12"" (cost=0.29..8.30 rows=1 width=66) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (id = 2897631)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
43. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using ""rezdetayek_IX_id"" on rezdetayek ""Extent13"" (cost=0.29..8.30 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = 2897631)
  • Heap Fetches: 0
44. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on sirket ""Extent14"" (cost=0.00..1.01 rows=1 width=72) (actual time=0.003..0.003 rows=1 loops=1)

45. 0.006 0.006 ↑ 1.0 1 1

Index Scan using ""rezdetayek_IX_id"" on rezdetayek ""Extent15"" (cost=0.29..8.30 rows=1 width=52) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (id = 2897631)
46. 0.006 0.006 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent16"" (cost=0.00..1.10 rows=10 width=48) (actual time=0.003..0.006 rows=15 loops=1)

47. 0.005 0.005 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent17"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.004..0.005 rows=10 loops=1)

48. 0.025 0.063 ↑ 1.0 10 1

Hash Left Join (cost=2.45..3.62 rows=10 width=32) (actual time=0.058..0.063 rows=10 loops=1)

  • Hash Cond: (""Extent19"".id = ""Extent20"".id)
49. 0.015 0.029 ↑ 1.0 10 1

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.025..0.029 rows=10 loops=1)

  • Hash Cond: (""Extent18"".id = ""Extent19"".id)
50. 0.003 0.003 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent18"" (cost=0.00..1.10 rows=10 width=24) (actual time=0.001..0.003 rows=10 loops=1)

51. 0.007 0.011 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.011..0.011 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
52. 0.004 0.004 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent19"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.002..0.004 rows=15 loops=1)

53. 0.004 0.009 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.009..0.009 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
54. 0.005 0.005 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent20"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.004..0.005 rows=10 loops=1)

55. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ""konumhamfiyat_IX_rezid"" on konumhamfiyat ""Extent21"" (cost=0.29..27.46 rows=8 width=69) (actual time=0.015..0.016 rows=0 loops=1)

  • Index Cond: (rezid = ""Extent12"".id)
56. 0.000 0.000 ↓ 0.0 0

Index Scan using ""konumhamfiyatkategori_IX_konumhamfiyatid"" on konumhamfiyatkategori ""Extent22"" (cost=0.29..0.86 rows=2 width=33) (never executed)

  • Index Cond: (""Extent21"".id = konumhamfiyatid)
57. 0.127 551.153 ↓ 1.7 36 1

Nested Loop Left Join (cost=6,833.46..17,148.30 rows=21 width=1,914) (actual time=176.085..551.153 rows=36 loops=1)

58. 0.083 550.522 ↓ 1.8 18 1

Nested Loop Left Join (cost=6,832.62..17,118.64 rows=10 width=739) (actual time=175.997..550.522 rows=18 loops=1)

59. 0.074 550.313 ↓ 1.8 18 1

Hash Left Join (cost=6,832.48..17,117.06 rows=10 width=698) (actual time=175.969..550.313 rows=18 loops=1)

  • Hash Cond: (""Extent39"".odemeid = ""Extent40"".id)
60. 10.082 550.217 ↓ 1.8 18 1

Hash Join (cost=6,831.36..17,115.93 rows=10 width=655) (actual time=175.907..550.217 rows=18 loops=1)

  • Hash Cond: (""Extent32"".rezid = ""Alias39"".id)
61. 76.237 540.001 ↑ 1.0 112,160 1

Hash Left Join (cost=6,799.19..16,663.05 rows=112,160 width=377) (actual time=78.885..540.001 rows=112,160 loops=1)

  • Hash Cond: (""Extent32"".id = ""Extent39"".id)
62. 56.374 422.784 ↑ 1.0 112,160 1

Hash Left Join (cost=3,429.30..12,998.73 rows=112,160 width=352) (actual time=37.156..422.784 rows=112,160 loops=1)

  • Hash Cond: (""Extent32"".pansiyonid = ""Extent38"".id)
63. 54.454 366.397 ↑ 1.0 112,160 1

Hash Left Join (cost=3,428.14..12,525.11 rows=112,160 width=313) (actual time=37.130..366.397 rows=112,160 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent37"".id)
64. 54.440 311.919 ↑ 1.0 112,160 1

Hash Join (cost=3,426.78..12,223.09 rows=112,160 width=275) (actual time=37.088..311.919 rows=112,160 loops=1)

  • Hash Cond: (""Extent32"".odakonumid = ""Extent36"".id)
65. 47.075 257.460 ↑ 1.0 112,160 1

Hash Left Join (cost=3,425.42..11,849.32 rows=112,160 width=224) (actual time=37.052..257.460 rows=112,160 loops=1)

  • Hash Cond: (""Extent32"".odaid = ""Extent35"".id)
66. 45.977 209.822 ↑ 1.0 112,160 1

Hash Left Join (cost=3,379.32..11,507.32 rows=112,160 width=147) (actual time=36.475..209.822 rows=112,160 loops=1)

  • Hash Cond: (""Extent32"".acentaid = ""Extent34"".id)
67. 49.448 163.731 ↑ 1.0 112,160 1

Hash Left Join (cost=3,369.89..11,191.92 rows=112,160 width=81) (actual time=36.336..163.731 rows=112,160 loops=1)

  • Hash Cond: (""Extent32"".id = ""Extent33"".id)
68. 78.641 78.641 ↑ 1.0 112,160 1

Seq Scan on geceleme ""Extent32"" (cost=0.00..7,527.60 rows=112,160 width=77) (actual time=0.012..78.641 rows=112,160 loops=1)

69. 17.831 35.642 ↑ 1.0 111,995 1

Hash (cost=1,969.95..1,969.95 rows=111,995 width=4) (actual time=35.642..35.642 rows=111,995 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4962kB
70. 17.811 17.811 ↑ 1.0 111,995 1

Seq Scan on gecelemedetayek ""Extent33"" (cost=0.00..1,969.95 rows=111,995 width=4) (actual time=0.023..17.811 rows=111,995 loops=1)

71. 0.035 0.114 ↑ 1.0 108 1

Hash (cost=8.08..8.08 rows=108 width=66) (actual time=0.114..0.114 rows=108 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
72. 0.079 0.079 ↑ 1.0 108 1

Seq Scan on acenta ""Extent34"" (cost=0.00..8.08 rows=108 width=66) (actual time=0.012..0.079 rows=108 loops=1)

73. 0.316 0.563 ↑ 1.0 538 1

Hash (cost=39.38..39.38 rows=538 width=77) (actual time=0.563..0.563 rows=538 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
74. 0.247 0.247 ↑ 1.0 538 1

Seq Scan on oda ""Extent35"" (cost=0.00..39.38 rows=538 width=77) (actual time=0.016..0.247 rows=538 loops=1)

75. 0.010 0.019 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=51) (actual time=0.019..0.019 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
76. 0.009 0.009 ↑ 1.0 16 1

Seq Scan on odakonum ""Extent36"" (cost=0.00..1.16 rows=16 width=51) (actual time=0.006..0.009 rows=16 loops=1)

77. 0.013 0.024 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=38) (actual time=0.024..0.024 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
78. 0.011 0.011 ↑ 1.0 16 1

Seq Scan on fiyatkonum ""Extent37"" (cost=0.00..1.16 rows=16 width=38) (actual time=0.008..0.011 rows=16 loops=1)

79. 0.005 0.013 ↓ 1.1 8 1

Hash (cost=1.07..1.07 rows=7 width=39) (actual time=0.013..0.013 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
80. 0.008 0.008 ↓ 1.1 8 1

Seq Scan on pansiyon ""Extent38"" (cost=0.00..1.07 rows=7 width=39) (actual time=0.007..0.008 rows=8 loops=1)

81. 23.402 40.980 ↑ 1.0 111,995 1

Hash (cost=1,969.95..1,969.95 rows=111,995 width=25) (actual time=40.980..40.980 rows=111,995 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 7259kB
82. 17.578 17.578 ↑ 1.0 111,995 1

Seq Scan on gecelemedetayek ""Extent39"" (cost=0.00..1,969.95 rows=111,995 width=25) (actual time=0.012..17.578 rows=111,995 loops=1)

83. 0.024 0.134 ↑ 1.0 1 1

Hash (cost=32.16..32.16 rows=1 width=278) (actual time=0.134..0.134 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
84. 0.001 0.110 ↑ 1.0 1 1

Subquery Scan on "Alias39" (cost=3.31..32.16 rows=1 width=278) (actual time=0.107..0.110 rows=1 loops=1)

85. 0.003 0.109 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.107..0.109 rows=1 loops=1)

86. 0.002 0.106 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.31..32.15 rows=1 width=278) (actual time=0.106..0.106 rows=1 loops=1)

  • Join Filter: (""Extent23"".tumbilbordid = ""Extent30"".id)
  • Rows Removed by Join Filter: 10
87. 0.000 0.041 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..28.41 rows=1 width=246) (actual time=0.041..0.041 rows=1 loops=1)

  • Join Filter: (""Extent27"".id = ""Extent28"".id)
  • Rows Removed by Join Filter: 10
88. 0.002 0.038 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..27.18 rows=1 width=242) (actual time=0.037..0.038 rows=1 loops=1)

  • Join Filter: (""Extent23"".tumbilbordid = ""Extent27"".id)
  • Rows Removed by Join Filter: 15
89. 0.000 0.031 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..25.95 rows=1 width=194) (actual time=0.031..0.031 rows=1 loops=1)

  • Join Filter: (""Extent23"".id = ""Extent26"".id)
90. 0.001 0.022 ↑ 1.0 1 1

Nested Loop (cost=0.57..17.64 rows=1 width=142) (actual time=0.022..0.022 rows=1 loops=1)

  • Join Filter: (""Extent23"".sirketid = ""Extent25"".id)
91. 0.001 0.019 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=70) (actual time=0.019..0.019 rows=1 loops=1)

  • Join Filter: (""Extent23"".id = ""Extent24"".id)
92. 0.008 0.008 ↑ 1.0 1 1

Index Scan using ""PK_public.rez"" on rez ""Extent23"" (cost=0.29..8.30 rows=1 width=66) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = 2897631)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
93. 0.010 0.010 ↑ 1.0 1 1

Index Only Scan using ""rezdetayek_IX_id"" on rezdetayek ""Extent24"" (cost=0.29..8.30 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (id = 2897631)
  • Heap Fetches: 0
94. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on sirket ""Extent25"" (cost=0.00..1.01 rows=1 width=72) (actual time=0.002..0.002 rows=1 loops=1)

95. 0.009 0.009 ↑ 1.0 1 1

Index Scan using ""rezdetayek_IX_id"" on rezdetayek ""Extent26"" (cost=0.29..8.30 rows=1 width=52) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = 2897631)
96. 0.005 0.005 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent27"" (cost=0.00..1.10 rows=10 width=48) (actual time=0.002..0.005 rows=15 loops=1)

97. 0.003 0.003 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent28"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.002..0.003 rows=10 loops=1)

98. 0.014 0.063 ↑ 1.0 10 1

Hash Left Join (cost=2.45..3.62 rows=10 width=32) (actual time=0.058..0.063 rows=10 loops=1)

  • Hash Cond: (""Extent30"".id = ""Extent31"".id)
99. 0.024 0.041 ↑ 1.0 10 1

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.038..0.041 rows=10 loops=1)

  • Hash Cond: (""Extent29"".id = ""Extent30"".id)
100. 0.003 0.003 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent29"" (cost=0.00..1.10 rows=10 width=24) (actual time=0.001..0.003 rows=10 loops=1)

101. 0.007 0.014 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.014..0.014 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
102. 0.007 0.007 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent30"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.006..0.007 rows=15 loops=1)

103. 0.005 0.008 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.008..0.008 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
104. 0.003 0.003 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent31"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.002..0.003 rows=10 loops=1)

105. 0.008 0.022 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=43) (actual time=0.022..0.022 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
106. 0.014 0.014 ↑ 1.0 5 1

Seq Scan on odeme ""Extent40"" (cost=0.00..1.05 rows=5 width=43) (actual time=0.013..0.014 rows=5 loops=1)

107. 0.126 0.126 ↑ 1.0 1 18

Index Scan using ""PK_public.pazar"" on pazar ""Extent41"" (cost=0.14..0.16 rows=1 width=41) (actual time=0.007..0.007 rows=1 loops=18)

  • Index Cond: (""Extent39"".pazarid = id)
108. 0.036 0.504 ↑ 1.5 2 18

Nested Loop (cost=0.84..2.94 rows=3 width=86) (actual time=0.021..0.028 rows=2 loops=18)

109. 0.288 0.288 ↑ 1.5 2 18

Index Scan using mamisil2 on gecelememusteri ""Extent42"" (cost=0.42..0.57 rows=3 width=33) (actual time=0.012..0.016 rows=2 loops=18)

  • Index Cond: (""Extent32"".id = gecelemeid)
110. 0.180 0.180 ↑ 1.0 1 36

Index Scan using ""PK_public.musteri"" on musteri ""Extent43"" (cost=0.42..0.79 rows=1 width=53) (actual time=0.005..0.005 rows=1 loops=36)

  • Index Cond: (id = ""Extent42"".musteriid)
111. 0.024 0.576 ↓ 1.2 11 1

Subquery Scan on "*SELECT* 2_1" (cost=4.60..48.88 rows=9 width=2,144) (actual time=0.414..0.576 rows=11 loops=1)

112. 0.027 0.552 ↓ 1.2 11 1

Nested Loop Left Join (cost=4.60..48.77 rows=9 width=2,140) (actual time=0.409..0.552 rows=11 loops=1)

  • Join Filter: (""Extent55"".kdvid = ""Extent59"".id)
  • Rows Removed by Join Filter: 23
113. 0.014 0.503 ↓ 1.2 11 1

Nested Loop Left Join (cost=4.60..47.37 rows=9 width=721) (actual time=0.384..0.503 rows=11 loops=1)

114. 0.012 0.456 ↓ 1.2 11 1

Nested Loop Left Join (cost=4.46..45.98 rows=9 width=681) (actual time=0.359..0.456 rows=11 loops=1)

115. 0.020 0.400 ↓ 1.2 11 1

Nested Loop Left Join (cost=4.17..43.21 rows=9 width=644) (actual time=0.337..0.400 rows=11 loops=1)

116. 0.008 0.358 ↓ 1.2 11 1

Nested Loop Left Join (cost=4.03..41.79 rows=9 width=593) (actual time=0.323..0.358 rows=11 loops=1)

117. 0.005 0.296 ↓ 2.0 2 1

Nested Loop Left Join (cost=3.74..40.67 rows=1 width=440) (actual time=0.284..0.296 rows=2 loops=1)

118. 0.005 0.275 ↓ 2.0 2 1

Nested Loop (cost=3.59..40.48 rows=1 width=315) (actual time=0.265..0.275 rows=2 loops=1)

119. 0.015 0.227 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.224..0.227 rows=1 loops=1)

120. 0.003 0.212 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.31..32.15 rows=1 width=278) (actual time=0.212..0.212 rows=1 loops=1)

  • Join Filter: (""Extent44"".tumbilbordid = ""Extent51"".id)
  • Rows Removed by Join Filter: 10
121. 0.003 0.117 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..28.41 rows=1 width=246) (actual time=0.117..0.117 rows=1 loops=1)

  • Join Filter: (""Extent48"".id = ""Extent49"".id)
  • Rows Removed by Join Filter: 10
122. 0.003 0.109 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..27.18 rows=1 width=242) (actual time=0.109..0.109 rows=1 loops=1)

  • Join Filter: (""Extent44"".tumbilbordid = ""Extent48"".id)
  • Rows Removed by Join Filter: 15
123. 0.002 0.090 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..25.95 rows=1 width=194) (actual time=0.090..0.090 rows=1 loops=1)

  • Join Filter: (""Extent44"".id = ""Extent47"".id)
124. 0.003 0.079 ↑ 1.0 1 1

Nested Loop (cost=0.57..17.64 rows=1 width=142) (actual time=0.079..0.079 rows=1 loops=1)

  • Join Filter: (""Extent44"".sirketid = ""Extent46"".id)
125. 0.003 0.066 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=70) (actual time=0.066..0.066 rows=1 loops=1)

  • Join Filter: (""Extent44"".id = ""Extent45"".id)
126. 0.040 0.040 ↑ 1.0 1 1

Index Scan using ""PK_public.rez"" on rez ""Extent44"" (cost=0.29..8.30 rows=1 width=66) (actual time=0.040..0.040 rows=1 loops=1)

  • Index Cond: (id = 2897631)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
127. 0.023 0.023 ↑ 1.0 1 1

Index Only Scan using ""rezdetayek_IX_id"" on rezdetayek ""Extent45"" (cost=0.29..8.30 rows=1 width=4) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: (id = 2897631)
  • Heap Fetches: 0
128. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on sirket ""Extent46"" (cost=0.00..1.01 rows=1 width=72) (actual time=0.010..0.010 rows=1 loops=1)

129. 0.009 0.009 ↑ 1.0 1 1

Index Scan using ""rezdetayek_IX_id"" on rezdetayek ""Extent47"" (cost=0.29..8.30 rows=1 width=52) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = 2897631)
130. 0.016 0.016 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent48"" (cost=0.00..1.10 rows=10 width=48) (actual time=0.013..0.016 rows=15 loops=1)

131. 0.005 0.005 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent49"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.004..0.005 rows=10 loops=1)

132. 0.017 0.092 ↑ 1.0 10 1

Hash Left Join (cost=2.45..3.62 rows=10 width=32) (actual time=0.087..0.092 rows=10 loops=1)

  • Hash Cond: (""Extent51"".id = ""Extent52"".id)
133. 0.026 0.065 ↑ 1.0 10 1

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.061..0.065 rows=10 loops=1)

  • Hash Cond: (""Extent50"".id = ""Extent51"".id)
134. 0.006 0.006 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent50"" (cost=0.00..1.10 rows=10 width=24) (actual time=0.004..0.006 rows=10 loops=1)

135. 0.028 0.033 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.033..0.033 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
136. 0.005 0.005 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent51"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.003..0.005 rows=15 loops=1)

137. 0.006 0.010 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.010..0.010 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
138. 0.004 0.004 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent52"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.003..0.004 rows=10 loops=1)

139. 0.043 0.043 ↓ 2.0 2 1

Index Scan using ""folio_IX_rezid"" on folio ""Extent53"" (cost=0.29..8.30 rows=1 width=37) (actual time=0.038..0.043 rows=2 loops=1)

  • Index Cond: (rezid = ""Extent44"".id)
140. 0.016 0.016 ↓ 0.0 0 2

Index Scan using ""PK_public.fatura"" on fatura ""Extent54"" (cost=0.15..0.17 rows=1 width=125) (actual time=0.008..0.008 rows=0 loops=2)

  • Index Cond: (""Extent53"".faturaid = id)
141. 0.054 0.054 ↑ 1.5 6 2

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk ""Extent55"" (cost=0.29..1.03 rows=9 width=153) (actual time=0.023..0.027 rows=6 loops=2)

  • Index Cond: (""Extent53"".id = folioid)
142. 0.022 0.022 ↑ 1.0 1 11

Index Scan using ""PK_public.depkod"" on depkod ""Extent56"" (cost=0.14..0.16 rows=1 width=51) (actual time=0.002..0.002 rows=1 loops=11)

  • Index Cond: (""Extent55"".depkodid = id)
143. 0.044 0.044 ↑ 1.0 1 11

Index Scan using ""PK_public.folio"" on folio ""Extent57"" (cost=0.29..0.31 rows=1 width=37) (actual time=0.004..0.004 rows=1 loops=11)

  • Index Cond: (""Extent55"".kaynakfolioid = id)
144. 0.033 0.033 ↑ 1.0 1 11

Index Scan using ""PK_public.doviz"" on doviz ""Extent58"" (cost=0.14..0.16 rows=1 width=40) (actual time=0.003..0.003 rows=1 loops=11)

  • Index Cond: (""Extent55"".dovizid = id)
145. 0.014 0.022 ↑ 1.0 3 11

Materialize (cost=0.00..1.04 rows=3 width=35) (actual time=0.001..0.002 rows=3 loops=11)

146. 0.008 0.008 ↑ 1.0 3 1

Seq Scan on kdv ""Extent59"" (cost=0.00..1.03 rows=3 width=35) (actual time=0.007..0.008 rows=3 loops=1)

147. 0.027 0.278 ↓ 11.5 23 1

Subquery Scan on "*SELECT* 2" (cost=32.18..35.01 rows=2 width=2,329) (actual time=0.191..0.278 rows=23 loops=1)

148. 0.089 0.251 ↓ 11.5 23 1

Hash Join (cost=32.18..34.99 rows=2 width=2,329) (actual time=0.186..0.251 rows=23 loops=1)

  • Hash Cond: (""Extent69"".rezid = ""Alias77"".id)
149. 0.023 0.023 ↓ 1.3 73 1

Seq Scan on rezdetaybilgi ""Extent69"" (cost=0.00..2.58 rows=58 width=129) (actual time=0.009..0.023 rows=73 loops=1)

150. 0.005 0.139 ↑ 1.0 1 1

Hash (cost=32.16..32.16 rows=1 width=278) (actual time=0.139..0.139 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
151. 0.002 0.134 ↑ 1.0 1 1

Subquery Scan on "Alias77" (cost=3.31..32.16 rows=1 width=278) (actual time=0.131..0.134 rows=1 loops=1)

152. 0.003 0.132 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.129..0.132 rows=1 loops=1)

153. 0.004 0.129 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.31..32.15 rows=1 width=278) (actual time=0.129..0.129 rows=1 loops=1)

  • Join Filter: (""Extent60"".tumbilbordid = ""Extent67"".id)
  • Rows Removed by Join Filter: 10
154. 0.003 0.054 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..28.41 rows=1 width=246) (actual time=0.054..0.054 rows=1 loops=1)

  • Join Filter: (""Extent64"".id = ""Extent65"".id)
  • Rows Removed by Join Filter: 10
155. 0.002 0.048 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..27.18 rows=1 width=242) (actual time=0.048..0.048 rows=1 loops=1)

  • Join Filter: (""Extent60"".tumbilbordid = ""Extent64"".id)
  • Rows Removed by Join Filter: 15
156. 0.002 0.040 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..25.95 rows=1 width=194) (actual time=0.040..0.040 rows=1 loops=1)

  • Join Filter: (""Extent60"".id = ""Extent63"".id)
157. 0.001 0.029 ↑ 1.0 1 1

Nested Loop (cost=0.57..17.64 rows=1 width=142) (actual time=0.029..0.029 rows=1 loops=1)

  • Join Filter: (""Extent60"".sirketid = ""Extent62"".id)
158. 0.002 0.025 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=70) (actual time=0.025..0.025 rows=1 loops=1)

  • Join Filter: (""Extent60"".id = ""Extent61"".id)
159. 0.012 0.012 ↑ 1.0 1 1

Index Scan using ""PK_public.rez"" on rez ""Extent60"" (cost=0.29..8.30 rows=1 width=66) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (id = 2897631)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
160. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using ""rezdetayek_IX_id"" on rezdetayek ""Extent61"" (cost=0.29..8.30 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (id = 2897631)
  • Heap Fetches: 0
161. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on sirket ""Extent62"" (cost=0.00..1.01 rows=1 width=72) (actual time=0.003..0.003 rows=1 loops=1)

162. 0.009 0.009 ↑ 1.0 1 1

Index Scan using ""rezdetayek_IX_id"" on rezdetayek ""Extent63"" (cost=0.29..8.30 rows=1 width=52) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = 2897631)
163. 0.006 0.006 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent64"" (cost=0.00..1.10 rows=10 width=48) (actual time=0.003..0.006 rows=15 loops=1)

164. 0.003 0.003 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent65"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.002..0.003 rows=10 loops=1)

165. 0.023 0.071 ↑ 1.0 10 1

Hash Left Join (cost=2.45..3.62 rows=10 width=32) (actual time=0.066..0.071 rows=10 loops=1)

  • Hash Cond: (""Extent67"".id = ""Extent68"".id)
166. 0.023 0.037 ↑ 1.0 10 1

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.033..0.037 rows=10 loops=1)

  • Hash Cond: (""Extent66"".id = ""Extent67"".id)
167. 0.003 0.003 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent66"" (cost=0.00..1.10 rows=10 width=24) (actual time=0.002..0.003 rows=10 loops=1)

168. 0.005 0.011 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.011..0.011 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
169. 0.006 0.006 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent67"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.004..0.006 rows=15 loops=1)

170. 0.006 0.011 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.011..0.011 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
171. 0.005 0.005 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent68"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.004..0.005 rows=10 loops=1)