explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5ern

Settings
# exclusive inclusive rows x rows loops node
1. 1.780 1,405.253 ↓ 2.1 107 1

Sort (cost=66,027.02..66,027.15 rows=52 width=2,229) (actual time=1,405.248..1,405.253 rows=107 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: 132kB
2. 0.020 1,403.473 ↓ 2.1 107 1

Append (cost=34.17..66,025.54 rows=52 width=2,229) (actual time=0.275..1,403.473 rows=107 loops=1)

3. 0.167 1,403.247 ↓ 2.1 107 1

Subquery Scan on "UnionAll3" (cost=34.17..65,990.52 rows=50 width=2,235) (actual time=0.275..1,403.247 rows=107 loops=1)

4. 0.019 1,403.080 ↓ 2.1 107 1

Append (cost=34.17..65,990.02 rows=50 width=2,235) (actual time=0.272..1,403.080 rows=107 loops=1)

5. 0.021 1,402.734 ↓ 2.5 101 1

Append (cost=34.17..65,940.73 rows=41 width=1,940) (actual time=0.272..1,402.734 rows=101 loops=1)

6. 0.026 0.272 ↑ 3.0 1 1

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

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

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

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

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

9. 0.011 0.027 ↑ 1.0 44 1

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

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

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

11. 0.003 0.141 ↑ 1.0 1 1

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

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

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

13. 0.003 0.137 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.135..0.137 rows=1 loops=1)

14. 0.003 0.134 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2893068)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
21. 0.024 0.024 ↑ 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.024..0.024 rows=1 loops=1)

  • Index Cond: (id = 2893068)
  • Heap Fetches: 1
22. 0.009 0.009 ↑ 1.0 1 1

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

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

  • Index Cond: (id = 2893068)
24. 0.009 0.009 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent5"" (cost=0.00..1.10 rows=10 width=48) (actual time=0.006..0.009 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.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: (""Extent8"".id = ""Extent9"".id)
27. 0.014 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: (""Extent7"".id = ""Extent8"".id)
28. 0.004 0.004 ↑ 1.0 10 1

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

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

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

31. 0.002 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.006 0.006 ↑ 1.0 10 1

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

33. 0.000 0.100 ↓ 0.0 0 1

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

34. 0.001 0.100 ↓ 0.0 0 1

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

35. 0.002 0.090 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.088..0.090 rows=1 loops=1)

36. 0.002 0.088 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2893068)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
43. 0.004 0.004 ↑ 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.004..0.004 rows=1 loops=1)

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

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

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

47. 0.003 0.003 ↑ 1.0 10 1

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

48. 0.014 0.056 ↑ 1.0 10 1

Hash Left Join (cost=2.45..3.62 rows=10 width=32) (actual time=0.050..0.056 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.031..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.002..0.003 rows=10 loops=1)

51. 0.006 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.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.003 0.007 ↑ 1.0 10 1

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

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

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

55. 0.009 0.009 ↓ 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.009..0.009 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. 20.591 1,402.341 ↓ 4.8 100 1

Hash Join (cost=40,122.26..65,835.29 rows=21 width=1,793) (actual time=339.706..1,402.341 rows=100 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

66. 109.587 198.107 ↓ 1.0 353,896 1

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

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

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

68. 41.095 81.638 ↑ 1.0 112,160 1

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

  • Buckets: 131072 Batches: 2 Memory Usage: 7035kB
69. 40.543 40.543 ↑ 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.543 rows=112,160 loops=1)

70. 0.038 0.090 ↑ 1.0 108 1

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

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

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

72. 0.170 0.376 ↑ 1.0 538 1

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

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

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

74. 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
75. 0.009 0.009 ↑ 1.0 16 1

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

76. 0.008 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
77. 0.010 0.010 ↑ 1.0 16 1

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

78. 0.013 0.021 ↓ 1.1 8 1

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

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

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

80. 0.006 0.095 ↑ 1.0 1 1

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

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

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

82. 0.003 0.088 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.086..0.088 rows=1 loops=1)

83. 0.001 0.085 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

  • Join Filter: (""Extent23"".id = ""Extent24"".id)
89. 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 = 2893068)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
90. 0.008 0.008 ↑ 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.008..0.008 rows=1 loops=1)

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

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

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

94. 0.003 0.003 ↑ 1.0 10 1

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

95. 0.010 0.039 ↑ 1.0 10 1

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

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

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.019..0.023 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.002..0.003 rows=10 loops=1)

98. 0.003 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
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.003..0.005 rows=15 loops=1)

100. 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
101. 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)

102. 0.013 0.327 ↑ 1.5 6 1

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

103. 0.019 0.314 ↑ 1.5 6 1

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

  • Join Filter: (""Extent51"".kdvid = ""Extent55"".id)
  • Rows Removed by Join Filter: 6
104. 0.012 0.283 ↑ 1.5 6 1

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

105. 0.011 0.259 ↑ 1.5 6 1

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

106. 0.008 0.230 ↑ 1.5 6 1

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

107. 0.006 0.204 ↑ 1.5 6 1

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

108. 0.003 0.175 ↑ 1.0 1 1

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

109. 0.004 0.170 ↑ 1.0 1 1

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

110. 0.005 0.155 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.151..0.155 rows=1 loops=1)

111. 0.004 0.150 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=70) (actual time=0.048..0.048 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 = 2893068)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
118. 0.012 0.012 ↑ 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.012..0.012 rows=1 loops=1)

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

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

120. 0.020 0.020 ↑ 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.020..0.020 rows=1 loops=1)

  • Index Cond: (id = 2893068)
121. 0.011 0.011 ↓ 1.5 15 1

Seq Scan on tumbilbord ""Extent44"" (cost=0.00..1.10 rows=10 width=48) (actual time=0.007..0.011 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.006 0.041 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent47"".id = ""Extent48"".id)
124. 0.017 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: (""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.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
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.003..0.004 rows=15 loops=1)

128. 0.002 0.005 ↑ 1.0 10 1

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

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

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

130. 0.011 0.011 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (""Extent51"".dovizid = id)
136. 0.005 0.012 ↑ 1.5 2 6

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

137. 0.007 0.007 ↑ 1.5 2 1

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

138. 0.000 0.206 ↓ 0.0 0 1

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

139. 0.050 0.206 ↓ 0.0 0 1

Hash Join (cost=32.18..34.99 rows=2 width=2,102) (actual time=0.206..0.206 rows=0 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.008 0.140 ↑ 1.0 1 1

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

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

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

143. 0.003 0.130 ↑ 1.0 1 1

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

144. 0.004 0.127 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2893068)
  • Filter: ((NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
151. 0.012 0.012 ↑ 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.012..0.012 rows=1 loops=1)

  • Index Cond: (id = 2893068)
  • Heap Fetches: 1
152. 0.004 0.004 ↑ 1.0 1 1

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

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

  • Index Cond: (id = 2893068)
154. 0.007 0.007 ↓ 1.5 15 1

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

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

156. 0.014 0.052 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent63"".id = ""Extent64"".id)
157. 0.016 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)
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.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
160. 0.005 0.005 ↓ 1.5 15 1

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

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)