explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mRxh

Settings
# exclusive inclusive rows x rows loops node
1. 0.915 525.577 ↓ 1.4 71 1

Sort (cost=17,333.22..17,333.35 rows=52 width=2,456) (actual time=525.574..525.577 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"".""C126"", ""UnionAll3"".""C142"", ""UnionAll3"".""C160"", ""UnionAll3"".""C175"", ""UnionAll3"".""C185"", ""UnionAll3"".""C200"", ""UnionAll3"".""C201"", ""UnionAll3"".""C213"", ""UnionAll3"".""C223"", ""UnionAll3"".""C243"", ""UnionAll3"".""C252"", ""UnionAll3"".""C272"
  • Sort Method: quicksort Memory: 79kB
2. 0.010 524.662 ↓ 1.4 71 1

Append (cost=34.17..17,331.74 rows=52 width=2,456) (actual time=0.309..524.662 rows=71 loops=1)

3. 0.095 524.386 ↑ 1.0 48 1

Subquery Scan on "UnionAll3" (cost=34.17..17,296.72 rows=50 width=2,462) (actual time=0.308..524.386 rows=48 loops=1)

4. 0.009 524.291 ↑ 1.0 48 1

Append (cost=34.17..17,296.22 rows=50 width=2,462) (actual time=0.306..524.291 rows=48 loops=1)

5. 0.008 523.806 ↑ 1.1 37 1

Append (cost=34.17..17,246.93 rows=41 width=2,113) (actual time=0.306..523.806 rows=37 loops=1)

6. 0.035 0.306 ↑ 3.0 1 1

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

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

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

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

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

9. 0.020 0.034 ↑ 1.0 44 1

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

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

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

11. 0.007 0.152 ↑ 1.0 1 1

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

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

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

13. 0.003 0.144 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.142..0.144 rows=1 loops=1)

14. 0.002 0.141 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.31..32.15 rows=1 width=278) (actual time=0.141..0.141 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.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.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.001 0.059 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent1"".id = ""Extent2"".id)
20. 0.031 0.031 ↑ 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.031..0.031 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) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
21. 0.019 0.019 ↑ 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.019..0.019 rows=1 loops=1)

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

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

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

25. 0.005 0.005 ↑ 1.0 10 1

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

26. 0.013 0.051 ↑ 1.0 10 1

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

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

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

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

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

29. 0.007 0.011 ↓ 1.5 15 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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.002..0.004 rows=15 loops=1)

31. 0.004 0.007 ↑ 1.0 10 1

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

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

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

33. 0.000 0.124 ↓ 0.0 0 1

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

34. 0.001 0.124 ↓ 0.0 0 1

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

35. 0.003 0.103 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.101..0.103 rows=1 loops=1)

36. 0.002 0.100 ↑ 1.0 1 1

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

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

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

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

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

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

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

  • Join Filter: (""Extent12"".id = ""Extent15"".id)
40. 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: (""Extent12"".sirketid = ""Extent14"".id)
41. 0.001 0.019 ↑ 1.0 1 1

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

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

Index Scan using ""PK_public.rez"" on rez ""Extent12"" (cost=0.29..8.30 rows=1 width=66) (actual time=0.009..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) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
43. 0.008 0.008 ↑ 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.008..0.008 rows=1 loops=1)

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

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

