explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WGau

Settings
# exclusive inclusive rows x rows loops node
1. 1.254 50.929 ↑ 1.2 57 1

Sort (cost=5,146.89..5,147.06 rows=69 width=2,574) (actual time=50.927..50.929 rows=57 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: 80kB
2. 0.006 49.675 ↑ 1.2 57 1

Append (cost=34.17..5,144.78 rows=69 width=2,574) (actual time=0.406..49.675 rows=57 loops=1)

3. 0.109 49.435 ↑ 1.2 56 1

Subquery Scan on "UnionAll4" (cost=34.17..5,109.76 rows=67 width=2,580) (actual time=0.405..49.435 rows=56 loops=1)

4. 0.008 49.326 ↑ 1.2 56 1

Append (cost=34.17..5,109.09 rows=67 width=2,580) (actual time=0.403..49.326 rows=56 loops=1)

5. 0.007 48.815 ↑ 1.2 47 1

Append (cost=34.17..5,059.63 rows=58 width=2,181) (actual time=0.403..48.815 rows=47 loops=1)

6. 0.031 0.403 ↑ 3.0 1 1

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

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

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

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

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

9. 0.015 0.031 ↑ 1.0 44 1

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

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

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

11. 0.010 0.243 ↑ 1.0 1 1

Hash (cost=32.16..32.16 rows=1 width=278) (actual time=0.243..0.243 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.005 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.227 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2898704)
  • 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.053 0.053 ↑ 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.053..0.053 rows=1 loops=1)

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

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

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

  • Index Cond: (id = 2898704)
24. 0.015 0.015 ↓ 1.5 15 1

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

25. 0.009 0.009 ↑ 1.0 10 1

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

26. 0.013 0.061 ↑ 1.0 10 1

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

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

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

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

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

29. 0.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
30. 0.005 0.005 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent8"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.004..0.005 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.159 ↓ 0.0 0 1

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

34. 0.002 0.159 ↓ 0.0 0 1

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

35. 0.003 0.130 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.128..0.130 rows=1 loops=1)

36. 0.002 0.127 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2898704)
  • 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.019 0.019 ↑ 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.019..0.019 rows=1 loops=1)

  • Index Cond: (id = 2898704)
  • 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 = 2898704)
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.013 0.069 ↑ 1.0 10 1

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

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

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

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

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

51. 0.014 0.018 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.017..0.018 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.003..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.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.097 48.246 ↓ 1.2 46 1

Nested Loop (cost=60.80..4,954.02 rows=38 width=2,050) (actual time=0.737..48.246 rows=46 loops=1)

58. 0.007 0.125 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.118..0.125 rows=1 loops=1)

59. 0.003 0.118 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2898704)
  • 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.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 = 2898704)
  • 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.003..0.003 rows=1 loops=1)

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

  • Index Cond: (id = 2898704)
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.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)

71. 0.013 0.060 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent30"".id = ""Extent31"".id)
72. 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: (""Extent29"".id = ""Extent30"".id)
73. 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)

74. 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
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.003..0.004 rows=15 loops=1)

76. 0.011 0.015 ↑ 1.0 10 1

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

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

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

78. 0.009 48.024 ↓ 1.2 46 1

Append (cost=57.49..4,921.48 rows=38 width=708) (actual time=0.611..48.024 rows=46 loops=1)

79. 0.027 1.894 ↓ 1.5 32 1

Subquery Scan on "*SELECT* 1" (cost=57.49..461.21 rows=22 width=689) (actual time=0.610..1.894 rows=32 loops=1)

80. 0.031 1.867 ↓ 1.5 32 1

Nested Loop Left Join (cost=57.49..460.99 rows=22 width=689) (actual time=0.608..1.867 rows=32 loops=1)

81. 0.018 1.340 ↓ 1.6 16 1

Nested Loop Left Join (cost=56.65..278.28 rows=10 width=461) (actual time=0.551..1.340 rows=16 loops=1)

