explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nfd4

Settings
# exclusive inclusive rows x rows loops node
1. 0.227 3.379 ↑ 3.6 19 1

Sort (cost=1,137.11..1,137.28 rows=69 width=2,574) (actual time=3.378..3.379 rows=19 loops=1)

  • Sort Key: ""UnionAll4"".""C2"", ""UnionAll4"".""C3"", ""UnionAll4"".""C4"", ""UnionAll4"".""C5"", ""UnionAll4"".""C6"", ""UnionAll4"".""C7"", ""UnionAll4"".""C9"", ""UnionAll4"".""C24"", ""UnionAll4"".""C45"", ""UnionAll4"".""C1"", ""UnionAll4"".""C84"", ""UnionAll4"".""C98"", ""UnionAll4"".""C107"", ""UnionAll4"".""C125"", ""UnionAll4"".""C126"", ""UnionAll4"".""C142"", ""UnionAll4"".""C160"", ""UnionAll4"".""C175"", ""UnionAll4"".""C185"", ""UnionAll4"".""C200"", ""UnionAll4"".""C201"", ""UnionAll4"".""C213"", ""UnionAll4"".""C223"", ""UnionAll4"".""C268"", ""UnionAll4"".""C277"", ""UnionAll4"".""C297"
  • Sort Method: quicksort Memory: 41kB
2. 0.003 3.152 ↑ 3.6 19 1

Append (cost=30.17..1,135.00 rows=69 width=2,574) (actual time=0.375..3.152 rows=19 loops=1)

3. 0.025 2.920 ↑ 3.7 18 1

Subquery Scan on "UnionAll4" (cost=30.17..1,103.99 rows=67 width=2,580) (actual time=0.374..2.920 rows=18 loops=1)

4. 0.003 2.895 ↑ 3.7 18 1

Append (cost=30.17..1,103.32 rows=67 width=2,580) (actual time=0.372..2.895 rows=18 loops=1)

5. 0.004 2.774 ↑ 3.2 18 1

Append (cost=30.17..1,057.85 rows=58 width=2,181) (actual time=0.372..2.774 rows=18 loops=1)

6. 0.073 0.449 ↓ 1.7 5 1

Hash Right Join (cost=30.17..34.29 rows=3 width=2,390) (actual time=0.372..0.449 rows=5 loops=1)

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

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

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

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

9. 0.019 0.036 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=42) (actual time=0.036..0.036 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.005 0.240 ↑ 1.0 1 1

Hash (cost=28.16..28.16 rows=1 width=278) (actual time=0.240..0.240 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.000 0.235 ↑ 1.0 1 1

Subquery Scan on "Alias1" (cost=3.31..28.16 rows=1 width=278) (actual time=0.233..0.235 rows=1 loops=1)

13. 0.004 0.235 ↑ 1.0 1 1

Limit (cost=3.31..28.15 rows=1 width=278) (actual time=0.232..0.235 rows=1 loops=1)

14. 0.003 0.231 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

Nested Loop (cost=0.57..13.64 rows=1 width=142) (actual time=0.125..0.125 rows=1 loops=1)

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

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

  • Join Filter: (""Extent1"".id = ""Extent2"".id)
20. 0.046 0.046 ↑ 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.046..0.046 rows=1 loops=1)

  • Index Cond: (id = 2901732)
  • 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) AND (NOT silinmis) AND (NOT silinmis))
21. 0.056 0.056 ↑ 1.0 1 1

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

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

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

23. 0.023 0.023 ↑ 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.023..0.023 rows=1 loops=1)

  • Index Cond: (id = 2901732)
24. 0.012 0.012 ↓ 1.5 15 1

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

25. 0.007 0.007 ↑ 1.0 10 1

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

26. 0.012 0.055 ↑ 1.0 10 1

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

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

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.030..0.034 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.009 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
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.003..0.004 rows=15 loops=1)

31. 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
32. 0.005 0.005 ↑ 1.0 10 1

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

33. 0.000 0.162 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.88..62.73 rows=17 width=2,444) (actual time=0.162..0.162 rows=0 loops=1)

34. 0.002 0.162 ↓ 0.0 0 1

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

35. 0.003 0.140 ↑ 1.0 1 1

Limit (cost=3.31..28.15 rows=1 width=278) (actual time=0.138..0.140 rows=1 loops=1)

36. 0.002 0.137 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

