explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oKI2

Settings
# exclusive inclusive rows x rows loops node
1. 1.977 1,446.283 ↓ 2.1 107 1

Sort (cost=66,066.17..66,066.30 rows=52 width=2,229) (actual time=1,446.278..1,446.283 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,444.306 ↓ 2.1 107 1

Append (cost=34.17..66,064.68 rows=52 width=2,229) (actual time=0.236..1,444.306 rows=107 loops=1)

3. 0.175 1,444.055 ↓ 2.1 107 1

Subquery Scan on "UnionAll3" (cost=34.17..66,029.67 rows=50 width=2,235) (actual time=0.235..1,444.055 rows=107 loops=1)

4. 0.017 1,443.880 ↓ 2.1 107 1

Append (cost=34.17..66,029.17 rows=50 width=2,235) (actual time=0.233..1,443.880 rows=107 loops=1)

5. 0.020 1,443.544 ↓ 2.5 101 1

Append (cost=34.17..65,979.88 rows=41 width=1,940) (actual time=0.233..1,443.544 rows=101 loops=1)

6. 0.020 0.233 ↑ 3.0 1 1

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

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

Hash Join (cost=1.99..5.61 rows=126 width=75) (actual time=0.040..0.104 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.007..0.016 rows=44 loops=1)

11. 0.003 0.109 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.000 0.106 ↑ 1.0 1 1

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

13. 0.004 0.106 ↑ 1.0 1 1

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

14. 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: (""Extent1"".tumbilbordid = ""Extent8"".id)
  • Rows Removed by Join Filter: 10
15. 0.001 0.054 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

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

25. 0.004 0.004 ↑ 1.0 10 1

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

26. 0.007 0.046 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent8"".id = ""Extent9"".id)
27. 0.013 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.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.008 0.014 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.014..0.014 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.001 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.007 0.007 ↑ 1.0 10 1

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

33. 0.000 0.087 ↓ 0.0 0 1

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

34. 0.002 0.087 ↓ 0.0 0 1

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

35. 0.002 0.077 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.075..0.077 rows=1 loops=1)

36. 0.002 0.075 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

