explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 53eJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.728 1,380.427 ↓ 1.4 71 1

Sort (cost=66,027.02..66,027.15 rows=52 width=2,229) (actual time=1,380.425..1,380.427 rows=71 loops=1)

  • Sort Key: ""UnionAll3"".""C2"", ""UnionAll3"".""C3"", ""UnionAll3"".""C4"", ""UnionAll3"".""C5"", ""UnionAll3"".""C6"", ""UnionAll3"".""C7"", ""UnionAll3"".""C9"", ""UnionAll3"".""C24"", ""UnionAll3"".""C45"", ""UnionAll3"".""C1"", ""UnionAll3"".""C84"", ""UnionAll3"".""C98"", ""UnionAll3"".""C107"", ""UnionAll3"".""C125"", ""UnionAll3"".""C141"", ""UnionAll3"".""C159"", ""UnionAll3"".""C174"", ""UnionAll3"".""C184"", ""UnionAll3"".""C192"", ""UnionAll3"".""C212"", ""UnionAll3"".""C221"", ""UnionAll3"".""C241"
  • Sort Method: quicksort Memory: 79kB
2. 0.011 1,379.699 ↓ 1.4 71 1

Append (cost=34.17..66,025.54 rows=52 width=2,229) (actual time=0.355..1,379.699 rows=71 loops=1)

3. 0.072 1,379.403 ↑ 1.0 48 1

Subquery Scan on "UnionAll3" (cost=34.17..65,990.52 rows=50 width=2,235) (actual time=0.355..1,379.403 rows=48 loops=1)

4. 0.009 1,379.331 ↑ 1.0 48 1

Append (cost=34.17..65,990.02 rows=50 width=2,235) (actual time=0.352..1,379.331 rows=48 loops=1)

5. 0.005 1,378.922 ↑ 1.1 37 1

Append (cost=34.17..65,940.73 rows=41 width=1,940) (actual time=0.352..1,378.922 rows=37 loops=1)

6. 0.028 0.353 ↑ 3.0 1 1

Hash Right Join (cost=34.17..38.29 rows=3 width=2,045) (actual time=0.352..0.353 rows=1 loops=1)

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

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

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

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

9. 0.021 0.039 ↑ 1.0 44 1

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

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

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

11. 0.010 0.190 ↑ 1.0 1 1

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

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

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

13. 0.003 0.179 ↑ 1.0 1 1

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

14. 0.002 0.176 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2897631)
  • 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))
21. 0.028 0.028 ↑ 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.028..0.028 rows=1 loops=1)

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

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

23. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (id = 2897631)
24. 0.007 0.007 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent5"" (cost=0.00..1.10 rows=10 width=48) (actual time=0.004..0.007 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.002..0.004 rows=10 loops=1)

26. 0.026 0.087 ↑ 1.0 10 1

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 0.006 0.006 ↓ 1.5 15 1

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

31. 0.009 0.017 ↑ 1.0 10 1

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

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

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

33. 0.001 0.172 ↓ 0.0 0 1

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

34. 0.001 0.171 ↓ 0.0 0 1

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

35. 0.003 0.152 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.150..0.152 rows=1 loops=1)

