explain.depesz.com

PostgreSQL's explain analyze made readable

Result: migV

Settings
# exclusive inclusive rows x rows loops node
1. 1.383 4.977 ↑ 1.2 58 1

Sort (cost=1,137.11..1,137.28 rows=69 width=2,574) (actual time=4.975..4.977 rows=58 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: 79kB
2. 0.007 3.594 ↑ 1.2 58 1

Append (cost=30.17..1,135.00 rows=69 width=2,574) (actual time=0.365..3.594 rows=58 loops=1)

3. 0.079 3.425 ↑ 1.2 58 1

Subquery Scan on "UnionAll4" (cost=30.17..1,103.99 rows=67 width=2,580) (actual time=0.364..3.425 rows=58 loops=1)

4. 0.007 3.346 ↑ 1.2 58 1

Append (cost=30.17..1,103.32 rows=67 width=2,580) (actual time=0.362..3.346 rows=58 loops=1)

5. 0.006 3.015 ↑ 1.1 51 1

Append (cost=30.17..1,057.85 rows=58 width=2,181) (actual time=0.362..3.015 rows=51 loops=1)

6. 0.036 0.363 ↑ 3.0 1 1

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

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

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

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

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

9. 0.016 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.015 0.015 ↑ 1.0 44 1

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

11. 0.010 0.196 ↑ 1.0 1 1

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

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

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

13. 0.004 0.185 ↑ 1.0 1 1

Limit (cost=3.31..28.15 rows=1 width=278) (actual time=0.182..0.185 rows=1 loops=1)

14. 0.003 0.181 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2901454)
  • 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.026 0.026 ↑ 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.026..0.026 rows=1 loops=1)

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

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

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

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

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

25. 0.006 0.006 ↑ 1.0 10 1

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

26. 0.022 0.078 ↑ 1.0 10 1

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

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

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.044..0.048 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.006 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
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.008 ↑ 1.0 10 1

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

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

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

33. 0.000 0.153 ↓ 0.0 0 1

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

34. 0.002 0.153 ↓ 0.0 0 1

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

35. 0.002 0.138 ↑ 1.0 1 1

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

36. 0.001 0.136 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2901454)
  • 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.043 0.043 ↑ 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.043..0.043 rows=1 loops=1)

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

Seq Scan on sirket ""Extent14"" (cost=0.00..1.01 rows=1 width=72) (actual time=0.006..0.006 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 = 2901454)
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.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: (""Extent19"".id = ""Extent20"".id)
49. 0.020 0.035 ↑ 1.0 10 1

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.032..0.035 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.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
52. 0.004 0.004 ↓ 1.5 15 1

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

53. 0.003 0.006 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.006..0.006 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.013 0.013 ↓ 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.013..0.013 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.099 2.493 ↓ 1.3 50 1

Nested Loop (cost=62.16..960.25 rows=38 width=2,050) (actual time=0.730..2.493 rows=50 loops=1)

58. 0.003 0.107 ↑ 1.0 1 1

Limit (cost=3.31..28.15 rows=1 width=278) (actual time=0.104..0.107 rows=1 loops=1)

59. 0.001 0.104 ↑ 1.0 1 1

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

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

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

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

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

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

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

  • Join Filter: (""Extent23"".id = ""Extent26"".id)
63. 0.001 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.001 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 = 2901454)
  • 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..4.30 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = 2901454)
  • Heap Fetches: 0
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.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (id = 2901454)
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.017 0.063 ↑ 1.0 10 1

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

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

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

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

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

74. 0.012 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
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.004 0.008 ↑ 1.0 10 1

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

78. 0.008 2.287 ↓ 1.3 50 1

Append (cost=58.85..931.70 rows=38 width=708) (actual time=0.616..2.287 rows=50 loops=1)

79. 0.022 1.225 ↓ 1.5 32 1

Subquery Scan on "*SELECT* 1" (cost=58.85..459.21 rows=22 width=689) (actual time=0.615..1.225 rows=32 loops=1)

80. 0.026 1.203 ↓ 1.5 32 1

Nested Loop Left Join (cost=58.85..458.99 rows=22 width=689) (actual time=0.613..1.203 rows=32 loops=1)

81. 0.027 0.937 ↓ 1.6 16 1

Nested Loop Left Join (cost=58.01..276.28 rows=10 width=461) (actual time=0.578..0.937 rows=16 loops=1)

82. 0.014 0.894 ↓ 1.6 16 1

Nested Loop Left Join (cost=57.87..274.70 rows=10 width=420) (actual time=0.568..0.894 rows=16 loops=1)

83. 0.046 0.848 ↓ 1.6 16 1

