explain.depesz.com

PostgreSQL's explain analyze made readable

Result: USv6

Settings
# exclusive inclusive rows x rows loops node
1. 1.013 524.570 ↓ 1.4 71 1

Sort (cost=17,336.42..17,336.55 rows=52 width=2,456) (actual time=524.567..524.570 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.012 523.557 ↓ 1.4 71 1

Append (cost=34.17..17,334.94 rows=52 width=2,456) (actual time=0.318..523.557 rows=71 loops=1)

3. 0.083 523.163 ↑ 1.0 48 1

Subquery Scan on "UnionAll3" (cost=34.17..17,299.93 rows=50 width=2,462) (actual time=0.318..523.163 rows=48 loops=1)

4. 0.009 523.080 ↑ 1.0 48 1

Append (cost=34.17..17,299.43 rows=50 width=2,462) (actual time=0.316..523.080 rows=48 loops=1)

5. 0.008 522.540 ↑ 1.1 37 1

Append (cost=34.17..17,250.13 rows=41 width=2,113) (actual time=0.316..522.540 rows=37 loops=1)

6. 0.027 0.316 ↑ 3.0 1 1

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

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

Hash Join (cost=1.99..5.61 rows=126 width=75) (actual time=0.065..0.129 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.017 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.017 0.017 ↑ 1.0 44 1

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

11. 0.007 0.160 ↑ 1.0 1 1

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

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

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

13. 0.004 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)

14. 0.003 0.148 ↑ 1.0 1 1

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

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

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

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

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

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

Nested Loop Left Join (cost=0.86..25.95 rows=1 width=194) (actual time=0.081..0.081 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.003 0.055 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=70) (actual time=0.055..0.055 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 = 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.025 0.025 ↑ 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.025..0.025 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.016 0.016 ↑ 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.016..0.016 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.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.012 0.049 ↑ 1.0 10 1

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

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

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

29. 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
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.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
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.117 ↓ 0.0 0 1

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

34. 0.002 0.117 ↓ 0.0 0 1

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

35. 0.002 0.104 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.102..0.104 rows=1 loops=1)

36. 0.002 0.102 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent16"".id = ""Extent17"".id)
  • Rows Removed by Join Filter: 10
38. 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: (""Extent12"".tumbilbordid = ""Extent16"".id)
  • Rows Removed by Join Filter: 15
39. 0.001 0.038 ↑ 1.0 1 1

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

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

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

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

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

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

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

  • Index Cond: (id = 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.016 0.016 ↑ 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.016..0.016 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.003..0.003 rows=1 loops=1)

45. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (id = 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.003..0.006 rows=15 loops=1)

47. 0.006 0.006 ↑ 1.0 10 1

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

48. 0.012 0.048 ↑ 1.0 10 1

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

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

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

53. 0.003 0.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
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.011 0.011 ↓ 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.011..0.011 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.109 522.099 ↓ 1.7 36 1

Nested Loop Left Join (cost=6,833.46..17,144.70 rows=21 width=1,914) (actual time=170.140..522.099 rows=36 loops=1)

58. 0.082 521.558 ↓ 1.8 18 1

Nested Loop Left Join (cost=6,832.62..17,115.03 rows=10 width=739) (actual time=170.078..521.558 rows=18 loops=1)

59. 0.086 521.368 ↓ 1.8 18 1

Hash Left Join (cost=6,832.48..17,113.46 rows=10 width=698) (actual time=170.053..521.368 rows=18 loops=1)

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

Hash Join (cost=6,831.36..17,112.32 rows=10 width=655) (actual time=169.974..521.257 rows=18 loops=1)

  • Hash Cond: (""Extent32"".rezid = ""Alias39"".id)
61. 77.776 511.013 ↑ 1.0 111,995 1

