explain.depesz.com

PostgreSQL's explain analyze made readable

Result: riyp

Settings
# exclusive inclusive rows x rows loops node
1. 3.650 58.997 ↓ 1.8 127 1

Sort (cost=5,146.89..5,147.06 rows=69 width=2,574) (actual time=58.992..58.997 rows=127 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: 153kB
2. 0.016 55.347 ↓ 1.8 127 1

Append (cost=34.17..5,144.78 rows=69 width=2,574) (actual time=0.417..55.347 rows=127 loops=1)

3. 0.165 55.145 ↓ 1.9 127 1

Subquery Scan on "UnionAll4" (cost=34.17..5,109.76 rows=67 width=2,580) (actual time=0.416..55.145 rows=127 loops=1)

4. 0.015 54.980 ↓ 1.9 127 1

Append (cost=34.17..5,109.09 rows=67 width=2,580) (actual time=0.414..54.980 rows=127 loops=1)

5. 0.013 54.536 ↓ 2.1 121 1

Append (cost=34.17..5,059.63 rows=58 width=2,181) (actual time=0.414..54.536 rows=121 loops=1)

6. 0.027 0.414 ↑ 3.0 1 1

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

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

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

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

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

9. 0.016 0.037 ↑ 1.0 44 1

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

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

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

11. 0.007 0.240 ↑ 1.0 1 1

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

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

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

13. 0.004 0.232 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.229..0.232 rows=1 loops=1)

14. 0.003 0.228 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2893068)
  • 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.062 0.062 ↑ 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.062..0.062 rows=1 loops=1)

  • Index Cond: (id = 2893068)
  • Heap Fetches: 1
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.010 0.010 ↑ 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.010..0.010 rows=1 loops=1)

  • Index Cond: (id = 2893068)
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.009..0.012 rows=15 loops=1)

25. 0.005 0.005 ↑ 1.0 10 1

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

26. 0.011 0.057 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent8"".id = ""Extent9"".id)
27. 0.018 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.008 0.012 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.012..0.012 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.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
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.143 ↓ 0.0 0 1

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

34. 0.002 0.143 ↓ 0.0 0 1

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

35. 0.002 0.114 ↑ 1.0 1 1

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

36. 0.002 0.112 ↑ 1.0 1 1

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

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

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

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

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

  • Join Filter: (""Extent12"".tumbilbordid = ""Extent16"".id)
  • Rows Removed by Join Filter: 15
39. 0.001 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: (""Extent12"".id = ""Extent15"".id)
40. 0.002 0.031 ↑ 1.0 1 1

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

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

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=70) (actual time=0.027..0.027 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 = 2893068)
  • 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.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

  • Index Cond: (id = 2893068)
  • Heap Fetches: 1
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.008 0.008 ↑ 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.008..0.008 rows=1 loops=1)

  • Index Cond: (id = 2893068)
46. 0.005 0.005 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent16"" (cost=0.00..1.10 rows=10 width=48) (actual time=0.002..0.005 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.059 ↑ 1.0 10 1

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

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

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.034..0.038 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.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
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.003..0.005 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.027 0.027 ↓ 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.027..0.027 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.217 53.966 ↓ 3.2 120 1

Nested Loop (cost=60.80..4,954.02 rows=38 width=2,050) (actual time=0.960..53.966 rows=120 loops=1)

58. 0.008 0.100 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.093..0.100 rows=1 loops=1)

59. 0.002 0.092 ↑ 1.0 1 1

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

  • Join Filter: (""Extent23"".tumbilbordid = ""Extent30"".id)
  • Rows Removed by Join Filter: 10
60. 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
61. 0.002 0.039 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent23"".id = ""Extent26"".id)
63. 0.001 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: (""Extent23"".sirketid = ""Extent25"".id)
64. 0.000 0.020 ↑ 1.0 1 1

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

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

  • Index Cond: (id = 2893068)
  • 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.009 0.009 ↑ 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.009 rows=1 loops=1)

  • Index Cond: (id = 2893068)
  • Heap Fetches: 1
67. 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)

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

  • Index Cond: (id = 2893068)
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.002..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.011 0.048 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent30"".id = ""Extent31"".id)
72. 0.016 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)
73. 0.004 0.004 ↑ 1.0 10 1

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

74. 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
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.006 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
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.019 53.649 ↓ 3.2 120 1