Nested Loop (cost=0.57..17.64 rows=1 width=142) (actual time=0.013..0.013 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.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.003 0.003 ↑ 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.003..0.003 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.002..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.006 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: (""Extent19"".id = ""Extent20"".id)
49. 0.018 0.034 ↑ 1.0 10 1

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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.001 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
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.008 0.008 ↓ 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.008..0.008 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.749 1,443.204 ↓ 4.8 100 1

Hash Join (cost=40,122.26..65,874.44 rows=21 width=1,793) (actual time=373.693..1,443.204 rows=100 loops=1)

  • Hash Cond: (""Extent32"".rezid = ""Alias39"".id)
58. 133.110 1,422.350 ↑ 1.0 243,211 1

Hash Left Join (cost=40,090.09..64,929.49 rows=243,350 width=434) (actual time=314.933..1,422.350 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".pansiyonid = ""Extent37"".id)
59. 130.094 1,289.225 ↑ 1.0 243,211 1

Hash Left Join (cost=40,088.93..63,903.23 rows=243,350 width=395) (actual time=314.904..1,289.225 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent36"".id)
60. 126.086 1,159.114 ↑ 1.0 243,211 1

Hash Join (cost=40,087.57..63,249.54 rows=243,350 width=357) (actual time=314.871..1,159.114 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".odakonumid = ""Extent35"".id)
61. 121.041 1,033.012 ↑ 1.0 243,211 1

Hash Left Join (cost=40,086.21..62,440.19 rows=243,350 width=306) (actual time=314.841..1,033.012 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".odaid = ""Extent34"".id)
62. 121.189 911.567 ↑ 1.0 243,211 1

Hash Left Join (cost=40,040.11..61,752.08 rows=243,350 width=229) (actual time=314.423..911.567 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".acentaid = ""Extent33"".id)
63. 236.774 790.292 ↑ 1.0 243,211 1

Hash Right Join (cost=40,030.68..61,078.80 rows=243,350 width=163) (actual time=314.312..790.292 rows=243,211 loops=1)

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

Hash Join (cost=29,677.08..42,006.38 rows=243,350 width=86) (actual time=232.367..472.154 rows=242,854 loops=1)

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

Seq Scan on gecelememusteri ""Extent38"" (cost=0.00..4,461.50 rows=243,350 width=33) (actual time=0.017..53.552 rows=242,854 loops=1)

66. 106.314 231.536 ↓ 1.0 353,896 1

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

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

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

68. 40.417 81.364 ↑ 1.0 112,160 1

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

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

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

70. 0.035 0.086 ↑ 1.0 108 1

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

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

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

72. 0.175 0.404 ↑ 1.0 538 1

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

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

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

74. 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
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.005..0.009 rows=16 loops=1)

76. 0.006 0.017 ↑ 1.0 16 1

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

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

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

78. 0.008 0.015 ↓ 1.1 8 1

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

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

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

80. 0.004 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
81. 0.001 0.101 ↑ 1.0 1 1

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

82. 0.002 0.100 ↑ 1.0 1 1

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

83. 0.003 0.098 ↑ 1.0 1 1

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

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

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

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

Nested Loop Left Join (cost=0.86..27.18 rows=1 width=242) (actual time=0.039..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.025 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent23"".id = ""Extent24"".id)
89. 0.011 0.011 ↑ 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.011 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.010 0.010 ↑ 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.010..0.010 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.007 0.007 ↑ 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.007..0.007 rows=1 loops=1)

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

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

94. 0.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.016 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: (""Extent30"".id = ""Extent31"".id)
96. 0.018 0.029 ↑ 1.0 10 1

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.026..0.029 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.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
99. 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)

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

102. 0.014 0.319 ↑ 1.5 6 1

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

103. 0.028 0.305 ↑ 1.5 6 1

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

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

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

105. 0.010 0.241 ↑ 1.5 6 1

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

106. 0.008 0.213 ↑ 1.5 6 1

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

107. 0.006 0.187 ↑ 1.5 6 1

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

108. 0.004 0.160 ↑ 1.0 1 1

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

109. 0.004 0.155 ↑ 1.0 1 1

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

110. 0.005 0.141 ↑ 1.0 1 1

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

111. 0.003 0.136 ↑ 1.0 1 1

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

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

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

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

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

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

Nested Loop Left Join (cost=0.86..25.95 rows=1 width=194) (actual time=0.065..0.065 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.004 0.004 ↑ 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.004..0.004 rows=1 loops=1)

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

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

122. 0.006 0.006 ↑ 1.0 10 1

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

123. 0.006 0.047 ↑ 1.0 10 1

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

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

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

  • Hash Cond: (""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.012 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
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.010 0.010 ↑ 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.010 rows=1 loops=1)

  • Index Cond: (rezid = ""Extent40"".id)
131. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

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

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk ""Extent51"" (cost=0.29..1.03 rows=9 width=153) (actual time=0.017..0.021 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.006 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.006 0.006 ↑ 1.5 2 1

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

138. 0.000 0.231 ↓ 0.0 0 1

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

139. 0.020 0.231 ↓ 0.0 0 1

Hash Join (cost=32.18..34.99 rows=2 width=2,102) (actual time=0.231..0.231 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.009..0.016 rows=73 loops=1)

141. 0.009 0.195 ↑ 1.0 1 1

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

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

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

143. 0.004 0.184 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.181..0.184 rows=1 loops=1)

144. 0.003 0.180 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

  • Join Filter: (""Extent56"".sirketid = ""Extent58"".id)
149. 0.002 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: (""Extent56"".id = ""Extent57"".id)
150. 0.011 0.011 ↑ 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.011..0.011 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.002 0.002 ↑ 1.0 1 1

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

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

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

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

155. 0.020 0.020 ↑ 1.0 10 1

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

156. 0.028 0.095 ↑ 1.0 10 1

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

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

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

  • Hash Cond: (""Extent62"".id = ""Extent63"".id)
158. 0.005 0.005 ↑ 1.0 10 1

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

159. 0.028 0.034 ↓ 1.5 15 1

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

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

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

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

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