Hash Left Join (cost=6,799.19..16,660.06 rows=111,995 width=377) (actual time=73.723..511.013 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".id = ""Extent39"".id)
62. 56.670 391.358 ↑ 1.0 111,995 1

Hash Left Join (cost=3,429.30..12,996.18 rows=111,995 width=352) (actual time=31.218..391.358 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".pansiyonid = ""Extent38"".id)
63. 54.898 334.672 ↑ 1.0 111,995 1

Hash Left Join (cost=3,428.14..12,523.24 rows=111,995 width=313) (actual time=31.189..334.672 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent37"".id)
64. 53.614 279.758 ↑ 1.0 111,995 1

Hash Join (cost=3,426.78..12,221.67 rows=111,995 width=275) (actual time=31.156..279.758 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".odakonumid = ""Extent36"".id)
65. 47.827 226.128 ↑ 1.0 111,995 1

Hash Left Join (cost=3,425.42..11,848.44 rows=111,995 width=224) (actual time=31.125..226.128 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".odaid = ""Extent35"".id)
66. 46.168 177.918 ↑ 1.0 111,995 1

Hash Left Join (cost=3,379.32..11,506.87 rows=111,995 width=147) (actual time=30.727..177.918 rows=111,995 loops=1)

  • Hash Cond: (""Extent32"".acentaid = ""Extent34"".id)
67. 48.215 131.649 ↑ 1.0 111,995 1

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

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

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

69. 16.729 29.883 ↑ 1.0 111,995 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 4962kB
70. 13.154 13.154 ↑ 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..13.154 rows=111,995 loops=1)

71. 0.048 0.101 ↑ 1.0 108 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
72. 0.053 0.053 ↑ 1.0 108 1

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

73. 0.168 0.383 ↑ 1.0 538 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
74. 0.215 0.215 ↑ 1.0 538 1

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

75. 0.007 0.016 ↑ 1.0 16 1

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

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

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

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

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

79. 0.009 0.016 ↓ 1.1 8 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
80. 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)

81. 24.445 41.879 ↑ 1.0 111,995 1

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

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

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

83. 0.008 0.116 ↑ 1.0 1 1

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

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

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

85. 0.002 0.107 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.106..0.107 rows=1 loops=1)

86. 0.002 0.105 ↑ 1.0 1 1

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

  • Join Filter: (""Extent23"".tumbilbordid = ""Extent30"".id)
  • Rows Removed by Join Filter: 10
87. 0.002 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: (""Extent27"".id = ""Extent28"".id)
  • Rows Removed by Join Filter: 10
88. 0.001 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: (""Extent23"".tumbilbordid = ""Extent27"".id)
  • Rows Removed by Join Filter: 15
89. 0.001 0.032 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent23"".sirketid = ""Extent25"".id)
91. 0.000 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: (""Extent23"".id = ""Extent24"".id)
92. 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 = 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.009 0.009 ↑ 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.009..0.009 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.008 0.008 ↑ 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.008..0.008 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.014 0.061 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent30"".id = ""Extent31"".id)
99. 0.018 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: (""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.013 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
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.005 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
104. 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)

105. 0.009 0.025 ↑ 1.0 5 1

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

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

Seq Scan on odeme ""Extent40"" (cost=0.00..1.05 rows=5 width=43) (actual time=0.014..0.016 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.432 ↑ 1.5 2 18

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

109. 0.234 0.234 ↑ 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.013 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.531 ↓ 1.2 11 1

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

112. 0.026 0.506 ↓ 1.2 11 1

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

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

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

114. 0.011 0.427 ↓ 1.2 11 1

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

115. 0.020 0.383 ↓ 1.2 11 1

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

116. 0.010 0.341 ↓ 1.2 11 1

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

117. 0.004 0.303 ↓ 2.0 2 1

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

118. 0.006 0.289 ↓ 2.0 2 1

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

119. 0.016 0.229 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.225..0.229 rows=1 loops=1)

120. 0.004 0.213 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

  • Join Filter: (""Extent44"".id = ""Extent45"".id)
126. 0.043 0.043 ↑ 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.043..0.043 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.022 0.022 ↑ 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.021..0.022 rows=1 loops=1)

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

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

129. 0.009 0.009 ↑ 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.009..0.009 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.005 0.005 ↑ 1.0 10 1

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

132. 0.017 0.098 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent51"".id = ""Extent52"".id)
133. 0.031 0.060 ↑ 1.0 10 1

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.056..0.060 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.020 0.025 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.025..0.025 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.004..0.005 rows=15 loops=1)

137. 0.017 0.021 ↑ 1.0 10 1

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

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

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

139. 0.054 0.054 ↓ 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.044..0.054 rows=2 loops=1)

  • Index Cond: (rezid = ""Extent44"".id)
140. 0.010 0.010 ↓ 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.005..0.005 rows=0 loops=2)

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

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk ""Extent55"" (cost=0.29..1.03 rows=9 width=153) (actual time=0.010..0.014 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.022 0.022 ↑ 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.002..0.002 rows=1 loops=11)

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

146. 0.007 0.007 ↑ 1.0 3 1

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

147. 0.117 0.382 ↓ 11.5 23 1

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

148. 0.085 0.265 ↓ 11.5 23 1

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

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

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

150. 0.007 0.160 ↑ 1.0 1 1

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

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

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

152. 0.004 0.152 ↑ 1.0 1 1

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

153. 0.003 0.148 ↑ 1.0 1 1

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

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

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

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

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

  • Join Filter: (""Extent60"".tumbilbordid = ""Extent64"".id)
  • Rows Removed by Join Filter: 15
156. 0.003 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: (""Extent60"".id = ""Extent63"".id)
157. 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: (""Extent60"".sirketid = ""Extent62"".id)
158. 0.002 0.031 ↑ 1.0 1 1

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

  • Join Filter: (""Extent60"".id = ""Extent61"".id)
159. 0.011 0.011 ↑ 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.011..0.011 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.018 0.018 ↑ 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.018..0.018 rows=1 loops=1)

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

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

162. 0.009 0.009 ↑ 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.009..0.009 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.020 0.083 ↑ 1.0 10 1

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

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

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.038..0.042 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.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
169. 0.006 0.006 ↓ 1.5 15 1

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

170. 0.003 0.021 ↑ 1.0 10 1

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

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

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