explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XWpH

Settings
# exclusive inclusive rows x rows loops node
1. 0.918 503.235 ↓ 1.4 71 1

Sort (cost=17,333.22..17,333.35 rows=52 width=2,456) (actual time=503.232..503.235 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 502.317 ↓ 1.4 71 1

Append (cost=34.17..17,331.74 rows=52 width=2,456) (actual time=0.308..502.317 rows=71 loops=1)

3. 0.080 502.058 ↑ 1.0 48 1

Subquery Scan on "UnionAll3" (cost=34.17..17,296.72 rows=50 width=2,462) (actual time=0.308..502.058 rows=48 loops=1)

4. 0.008 501.978 ↑ 1.0 48 1

Append (cost=34.17..17,296.22 rows=50 width=2,462) (actual time=0.306..501.978 rows=48 loops=1)

5. 0.007 501.498 ↑ 1.1 37 1

Append (cost=34.17..17,246.93 rows=41 width=2,113) (actual time=0.306..501.498 rows=37 loops=1)

6. 0.026 0.306 ↑ 3.0 1 1

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

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

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

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

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

9. 0.015 0.032 ↑ 1.0 44 1

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

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

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

11. 0.008 0.163 ↑ 1.0 1 1

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

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

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

13. 0.003 0.154 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.152..0.154 rows=1 loops=1)

14. 0.003 0.151 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

  • Join Filter: (""Extent1"".id = ""Extent2"".id)
20. 0.023 0.023 ↑ 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.023..0.023 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.020 0.020 ↑ 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.020..0.020 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.012 0.012 ↑ 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.012..0.012 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.005..0.008 rows=15 loops=1)

25. 0.015 0.015 ↑ 1.0 10 1

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

26. 0.016 0.054 ↑ 1.0 10 1

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

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

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

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

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

29. 0.007 0.011 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.010..0.011 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.007 ↑ 1.0 10 1

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

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

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

33. 0.000 0.117 ↓ 0.0 0 1

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

34. 0.002 0.117 ↓ 0.0 0 1

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

35. 0.002 0.103 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.101..0.103 rows=1 loops=1)

36. 0.003 0.101 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.31..32.15 rows=1 width=278) (actual time=0.101..0.101 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.000 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.002 0.023 ↑ 1.0 1 1

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

  • Join Filter: (""Extent12"".sirketid = ""Extent14"".id)
41. 0.000 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: (""Extent12"".id = ""Extent13"".id)
42. 0.010 0.010 ↑ 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.010..0.010 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.002 0.002 ↑ 1.0 1 1

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

45. 0.010 0.010 ↑ 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.010..0.010 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.017 0.052 ↑ 1.0 10 1

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

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

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.024..0.028 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.004 0.008 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.008..0.008 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.007 ↑ 1.0 10 1

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

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

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

55. 0.012 0.012 ↓ 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.012..0.012 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.105 501.068 ↓ 1.7 36 1

Nested Loop Left Join (cost=6,833.46..17,141.49 rows=21 width=1,914) (actual time=160.537..501.068 rows=36 loops=1)

58. 0.088 500.639 ↓ 1.8 18 1

Nested Loop (cost=6,832.62..17,111.83 rows=10 width=739) (actual time=160.494..500.639 rows=18 loops=1)

59. 0.047 500.443 ↓ 1.8 18 1

Hash Join (cost=6,832.48..17,110.25 rows=10 width=698) (actual time=160.448..500.443 rows=18 loops=1)

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

Hash Join (cost=6,831.36..17,109.11 rows=10 width=655) (actual time=160.420..500.383 rows=18 loops=1)

  • Hash Cond: (""Extent32"".rezid = ""Alias39"".id)
61. 60.705 490.212 ↓ 1.0 111,991 1

Hash Join (cost=6,799.19..16,657.47 rows=111,830 width=377) (actual time=68.987..490.212 rows=111,991 loops=1)

  • Hash Cond: (""Extent32"".pansiyonid = ""Extent38"".id)
62. 56.695 429.494 ↓ 1.0 111,995 1

Hash Join (cost=6,798.03..16,185.24 rows=111,830 width=338) (actual time=68.960..429.494 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent37"".id)
63. 56.356 372.785 ↓ 1.0 111,995 1

Hash Join (cost=6,796.67..15,884.11 rows=111,830 width=300) (actual time=68.931..372.785 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".odakonumid = ""Extent36"".id)
64. 50.233 316.414 ↓ 1.0 111,995 1

Hash Left Join (cost=6,795.31..15,511.44 rows=111,830 width=249) (actual time=68.900..316.414 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".odaid = ""Extent35"".id)
65. 49.295 265.815 ↓ 1.0 111,995 1

Hash Left Join (cost=6,749.20..15,170.30 rows=111,830 width=172) (actual time=68.514..265.815 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".acentaid = ""Extent34"".id)
66. 53.577 216.421 ↓ 1.0 111,995 1

Hash Join (cost=6,739.77..14,855.80 rows=111,830 width=106) (actual time=68.386..216.421 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".id = ""Extent39"".id)
67. 47.535 123.658 ↑ 1.0 111,995 1

Hash Join (cost=3,369.89..11,191.92 rows=111,995 width=81) (actual time=28.616..123.658 rows=111,995 loops=1)

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

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

69. 15.551 28.014 ↑ 1.0 111,995 1

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

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

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

71. 22.032 39.186 ↑ 1.0 111,995 1

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

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

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

73. 0.038 0.099 ↑ 1.0 108 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
74. 0.061 0.061 ↑ 1.0 108 1

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

75. 0.164 0.366 ↑ 1.0 538 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
76. 0.202 0.202 ↑ 1.0 538 1

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

77. 0.007 0.015 ↑ 1.0 16 1

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

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

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

79. 0.006 0.014 ↑ 1.0 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
80. 0.008 0.008 ↑ 1.0 16 1

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

81. 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
82. 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)

83. 0.003 0.102 ↑ 1.0 1 1

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

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

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

85. 0.002 0.098 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.096..0.098 rows=1 loops=1)

86. 0.002 0.096 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

  • Join Filter: (""Extent23"".id = ""Extent24"".id)
92. 0.009 0.009 ↑ 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.009..0.009 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.012 0.012 ↑ 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.012..0.012 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.006 0.006 ↑ 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.006..0.006 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.016 0.052 ↑ 1.0 10 1

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

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

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

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

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

101. 0.004 0.008 ↓ 1.5 15 1

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

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

Seq Scan on tumbilbord ""Extent30"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.002..0.004 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.007 0.013 ↑ 1.0 5 1

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

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

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

107. 0.108 0.108 ↑ 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.006..0.006 rows=1 loops=18)

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

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

109. 0.162 0.162 ↑ 1.5 2 18

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

  • Index Cond: (""Extent32"".id = gecelemeid)
110. 0.108 0.108 ↑ 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.003..0.003 rows=1 loops=36)

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

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

112. 0.038 0.449 ↓ 1.2 11 1

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

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

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

114. 0.011 0.356 ↓ 1.2 11 1

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

115. 0.020 0.312 ↓ 1.2 11 1

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

116. 0.009 0.270 ↓ 1.2 11 1

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

117. 0.004 0.233 ↓ 2.0 2 1

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

118. 0.005 0.219 ↓ 2.0 2 1

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

119. 0.005 0.194 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.190..0.194 rows=1 loops=1)