36. 0.001 0.149 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Hash Cond: (""Extent19"".id = ""Extent20"".id)
49. 0.022 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: (""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.012 0.018 ↓ 1.5 15 1

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

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

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

53. 0.011 0.016 ↑ 1.0 10 1

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

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

Seq Scan on tumbilbordek ""Extent20"" (cost=0.00..1.10 rows=10 width=4) (actual time=0.004..0.005 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. 21.178 1,378.392 ↓ 1.7 36 1

Hash Join (cost=40,122.26..65,835.29 rows=21 width=1,793) (actual time=861.772..1,378.392 rows=36 loops=1)

  • Hash Cond: (""Extent32"".rezid = ""Alias39"".id)
58. 131.927 1,357.069 ↓ 1.0 243,211 1

Hash Left Join (cost=40,090.09..64,892.20 rows=242,854 width=434) (actual time=276.371..1,357.069 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".pansiyonid = ""Extent37"".id)
59. 128.440 1,225.127 ↓ 1.0 243,211 1

Hash Left Join (cost=40,088.93..63,868.04 rows=242,854 width=395) (actual time=276.341..1,225.127 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent36"".id)
60. 124.765 1,096.671 ↓ 1.0 243,211 1

Hash Join (cost=40,087.57..63,215.68 rows=242,854 width=357) (actual time=276.310..1,096.671 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".odakonumid = ""Extent35"".id)
61. 119.856 971.875 ↓ 1.0 243,211 1

Hash Left Join (cost=40,086.21..62,407.97 rows=242,854 width=306) (actual time=276.264..971.875 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".odaid = ""Extent34"".id)
62. 111.717 851.641 ↓ 1.0 243,211 1

Hash Left Join (cost=40,040.11..61,721.17 rows=242,854 width=229) (actual time=275.872..851.641 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".acentaid = ""Extent33"".id)
63. 233.918 739.841 ↓ 1.0 243,211 1

Hash Right Join (cost=40,030.68..61,049.23 rows=242,854 width=163) (actual time=275.765..739.841 rows=243,211 loops=1)

  • Hash Cond: (""Extent38"".gecelemeid = ""Extent32"".id)
64. 185.381 423.815 ↑ 1.0 242,854 1

Hash Join (cost=29,677.08..41,992.12 rows=242,854 width=86) (actual time=192.871..423.815 rows=242,854 loops=1)

  • Hash Cond: (""Extent38"".musteriid = ""Extent39"".id)
65. 46.501 46.501 ↑ 1.0 242,854 1

Seq Scan on gecelememusteri ""Extent38"" (cost=0.00..4,456.54 rows=242,854 width=33) (actual time=0.011..46.501 rows=242,854 loops=1)

66. 105.412 191.933 ↓ 1.0 353,896 1

Hash (cost=21,868.70..21,868.70 rows=350,670 width=53) (actual time=191.933..191.933 rows=353,896 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 8545kB
67. 86.521 86.521 ↓ 1.0 353,896 1

Seq Scan on musteri ""Extent39"" (cost=0.00..21,868.70 rows=350,670 width=53) (actual time=0.009..86.521 rows=353,896 loops=1)

68. 41.629 82.108 ↑ 1.0 112,160 1

Hash (cost=7,527.60..7,527.60 rows=112,160 width=77) (actual time=82.108..82.108 rows=112,160 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 7035kB
69. 40.479 40.479 ↑ 1.0 112,160 1

Seq Scan on geceleme ""Extent32"" (cost=0.00..7,527.60 rows=112,160 width=77) (actual time=0.009..40.479 rows=112,160 loops=1)

70. 0.034 0.083 ↑ 1.0 108 1

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

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

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

72. 0.184 0.378 ↑ 1.0 538 1

Hash (cost=39.38..39.38 rows=538 width=77) (actual time=0.378..0.378 rows=538 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
73. 0.194 0.194 ↑ 1.0 538 1

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

74. 0.013 0.031 ↑ 1.0 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
75. 0.018 0.018 ↑ 1.0 16 1

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

76. 0.007 0.016 ↑ 1.0 16 1

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

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

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

78. 0.008 0.015 ↓ 1.1 8 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
79. 0.007 0.007 ↓ 1.1 8 1

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

80. 0.005 0.145 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
81. 0.001 0.140 ↑ 1.0 1 1

Subquery Scan on "Alias39" (cost=3.31..32.16 rows=1 width=278) (actual time=0.138..0.140 rows=1 loops=1)

82. 0.002 0.139 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.138..0.139 rows=1 loops=1)

83. 0.001 0.137 ↑ 1.0 1 1

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

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

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

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

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

  • Join Filter: (""Extent23"".tumbilbordid = ""Extent27"".id)
  • Rows Removed by Join Filter: 15
86. 0.000 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: (""Extent23"".id = ""Extent26"".id)
87. 0.000 0.039 ↑ 1.0 1 1

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

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

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

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

  • Index Cond: (id = 2897631)
  • 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))
90. 0.015 0.015 ↑ 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.015..0.015 rows=1 loops=1)

  • Index Cond: (id = 2897631)
  • Heap Fetches: 0
91. 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)

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

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

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

95. 0.028 0.077 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent30"".id = ""Extent31"".id)
96. 0.023 0.036 ↑ 1.0 10 1

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

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

98. 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
99. 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)

100. 0.008 0.013 ↑ 1.0 10 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
101. 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.003..0.005 rows=10 loops=1)

102. 0.022 0.400 ↓ 1.2 11 1

Subquery Scan on "*SELECT* 2_1" (cost=4.60..48.88 rows=9 width=1,917) (actual time=0.259..0.400 rows=11 loops=1)

103. 0.024 0.378 ↓ 1.2 11 1

Nested Loop Left Join (cost=4.60..48.77 rows=9 width=1,913) (actual time=0.253..0.378 rows=11 loops=1)

  • Join Filter: (""Extent51"".kdvid = ""Extent55"".id)
  • Rows Removed by Join Filter: 23
104. 0.017 0.332 ↓ 1.2 11 1

Nested Loop Left Join (cost=4.60..47.37 rows=9 width=721) (actual time=0.230..0.332 rows=11 loops=1)

105. 0.009 0.304 ↓ 1.2 11 1

Nested Loop Left Join (cost=4.46..45.98 rows=9 width=681) (actual time=0.224..0.304 rows=11 loops=1)

106. 0.021 0.262 ↓ 1.2 11 1

Nested Loop Left Join (cost=4.17..43.21 rows=9 width=644) (actual time=0.210..0.262 rows=11 loops=1)

107. 0.009 0.219 ↓ 1.2 11 1

Nested Loop Left Join (cost=4.03..41.79 rows=9 width=593) (actual time=0.193..0.219 rows=11 loops=1)

108. 0.005 0.186 ↓ 2.0 2 1

Nested Loop Left Join (cost=3.74..40.67 rows=1 width=440) (actual time=0.178..0.186 rows=2 loops=1)

109. 0.004 0.179 ↓ 2.0 2 1

Nested Loop (cost=3.59..40.48 rows=1 width=315) (actual time=0.173..0.179 rows=2 loops=1)

110. 0.005 0.145 ↑ 1.0 1 1

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

111. 0.004 0.140 ↑ 1.0 1 1

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

  • Join Filter: (""Extent40"".tumbilbordid = ""Extent47"".id)
  • Rows Removed by Join Filter: 10
112. 0.003 0.093 ↑ 1.0 1 1

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

  • Join Filter: (""Extent44"".id = ""Extent45"".id)
  • Rows Removed by Join Filter: 10
113. 0.003 0.084 ↑ 1.0 1 1

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

  • Join Filter: (""Extent40"".tumbilbordid = ""Extent44"".id)
  • Rows Removed by Join Filter: 15
114. 0.003 0.071 ↑ 1.0 1 1

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

  • Join Filter: (""Extent40"".id = ""Extent43"".id)
115. 0.002 0.057 ↑ 1.0 1 1

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

  • Join Filter: (""Extent40"".sirketid = ""Extent42"".id)
116. 0.004 0.047 ↑ 1.0 1 1

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

  • Join Filter: (""Extent40"".id = ""Extent41"".id)
117. 0.032 0.032 ↑ 1.0 1 1

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

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

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

  • Index Cond: (id = 2897631)
  • Heap Fetches: 0
119. 0.008 0.008 ↑ 1.0 1 1

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

120. 0.011 0.011 ↑ 1.0 1 1

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

  • Index Cond: (id = 2897631)
121. 0.010 0.010 ↓ 1.5 15 1

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

122. 0.006 0.006 ↑ 1.0 10 1

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

123. 0.009 0.043 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent47"".id = ""Extent48"".id)
124. 0.016 0.028 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent46"".id = ""Extent47"".id)
125. 0.004 0.004 ↑ 1.0 10 1

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