Append (cost=57.49..4,921.48 rows=38 width=708) (actual time=0.861..53.649 rows=120 loops=1)

79. 0.060 2.487 ↓ 4.5 100 1

Subquery Scan on "*SELECT* 1" (cost=57.49..461.21 rows=22 width=689) (actual time=0.860..2.487 rows=100 loops=1)

80. 0.108 2.427 ↓ 4.5 100 1

Nested Loop Left Join (cost=57.49..460.99 rows=22 width=689) (actual time=0.859..2.427 rows=100 loops=1)

81. 0.023 1.469 ↓ 2.5 25 1

Nested Loop Left Join (cost=56.65..278.28 rows=10 width=461) (actual time=0.758..1.469 rows=25 loops=1)

82. 0.027 1.396 ↓ 2.5 25 1

Nested Loop Left Join (cost=56.51..276.70 rows=10 width=420) (actual time=0.739..1.396 rows=25 loops=1)

83. 0.032 1.319 ↓ 2.5 25 1

Hash Left Join (cost=56.38..275.20 rows=10 width=377) (actual time=0.720..1.319 rows=25 loops=1)

  • Hash Cond: (""Extent32"".acentaid = ""Extent34"".id)
84. 0.034 1.176 ↓ 2.5 25 1

Hash Left Join (cost=46.95..265.74 rows=10 width=311) (actual time=0.598..1.176 rows=25 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent37"".id)
85. 0.019 1.121 ↓ 2.5 25 1

Nested Loop (cost=45.59..264.35 rows=10 width=273) (actual time=0.564..1.121 rows=25 loops=1)

  • Join Filter: (""Extent32"".odakonumid = ""Extent36"".id)
  • Rows Removed by Join Filter: 25
86. 0.025 1.077 ↓ 2.5 25 1

Nested Loop Left Join (cost=45.59..260.96 rows=10 width=222) (actual time=0.549..1.077 rows=25 loops=1)

87. 0.017 1.002 ↓ 2.5 25 1

Nested Loop Left Join (cost=45.17..176.61 rows=10 width=197) (actual time=0.537..1.002 rows=25 loops=1)

88. 0.068 0.635 ↓ 2.5 25 1

Hash Right Join (cost=44.75..92.26 rows=10 width=193) (actual time=0.486..0.635 rows=25 loops=1)

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

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

90. 0.016 0.250 ↓ 2.5 25 1