Hash Left Join (cost=57.74..273.22 rows=10 width=377) (actual time=0.557..0.848 rows=16 loops=1)

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

Nested Loop Left Join (cost=48.31..263.76 rows=10 width=311) (actual time=0.440..0.706 rows=16 loops=1)

85. 0.026 0.651 ↓ 1.6 16 1

Hash Left Join (cost=47.89..179.41 rows=10 width=307) (actual time=0.428..0.651 rows=16 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent37"".id)
86. 0.024 0.609 ↓ 1.6 16 1

Hash Join (cost=46.53..178.01 rows=10 width=269) (actual time=0.398..0.609 rows=16 loops=1)

  • Hash Cond: (""Extent32"".odakonumid = ""Extent36"".id)
87. 0.013 0.566 ↓ 1.6 16 1

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

88. 0.072 0.441 ↓ 1.6 16 1

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

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

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

90. 0.010 0.148 ↓ 1.6 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
91. 0.042 0.138 ↓ 1.6 16 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

99. 0.006 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.010 0.010 ↑ 1.0 16 1

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

101. 0.032 0.032 ↑ 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.002..0.002 rows=1 loops=16)

  • Index Cond: (id = ""Extent32"".id)
  • Heap Fetches: 16
102. 0.042 0.096 ↑ 1.0 108 1

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

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

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

104. 0.032 0.032 ↑ 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.002..0.002 rows=1 loops=16)

  • Index Cond: (""Extent39"".odemeid = id)
105. 0.016 0.016 ↑ 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.001..0.001 rows=1 loops=16)

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

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

107. 0.112 0.112 ↑ 1.5 2 16

Index Scan using mamisil2 on gecelememusteri ""Extent42"" (cost=0.42..15.87 rows=3 width=33) (actual time=0.006..0.007 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 1.054 ↓ 1.1 18 1

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

110. 0.017 1.042 ↓ 1.1 18 1

Nested Loop Left Join (cost=58.72..472.33 rows=16 width=733) (actual time=0.638..1.042 rows=18 loops=1)

111. 0.018 0.989 ↓ 1.1 18 1

Nested Loop (cost=58.43..467.31 rows=16 width=506) (actual time=0.620..0.989 rows=18 loops=1)

  • Join Filter: (""Extent44"".id = ""Extent54"".gecelemeid)
112. 0.024 0.683 ↓ 1.6 16 1

Nested Loop (cost=58.01..196.82 rows=10 width=461) (actual time=0.426..0.683 rows=16 loops=1)

113. 0.023 0.643 ↓ 1.6 16 1

Nested Loop (cost=57.87..195.24 rows=10 width=420) (actual time=0.419..0.643 rows=16 loops=1)

114. 0.019 0.604 ↓ 1.6 16 1

Nested Loop (cost=57.74..193.76 rows=10 width=377) (actual time=0.410..0.604 rows=16 loops=1)

  • Join Filter: (""Extent44"".id = ""Extent51"".id)
115. 0.027 0.553 ↓ 1.6 16 1

Hash Join (cost=57.32..188.87 rows=10 width=352) (actual time=0.398..0.553 rows=16 loops=1)

  • Hash Cond: (""Extent44"".fiyatkonumid = ""Extent49"".id)
116. 0.026 0.508 ↓ 1.6 16 1

Hash Join (cost=55.96..187.47 rows=10 width=314) (actual time=0.366..0.508 rows=16 loops=1)

  • Hash Cond: (""Extent44"".odakonumid = ""Extent48"".id)
117. 0.022 0.468 ↓ 1.6 16 1

Hash Join (cost=54.60..186.07 rows=10 width=263) (actual time=0.336..0.468 rows=16 loops=1)

  • Hash Cond: (""Extent44"".acentaid = ""Extent46"".id)
118. 0.017 0.383 ↓ 1.6 16 1

Nested Loop (cost=45.17..176.61 rows=10 width=197) (actual time=0.263..0.383 rows=16 loops=1)

119. 0.064 0.302 ↓ 1.6 16 1

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

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

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

121. 0.011 0.068 ↓ 1.6 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
122. 0.019 0.057 ↓ 1.6 16 1

Hash Join (cost=5.65..44.63 rows=10 width=116) (actual time=0.038..0.057 rows=16 loops=1)

  • Hash Cond: (""Extent44"".pansiyonid = ""Extent50"".id)
123. 0.017 0.029 ↓ 1.6 16 1

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

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

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

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

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

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

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

127. 0.064 0.064 ↑ 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.004..0.004 rows=1 loops=16)

  • Index Cond: (id = ""Extent44"".id)
  • Heap Fetches: 16
128. 0.033 0.063 ↑ 1.0 108 1

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

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

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