Nested Loop (cost=0.57..13.64 rows=1 width=142) (actual time=0.041..0.041 rows=1 loops=1)

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

Nested Loop Left Join (cost=0.57..12.62 rows=1 width=70) (actual time=0.037..0.037 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 = 2901732)
  • 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) AND (NOT silinmis) AND (NOT silinmis))
43. 0.024 0.024 ↑ 1.0 1 1

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

  • Index Cond: (id = 2901732)
  • 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.007 0.007 ↑ 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.007..0.007 rows=1 loops=1)

  • Index Cond: (id = 2901732)
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.003 0.003 ↑ 1.0 10 1

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

48. 0.014 0.074 ↑ 1.0 10 1

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

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

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

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

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

51. 0.010 0.015 ↓ 1.5 15 1

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

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

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

53. 0.013 0.017 ↑ 1.0 10 1

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

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

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

55. 0.020 0.020 ↓ 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.020..0.020 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.033 2.159 ↑ 2.9 13 1

Nested Loop (cost=62.16..960.25 rows=38 width=2,050) (actual time=1.196..2.159 rows=13 loops=1)

58. 0.003 0.126 ↑ 1.0 1 1

Limit (cost=3.31..28.15 rows=1 width=278) (actual time=0.124..0.126 rows=1 loops=1)

59. 0.001 0.123 ↑ 1.0 1 1

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

  • Join Filter: (""Extent23"".tumbilbordid = ""Extent30"".id)
  • Rows Removed by Join Filter: 10
60. 0.002 0.051 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..24.41 rows=1 width=246) (actual time=0.050..0.051 rows=1 loops=1)

  • Join Filter: (""Extent27"".id = ""Extent28"".id)
  • Rows Removed by Join Filter: 10
61. 0.003 0.047 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent23"".id = ""Extent26"".id)
63. 0.000 0.023 ↑ 1.0 1 1

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

  • Join Filter: (""Extent23"".sirketid = ""Extent25"".id)
64. 0.002 0.020 ↑ 1.0 1 1

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

  • Join Filter: (""Extent23"".id = ""Extent24"".id)
65. 0.010 0.010 ↑ 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.010..0.010 rows=1 loops=1)

  • Index Cond: (id = 2901732)
  • 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) AND (NOT silinmis) AND (NOT silinmis))
66. 0.008 0.008 ↑ 1.0 1 1

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

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

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

68. 0.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

  • Index Cond: (id = 2901732)
69. 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.003..0.005 rows=15 loops=1)

70. 0.002 0.002 ↑ 1.0 10 1

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

71. 0.016 0.071 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent30"".id = ""Extent31"".id)
72. 0.020 0.043 ↑ 1.0 10 1

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

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

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

74. 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
75. 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)

76. 0.009 0.012 ↑ 1.0 10 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
77. 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)

78. 0.004 2.000 ↑ 2.9 13 1

Append (cost=58.85..931.70 rows=38 width=708) (actual time=1.063..2.000 rows=13 loops=1)

79. 0.011 1.754 ↑ 1.7 13 1

Subquery Scan on "*SELECT* 1" (cost=58.85..459.21 rows=22 width=689) (actual time=1.063..1.754 rows=13 loops=1)

80. 0.021 1.743 ↑ 1.7 13 1

Nested Loop Left Join (cost=58.85..458.99 rows=22 width=689) (actual time=1.061..1.743 rows=13 loops=1)

81. 0.015 1.397 ↓ 1.3 13 1

Nested Loop Left Join (cost=58.01..276.28 rows=10 width=461) (actual time=0.986..1.397 rows=13 loops=1)

82. 0.012 1.356 ↓ 1.3 13 1

Nested Loop Left Join (cost=57.87..274.70 rows=10 width=420) (actual time=0.974..1.356 rows=13 loops=1)

83. 0.028 1.305 ↓ 1.3 13 1

Hash Left Join (cost=57.74..273.22 rows=10 width=377) (actual time=0.951..1.305 rows=13 loops=1)

  • Hash Cond: (""Extent32"".acentaid = ""Extent34"".id)
84. 0.018 1.149 ↓ 1.3 13 1

Nested Loop Left Join (cost=48.31..263.76 rows=10 width=311) (actual time=0.807..1.149 rows=13 loops=1)

85. 0.025 1.079 ↓ 1.3 13 1

