explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eAPm

Settings
# exclusive inclusive rows x rows loops node
1. 1.250 55.642 ↑ 1.2 58 1

Sort (cost=5,122.94..5,123.11 rows=69 width=2,574) (actual time=55.640..55.642 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.008 54.392 ↑ 1.2 58 1

Append (cost=30.17..5,120.83 rows=69 width=2,574) (actual time=0.347..54.392 rows=58 loops=1)

3. 0.078 54.193 ↑ 1.2 58 1

Subquery Scan on "UnionAll4" (cost=30.17..5,089.82 rows=67 width=2,580) (actual time=0.347..54.193 rows=58 loops=1)

4. 0.007 54.115 ↑ 1.2 58 1

Append (cost=30.17..5,089.15 rows=67 width=2,580) (actual time=0.345..54.115 rows=58 loops=1)

5. 0.007 53.650 ↑ 1.1 51 1

Append (cost=30.17..5,043.68 rows=58 width=2,181) (actual time=0.344..53.650 rows=51 loops=1)

6. 0.028 0.345 ↑ 3.0 1 1

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

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

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

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

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

9. 0.015 0.030 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=42) (actual time=0.030..0.030 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.006..0.015 rows=44 loops=1)

11. 0.004 0.204 ↑ 1.0 1 1

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

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

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

13. 0.004 0.199 ↑ 1.0 1 1

Limit (cost=3.31..28.15 rows=1 width=278) (actual time=0.197..0.199 rows=1 loops=1)

14. 0.003 0.195 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

26. 0.017 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: (""Extent8"".id = ""Extent9"".id)
27. 0.027 0.043 ↑ 1.0 10 1

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

  • Hash Cond: (""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.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
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.142 ↓ 0.0 0 1

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

34. 0.005 0.142 ↓ 0.0 0 1

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

35. 0.002 0.119 ↑ 1.0 1 1

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

36. 0.003 0.117 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2901454)
  • 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.006 0.006 ↑ 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.006..0.006 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.012 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: (""Extent19"".id = ""Extent20"".id)
49. 0.014 0.027 ↑ 1.0 10 1

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

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

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

51. 0.004 0.008 ↓ 1.5 15 1

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

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

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

53. 0.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
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.018 0.018 ↓ 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.018..0.018 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.094 53.156 ↓ 1.3 50 1

Nested Loop (cost=62.16..4,946.08 rows=38 width=2,050) (actual time=0.868..53.156 rows=50 loops=1)

58. 0.007 0.131 ↑ 1.0 1 1

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

59. 0.002 0.124 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

  • Join Filter: (""Extent23"".sirketid = ""Extent25"".id)
64. 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: (""Extent23"".id = ""Extent24"".id)
65. 0.008 0.008 ↑ 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.008..0.008 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.021 0.021 ↑ 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.021..0.021 rows=1 loops=1)

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

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

71. 0.012 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.027 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: (""Extent29"".id = ""Extent30"".id)
73. 0.003 0.003 ↑ 1.0 10 1

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

74. 0.005 0.010 ↓ 1.5 15 1

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

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

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

76. 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
77. 0.005 0.005 ↑ 1.0 10 1

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

78. 0.009 52.931 ↓ 1.3 50 1

Append (cost=58.85..4,917.53 rows=38 width=708) (actual time=0.739..52.931 rows=50 loops=1)

79. 0.022 1.550 ↓ 1.5 32 1

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

80. 0.042 1.528 ↓ 1.5 32 1

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

81. 0.014 1.134 ↓ 1.6 16 1

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

82. 0.017 1.088 ↓ 1.6 16 1

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

83. 0.030 1.039 ↓ 1.6 16 1

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

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

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

85. 0.023 0.844 ↓ 1.6 16 1

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

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

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

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

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

88. 0.060 0.506 ↓ 1.6 16 1

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

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

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

90. 0.013 0.231 ↓ 1.6 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
91. 0.033 0.218 ↓ 1.6 16 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

99. 0.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
100. 0.009 0.009 ↑ 1.0 16 1

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

101. 0.048 0.048 ↑ 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.003..0.003 rows=1 loops=16)

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

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

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

Seq Scan on acenta ""Extent34"" (cost=0.00..8.08 rows=108 width=66) (actual time=0.006..0.060 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.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.016 0.352 ↑ 1.5 2 16

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

107. 0.208 0.208 ↑ 1.5 2 16

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

  • Index Cond: (""Extent32"".id = gecelemeid)
108. 0.128 0.128 ↑ 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.004..0.004 rows=1 loops=32)

  • Index Cond: (id = ""Extent42"".musteriid)
109. 0.013 51.372 ↓ 1.1 18 1

Subquery Scan on "*SELECT* 2_2" (cost=276.32..4,458.32 rows=16 width=733) (actual time=49.607..51.372 rows=18 loops=1)

110. 0.025 51.359 ↓ 1.1 18 1

Nested Loop Left Join (cost=276.32..4,458.16 rows=16 width=733) (actual time=49.604..51.359 rows=18 loops=1)

111. 0.045 51.280 ↓ 1.1 18 1