130. 0.008 0.014 ↑ 1.0 16 1

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

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

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

132. 0.009 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.009 0.009 ↑ 1.0 16 1

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

134. 0.032 0.032 ↑ 1.0 1 16

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

  • Index Cond: (id = ""Extent45"".id)
135. 0.016 0.016 ↑ 1.0 1 16

Index Scan using ""PK_public.odeme"" on odeme ""Extent52"" (cost=0.13..0.15 rows=1 width=43) (actual time=0.001..0.001 rows=1 loops=16)

  • Index Cond: (id = ""Extent51"".odemeid)
136. 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: (id = ""Extent51"".pazarid)
137. 0.288 0.288 ↑ 885.0 1 16

Index Scan using ""hesayr_IX_gecelemeid"" on hesayr ""Extent54"" (cost=0.42..15.99 rows=885 width=45) (actual time=0.017..0.018 rows=1 loops=16)

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

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

  • Index Cond: (""Extent54"".konumhamfiyatid = id)
139. 0.014 0.324 ↑ 1.3 7 1

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

140. 0.019 0.310 ↑ 1.3 7 1

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

  • Join Filter: (""Extent67"".kdvid = ""Extent71"".id)
  • Rows Removed by Join Filter: 10
141. 0.009 0.277 ↑ 1.3 7 1

Nested Loop Left Join (cost=4.60..43.37 rows=9 width=721) (actual time=0.207..0.277 rows=7 loops=1)

142. 0.009 0.226 ↑ 1.3 7 1

Nested Loop Left Join (cost=4.46..41.98 rows=9 width=681) (actual time=0.169..0.226 rows=7 loops=1)

143. 0.005 0.196 ↑ 1.3 7 1

Nested Loop Left Join (cost=4.17..39.21 rows=9 width=644) (actual time=0.158..0.196 rows=7 loops=1)

144. 0.006 0.170 ↑ 1.3 7 1

Nested Loop Left Join (cost=4.03..37.79 rows=9 width=593) (actual time=0.148..0.170 rows=7 loops=1)

145. 0.003 0.142 ↓ 2.0 2 1

Nested Loop Left Join (cost=3.74..36.67 rows=1 width=440) (actual time=0.135..0.142 rows=2 loops=1)

146. 0.002 0.133 ↓ 2.0 2 1

Nested Loop (cost=3.59..36.48 rows=1 width=315) (actual time=0.127..0.133 rows=2 loops=1)

147. 0.003 0.116 ↑ 1.0 1 1

Limit (cost=3.31..28.15 rows=1 width=278) (actual time=0.113..0.116 rows=1 loops=1)

148. 0.002 0.113 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2901454)
  • 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 = 2901454)
158. 0.006 0.006 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent60"" (cost=0.00..1.10 rows=10 width=48) (actual time=0.003..0.006 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.015 0.066 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent63"".id = ""Extent64"".id)
161. 0.018 0.033 ↑ 1.0 10 1

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

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

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

163. 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
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.004 0.018 ↑ 1.0 10 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
166. 0.014 0.014 ↑ 1.0 10 1

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

167. 0.015 0.015 ↓ 2.0 2 1

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

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

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

  • Index Cond: (""Extent65"".faturaid = id)
169. 0.022 0.022 ↑ 2.2 4 2

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk ""Extent67"" (cost=0.29..1.03 rows=9 width=153) (actual time=0.009..0.011 rows=4 loops=2)

  • Index Cond: (""Extent65"".id = folioid)
170. 0.021 0.021 ↑ 1.0 1 7

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

  • Index Cond: (""Extent67"".depkodid = id)
171. 0.021 0.021 ↑ 1.0 1 7

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

  • Index Cond: (""Extent67"".kaynakfolioid = id)
172. 0.042 0.042 ↑ 1.0 1 7

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

  • Index Cond: (""Extent67"".dovizid = id)
173. 0.008 0.014 ↑ 1.5 2 7

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

174. 0.006 0.006 ↑ 1.0 3 1

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

175. 0.000 0.162 ↓ 0.0 0 1

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

176. 0.023 0.162 ↓ 0.0 0 1

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

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

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

178. 0.004 0.125 ↑ 1.0 1 1

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

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

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

180. 0.002 0.120 ↑ 1.0 1 1

Limit (cost=3.31..28.15 rows=1 width=278) (actual time=0.118..0.120 rows=1 loops=1)

181. 0.002 0.118 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2901454)
  • 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.018 0.018 ↑ 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.018..0.018 rows=1 loops=1)

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

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

192. 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)

193. 0.016 0.062 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent79"".id = ""Extent80"".id)
194. 0.020 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: (""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.002..0.003 rows=10 loops=1)

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

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

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