120. 0.004 0.189 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

  • Join Filter: (""Extent44"".id = ""Extent45"".id)
126. 0.041 0.041 ↑ 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.041 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.021 0.021 ↑ 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.021..0.021 rows=1 loops=1)

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

Seq Scan on sirket ""Extent46"" (cost=0.00..1.01 rows=1 width=72) (actual time=0.009..0.009 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.009 0.009 ↓ 1.5 15 1

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

131. 0.006 0.006 ↑ 1.0 10 1

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

132. 0.015 0.079 ↑ 1.0 10 1

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

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

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.052..0.056 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.008 0.013 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.013..0.013 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.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
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.020 0.020 ↓ 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.017..0.020 rows=2 loops=1)

  • Index Cond: (rezid = ""Extent44"".id)
140. 0.010 0.010 ↓ 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.005..0.005 rows=0 loops=2)

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

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk ""Extent55"" (cost=0.29..1.03 rows=9 width=153) (actual time=0.010..0.014 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.033 0.033 ↑ 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.003..0.003 rows=1 loops=11)

  • Index Cond: (""Extent55"".kaynakfolioid = id)
144. 0.022 0.022 ↑ 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.002..0.002 rows=1 loops=11)

  • Index Cond: (""Extent55"".dovizid = id)
145. 0.015 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.007 0.007 ↑ 1.0 3 1

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

147. 0.026 0.248 ↓ 11.5 23 1

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

148. 0.071 0.222 ↓ 11.5 23 1

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

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

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

150. 0.005 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
151. 0.002 0.129 ↑ 1.0 1 1

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

152. 0.004 0.127 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.124..0.127 rows=1 loops=1)

153. 0.003 0.123 ↑ 1.0 1 1

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

  • Join Filter: (""Extent60"".tumbilbordid = ""Extent67"".id)
  • Rows Removed by Join Filter: 10
154. 0.002 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.003 0.049 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..27.18 rows=1 width=242) (actual time=0.049..0.049 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.028 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent60"".id = ""Extent61"".id)
159. 0.011 0.011 ↑ 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.011..0.011 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.010 0.010 ↑ 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.010..0.010 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.017 0.066 ↑ 1.0 10 1

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

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

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

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

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

168. 0.014 0.020 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.020..0.020 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.005..0.006 rows=15 loops=1)

170. 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
171. 0.004 0.004 ↑ 1.0 10 1

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