Hash Left Join (cost=47.89..179.41 rows=10 width=307) (actual time=0.782..1.079 rows=13 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent37"".id)
86. 0.027 1.038 ↓ 1.3 13 1

Hash Join (cost=46.53..178.01 rows=10 width=269) (actual time=0.752..1.038 rows=13 loops=1)

  • Hash Cond: (""Extent32"".odakonumid = ""Extent36"".id)
87. 0.022 0.990 ↓ 1.3 13 1

Nested Loop Left Join (cost=45.17..176.61 rows=10 width=218) (actual time=0.716..0.990 rows=13 loops=1)

88. 0.097 0.669 ↓ 1.3 13 1

Hash Right Join (cost=44.75..92.26 rows=10 width=193) (actual time=0.659..0.669 rows=13 loops=1)

  • Hash Cond: (""Extent35"".id = ""Extent32"".odaid)
89. 0.326 0.326 ↑ 1.0 538 1

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

90. 0.010 0.246 ↓ 1.3 13 1

Hash (cost=44.63..44.63 rows=10 width=116) (actual time=0.246..0.246 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
91. 0.034 0.236 ↓ 1.3 13 1

Hash Left Join (cost=5.65..44.63 rows=10 width=116) (actual time=0.130..0.236 rows=13 loops=1)

  • Hash Cond: (""Extent32"".pansiyonid = ""Extent38"".id)
92. 0.128 0.184 ↓ 1.3 13 1

Bitmap Heap Scan on geceleme ""Extent32"" (cost=4.50..43.43 rows=10 width=77) (actual time=0.084..0.184 rows=13 loops=1)

  • Recheck Cond: (""Extent23"".id = rezid)
  • Heap Blocks: exact=11
93. 0.056 0.056 ↓ 1.3 13 1

Bitmap Index Scan on ""geceleme_GecelemeRezId"" (cost=0.00..4.49 rows=10 width=0) (actual time=0.056..0.056 rows=13 loops=1)

  • Index Cond: (""Extent23"".id = rezid)
94. 0.009 0.018 ↓ 1.1 8 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
95. 0.009 0.009 ↓ 1.1 8 1

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

96. 0.299 0.299 ↑ 1.0 1 13

Index Scan using ""gecelemedetayek_IX_id"" on gecelemedetayek ""Extent39"" (cost=0.42..8.44 rows=1 width=25) (actual time=0.023..0.023 rows=1 loops=13)

  • Index Cond: (""Extent32"".id = id)
97. 0.012 0.021 ↑ 1.0 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
98. 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)

99. 0.007 0.016 ↑ 1.0 16 1

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

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

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

101. 0.052 0.052 ↑ 1.0 1 13

Index Only Scan using ""gecelemedetayek_IX_id"" on gecelemedetayek ""Extent33"" (cost=0.42..8.44 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=13)

  • Index Cond: (id = ""Extent32"".id)
  • Heap Fetches: 13
102. 0.036 0.128 ↑ 1.0 108 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
103. 0.092 0.092 ↑ 1.0 108 1

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

104. 0.039 0.039 ↑ 1.0 1 13

Index Scan using ""PK_public.odeme"" on odeme ""Extent40"" (cost=0.13..0.15 rows=1 width=43) (actual time=0.003..0.003 rows=1 loops=13)

  • Index Cond: (""Extent39"".odemeid = id)
105. 0.026 0.026 ↑ 1.0 1 13

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

  • Index Cond: (""Extent39"".pazarid = id)
106. 0.013 0.325 ↑ 3.0 1 13

Nested Loop (cost=0.84..18.24 rows=3 width=86) (actual time=0.025..0.025 rows=1 loops=13)

107. 0.247 0.247 ↑ 3.0 1 13

Index Scan using mamisil2 on gecelememusteri ""Extent42"" (cost=0.42..15.87 rows=3 width=33) (actual time=0.018..0.019 rows=1 loops=13)

  • Index Cond: (""Extent32"".id = gecelemeid)
108. 0.065 0.065 ↑ 1.0 1 13

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=13)

  • Index Cond: (id = ""Extent42"".musteriid)
109. 0.000 0.242 ↓ 0.0 0 1

Subquery Scan on "*SELECT* 2_2" (cost=58.72..472.49 rows=16 width=733) (actual time=0.242..0.242 rows=0 loops=1)

110. 0.000 0.242 ↓ 0.0 0 1