126. 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
127. 0.004 0.004 ↓ 1.5 15 1

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

128. 0.002 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
129. 0.004 0.004 ↑ 1.0 10 1

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

130. 0.030 0.030 ↓ 2.0 2 1

Index Scan using ""folio_IX_rezid"" on folio ""Extent49"" (cost=0.29..8.30 rows=1 width=37) (actual time=0.028..0.030 rows=2 loops=1)

  • Index Cond: (rezid = ""Extent40"".id)
131. 0.002 0.002 ↓ 0.0 0 2

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

  • Index Cond: (""Extent49"".faturaid = id)
132. 0.024 0.024 ↑ 1.5 6 2

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk ""Extent51"" (cost=0.29..1.03 rows=9 width=153) (actual time=0.008..0.012 rows=6 loops=2)

  • Index Cond: (""Extent49"".id = folioid)
133. 0.022 0.022 ↑ 1.0 1 11

Index Scan using ""PK_public.depkod"" on depkod ""Extent52"" (cost=0.14..0.16 rows=1 width=51) (actual time=0.002..0.002 rows=1 loops=11)

  • Index Cond: (""Extent51"".depkodid = id)
134. 0.033 0.033 ↑ 1.0 1 11

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

  • Index Cond: (""Extent51"".kaynakfolioid = id)
135. 0.011 0.011 ↑ 1.0 1 11

Index Scan using ""PK_public.doviz"" on doviz ""Extent54"" (cost=0.14..0.16 rows=1 width=40) (actual time=0.001..0.001 rows=1 loops=11)

  • Index Cond: (""Extent51"".dovizid = id)
136. 0.015 0.022 ↑ 1.0 3 11

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

137. 0.007 0.007 ↑ 1.0 3 1

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

138. 0.026 0.285 ↓ 11.5 23 1

Subquery Scan on "*SELECT* 2" (cost=32.18..35.01 rows=2 width=2,102) (actual time=0.209..0.285 rows=23 loops=1)

139. 0.072 0.259 ↓ 11.5 23 1

Hash Join (cost=32.18..34.99 rows=2 width=2,102) (actual time=0.205..0.259 rows=23 loops=1)

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

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

141. 0.007 0.171 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
142. 0.002 0.164 ↑ 1.0 1 1

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

143. 0.003 0.162 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.159..0.162 rows=1 loops=1)

144. 0.004 0.159 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".tumbilbordid = ""Extent63"".id)
  • Rows Removed by Join Filter: 10
145. 0.003 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: (""Extent60"".id = ""Extent61"".id)
  • Rows Removed by Join Filter: 10
146. 0.003 0.046 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2897631)
  • Heap Fetches: 0
152. 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)

153. 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 = 2897631)
154. 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)

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

156. 0.015 0.100 ↑ 1.0 10 1

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

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

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

  • Hash Cond: (""Extent62"".id = ""Extent63"".id)
158. 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)

159. 0.025 0.033 ↓ 1.5 15 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
160. 0.008 0.008 ↓ 1.5 15 1

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

161. 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
162. 0.004 0.004 ↑ 1.0 10 1

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