explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uv9O

Settings
# exclusive inclusive rows x rows loops node
1. 0.536 2.560 ↑ 1.2 43 1

Sort (cost=283.51..283.64 rows=53 width=2,128) (actual time=2.558..2.560 rows=43 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: 65kB
2. 0.006 2.024 ↑ 1.2 43 1

Append (cost=34.17..281.99 rows=53 width=2,128) (actual time=0.354..2.024 rows=43 loops=1)

3. 0.047 1.847 ↑ 1.2 42 1

Subquery Scan on "UnionAll3" (cost=34.17..246.98 rows=51 width=2,134) (actual time=0.354..1.847 rows=42 loops=1)

4. 0.005 1.800 ↑ 1.2 42 1

Append (cost=34.17..246.47 rows=51 width=2,134) (actual time=0.352..1.800 rows=42 loops=1)

5. 0.005 1.478 ↑ 1.3 33 1

Append (cost=34.17..197.16 rows=42 width=1,857) (actual time=0.351..1.478 rows=33 loops=1)

6. 0.031 0.351 ↑ 3.0 1 1

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

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

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

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

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

9. 0.014 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.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.005 0.207 ↑ 1.0 1 1

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

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

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

13. 0.003 0.201 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.199..0.201 rows=1 loops=1)

14. 0.003 0.198 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = 2898704)
  • 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.030 0.030 ↑ 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.030..0.030 rows=1 loops=1)

  • Index Cond: (id = 2898704)
  • 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.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

  • Index Cond: (id = 2898704)
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.006..0.007 rows=10 loops=1)

26. 0.017 0.077 ↑ 1.0 10 1

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

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

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.041..0.045 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.008 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
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.004..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.060 0.990 ↓ 1.5 32 1

Nested Loop Left Join (cost=10.19..91.72 rows=22 width=1,736) (actual time=0.349..0.990 rows=32 loops=1)

34. 0.038 0.690 ↓ 1.6 16 1

Hash Left Join (cost=9.77..85.73 rows=10 width=626) (actual time=0.305..0.690 rows=16 loops=1)

  • Hash Cond: (""Extent21"".pansiyonid = ""Extent26"".id)
35. 0.044 0.637 ↓ 1.6 16 1

Nested Loop Left Join (cost=8.61..84.53 rows=10 width=587) (actual time=0.270..0.637 rows=16 loops=1)

36. 0.015 0.561 ↓ 1.6 16 1

Nested Loop (cost=8.48..83.01 rows=10 width=549) (actual time=0.254..0.561 rows=16 loops=1)

37. 0.011 0.386 ↓ 1.6 16 1

Nested Loop Left Join (cost=8.34..81.49 rows=10 width=498) (actual time=0.242..0.386 rows=16 loops=1)

38. 0.027 0.311 ↓ 1.6 16 1

Nested Loop Left Join (cost=8.07..78.55 rows=10 width=421) (actual time=0.213..0.311 rows=16 loops=1)

39. 0.011 0.236 ↓ 1.6 16 1

Nested Loop (cost=7.80..75.70 rows=10 width=355) (actual time=0.194..0.236 rows=16 loops=1)

40. 0.004 0.115 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.112..0.115 rows=1 loops=1)

41. 0.002 0.111 ↑ 1.0 1 1

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

  • Join Filter: (""Extent12"".tumbilbordid = ""Extent19"".id)
  • Rows Removed by Join Filter: 10
42. 0.001 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: (""Extent16"".id = ""Extent17"".id)
  • Rows Removed by Join Filter: 10
43. 0.002 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
44. 0.001 0.037 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent12"".sirketid = ""Extent14"".id)
46. 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: (""Extent12"".id = ""Extent13"".id)
47. 0.011 0.011 ↑ 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.011..0.011 rows=1 loops=1)

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

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 = 2898704)
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.012 0.060 ↑ 1.0 10 1

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

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

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.038..0.041 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.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
59. 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)

60. 0.041 0.110 ↓ 1.6 16 1

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

  • Recheck Cond: (rezid = ""Extent12"".id)
  • Heap Blocks: exact=11
61. 0.069 0.069 ↓ 1.6 16 1

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

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

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

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

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

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

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

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

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

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

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

68. 0.240 0.240 ↑ 1.5 2 16

Index Scan using mamisil2 on gecelememusteri ""Extent27"" (cost=0.42..0.57 rows=3 width=33) (actual time=0.012..0.015 rows=2 loops=16)

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

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

70. 0.002 0.132 ↓ 0.0 0 1

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

71. 0.002 0.111 ↑ 1.0 1 1

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