Hash (cost=44.63..44.63 rows=10 width=116) (actual time=0.250..0.250 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
91. 0.032 0.234 ↓ 2.5 25 1

Hash Left Join (cost=5.65..44.63 rows=10 width=116) (actual time=0.115..0.234 rows=25 loops=1)

  • Hash Cond: (""Extent32"".pansiyonid = ""Extent38"".id)
92. 0.135 0.183 ↓ 2.5 25 1

Bitmap Heap Scan on geceleme ""Extent32"" (cost=4.50..43.43 rows=10 width=77) (actual time=0.074..0.183 rows=25 loops=1)

  • Recheck Cond: (""Extent23"".id = rezid)
  • Heap Blocks: exact=15
93. 0.048 0.048 ↓ 2.5 25 1

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

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

Hash (cost=1.07..1.07 rows=7 width=39) (actual time=0.019..0.019 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.350 0.350 ↑ 1.0 1 25

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

  • Index Cond: (id = ""Extent32"".id)
  • Heap Fetches: 25
97. 0.050 0.050 ↑ 1.0 1 25

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

  • Index Cond: (""Extent32"".id = id)
98. 0.019 0.025 ↑ 8.0 2 25

Materialize (cost=0.00..1.24 rows=16 width=51) (actual time=0.001..0.001 rows=2 loops=25)

99. 0.006 0.006 ↑ 8.0 2 1

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

100. 0.009 0.021 ↑ 1.0 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
101. 0.012 0.012 ↑ 1.0 16 1

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

102. 0.039 0.111 ↑ 1.0 108 1

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

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

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

104. 0.050 0.050 ↑ 1.0 1 25

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

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

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

  • Index Cond: (""Extent39"".pazarid = id)
106. 0.075 0.850 ↓ 1.3 4 25

Nested Loop (cost=0.84..18.24 rows=3 width=86) (actual time=0.017..0.034 rows=4 loops=25)

107. 0.475 0.475 ↓ 1.3 4 25

Index Scan using mamisil2 on gecelememusteri ""Extent42"" (cost=0.42..15.87 rows=3 width=33) (actual time=0.011..0.019 rows=4 loops=25)

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

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

  • Index Cond: (id = ""Extent42"".musteriid)
109. 0.015 51.143 ↓ 1.2 20 1

Subquery Scan on "*SELECT* 2_2" (cost=278.29..4,460.27 rows=16 width=733) (actual time=16.337..51.143 rows=20 loops=1)

110. 0.017 51.128 ↓ 1.2 20 1

Nested Loop Left Join (cost=278.29..4,460.11 rows=16 width=733) (actual time=16.334..51.128 rows=20 loops=1)

111. 0.040 51.091 ↓ 1.2 20 1

Hash Left Join (cost=278.01..4,455.09 rows=16 width=506) (actual time=16.319..51.091 rows=20 loops=1)

  • Hash Cond: (""Extent51"".odemeid = ""Extent52"".id)
112. 10.866 51.031 ↓ 1.2 20 1

Hash Join (cost=276.90..4,453.93 rows=16 width=463) (actual time=16.274..51.031 rows=20 loops=1)

  • Hash Cond: (""Extent54"".gecelemeid = ""Extent44"".id)
113. 39.456 39.456 ↑ 1.0 177,082 1

Seq Scan on hesayr ""Extent54"" (cost=0.00..3,512.82 rows=177,082 width=45) (actual time=0.012..39.456 rows=177,082 loops=1)

114. 0.044 0.709 ↓ 2.5 25 1

Hash (cost=276.77..276.77 rows=10 width=418) (actual time=0.709..0.709 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
115. 0.035 0.665 ↓ 2.5 25 1

Nested Loop Left Join (cost=56.52..276.77 rows=10 width=418) (actual time=0.385..0.665 rows=25 loops=1)

116. 0.034 0.605 ↓ 2.5 25 1

Hash Left Join (cost=56.38..275.20 rows=10 width=377) (actual time=0.375..0.605 rows=25 loops=1)

  • Hash Cond: (""Extent44"".acentaid = ""Extent46"".id)
117. 0.028 0.507 ↓ 2.5 25 1

Hash Left Join (cost=46.95..265.74 rows=10 width=311) (actual time=0.293..0.507 rows=25 loops=1)

  • Hash Cond: (""Extent44"".fiyatkonumid = ""Extent49"".id)
118. 0.028 0.467 ↓ 2.5 25 1

Nested Loop (cost=45.59..264.35 rows=10 width=273) (actual time=0.268..0.467 rows=25 loops=1)

  • Join Filter: (""Extent44"".odakonumid = ""Extent48"".id)
  • Rows Removed by Join Filter: 25
119. 0.007 0.439 ↓ 2.5 25 1

Nested Loop Left Join (cost=45.59..260.96 rows=10 width=222) (actual time=0.260..0.439 rows=25 loops=1)

120. 0.031 0.382 ↓ 2.5 25 1

Nested Loop Left Join (cost=45.17..176.61 rows=10 width=197) (actual time=0.252..0.382 rows=25 loops=1)

121. 0.063 0.301 ↓ 2.5 25 1

Hash Right Join (cost=44.75..92.26 rows=10 width=193) (actual time=0.239..0.301 rows=25 loops=1)

  • Hash Cond: (""Extent47"".id = ""Extent44"".odaid)
122. 0.150 0.150 ↑ 1.0 538 1

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

123. 0.017 0.088 ↓ 2.5 25 1

Hash (cost=44.63..44.63 rows=10 width=116) (actual time=0.088..0.088 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
124. 0.023 0.071 ↓ 2.5 25 1

Hash Left Join (cost=5.65..44.63 rows=10 width=116) (actual time=0.044..0.071 rows=25 loops=1)

  • Hash Cond: (""Extent44"".pansiyonid = ""Extent50"".id)
125. 0.023 0.036 ↓ 2.5 25 1

Bitmap Heap Scan on geceleme ""Extent44"" (cost=4.50..43.43 rows=10 width=77) (actual time=0.018..0.036 rows=25 loops=1)

  • Recheck Cond: (""Extent23"".id = rezid)
  • Heap Blocks: exact=15
126. 0.013 0.013 ↓ 2.5 25 1

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

  • Index Cond: (""Extent23"".id = rezid)
127. 0.007 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
128. 0.005 0.005 ↓ 1.1 8 1

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

129. 0.050 0.050 ↑ 1.0 1 25

Index Only Scan using ""gecelemedetayek_IX_id"" on gecelemedetayek ""Extent45"" (cost=0.42..8.44 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=25)

  • Index Cond: (id = ""Extent44"".id)
  • Heap Fetches: 25
130. 0.050 0.050 ↑ 1.0 1 25

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

  • Index Cond: (""Extent44"".id = id)
131. 0.000 0.000 ↑ 8.0 2 25

Materialize (cost=0.00..1.24 rows=16 width=51) (actual time=0.000..0.000 rows=2 loops=25)

132. 0.003 0.003 ↑ 8.0 2 1

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

133. 0.006 0.012 ↑ 1.0 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
134. 0.006 0.006 ↑ 1.0 16 1

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

135. 0.033 0.064 ↑ 1.0 108 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
136. 0.031 0.031 ↑ 1.0 108 1

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

137. 0.025 0.025 ↑ 1.0 1 25

Index Scan using ""PK_public.pazar"" on pazar ""Extent53"" (cost=0.14..0.16 rows=1 width=41) (actual time=0.001..0.001 rows=1 loops=25)

  • Index Cond: (""Extent51"".pazarid = id)
138. 0.009 0.020 ↑ 1.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
139. 0.011 0.011 ↑ 1.0 5 1

Seq Scan on odeme ""Extent52"" (cost=0.00..1.05 rows=5 width=43) (actual time=0.010..0.011 rows=5 loops=1)

140. 0.020 0.020 ↓ 0.0 0 20

Index Scan using ""PK_public.konumhamfiyat"" on konumhamfiyat ""Extent55"" (cost=0.29..0.31 rows=1 width=69) (actual time=0.001..0.001 rows=0 loops=20)

  • Index Cond: (""Extent54"".konumhamfiyatid = id)
141. 0.022 0.429 ↑ 1.5 6 1

Subquery Scan on "*SELECT* 2_1" (cost=4.60..48.88 rows=9 width=2,262) (actual time=0.354..0.429 rows=6 loops=1)

142. 0.018 0.407 ↑ 1.5 6 1

Nested Loop Left Join (cost=4.60..48.77 rows=9 width=2,258) (actual time=0.343..0.407 rows=6 loops=1)

  • Join Filter: (""Extent67"".kdvid = ""Extent71"".id)
  • Rows Removed by Join Filter: 6
143. 0.010 0.371 ↑ 1.5 6 1

Nested Loop Left Join (cost=4.60..47.37 rows=9 width=721) (actual time=0.320..0.371 rows=6 loops=1)

144. 0.010 0.337 ↑ 1.5 6 1

Nested Loop Left Join (cost=4.46..45.98 rows=9 width=681) (actual time=0.296..0.337 rows=6 loops=1)

145. 0.012 0.303 ↑ 1.5 6 1

Nested Loop Left Join (cost=4.17..43.21 rows=9 width=644) (actual time=0.275..0.303 rows=6 loops=1)

146. 0.007 0.273 ↑ 1.5 6 1

Nested Loop Left Join (cost=4.03..41.79 rows=9 width=593) (actual time=0.261..0.273 rows=6 loops=1)

147. 0.002 0.238 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.74..40.67 rows=1 width=440) (actual time=0.234..0.238 rows=1 loops=1)

148. 0.004 0.231 ↑ 1.0 1 1

Nested Loop (cost=3.59..40.48 rows=1 width=315) (actual time=0.227..0.231 rows=1 loops=1)

149. 0.005 0.198 ↑ 1.0 1 1

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

150. 0.004 0.193 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".tumbilbordid = ""Extent63"".id)
  • Rows Removed by Join Filter: 10
151. 0.002 0.102 ↑ 1.0 1 1

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

  • Join Filter: (""Extent60"".id = ""Extent61"".id)
  • Rows Removed by Join Filter: 10
152. 0.003 0.091 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".tumbilbordid = ""Extent60"".id)
  • Rows Removed by Join Filter: 15
153. 0.002 0.079 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".id = ""Extent59"".id)
154. 0.002 0.070 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".sirketid = ""Extent58"".id)
155. 0.002 0.058 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".id = ""Extent57"".id)
156. 0.033 0.033 ↑ 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.033..0.033 rows=1 loops=1)

  • Index Cond: (id = 2893068)
  • 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))