Hash Left Join (cost=276.03..4,453.14 rows=16 width=506) (actual time=49.558..51.280 rows=18 loops=1)

  • Hash Cond: (""Extent51"".odemeid = ""Extent52"".id)
112. 11.022 51.210 ↓ 1.1 18 1

Hash Join (cost=274.92..4,451.96 rows=16 width=463) (actual time=49.501..51.210 rows=18 loops=1)

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

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

114. 0.032 0.615 ↓ 1.6 16 1

Hash (cost=274.79..274.79 rows=10 width=418) (actual time=0.615..0.615 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
115. 0.020 0.583 ↓ 1.6 16 1

Nested Loop Left Join (cost=57.88..274.79 rows=10 width=418) (actual time=0.385..0.583 rows=16 loops=1)

116. 0.026 0.547 ↓ 1.6 16 1

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

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

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

118. 0.023 0.412 ↓ 1.6 16 1

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

  • Hash Cond: (""Extent44"".fiyatkonumid = ""Extent49"".id)
119. 0.021 0.377 ↓ 1.6 16 1

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

  • Hash Cond: (""Extent44"".odakonumid = ""Extent48"".id)
120. 0.006 0.342 ↓ 1.6 16 1

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

121. 0.064 0.288 ↓ 1.6 16 1

Hash Right Join (cost=44.75..92.26 rows=10 width=193) (actual time=0.223..0.288 rows=16 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.003..0.150 rows=538 loops=1)

123. 0.009 0.074 ↓ 1.6 16 1

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

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

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

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

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

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

Bitmap Index Scan on ""geceleme_GecelemeRezId"" (cost=0.00..4.49 rows=10 width=0) (actual time=0.011..0.011 rows=16 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.003..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.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.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
133. 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)

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

  • Index Cond: (id = ""Extent44"".id)
  • Heap Fetches: 16
135. 0.032 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.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.011 0.025 ↑ 1.0 5 1

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

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

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

140. 0.054 0.054 ↓ 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.003..0.003 rows=0 loops=18)

  • Index Cond: (""Extent54"".konumhamfiyatid = id)
141. 0.029 0.458 ↑ 1.3 7 1

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

142. 0.023 0.429 ↑ 1.3 7 1

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

  • Join Filter: (""Extent67"".kdvid = ""Extent71"".id)
  • Rows Removed by Join Filter: 10
143. 0.012 0.392 ↑ 1.3 7 1

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

144. 0.013 0.359 ↑ 1.3 7 1

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

145. 0.014 0.304 ↑ 1.3 7 1

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

146. 0.007 0.269 ↑ 1.3 7 1

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

147. 0.005 0.206 ↓ 2.0 2 1

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

148. 0.005 0.195 ↓ 2.0 2 1

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

149. 0.004 0.139 ↑ 1.0 1 1

Limit (cost=3.31..28.15 rows=1 width=278) (actual time=0.136..0.139 rows=1 loops=1)

150. 0.003 0.135 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

  • Join Filter: (""Extent56"".id = ""Extent57"".id)
156. 0.019 0.019 ↑ 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.019..0.019 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))
157. 0.016 0.016 ↑ 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.016..0.016 rows=1 loops=1)

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

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

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

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

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

162. 0.014 0.055 ↑ 1.0 10 1

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

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

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

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

167. 0.008 0.011 ↑ 1.0 10 1

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

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

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

169. 0.051 0.051 ↓ 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.033..0.051 rows=2 loops=1)

  • Index Cond: (rezid = ""Extent56"".id)
170. 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)
171. 0.056 0.056 ↑ 2.2 4 2

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

  • Index Cond: (""Extent65"".id = folioid)
172. 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)
173. 0.042 0.042 ↑ 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.006..0.006 rows=1 loops=7)

  • Index Cond: (""Extent67"".kaynakfolioid = id)
174. 0.021 0.021 ↑ 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.003..0.003 rows=1 loops=7)

  • Index Cond: (""Extent67"".dovizid = id)
175. 0.007 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)

176. 0.007 0.007 ↑ 1.0 3 1

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

177. 0.000 0.191 ↓ 0.0 0 1

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

178. 0.022 0.191 ↓ 0.0 0 1

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

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

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

180. 0.015 0.153 ↑ 1.0 1 1

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

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

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

182. 0.004 0.136 ↑ 1.0 1 1

Limit (cost=3.31..28.15 rows=1 width=278) (actual time=0.133..0.136 rows=1 loops=1)

183. 0.003 0.132 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.31..28.15 rows=1 width=278) (actual time=0.132..0.132 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..24.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.004 0.059 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent72"".id = ""Extent75"".id)
187. 0.002 0.030 ↑ 1.0 1 1

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

  • Join Filter: (""Extent72"".sirketid = ""Extent74"".id)
188. 0.002 0.023 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..12.62 rows=1 width=70) (actual time=0.023..0.023 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 = 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))
190. 0.011 0.011 ↑ 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.010..0.011 rows=1 loops=1)

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

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

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

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

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

195. 0.027 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: (""Extent79"".id = ""Extent80"".id)
196. 0.013 0.026 ↑ 1.0 10 1

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

200. 0.005 0.010 ↑ 1.0 10 1

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

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

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