72. 0.002 0.109 ↑ 1.0 1 1

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

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

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

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

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

  • Join Filter: (""Extent28"".tumbilbordid = ""Extent32"".id)
  • Rows Removed by Join Filter: 15
75. 0.001 0.036 ↑ 1.0 1 1

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

  • Join Filter: (""Extent28"".id = ""Extent31"".id)
76. 0.001 0.027 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent28"".id = ""Extent29"".id)
78. 0.010 0.010 ↑ 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.010..0.010 rows=1 loops=1)

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

  • Index Cond: (id = 2898704)
  • 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.008 0.008 ↑ 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.008..0.008 rows=1 loops=1)

  • Index Cond: (id = 2898704)
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.057 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent35"".id = ""Extent36"".id)
85. 0.019 0.032 ↑ 1.0 10 1

Hash Join (cost=1.23..2.36 rows=10 width=28) (actual time=0.028..0.032 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.006 0.010 ↓ 1.5 15 1

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

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

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

89. 0.007 0.010 ↑ 1.0 10 1

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

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

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

91. 0.019 0.019 ↓ 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.019..0.019 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.014 0.317 ↑ 1.0 9 1

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

94. 0.023 0.303 ↑ 1.0 9 1

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

  • Join Filter: (""Extent50"".kdvid = ""Extent54"".id)
  • Rows Removed by Join Filter: 9
95. 0.008 0.271 ↑ 1.0 9 1

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

96. 0.009 0.245 ↑ 1.0 9 1

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

97. 0.007 0.209 ↑ 1.0 9 1

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

98. 0.005 0.175 ↑ 1.0 9 1

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

99. 0.001 0.131 ↑ 1.0 1 1

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

100. 0.002 0.124 ↑ 1.0 1 1

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

101. 0.003 0.101 ↑ 1.0 1 1

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

102. 0.002 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: (""Extent39"".tumbilbordid = ""Extent46"".id)
  • Rows Removed by Join Filter: 10
103. 0.001 0.047 ↑ 1.0 1 1

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

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

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

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

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

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

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

  • Join Filter: (""Extent39"".sirketid = ""Extent41"".id)
107. 0.000 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: (""Extent39"".id = ""Extent40"".id)
108. 0.009 0.009 ↑ 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.008..0.009 rows=1 loops=1)

  • Index Cond: (id = 2898704)
  • 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.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

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

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

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

  • Index Cond: (id = 2898704)
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.015 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: (""Extent46"".id = ""Extent47"".id)
115. 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: (""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.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
118. 0.004 0.004 ↓ 1.5 15 1

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

119. 0.003 0.007 ↑ 1.0 10 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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.021 0.021 ↑ 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.021..0.021 rows=1 loops=1)

  • Index Cond: (rezid = ""Extent39"".id)
122. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (""Extent48"".faturaid = id)
123. 0.039 0.039 ↑ 1.0 9 1

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

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

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

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

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

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

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

  • Index Cond: (""Extent50"".dovizid = id)
127. 0.004 0.009 ↑ 1.5 2 9

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

128. 0.005 0.005 ↑ 1.5 2 1

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

129. 0.001 0.171 ↑ 2.0 1 1

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

130. 0.025 0.170 ↑ 2.0 1 1

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

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

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

132. 0.005 0.127 ↑ 1.0 1 1

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

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

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

134. 0.003 0.121 ↑ 1.0 1 1

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

135. 0.002 0.118 ↑ 1.0 1 1

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

  • Join Filter: (""Extent55"".tumbilbordid = ""Extent62"".id)
  • Rows Removed by Join Filter: 10
136. 0.001 0.045 ↑ 1.0 1 1

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

  • Join Filter: (""Extent59"".id = ""Extent60"".id)
  • Rows Removed by Join Filter: 10
137. 0.002 0.039 ↑ 1.0 1 1

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

  • Join Filter: (""Extent55"".tumbilbordid = ""Extent59"".id)
  • Rows Removed by Join Filter: 15
138. 0.000 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: (""Extent55"".id = ""Extent58"".id)
139. 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: (""Extent55"".sirketid = ""Extent57"".id)
140. 0.001 0.022 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=70) (actual time=0.022..0.022 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 = 2898704)
  • 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.012 0.012 ↑ 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.012..0.012 rows=1 loops=1)

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

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

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

  • Index Cond: (id = 2898704)
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.012 0.071 ↑ 1.0 10 1

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

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

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

  • Hash Cond: (""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.001..0.003 rows=10 loops=1)

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

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

152. 0.029 0.033 ↑ 1.0 10 1

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

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

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