Nested Loop (cost=58.72..472.33 rows=16 width=733) (actual time=0.242..0.242 rows=0 loops=1)

111. 0.001 0.242 ↓ 0.0 0 1

Nested Loop (cost=58.43..467.31 rows=16 width=506) (actual time=0.242..0.242 rows=0 loops=1)

  • Join Filter: (""Extent44"".id = ""Extent54"".gecelemeid)
112. 0.000 0.241 ↓ 0.0 0 1

Nested Loop (cost=58.01..196.82 rows=10 width=461) (actual time=0.241..0.241 rows=0 loops=1)

113. 0.000 0.241 ↓ 0.0 0 1

Nested Loop (cost=57.87..195.24 rows=10 width=420) (actual time=0.241..0.241 rows=0 loops=1)

114. 0.001 0.241 ↓ 0.0 0 1

Nested Loop (cost=57.74..193.76 rows=10 width=377) (actual time=0.241..0.241 rows=0 loops=1)

  • Join Filter: (""Extent44"".id = ""Extent51"".id)
115. 0.016 0.240 ↓ 0.0 0 1

Hash Join (cost=57.32..188.87 rows=10 width=352) (actual time=0.240..0.240 rows=0 loops=1)

  • Hash Cond: (""Extent44"".fiyatkonumid = ""Extent49"".id)
116. 0.018 0.206 ↓ 0.0 0 1

Hash Join (cost=55.96..187.47 rows=10 width=314) (actual time=0.206..0.206 rows=0 loops=1)

  • Hash Cond: (""Extent44"".odakonumid = ""Extent48"".id)
117. 0.013 0.168 ↓ 0.0 0 1

Hash Join (cost=54.60..186.07 rows=10 width=263) (actual time=0.168..0.168 rows=0 loops=1)

  • Hash Cond: (""Extent44"".acentaid = ""Extent46"".id)
118. 0.001 0.089 ↓ 0.0 0 1

Nested Loop (cost=45.17..176.61 rows=10 width=197) (actual time=0.089..0.089 rows=0 loops=1)

119. 0.014 0.088 ↓ 0.0 0 1

Hash Join (cost=44.75..92.26 rows=10 width=193) (actual time=0.088..0.088 rows=0 loops=1)

  • Hash Cond: (""Extent47"".id = ""Extent44"".odaid)
120. 0.006 0.006 ↑ 538.0 1 1

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

121. 0.001 0.068 ↓ 0.0 0 1

Hash (cost=44.63..44.63 rows=10 width=116) (actual time=0.068..0.068 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
122. 0.028 0.067 ↓ 1.3 13 1

Hash Join (cost=5.65..44.63 rows=10 width=116) (actual time=0.052..0.067 rows=13 loops=1)

  • Hash Cond: (""Extent44"".pansiyonid = ""Extent50"".id)
123. 0.016 0.027 ↓ 1.3 13 1

Bitmap Heap Scan on geceleme ""Extent44"" (cost=4.50..43.43 rows=10 width=77) (actual time=0.016..0.027 rows=13 loops=1)

  • Recheck Cond: (""Extent23"".id = rezid)
  • Heap Blocks: exact=11
124. 0.011 0.011 ↓ 1.3 13 1

Bitmap Index Scan on ""geceleme_GecelemeRezId"" (cost=0.00..4.49 rows=10 width=0) (actual time=0.011..0.011 rows=13 loops=1)

  • Index Cond: (""Extent23"".id = rezid)
125. 0.006 0.012 ↓ 1.1 8 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
126. 0.006 0.006 ↓ 1.1 8 1

Seq Scan on pansiyon ""Extent50"" (cost=0.00..1.07 rows=7 width=39) (actual time=0.005..0.006 rows=8 loops=1)

127. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ""gecelemedetayek_IX_id"" on gecelemedetayek ""Extent45"" (cost=0.42..8.44 rows=1 width=4) (never executed)

  • Index Cond: (id = ""Extent44"".id)
  • Heap Fetches: 0
128. 0.034 0.066 ↑ 1.0 108 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
129. 0.032 0.032 ↑ 1.0 108 1

Seq Scan on acenta ""Extent46"" (cost=0.00..8.08 rows=108 width=66) (actual time=0.004..0.032 rows=108 loops=1)

130. 0.012 0.020 ↑ 1.0 16 1

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

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

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

132. 0.010 0.018 ↑ 1.0 16 1

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

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

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

134. 0.000 0.000 ↓ 0.0 0

Index Scan using ""gecelemedetayek_IX_id"" on gecelemedetayek ""Extent51"" (cost=0.42..0.48 rows=1 width=25) (never executed)

  • Index Cond: (id = ""Extent45"".id)
135. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = ""Extent51"".odemeid)
136. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.pazar"" on pazar ""Extent53"" (cost=0.14..0.16 rows=1 width=41) (never executed)

  • Index Cond: (id = ""Extent51"".pazarid)
