explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 42TN

Settings
# exclusive inclusive rows x rows loops node
1. 0.807 2.669 ↓ 1.1 57 1

Sort (cost=283.51..283.64 rows=53 width=2,128) (actual time=2.667..2.669 rows=57 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"".""C102"", ""UnionAll3"".""C118"", ""UnionAll3"".""C136"", ""UnionAll3"".""C151"", ""UnionAll3"".""C161"", ""UnionAll3"".""C169"", ""UnionAll3"".""C179"", ""UnionAll3"".""C193"", ""UnionAll3"".""C202"", ""UnionAll3"".""C211"", ""UnionAll3"".""C231"
  • Sort Method: quicksort Memory: 81kB
2. 0.007 1.862 ↓ 1.1 57 1

Append (cost=34.17..281.99 rows=53 width=2,128) (actual time=0.351..1.862 rows=57 loops=1)

3. 0.068 1.698 ↓ 1.1 56 1

Subquery Scan on "UnionAll3" (cost=34.17..246.98 rows=51 width=2,134) (actual time=0.351..1.698 rows=56 loops=1)

4. 0.006 1.630 ↓ 1.1 56 1

Append (cost=34.17..246.47 rows=51 width=2,134) (actual time=0.349..1.630 rows=56 loops=1)

5. 0.006 1.359 ↓ 1.3 55 1

Append (cost=34.17..197.16 rows=42 width=1,857) (actual time=0.349..1.359 rows=55 loops=1)

6. 0.032 0.350 ↑ 3.0 1 1

Hash Right Join (cost=34.17..38.29 rows=3 width=1,944) (actual time=0.349..0.350 rows=1 loops=1)

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

Hash Join (cost=1.99..5.61 rows=126 width=75) (actual time=0.050..0.114 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.013 0.028 ↑ 1.0 44 1

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

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

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

11. 0.005 0.204 ↑ 1.0 1 1

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

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

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

13. 0.004 0.198 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.195..0.198 rows=1 loops=1)

14. 0.002 0.194 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2896917)
  • 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))
21. 0.020 0.020 ↑ 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.020..0.020 rows=1 loops=1)

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

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

23. 0.010 0.010 ↑ 1.0 1 1

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

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

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

25. 0.007 0.007 ↑ 1.0 10 1

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

26. 0.018 0.090 ↑ 1.0 10 1

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

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

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

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

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

29. 0.031 0.036 ↓ 1.5 15 1

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

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

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

31. 0.009 0.015 ↑ 1.0 10 1

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

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

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

33. 0.100 0.865 ↓ 2.5 54 1

Nested Loop Left Join (cost=10.19..91.72 rows=22 width=1,736) (actual time=0.317..0.865 rows=54 loops=1)

34. 0.034 0.549 ↓ 1.8 18 1

Hash Left Join (cost=9.77..85.73 rows=10 width=626) (actual time=0.281..0.549 rows=18 loops=1)

  • Hash Cond: (""Extent21"".pansiyonid = ""Extent26"".id)
35. 0.015 0.501 ↓ 1.8 18 1

Nested Loop Left Join (cost=8.61..84.53 rows=10 width=587) (actual time=0.253..0.501 rows=18 loops=1)

36. 0.018 0.450 ↓ 1.8 18 1

Nested Loop (cost=8.48..83.01 rows=10 width=549) (actual time=0.239..0.450 rows=18 loops=1)

37. 0.017 0.396 ↓ 1.8 18 1

Nested Loop Left Join (cost=8.34..81.49 rows=10 width=498) (actual time=0.222..0.396 rows=18 loops=1)

38. 0.032 0.325 ↓ 1.8 18 1

Nested Loop Left Join (cost=8.07..78.55 rows=10 width=421) (actual time=0.207..0.325 rows=18 loops=1)

39. 0.014 0.221 ↓ 1.8 18 1

Nested Loop (cost=7.80..75.70 rows=10 width=355) (actual time=0.167..0.221 rows=18 loops=1)

40. 0.003 0.128 ↑ 1.0 1 1

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