157. 0.023 0.023 ↑ 1.0 1 1

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

  • Index Cond: (id = 2893068)
  • Heap Fetches: 1
158. 0.010 0.010 ↑ 1.0 1 1

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

159. 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 = 2893068)
160. 0.009 0.009 ↓ 1.5 15 1

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

161. 0.009 0.009 ↑ 1.0 10 1

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

162. 0.014 0.087 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent63"".id = ""Extent64"".id)
163. 0.024 0.040 ↑ 1.0 10 1

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

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

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

165. 0.007 0.012 ↓ 1.5 15 1

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

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

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

167. 0.017 0.033 ↑ 1.0 10 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
168. 0.016 0.016 ↑ 1.0 10 1

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

169. 0.029 0.029 ↑ 1.0 1 1

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

  • Index Cond: (rezid = ""Extent56"".id)
170. 0.005 0.005 ↓ 0.0 0 1

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

  • Index Cond: (""Extent65"".faturaid = id)
171. 0.028 0.028 ↑ 1.5 6 1

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk ""Extent67"" (cost=0.29..1.03 rows=9 width=153) (actual time=0.023..0.028 rows=6 loops=1)

  • Index Cond: (""Extent65"".id = folioid)
172. 0.018 0.018 ↑ 1.0 1 6