137. 0.000 0.000 ↓ 0.0 0

Index Scan using ""hesayr_IX_gecelemeid"" on hesayr ""Extent54"" (cost=0.42..15.99 rows=885 width=45) (never executed)

  • Index Cond: (gecelemeid = ""Extent45"".id)
138. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.konumhamfiyat"" on konumhamfiyat ""Extent55"" (cost=0.29..0.31 rows=1 width=69) (never executed)

  • Index Cond: (id = ""Extent54"".konumhamfiyatid)
139. 0.000 0.118 ↓ 0.0 0 1

Subquery Scan on "*SELECT* 2_1" (cost=4.60..44.88 rows=9 width=2,262) (actual time=0.118..0.118 rows=0 loops=1)

140. 0.000 0.118 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.60..44.77 rows=9 width=2,258) (actual time=0.118..0.118 rows=0 loops=1)

  • Join Filter: (""Extent67"".kdvid = ""Extent71"".id)
141. 0.001 0.118 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.60..43.37 rows=9 width=721) (actual time=0.118..0.118 rows=0 loops=1)

142. 0.000 0.117 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.46..41.98 rows=9 width=681) (actual time=0.117..0.117 rows=0 loops=1)

143. 0.000 0.117 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.17..39.21 rows=9 width=644) (actual time=0.117..0.117 rows=0 loops=1)

144. 0.000 0.117 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.03..37.79 rows=9 width=593) (actual time=0.117..0.117 rows=0 loops=1)

145. 0.000 0.117 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.74..36.67 rows=1 width=440) (actual time=0.117..0.117 rows=0 loops=1)

146. 0.001 0.117 ↓ 0.0 0 1

Nested Loop (cost=3.59..36.48 rows=1 width=315) (actual time=0.117..0.117 rows=0 loops=1)

147. 0.002 0.103 ↑ 1.0 1 1

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

148. 0.002 0.101 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".tumbilbordid = ""Extent63"".id)
  • Rows Removed by Join Filter: 10
149. 0.001 0.047 ↑ 1.0 1 1

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

  • Join Filter: (""Extent60"".id = ""Extent61"".id)
  • Rows Removed by Join Filter: 10
150. 0.002 0.043 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".tumbilbordid = ""Extent60"".id)
  • Rows Removed by Join Filter: 15
151. 0.001 0.036 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".id = ""Extent59"".id)
152. 0.001 0.028 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".sirketid = ""Extent58"".id)
153. 0.001 0.024 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".id = ""Extent57"".id)
154. 0.012 0.012 ↑ 1.0 1 1

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

  • Index Cond: (id = 2901732)
  • 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) AND (NOT silinmis) AND (NOT silinmis))
155. 0.011 0.011 ↑ 1.0 1 1

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

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

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

157. 0.007 0.007 ↑ 1.0 1 1

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

  • Index Cond: (id = 2901732)
158. 0.005 0.005 ↓ 1.5 15 1

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

159. 0.003 0.003 ↑ 1.0 10 1

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

160. 0.012 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: (""Extent63"".id = ""Extent64"".id)
161. 0.017 0.032 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent62"".id = ""Extent63"".id)
162. 0.006 0.006 ↑ 1.0 10 1

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

163. 0.005 0.009 ↓ 1.5 15 1

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

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

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

165. 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
166. 0.003 0.003 ↑ 1.0 10 1

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

167. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ""folio_IX_rezid"" on folio ""Extent65"" (cost=0.29..8.30 rows=1 width=37) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (rezid = ""Extent56"".id)
168. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.fatura"" on fatura ""Extent66"" (cost=0.15..0.17 rows=1 width=125) (never executed)

  • Index Cond: (""Extent65"".faturaid = id)
169. 0.000 0.000 ↓ 0.0 0

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk ""Extent67"" (cost=0.29..1.03 rows=9 width=153) (never executed)

  • Index Cond: (""Extent65"".id = folioid)
170. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.depkod"" on depkod ""Extent68"" (cost=0.14..0.16 rows=1 width=51) (never executed)

  • Index Cond: (""Extent67"".depkodid = id)
171. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.folio"" on folio ""Extent69"" (cost=0.29..0.31 rows=1 width=37) (never executed)

  • Index Cond: (""Extent67"".kaynakfolioid = id)
172. 0.000 0.000 ↓ 0.0 0

Index Scan using ""PK_public.doviz"" on doviz ""Extent70"" (cost=0.14..0.16 rows=1 width=40) (never executed)

  • Index Cond: (""Extent67"".dovizid = id)
173. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.04 rows=3 width=35) (never executed)

174. 0.000 0.000 ↓ 0.0 0

Seq Scan on kdv ""Extent71"" (cost=0.00..1.03 rows=3 width=35) (never executed)

175. 0.002 0.229 ↑ 2.0 1 1

Subquery Scan on "*SELECT* 2" (cost=28.18..31.01 rows=2 width=2,447) (actual time=0.193..0.229 rows=1 loops=1)

176. 0.063 0.227 ↑ 2.0 1 1

Hash Join (cost=28.18..30.99 rows=2 width=2,447) (actual time=0.191..0.227 rows=1 loops=1)

  • Hash Cond: (""Extent81"".rezid = ""Alias77"".id)
177. 0.038 0.038 ↓ 1.3 73 1

Seq Scan on rezdetaybilgi ""Extent81"" (cost=0.00..2.58 rows=58 width=129) (actual time=0.010..0.038 rows=73 loops=1)

178. 0.004 0.126 ↑ 1.0 1 1

Hash (cost=28.16..28.16 rows=1 width=278) (actual time=0.126..0.126 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
179. 0.001 0.122 ↑ 1.0 1 1

Subquery Scan on "Alias77" (cost=3.31..28.16 rows=1 width=278) (actual time=0.120..0.122 rows=1 loops=1)

180. 0.002 0.121 ↑ 1.0 1 1

Limit (cost=3.31..28.15 rows=1 width=278) (actual time=0.119..0.121 rows=1 loops=1)

181. 0.001 0.119 ↑ 1.0 1 1

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

  • Join Filter: (""Extent72"".tumbilbordid = ""Extent79"".id)
  • Rows Removed by Join Filter: 10
182. 0.002 0.064 ↑ 1.0 1 1

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

  • Join Filter: (""Extent76"".id = ""Extent77"".id)
  • Rows Removed by Join Filter: 10
183. 0.002 0.060 ↑ 1.0 1 1

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

  • Join Filter: (""Extent72"".tumbilbordid = ""Extent76"".id)
  • Rows Removed by Join Filter: 15
184. 0.000 0.053 ↑ 1.0 1 1

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

  • Join Filter: (""Extent72"".id = ""Extent75"".id)
185. 0.001 0.042 ↑ 1.0 1 1

Nested Loop (cost=0.57..13.64 rows=1 width=142) (actual time=0.042..0.042 rows=1 loops=1)

  • Join Filter: (""Extent72"".sirketid = ""Extent74"".id)
186. 0.001 0.038 ↑ 1.0 1 1

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

  • Join Filter: (""Extent72"".id = ""Extent73"".id)
187. 0.012 0.012 ↑ 1.0 1 1

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

  • Index Cond: (id = 2901732)
  • 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) AND (NOT silinmis) AND (NOT silinmis))
188. 0.025 0.025 ↑ 1.0 1 1

Index Only Scan using ""rezdetayek_IX_id"" on rezdetayek ""Extent73"" (cost=0.29..4.30 rows=1 width=4) (actual time=0.025..0.025 rows=1 loops=1)

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

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

190. 0.011 0.011 ↑ 1.0 1 1

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

  • Index Cond: (id = 2901732)
191. 0.005 0.005 ↓ 1.5 15 1

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

192. 0.002 0.002 ↑ 1.0 10 1

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

193. 0.015 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: (""Extent79"".id = ""Extent80"".id)
194. 0.014 0.028 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent78"".id = ""Extent79"".id)
195. 0.003 0.003 ↑ 1.0 10 1

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

196. 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
197. 0.006 0.006 ↓ 1.5 15 1

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

198. 0.008 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
199. 0.003 0.003 ↑ 1.0 10 1

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