41. 0.002 0.125 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent16"".id = ""Extent17"".id)
  • Rows Removed by Join Filter: 10
43. 0.001 0.052 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2896917)
  • 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))
48. 0.011 0.011 ↑ 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.011..0.011 rows=1 loops=1)

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

50. 0.010 0.010 ↑ 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.010..0.010 rows=1 loops=1)

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

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

53. 0.030 0.067 ↑ 1.0 10 1

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

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

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

  • Hash Cond: (""Extent18"".id = ""Extent19"".id)
55. 0.007 0.007 ↑ 1.0 10 1

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

56. 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
57. 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)

58. 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
59. 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.003..0.005 rows=10 loops=1)

60. 0.056 0.079 ↓ 1.8 18 1

Bitmap Heap Scan on geceleme ""Extent21"" (cost=4.50..43.43 rows=10 width=77) (actual time=0.038..0.079 rows=18 loops=1)

  • Recheck Cond: (rezid = ""Extent12"".id)
  • Heap Blocks: exact=10
61. 0.023 0.023 ↓ 1.8 18 1

Bitmap Index Scan on ""geceleme_GecelemeRezId"" (cost=0.00..4.49 rows=10 width=0) (actual time=0.023..0.023 rows=18 loops=1)

  • Index Cond: (rezid = ""Extent12"".id)
62. 0.072 0.072 ↑ 1.0 1 18

Index Scan using ""PK_public.acenta"" on acenta ""Extent22"" (cost=0.27..0.29 rows=1 width=66) (actual time=0.004..0.004 rows=1 loops=18)

  • Index Cond: (""Extent21"".acentaid = id)
63. 0.054 0.054 ↑ 1.0 1 18

Index Scan using ""PK_public.oda"" on oda ""Extent23"" (cost=0.28..0.29 rows=1 width=77) (actual time=0.003..0.003 rows=1 loops=18)

  • Index Cond: (""Extent21"".odaid = id)
64. 0.036 0.036 ↑ 1.0 1 18

Index Scan using ""PK_public.odakonum"" on odakonum ""Extent24"" (cost=0.14..0.15 rows=1 width=51) (actual time=0.002..0.002 rows=1 loops=18)

  • Index Cond: (id = ""Extent21"".odakonumid)
65. 0.036 0.036 ↑ 1.0 1 18

Index Scan using ""PK_public.fiyatkonum"" on fiyatkonum ""Extent25"" (cost=0.14..0.15 rows=1 width=38) (actual time=0.002..0.002 rows=1 loops=18)

  • Index Cond: (""Extent21"".fiyatkonumid = id)
66. 0.006 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
67. 0.008 0.008 ↓ 1.1 8 1

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

68. 0.216 0.216 ↑ 1.0 3 18

Index Scan using ""gecelememusteri_IX_gecelemeid"" on gecelememusteri ""Extent27"" (cost=0.42..0.57 rows=3 width=33) (actual time=0.009..0.012 rows=3 loops=18)

  • Index Cond: (""Extent21"".id = gecelemeid)
69. 0.001 0.138 ↓ 0.0 0 1

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

70. 0.001 0.137 ↓ 0.0 0 1

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

71. 0.003 0.123 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.121..0.123 rows=1 loops=1)

72. 0.001 0.120 ↑ 1.0 1 1

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

  • Join Filter: (""Extent28"".tumbilbordid = ""Extent35"".id)
  • Rows Removed by Join Filter: 10
73. 0.001 0.046 ↑ 1.0 1 1

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

  • Join Filter: (""Extent32"".id = ""Extent33"".id)
  • Rows Removed by Join Filter: 10
74. 0.002 0.042 ↑ 1.0 1 1

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

  • Join Filter: (""Extent28"".tumbilbordid = ""Extent32"".id)
  • Rows Removed by Join Filter: 15
75. 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: (""Extent28"".id = ""Extent31"".id)
76. 0.000 0.024 ↑ 1.0 1 1

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

  • Join Filter: (""Extent28"".sirketid = ""Extent30"".id)