82. 0.015 1.290 ↓ 1.6 16 1

Nested Loop Left Join (cost=56.51..276.70 rows=10 width=420) (actual time=0.537..1.290 rows=16 loops=1)

83. 0.039 1.227 ↓ 1.6 16 1

Hash Left Join (cost=56.38..275.20 rows=10 width=377) (actual time=0.514..1.227 rows=16 loops=1)

  • Hash Cond: (""Extent32"".acentaid = ""Extent34"".id)
84. 0.019 1.098 ↓ 1.6 16 1

Nested Loop (cost=46.95..265.74 rows=10 width=311) (actual time=0.400..1.098 rows=16 loops=1)

  • Join Filter: (""Extent32"".odakonumid = ""Extent36"".id)
85. 0.022 1.063 ↓ 1.6 16 1

Nested Loop Left Join (cost=46.95..262.35 rows=10 width=260) (actual time=0.383..1.063 rows=16 loops=1)

86. 0.039 0.929 ↓ 1.6 16 1

Hash Join (cost=46.53..178.00 rows=10 width=256) (actual time=0.311..0.929 rows=16 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent37"".id)
87. 0.033 0.868 ↓ 1.6 16 1

Nested Loop Left Join (cost=45.17..176.61 rows=10 width=218) (actual time=0.266..0.868 rows=16 loops=1)

88. 0.069 0.483 ↓ 1.6 16 1

Hash Right Join (cost=44.75..92.26 rows=10 width=193) (actual time=0.231..0.483 rows=16 loops=1)

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

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

90. 0.016 0.198 ↓ 1.6 16 1