Index Scan using ""PK_public.depkod"" on depkod ""Extent68"" (cost=0.14..0.16 rows=1 width=51) (actual time=0.003..0.003 rows=1 loops=6)

  • Index Cond: (""Extent67"".depkodid = id)
173. 0.024 0.024 ↑ 1.0 1 6

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

  • Index Cond: (""Extent67"".kaynakfolioid = id)
174. 0.024 0.024 ↑ 1.0 1 6

Index Scan using ""PK_public.doviz"" on doviz ""Extent70"" (cost=0.14..0.16 rows=1 width=40) (actual time=0.004..0.004 rows=1 loops=6)

  • Index Cond: (""Extent67"".dovizid = id)
175. 0.012 0.018 ↑ 1.5 2 6

Materialize (cost=0.00..1.04 rows=3 width=35) (actual time=0.003..0.003 rows=2 loops=6)

176. 0.006 0.006 ↑ 1.5 2 1

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

177. 0.001 0.186 ↓ 0.0 0 1

Subquery Scan on "*SELECT* 2" (cost=32.18..35.01 rows=2 width=2,447) (actual time=0.186..0.186 rows=0 loops=1)

178. 0.020 0.185 ↓ 0.0 0 1

Hash Join (cost=32.18..34.99 rows=2 width=2,447) (actual time=0.185..0.185 rows=0 loops=1)

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

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

180. 0.008 0.142 ↑ 1.0 1 1

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

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

182. 0.004 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)

183. 0.003 0.128 ↑ 1.0 1 1

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

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

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

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

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

  • Join Filter: (""Extent72"".tumbilbordid = ""Extent76"".id)
  • Rows Removed by Join Filter: 15
186. 0.002 0.047 ↑ 1.0 1 1

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

  • Join Filter: (""Extent72"".id = ""Extent75"".id)
187. 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: (""Extent72"".sirketid = ""Extent74"".id)
188. 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: (""Extent72"".id = ""Extent73"".id)
189. 0.010 0.010 ↑ 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.010..0.010 rows=1 loops=1)

  • Index Cond: (id = 2893068)
  • 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))
190. 0.012 0.012 ↑ 1.0 1 1

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

  • Index Cond: (id = 2893068)
  • Heap Fetches: 1
191. 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.002..0.003 rows=1 loops=1)

192. 0.017 0.017 ↑ 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.017..0.017 rows=1 loops=1)

  • Index Cond: (id = 2893068)
193. 0.006 0.006 ↓ 1.5 15 1

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

194. 0.003 0.003 ↑ 1.0 10 1

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

195. 0.013 0.065 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent79"".id = ""Extent80"".id)
196. 0.030 0.045 ↑ 1.0 10 1

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

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

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

198. 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
199. 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)

200. 0.003 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
201. 0.004 0.004 ↑ 1.0 10 1

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