77. 0.002 0.020 ↑ 1.0 1 1

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

  • Join Filter: (""Extent28"".id = ""Extent29"".id)
78. 0.009 0.009 ↑ 1.0 1 1

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

  • Index Cond: (id = 2896917)
  • 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))
79. 0.009 0.009 ↑ 1.0 1 1

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

  • Index Cond: (id = 2896917)
  • Heap Fetches: 0
80. 0.004 0.004 ↑ 1.0 1 1

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

81. 0.007 0.007 ↑ 1.0 1 1

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

  • Index Cond: (id = 2896917)
82. 0.008 0.008 ↓ 1.5 15 1

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

83. 0.003 0.003 ↑ 1.0 10 1

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

84. 0.015 0.073 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent35"".id = ""Extent36"".id)
85. 0.024 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: (""Extent34"".id = ""Extent35"".id)
86. 0.003 0.003 ↑ 1.0 10 1

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

87. 0.009 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
88. 0.006 0.006 ↓ 1.5 15 1

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

89. 0.012 0.016 ↑ 1.0 10 1

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

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

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

91. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ""konumhamfiyat_IX_rezid"" on konumhamfiyat ""Extent37"" (cost=0.29..27.46 rows=8 width=69) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (rezid = ""Extent28"".id)
92. 0.000 0.000 ↓ 0.0 0

Index Scan using ""konumhamfiyatkategori_IX_konumhamfiyatid"" on konumhamfiyatkategori ""Extent38"" (cost=0.29..0.86 rows=2 width=33) (never executed)

  • Index Cond: (""Extent37"".id = konumhamfiyatid)
93. 0.003 0.265 ↑ 9.0 1 1

Subquery Scan on "*SELECT* 2_1" (cost=4.60..48.88 rows=9 width=1,816) (actual time=0.260..0.265 rows=1 loops=1)

94. 0.003 0.262 ↑ 9.0 1 1

Nested Loop Left Join (cost=4.60..48.77 rows=9 width=1,812) (actual time=0.258..0.262 rows=1 loops=1)

  • Join Filter: (""Extent50"".kdvid = ""Extent54"".id)
  • Rows Removed by Join Filter: 1
95. 0.002 0.247 ↑ 9.0 1 1

Nested Loop Left Join (cost=4.60..47.37 rows=9 width=721) (actual time=0.242..0.247 rows=1 loops=1)

96. 0.002 0.220 ↑ 9.0 1 1

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

97. 0.002 0.208 ↑ 9.0 1 1

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

98. 0.001 0.195 ↑ 9.0 1 1

Nested Loop Left Join (cost=4.03..41.79 rows=9 width=593) (actual time=0.191..0.195 rows=1 loops=1)

99. 0.001 0.171 ↑ 1.0 1 1

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

100. 0.001 0.165 ↑ 1.0 1 1

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

101. 0.003 0.149 ↑ 1.0 1 1

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

102. 0.002 0.146 ↑ 1.0 1 1

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

  • Join Filter: (""Extent39"".tumbilbordid = ""Extent46"".id)
  • Rows Removed by Join Filter: 10
103. 0.001 0.063 ↑ 1.0 1 1

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

  • Join Filter: (""Extent43"".id = ""Extent44"".id)
  • Rows Removed by Join Filter: 10
104. 0.002 0.060 ↑ 1.0 1 1

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

  • Join Filter: (""Extent39"".tumbilbordid = ""Extent43"".id)
  • Rows Removed by Join Filter: 15
105. 0.001 0.053 ↑ 1.0 1 1

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

  • Join Filter: (""Extent39"".id = ""Extent42"".id)
106. 0.001 0.043 ↑ 1.0 1 1

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

  • Join Filter: (""Extent39"".sirketid = ""Extent41"".id)
107. 0.001 0.039 ↑ 1.0 1 1

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

  • Join Filter: (""Extent39"".id = ""Extent40"".id)
108. 0.022 0.022 ↑ 1.0 1 1

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

  • Index Cond: (id = 2896917)
  • 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))
109. 0.016 0.016 ↑ 1.0 1 1

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

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

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