Hash (cost=44.63..44.63 rows=10 width=116) (actual time=0.198..0.198 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
91. 0.032 0.182 ↓ 1.6 16 1

Hash Left Join (cost=5.65..44.63 rows=10 width=116) (actual time=0.135..0.182 rows=16 loops=1)

  • Hash Cond: (""Extent32"".pansiyonid = ""Extent38"".id)
92. 0.055 0.136 ↓ 1.6 16 1

Bitmap Heap Scan on geceleme ""Extent32"" (cost=4.50..43.43 rows=10 width=77) (actual time=0.096..0.136 rows=16 loops=1)

  • Recheck Cond: (""Extent23"".id = rezid)
  • Heap Blocks: exact=11
93. 0.081 0.081 ↓ 1.6 16 1

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

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

Hash (cost=1.07..1.07 rows=7 width=39) (actual time=0.014..0.014 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.352 0.352 ↑ 1.0 1 16

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

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

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

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

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

99. 0.112 0.112 ↑ 1.0 1 16

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

  • Index Cond: (id = ""Extent32"".id)
  • Heap Fetches: 16
100. 0.009 0.016 ↑ 16.0 1 16

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

101. 0.007 0.007 ↑ 16.0 1 1

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

102. 0.041 0.090 ↑ 1.0 108 1

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

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

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

104. 0.048 0.048 ↑ 1.0 1 16

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

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

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

  • Index Cond: (""Extent39"".pazarid = id)
106. 0.064 0.496 ↑ 1.5 2 16

Nested Loop (cost=0.84..18.24 rows=3 width=86) (actual time=0.020..0.031 rows=2 loops=16)

107. 0.336 0.336 ↑ 1.5 2 16

Index Scan using mamisil2 on gecelememusteri ""Extent42"" (cost=0.42..15.87 rows=3 width=33) (actual time=0.015..0.021 rows=2 loops=16)

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

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

  • Index Cond: (id = ""Extent42"".musteriid)
109. 0.012 46.121 ↑ 1.1 14 1

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

110. 0.023 46.109 ↑ 1.1 14 1

Nested Loop Left Join (cost=278.29..4,460.11 rows=16 width=733) (actual time=34.217..46.109 rows=14 loops=1)

111. 0.065 46.030 ↑ 1.1 14 1

Hash Left Join (cost=278.01..4,455.09 rows=16 width=506) (actual time=34.182..46.030 rows=14 loops=1)

  • Hash Cond: (""Extent51"".odemeid = ""Extent52"".id)
112. 10.837 45.944 ↑ 1.1 14 1

Hash Join (cost=276.90..4,453.93 rows=16 width=463) (actual time=34.107..45.944 rows=14 loops=1)

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

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

114. 0.046 0.662 ↓ 1.6 16 1

Hash (cost=276.77..276.77 rows=10 width=418) (actual time=0.662..0.662 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
115. 0.024 0.616 ↓ 1.6 16 1

Nested Loop Left Join (cost=56.52..276.77 rows=10 width=418) (actual time=0.286..0.616 rows=16 loops=1)

116. 0.027 0.576 ↓ 1.6 16 1

Hash Left Join (cost=56.38..275.20 rows=10 width=377) (actual time=0.274..0.576 rows=16 loops=1)

  • Hash Cond: (""Extent44"".acentaid = ""Extent46"".id)
117. 0.005 0.483 ↓ 1.6 16 1

Nested Loop (cost=46.95..265.74 rows=10 width=311) (actual time=0.191..0.483 rows=16 loops=1)

  • Join Filter: (""Extent44"".odakonumid = ""Extent48"".id)
118. 0.011 0.462 ↓ 1.6 16 1

Nested Loop Left Join (cost=46.95..262.35 rows=10 width=260) (actual time=0.181..0.462 rows=16 loops=1)

119. 0.023 0.403 ↓ 1.6 16 1

Hash Join (cost=46.53..178.00 rows=10 width=256) (actual time=0.156..0.403 rows=16 loops=1)

  • Hash Cond: (""Extent44"".fiyatkonumid = ""Extent49"".id)
120. 0.013 0.365 ↓ 1.6 16 1

Nested Loop Left Join (cost=45.17..176.61 rows=10 width=218) (actual time=0.128..0.365 rows=16 loops=1)

121. 0.073 0.304 ↓ 1.6 16 1

Hash Right Join (cost=44.75..92.26 rows=10 width=193) (actual time=0.116..0.304 rows=16 loops=1)

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

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

123. 0.012 0.080 ↓ 1.6 16 1

Hash (cost=44.63..44.63 rows=10 width=116) (actual time=0.080..0.080 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
124. 0.022 0.068 ↓ 1.6 16 1

Hash Left Join (cost=5.65..44.63 rows=10 width=116) (actual time=0.050..0.068 rows=16 loops=1)

  • Hash Cond: (""Extent44"".pansiyonid = ""Extent50"".id)
125. 0.021 0.035 ↓ 1.6 16 1

Bitmap Heap Scan on geceleme ""Extent44"" (cost=4.50..43.43 rows=10 width=77) (actual time=0.022..0.035 rows=16 loops=1)

  • Recheck Cond: (""Extent23"".id = rezid)
  • Heap Blocks: exact=11
126. 0.014 0.014 ↓ 1.6 16 1

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

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

Hash (cost=1.07..1.07 rows=7 width=39) (actual time=0.011..0.011 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.048 0.048 ↑ 1.0 1 16

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

  • Index Cond: (""Extent44"".id = id)
130. 0.009 0.015 ↑ 1.0 16 1

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

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

132. 0.048 0.048 ↑ 1.0 1 16

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

  • Index Cond: (id = ""Extent44"".id)
  • Heap Fetches: 16
133. 0.012 0.016 ↑ 16.0 1 16

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

134. 0.004 0.004 ↑ 16.0 1 1

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

135. 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
136. 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.003..0.032 rows=108 loops=1)

137. 0.016 0.016 ↑ 1.0 1 16

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

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

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

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

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

140. 0.056 0.056 ↑ 1.0 1 14

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

  • Index Cond: (""Extent54"".konumhamfiyatid = id)
141. 0.029 0.503 ↑ 1.0 9 1

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

142. 0.027 0.474 ↑ 1.0 9 1

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

  • Join Filter: (""Extent67"".kdvid = ""Extent71"".id)
  • Rows Removed by Join Filter: 9
143. 0.015 0.420 ↑ 1.0 9 1

Nested Loop Left Join (cost=4.60..47.37 rows=9 width=721) (actual time=0.338..0.420 rows=9 loops=1)

144. 0.006 0.378 ↑ 1.0 9 1

Nested Loop Left Join (cost=4.46..45.98 rows=9 width=681) (actual time=0.313..0.378 rows=9 loops=1)

145. 0.014 0.327 ↑ 1.0 9 1

Nested Loop Left Join (cost=4.17..43.21 rows=9 width=644) (actual time=0.283..0.327 rows=9 loops=1)

146. 0.009 0.286 ↑ 1.0 9 1

Nested Loop Left Join (cost=4.03..41.79 rows=9 width=593) (actual time=0.266..0.286 rows=9 loops=1)

147. 0.004 0.240 ↑ 1.0 1 1

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

148. 0.004 0.229 ↑ 1.0 1 1

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

149. 0.005 0.183 ↑ 1.0 1 1

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

150. 0.003 0.178 ↑ 1.0 1 1

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

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

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

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

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

  • Join Filter: (""Extent56"".tumbilbordid = ""Extent60"".id)
  • Rows Removed by Join Filter: 15
153. 0.003 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.065 ↑ 1.0 1 1

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

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

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

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

  • Index Cond: (id = 2898704)
  • 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.029 0.029 ↑ 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.029..0.029 rows=1 loops=1)

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

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

159. 0.011 0.011 ↑ 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.011..0.011 rows=1 loops=1)

  • Index Cond: (id = 2898704)
160. 0.010 0.010 ↓ 1.5 15 1

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

161. 0.006 0.006 ↑ 1.0 10 1

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

162. 0.022 0.075 ↑ 1.0 10 1

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

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

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.038..0.042 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.011 0.016 ↓ 1.5 15 1

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

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

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

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

169. 0.042 0.042 ↑ 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.041..0.042 rows=1 loops=1)

  • Index Cond: (rezid = ""Extent56"".id)
170. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (""Extent65"".faturaid = id)
171. 0.037 0.037 ↑ 1.0 9 1

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

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

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

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

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

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

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

  • Index Cond: (""Extent67"".dovizid = id)
175. 0.010 0.027 ↑ 1.5 2 9

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

176. 0.017 0.017 ↑ 1.5 2 1

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

177. 0.005 0.234 ↑ 2.0 1 1

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

178. 0.043 0.229 ↑ 2.0 1 1

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

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

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

180. 0.011 0.160 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
181. 0.002 0.149 ↑ 1.0 1 1

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

182. 0.003 0.147 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.145..0.147 rows=1 loops=1)

183. 0.004 0.144 ↑ 1.0 1 1

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

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

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

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

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

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

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

  • Join Filter: (""Extent72"".id = ""Extent75"".id)
187. 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: (""Extent72"".sirketid = ""Extent74"".id)
188. 0.002 0.026 ↑ 1.0 1 1

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

  • Join Filter: (""Extent72"".id = ""Extent73"".id)
189. 0.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

  • Index Cond: (id = 2898704)
  • 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.011 0.011 ↑ 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.011..0.011 rows=1 loops=1)

  • Index Cond: (id = 2898704)
  • Heap Fetches: 0
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.003..0.003 rows=1 loops=1)

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

  • Index Cond: (id = 2898704)
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.007 0.007 ↑ 1.0 10 1

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

195. 0.014 0.074 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent79"".id = ""Extent80"".id)
196. 0.027 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.008 0.014 ↓ 1.5 15 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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.011 0.015 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.014..0.015 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.003..0.004 rows=10 loops=1)