45. 0.008 0.008 ↑ 1.0 1 1

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

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

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

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

  • Hash Cond: (""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.010 0.016 ↓ 1.5 15 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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.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.020 0.020 ↓ 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.020..0.020 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.115 523.368 ↓ 1.7 36 1

Nested Loop Left Join (cost=6,833.46..17,141.49 rows=21 width=1,914) (actual time=176.346..523.368 rows=36 loops=1)

58. 0.087 522.839 ↓ 1.8 18 1

Nested Loop Left Join (cost=6,832.62..17,111.83 rows=10 width=739) (actual time=176.273..522.839 rows=18 loops=1)

59. 0.089 522.644 ↓ 1.8 18 1

Hash Left Join (cost=6,832.48..17,110.25 rows=10 width=698) (actual time=176.245..522.644 rows=18 loops=1)

  • Hash Cond: (""Extent39"".odemeid = ""Extent40"".id)
60. 10.752 522.532 ↓ 1.8 18 1

Hash Join (cost=6,831.36..17,109.11 rows=10 width=655) (actual time=176.168..522.532 rows=18 loops=1)

  • Hash Cond: (""Extent32"".rezid = ""Alias39"".id)
61. 61.257 511.675 ↓ 1.0 111,995 1

Hash Left Join (cost=6,799.19..16,657.47 rows=111,830 width=377) (actual time=77.909..511.675 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".pansiyonid = ""Extent38"".id)
62. 58.040 450.404 ↓ 1.0 111,995 1

Hash Left Join (cost=6,798.03..16,185.24 rows=111,830 width=338) (actual time=77.880..450.404 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent37"".id)
63. 58.111 392.343 ↓ 1.0 111,995 1

Hash Join (cost=6,796.67..15,884.11 rows=111,830 width=300) (actual time=77.844..392.343 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".odakonumid = ""Extent36"".id)
64. 51.823 334.215 ↓ 1.0 111,995 1

Hash Left Join (cost=6,795.31..15,511.44 rows=111,830 width=249) (actual time=77.813..334.215 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".odaid = ""Extent35"".id)
65. 49.272 281.991 ↓ 1.0 111,995 1

Hash Left Join (cost=6,749.20..15,170.30 rows=111,830 width=172) (actual time=77.398..281.991 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".acentaid = ""Extent34"".id)
66. 56.458 232.629 ↓ 1.0 111,995 1

Hash Join (cost=6,739.77..14,855.80 rows=111,830 width=106) (actual time=77.277..232.629 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".id = ""Extent39"".id)
67. 49.237 131.272 ↑ 1.0 111,995 1

Hash Join (cost=3,369.89..11,191.92 rows=111,995 width=81) (actual time=31.781..131.272 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".id = ""Extent33"".id)
68. 51.020 51.020 ↑ 1.0 112,160 1

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

69. 18.225 31.015 ↑ 1.0 111,995 1

Hash (cost=1,969.95..1,969.95 rows=111,995 width=4) (actual time=31.015..31.015 rows=111,995 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4962kB
70. 12.790 12.790 ↑ 1.0 111,995 1

Seq Scan on gecelemedetayek ""Extent33"" (cost=0.00..1,969.95 rows=111,995 width=4) (actual time=0.012..12.790 rows=111,995 loops=1)

71. 25.431 44.899 ↑ 1.0 111,995 1

Hash (cost=1,969.95..1,969.95 rows=111,995 width=25) (actual time=44.899..44.899 rows=111,995 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 7259kB
72. 19.468 19.468 ↑ 1.0 111,995 1

Seq Scan on gecelemedetayek ""Extent39"" (cost=0.00..1,969.95 rows=111,995 width=25) (actual time=0.011..19.468 rows=111,995 loops=1)

73. 0.039 0.090 ↑ 1.0 108 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
74. 0.051 0.051 ↑ 1.0 108 1

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

75. 0.185 0.401 ↑ 1.0 538 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
76. 0.216 0.216 ↑ 1.0 538 1

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

77. 0.009 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
78. 0.008 0.008 ↑ 1.0 16 1

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

79. 0.011 0.021 ↑ 1.0 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
80. 0.010 0.010 ↑ 1.0 16 1

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

81. 0.007 0.014 ↓ 1.1 8 1

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

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

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

83. 0.006 0.105 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
84. 0.001 0.099 ↑ 1.0 1 1

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

85. 0.002 0.098 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.096..0.098 rows=1 loops=1)

86. 0.002 0.096 ↑ 1.0 1 1

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

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

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

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

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

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

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

  • Join Filter: (""Extent23"".id = ""Extent26"".id)
90. 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: (""Extent23"".sirketid = ""Extent25"".id)
91. 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: (""Extent23"".id = ""Extent24"".id)
92. 0.013 0.013 ↑ 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.013..0.013 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) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
93. 0.011 0.011 ↑ 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.011..0.011 rows=1 loops=1)

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

95. 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.009..0.010 rows=1 loops=1)

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

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

98. 0.011 0.045 ↑ 1.0 10 1

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

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

101. 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
102. 0.004 0.004 ↓ 1.5 15 1

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

103. 0.004 0.007 ↑ 1.0 10 1

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

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

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

105. 0.011 0.023 ↑ 1.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
106. 0.012 0.012 ↑ 1.0 5 1

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

107. 0.108 0.108 ↑ 1.0 1 18

Index Scan using ""PK_public.pazar"" on pazar ""Extent41"" (cost=0.14..0.16 rows=1 width=41) (actual time=0.006..0.006 rows=1 loops=18)

  • Index Cond: (""Extent39"".pazarid = id)
108. 0.054 0.414 ↑ 1.5 2 18

Nested Loop (cost=0.84..2.94 rows=3 width=86) (actual time=0.018..0.023 rows=2 loops=18)

109. 0.216 0.216 ↑ 1.5 2 18

Index Scan using mamisil2 on gecelememusteri ""Extent42"" (cost=0.42..0.57 rows=3 width=33) (actual time=0.010..0.012 rows=2 loops=18)

  • Index Cond: (""Extent32"".id = gecelemeid)
110. 0.144 0.144 ↑ 1.0 1 36

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

  • Index Cond: (id = ""Extent42"".musteriid)
111. 0.025 0.476 ↓ 1.2 11 1

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

112. 0.026 0.451 ↓ 1.2 11 1

Nested Loop Left Join (cost=4.60..48.77 rows=9 width=2,140) (actual time=0.323..0.451 rows=11 loops=1)

  • Join Filter: (""Extent55"".kdvid = ""Extent59"".id)
  • Rows Removed by Join Filter: 23
113. 0.019 0.403 ↓ 1.2 11 1

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

114. 0.010 0.373 ↓ 1.2 11 1

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

115. 0.018 0.330 ↓ 1.2 11 1

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

116. 0.010 0.290 ↓ 1.2 11 1

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

117. 0.004 0.254 ↓ 2.0 2 1

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

118. 0.005 0.242 ↓ 2.0 2 1

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

119. 0.006 0.213 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.209..0.213 rows=1 loops=1)

120. 0.002 0.207 ↑ 1.0 1 1

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

  • Join Filter: (""Extent44"".tumbilbordid = ""Extent51"".id)
  • Rows Removed by Join Filter: 10
121. 0.002 0.124 ↑ 1.0 1 1

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

  • Join Filter: (""Extent48"".id = ""Extent49"".id)
  • Rows Removed by Join Filter: 10
122. 0.003 0.113 ↑ 1.0 1 1

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

  • Join Filter: (""Extent44"".tumbilbordid = ""Extent48"".id)
  • Rows Removed by Join Filter: 15
123. 0.003 0.101 ↑ 1.0 1 1

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

  • Join Filter: (""Extent44"".id = ""Extent47"".id)
124. 0.002 0.088 ↑ 1.0 1 1

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

  • Join Filter: (""Extent44"".sirketid = ""Extent46"".id)
125. 0.003 0.076 ↑ 1.0 1 1

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

  • Join Filter: (""Extent44"".id = ""Extent45"".id)
126. 0.041 0.041 ↑ 1.0 1 1

Index Scan using ""PK_public.rez"" on rez ""Extent44"" (cost=0.29..8.30 rows=1 width=66) (actual time=0.041..0.041 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) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
127. 0.032 0.032 ↑ 1.0 1 1

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

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

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

129. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (id = 2897631)
130. 0.009 0.009 ↓ 1.5 15 1

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

131. 0.009 0.009 ↑ 1.0 10 1

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

132. 0.026 0.081 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent51"".id = ""Extent52"".id)
133. 0.028 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: (""Extent50"".id = ""Extent51"".id)
134. 0.004 0.004 ↑ 1.0 10 1

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

135. 0.007 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
136. 0.005 0.005 ↓ 1.5 15 1

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

137. 0.005 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
138. 0.006 0.006 ↑ 1.0 10 1

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

139. 0.024 0.024 ↓ 2.0 2 1

Index Scan using ""folio_IX_rezid"" on folio ""Extent53"" (cost=0.29..8.30 rows=1 width=37) (actual time=0.021..0.024 rows=2 loops=1)

  • Index Cond: (rezid = ""Extent44"".id)
140. 0.008 0.008 ↓ 0.0 0 2

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

  • Index Cond: (""Extent53"".faturaid = id)
141. 0.026 0.026 ↑ 1.5 6 2

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk ""Extent55"" (cost=0.29..1.03 rows=9 width=153) (actual time=0.009..0.013 rows=6 loops=2)

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

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

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

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

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

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

  • Index Cond: (""Extent55"".dovizid = id)
145. 0.016 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)

146. 0.006 0.006 ↑ 1.0 3 1

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

147. 0.026 0.266 ↓ 11.5 23 1

Subquery Scan on "*SELECT* 2" (cost=32.18..35.01 rows=2 width=2,329) (actual time=0.185..0.266 rows=23 loops=1)

148. 0.073 0.240 ↓ 11.5 23 1

Hash Join (cost=32.18..34.99 rows=2 width=2,329) (actual time=0.180..0.240 rows=23 loops=1)

  • Hash Cond: (""Extent69"".rezid = ""Alias77"".id)
149. 0.018 0.018 ↓ 1.3 73 1

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

150. 0.006 0.149 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
151. 0.001 0.143 ↑ 1.0 1 1

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

152. 0.004 0.142 ↑ 1.0 1 1

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

153. 0.003 0.138 ↑ 1.0 1 1

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

  • Join Filter: (""Extent60"".tumbilbordid = ""Extent67"".id)
  • Rows Removed by Join Filter: 10
154. 0.003 0.053 ↑ 1.0 1 1

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

  • Join Filter: (""Extent64"".id = ""Extent65"".id)
  • Rows Removed by Join Filter: 10
155. 0.002 0.047 ↑ 1.0 1 1

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

  • Join Filter: (""Extent60"".tumbilbordid = ""Extent64"".id)
  • Rows Removed by Join Filter: 15
156. 0.002 0.039 ↑ 1.0 1 1

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

  • Join Filter: (""Extent60"".id = ""Extent63"".id)
157. 0.001 0.029 ↑ 1.0 1 1

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

  • Join Filter: (""Extent60"".sirketid = ""Extent62"".id)
158. 0.001 0.023 ↑ 1.0 1 1

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

  • Join Filter: (""Extent60"".id = ""Extent61"".id)
159. 0.012 0.012 ↑ 1.0 1 1

Index Scan using ""PK_public.rez"" on rez ""Extent60"" (cost=0.29..8.30 rows=1 width=66) (actual time=0.012..0.012 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) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
160. 0.010 0.010 ↑ 1.0 1 1

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

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

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

162. 0.008 0.008 ↑ 1.0 1 1

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

  • Index Cond: (id = 2897631)
163. 0.006 0.006 ↓ 1.5 15 1

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

164. 0.003 0.003 ↑ 1.0 10 1

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

165. 0.026 0.082 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent67"".id = ""Extent68"".id)
166. 0.019 0.038 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent66"".id = ""Extent67"".id)
167. 0.004 0.004 ↑ 1.0 10 1

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

168. 0.011 0.015 ↓ 1.5 15 1

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

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

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

170. 0.013 0.018 ↑ 1.0 10 1

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

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

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