111. 0.009 0.009 ↑ 1.0 1 1

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

  • Index Cond: (id = 2896917)
112. 0.005 0.005 ↓ 1.5 15 1

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

113. 0.002 0.002 ↑ 1.0 10 1

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

114. 0.019 0.081 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent46"".id = ""Extent47"".id)
115. 0.040 0.054 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent45"".id = ""Extent46"".id)
116. 0.003 0.003 ↑ 1.0 10 1

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

117. 0.005 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
118. 0.006 0.006 ↓ 1.5 15 1

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

119. 0.004 0.008 ↑ 1.0 10 1

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

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

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

121. 0.015 0.015 ↑ 1.0 1 1

Index Scan using ""folio_IX_rezid"" on folio ""Extent48"" (cost=0.29..8.30 rows=1 width=37) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: (rezid = ""Extent39"".id)
122. 0.005 0.005 ↓ 0.0 0 1

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

  • Index Cond: (""Extent48"".faturaid = id)
123. 0.023 0.023 ↑ 9.0 1 1

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

  • Index Cond: (""Extent48"".id = folioid)
124. 0.011 0.011 ↑ 1.0 1 1

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

  • Index Cond: (""Extent50"".depkodid = id)
125. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (""Extent50"".kaynakfolioid = id)
126. 0.025 0.025 ↑ 1.0 1 1

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

  • Index Cond: (""Extent50"".dovizid = id)
127. 0.006 0.012 ↑ 1.5 2 1

Materialize (cost=0.00..1.04 rows=3 width=35) (actual time=0.011..0.012 rows=2 loops=1)

128. 0.006 0.006 ↑ 1.5 2 1

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

129. 0.001 0.157 ↑ 2.0 1 1

Subquery Scan on "*SELECT* 2" (cost=32.18..35.01 rows=2 width=2,001) (actual time=0.155..0.157 rows=1 loops=1)

130. 0.024 0.156 ↑ 2.0 1 1

Hash Join (cost=32.18..34.99 rows=2 width=2,001) (actual time=0.153..0.156 rows=1 loops=1)

  • Hash Cond: (""Extent64"".rezid = ""Alias77"".id)
131. 0.015 0.015 ↓ 1.3 73 1

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

132. 0.006 0.117 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
133. 0.001 0.111 ↑ 1.0 1 1

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

134. 0.002 0.110 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.108..0.110 rows=1 loops=1)

135. 0.002 0.108 ↑ 1.0 1 1

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

  • Join Filter: (""Extent55"".tumbilbordid = ""Extent62"".id)
  • Rows Removed by Join Filter: 10
136. 0.001 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: (""Extent59"".id = ""Extent60"".id)
  • Rows Removed by Join Filter: 10
137. 0.001 0.037 ↑ 1.0 1 1

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

  • Join Filter: (""Extent55"".tumbilbordid = ""Extent59"".id)
  • Rows Removed by Join Filter: 15
138. 0.001 0.031 ↑ 1.0 1 1

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

  • Join Filter: (""Extent55"".id = ""Extent58"".id)
139. 0.000 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: (""Extent55"".sirketid = ""Extent57"".id)
140. 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: (""Extent55"".id = ""Extent56"".id)
141. 0.009 0.009 ↑ 1.0 1 1

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

  • Index Cond: (id = 2896917)
  • 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))
142. 0.009 0.009 ↑ 1.0 1 1

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

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

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

144. 0.008 0.008 ↑ 1.0 1 1

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

  • Index Cond: (id = 2896917)
145. 0.005 0.005 ↓ 1.5 15 1

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

146. 0.005 0.005 ↑ 1.0 10 1

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

147. 0.017 0.063 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent62"".id = ""Extent63"".id)
148. 0.021 0.037 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent61"".id = ""Extent62"".id)
149. 0.003 0.003 ↑ 1.0 10 1

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

150. 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
151. 0.006 0.006 ↓ 1.5 15 1

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

152. 0.004 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
153. 0.005 0.005 ↑ 1.0 10 1

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