explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hsbA

Settings
# exclusive inclusive rows x rows loops node
1. 2.012 49.829 ↓ 1.1 73 1

Sort (cost=5,141.87..5,142.04 rows=69 width=2,501) (actual time=49.826..49.829 rows=73 loops=1)

  • Sort Key: ""UnionAll4"".""C2"", ""UnionAll4"".""C3"", ""UnionAll4"".""C4"", ""UnionAll4"".""C5"", ""UnionAll4"".""C6"", ""UnionAll4"".""C7"", ""UnionAll4"".""C9"", ""UnionAll4"".""C24"", ""UnionAll4"".""C45"", ""UnionAll4"".""C1"", ""UnionAll4"".""C84"", ""UnionAll4"".""C98"", ""UnionAll4"".""C107"", ""UnionAll4"".""C125"", ""UnionAll4"".""C126"", ""UnionAll4"".""C142"", ""UnionAll4"".""C160"", ""UnionAll4"".""C175"", ""UnionAll4"".""C185"", ""UnionAll4"".""C200"", ""UnionAll4"".""C201"", ""UnionAll4"".""C213"", ""UnionAll4"".""C223"", ""UnionAll4"".""C253"", ""UnionAll4"".""C262"", ""UnionAll4"".""C282"
  • Sort Method: quicksort Memory: 97kB
2. 0.008 47.817 ↓ 1.1 73 1

Append (cost=34.17..5,139.76 rows=69 width=2,501) (actual time=0.348..47.817 rows=73 loops=1)

3. 0.092 47.619 ↓ 1.1 72 1

Subquery Scan on "UnionAll4" (cost=34.17..5,104.75 rows=67 width=2,507) (actual time=0.348..47.619 rows=72 loops=1)

4. 0.008 47.527 ↓ 1.1 72 1

Append (cost=34.17..5,104.08 rows=67 width=2,507) (actual time=0.346..47.527 rows=72 loops=1)

5. 0.008 47.133 ↓ 1.2 71 1

Append (cost=34.17..5,054.61 rows=58 width=2,108) (actual time=0.345..47.133 rows=71 loops=1)

6. 0.028 0.346 ↑ 3.0 1 1

Hash Right Join (cost=34.17..38.29 rows=3 width=2,317) (actual time=0.345..0.346 rows=1 loops=1)

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

Hash Join (cost=1.99..5.61 rows=126 width=75) (actual time=0.050..0.116 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.008..0.032 rows=129 loops=1)

9. 0.015 0.031 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=42) (actual time=0.031..0.031 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.008..0.016 rows=44 loops=1)

11. 0.007 0.202 ↑ 1.0 1 1

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

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

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

13. 0.004 0.194 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.191..0.194 rows=1 loops=1)

14. 0.002 0.190 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

  • Join Filter: (""Extent1"".id = ""Extent2"".id)
20. 0.053 0.053 ↑ 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.053..0.053 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) 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 = 2896917)
  • 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.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 = 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.005 0.005 ↑ 1.0 10 1

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

26. 0.012 0.066 ↑ 1.0 10 1

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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.005 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.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.158 ↓ 0.0 0 1

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

34. 0.002 0.158 ↓ 0.0 0 1

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

35. 0.003 0.128 ↑ 1.0 1 1

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

36. 0.001 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
37. 0.002 0.058 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent12"".tumbilbordid = ""Extent16"".id)
  • Rows Removed by Join Filter: 15
39. 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)
40. 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: (""Extent12"".sirketid = ""Extent14"".id)
41. 0.001 0.033 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=70) (actual time=0.033..0.033 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 = 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) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
43. 0.022 0.022 ↑ 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.022..0.022 rows=1 loops=1)

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

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

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

47. 0.002 0.002 ↑ 1.0 10 1

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

48. 0.028 0.066 ↑ 1.0 10 1

Hash Left Join (cost=2.45..3.62 rows=10 width=32) (actual time=0.060..0.066 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.001..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.005 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
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.028 0.028 ↓ 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.028..0.028 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.123 46.621 ↓ 1.8 70 1

Nested Loop (cost=60.80..4,949.01 rows=38 width=1,977) (actual time=0.653..46.621 rows=70 loops=1)

58. 0.007 0.099 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.092..0.099 rows=1 loops=1)

59. 0.003 0.092 ↑ 1.0 1 1

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

  • Join Filter: (""Extent23"".tumbilbordid = ""Extent30"".id)
  • Rows Removed by Join Filter: 10
60. 0.001 0.040 ↑ 1.0 1 1

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

  • Join Filter: (""Extent27"".id = ""Extent28"".id)
  • Rows Removed by Join Filter: 10
61. 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: (""Extent23"".tumbilbordid = ""Extent27"".id)
  • Rows Removed by Join Filter: 15
62. 0.001 0.031 ↑ 1.0 1 1

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

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

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

  • Join Filter: (""Extent23"".sirketid = ""Extent25"".id)
64. 0.001 0.019 ↑ 1.0 1 1

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

  • Join Filter: (""Extent23"".id = ""Extent24"".id)
65. 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.009..0.010 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) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
66. 0.008 0.008 ↑ 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.008..0.008 rows=1 loops=1)

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

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

68. 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 = 2896917)
69. 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)

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

71. 0.012 0.049 ↑ 1.0 10 1

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

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

74. 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
75. 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)

76. 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
77. 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)

78. 0.009 46.399 ↓ 1.8 70 1

Append (cost=57.49..4,916.46 rows=38 width=635) (actual time=0.557..46.399 rows=70 loops=1)

79. 0.037 1.666 ↓ 2.5 54 1

Subquery Scan on "*SELECT* 1" (cost=57.49..461.21 rows=22 width=616) (actual time=0.556..1.666 rows=54 loops=1)

80. 0.054 1.629 ↓ 2.5 54 1

Nested Loop Left Join (cost=57.49..460.99 rows=22 width=616) (actual time=0.555..1.629 rows=54 loops=1)

81. 0.012 1.053 ↓ 1.8 18 1

Nested Loop Left Join (cost=56.65..278.28 rows=10 width=461) (actual time=0.482..1.053 rows=18 loops=1)

82. 0.018 1.005 ↓ 1.8 18 1

Nested Loop Left Join (cost=56.51..276.70 rows=10 width=420) (actual time=0.472..1.005 rows=18 loops=1)

83. 0.036 0.951 ↓ 1.8 18 1

Hash Left Join (cost=56.38..275.20 rows=10 width=377) (actual time=0.459..0.951 rows=18 loops=1)

  • Hash Cond: (""Extent32"".acentaid = ""Extent34"".id)
84. 0.033 0.821 ↓ 1.8 18 1

Hash Left Join (cost=46.95..265.74 rows=10 width=311) (actual time=0.345..0.821 rows=18 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent37"".id)
85. 0.020 0.763 ↓ 1.8 18 1

Nested Loop (cost=45.59..264.35 rows=10 width=273) (actual time=0.301..0.763 rows=18 loops=1)

  • Join Filter: (""Extent32"".odakonumid = ""Extent36"".id)
  • Rows Removed by Join Filter: 36
86. 0.020 0.725 ↓ 1.8 18 1

Nested Loop Left Join (cost=45.59..260.96 rows=10 width=222) (actual time=0.286..0.725 rows=18 loops=1)

87. 0.024 0.669 ↓ 1.8 18 1

Nested Loop Left Join (cost=45.17..176.61 rows=10 width=197) (actual time=0.274..0.669 rows=18 loops=1)

88. 0.073 0.501 ↓ 1.8 18 1

Hash Right Join (cost=44.75..92.26 rows=10 width=193) (actual time=0.245..0.501 rows=18 loops=1)

  • Hash Cond: (""Extent35"".id = ""Extent32"".odaid)
89. 0.220 0.220 ↑ 1.0 538 1

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

90. 0.013 0.208 ↓ 1.8 18 1

Hash (cost=44.63..44.63 rows=10 width=116) (actual time=0.208..0.208 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
91. 0.027 0.195 ↓ 1.8 18 1

Hash Left Join (cost=5.65..44.63 rows=10 width=116) (actual time=0.124..0.195 rows=18 loops=1)

  • Hash Cond: (""Extent32"".pansiyonid = ""Extent38"".id)
92. 0.086 0.145 ↓ 1.8 18 1

Bitmap Heap Scan on geceleme ""Extent32"" (cost=4.50..43.43 rows=10 width=77) (actual time=0.081..0.145 rows=18 loops=1)

  • Recheck Cond: (""Extent23"".id = rezid)
  • Heap Blocks: exact=10
93. 0.059 0.059 ↓ 1.8 18 1

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

  • Index Cond: (""Extent23"".id = rezid)
94. 0.015 0.023 ↓ 1.1 8 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
95. 0.008 0.008 ↓ 1.1 8 1

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

96. 0.144 0.144 ↑ 1.0 1 18

Index Only Scan using ""gecelemedetayek_IX_id"" on gecelemedetayek ""Extent33"" (cost=0.42..8.44 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=18)

  • Index Cond: (id = ""Extent32"".id)
  • Heap Fetches: 18
97. 0.036 0.036 ↑ 1.0 1 18

Index Scan using ""gecelemedetayek_IX_id"" on gecelemedetayek ""Extent39"" (cost=0.42..8.44 rows=1 width=25) (actual time=0.002..0.002 rows=1 loops=18)

  • Index Cond: (""Extent32"".id = id)
98. 0.012 0.018 ↑ 5.3 3 18

Materialize (cost=0.00..1.24 rows=16 width=51) (actual time=0.001..0.001 rows=3 loops=18)

99. 0.006 0.006 ↑ 5.3 3 1

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

100. 0.015 0.025 ↑ 1.0 16 1

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

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

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

102. 0.039 0.094 ↑ 1.0 108 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
103. 0.055 0.055 ↑ 1.0 108 1

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

104. 0.036 0.036 ↑ 1.0 1 18

Index Scan using ""PK_public.odeme"" on odeme ""Extent40"" (cost=0.13..0.15 rows=1 width=43) (actual time=0.002..0.002 rows=1 loops=18)

  • Index Cond: (""Extent39"".odemeid = id)
105. 0.036 0.036 ↑ 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.002..0.002 rows=1 loops=18)

  • Index Cond: (""Extent39"".pazarid = id)
106. 0.072 0.522 ↑ 1.0 3 18

Nested Loop (cost=0.84..18.24 rows=3 width=86) (actual time=0.016..0.029 rows=3 loops=18)

107. 0.288 0.288 ↑ 1.0 3 18

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

  • Index Cond: (""Extent32"".id = gecelemeid)
108. 0.162 0.162 ↑ 1.0 1 54

Index Scan using ""PK_public.musteri"" on musteri ""Extent43"" (cost=0.42..0.79 rows=1 width=53) (actual time=0.003..0.003 rows=1 loops=54)

  • Index Cond: (id = ""Extent42"".musteriid)
109. 0.011 44.724 ↑ 1.0 16 1

Subquery Scan on "*SELECT* 2_2" (cost=278.01..4,455.25 rows=16 width=660) (actual time=44.678..44.724 rows=16 loops=1)

110. 0.051 44.713 ↑ 1.0 16 1

Hash Left Join (cost=278.01..4,455.09 rows=16 width=660) (actual time=44.676..44.713 rows=16 loops=1)

  • Hash Cond: (""Extent51"".odemeid = ""Extent52"".id)
111. 10.695 44.638 ↑ 1.0 16 1

Hash Join (cost=276.90..4,453.93 rows=16 width=463) (actual time=44.613..44.638 rows=16 loops=1)

  • Hash Cond: (""Extent54"".gecelemeid = ""Extent44"".id)
112. 33.320 33.320 ↑ 1.0 177,082 1

Seq Scan on hesayr ""Extent54"" (cost=0.00..3,512.82 rows=177,082 width=45) (actual time=0.006..33.320 rows=177,082 loops=1)

113. 0.035 0.623 ↓ 1.8 18 1

Hash (cost=276.77..276.77 rows=10 width=418) (actual time=0.623..0.623 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
114. 0.021 0.588 ↓ 1.8 18 1

Nested Loop Left Join (cost=56.52..276.77 rows=10 width=418) (actual time=0.247..0.588 rows=18 loops=1)

115. 0.025 0.549 ↓ 1.8 18 1

Hash Left Join (cost=56.38..275.20 rows=10 width=377) (actual time=0.238..0.549 rows=18 loops=1)

  • Hash Cond: (""Extent44"".acentaid = ""Extent46"".id)
116. 0.026 0.456 ↓ 1.8 18 1

Hash Left Join (cost=46.95..265.74 rows=10 width=311) (actual time=0.157..0.456 rows=18 loops=1)

  • Hash Cond: (""Extent44"".fiyatkonumid = ""Extent49"".id)
117. 0.007 0.417 ↓ 1.8 18 1

Nested Loop (cost=45.59..264.35 rows=10 width=273) (actual time=0.129..0.417 rows=18 loops=1)

  • Join Filter: (""Extent44"".odakonumid = ""Extent48"".id)
  • Rows Removed by Join Filter: 36
118. 0.006 0.392 ↓ 1.8 18 1

Nested Loop Left Join (cost=45.59..260.96 rows=10 width=222) (actual time=0.120..0.392 rows=18 loops=1)

119. 0.007 0.350 ↓ 1.8 18 1

Nested Loop Left Join (cost=45.17..176.61 rows=10 width=197) (actual time=0.113..0.350 rows=18 loops=1)

120. 0.063 0.289 ↓ 1.8 18 1

Hash Right Join (cost=44.75..92.26 rows=10 width=193) (actual time=0.100..0.289 rows=18 loops=1)

  • Hash Cond: (""Extent47"".id = ""Extent44"".odaid)
121. 0.150 0.150 ↑ 1.0 538 1

Seq Scan on oda ""Extent47"" (cost=0.00..39.38 rows=538 width=77) (actual time=0.003..0.150 rows=538 loops=1)

122. 0.012 0.076 ↓ 1.8 18 1

Hash (cost=44.63..44.63 rows=10 width=116) (actual time=0.076..0.076 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
123. 0.023 0.064 ↓ 1.8 18 1

Hash Left Join (cost=5.65..44.63 rows=10 width=116) (actual time=0.045..0.064 rows=18 loops=1)

  • Hash Cond: (""Extent44"".pansiyonid = ""Extent50"".id)
124. 0.017 0.029 ↓ 1.8 18 1

Bitmap Heap Scan on geceleme ""Extent44"" (cost=4.50..43.43 rows=10 width=77) (actual time=0.016..0.029 rows=18 loops=1)

  • Recheck Cond: (""Extent23"".id = rezid)
  • Heap Blocks: exact=10
125. 0.012 0.012 ↓ 1.8 18 1

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

  • Index Cond: (""Extent23"".id = rezid)
126. 0.007 0.012 ↓ 1.1 8 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
127. 0.005 0.005 ↓ 1.1 8 1

Seq Scan on pansiyon ""Extent50"" (cost=0.00..1.07 rows=7 width=39) (actual time=0.003..0.005 rows=8 loops=1)

128. 0.054 0.054 ↑ 1.0 1 18

Index Only Scan using ""gecelemedetayek_IX_id"" on gecelemedetayek ""Extent45"" (cost=0.42..8.44 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=18)

  • Index Cond: (id = ""Extent44"".id)
  • Heap Fetches: 18
129. 0.036 0.036 ↑ 1.0 1 18

Index Scan using ""gecelemedetayek_IX_id"" on gecelemedetayek ""Extent51"" (cost=0.42..8.44 rows=1 width=25) (actual time=0.002..0.002 rows=1 loops=18)

  • Index Cond: (""Extent44"".id = id)
130. 0.014 0.018 ↑ 5.3 3 18

Materialize (cost=0.00..1.24 rows=16 width=51) (actual time=0.000..0.001 rows=3 loops=18)

131. 0.004 0.004 ↑ 5.3 3 1

Seq Scan on odakonum ""Extent48"" (cost=0.00..1.16 rows=16 width=51) (actual time=0.003..0.004 rows=3 loops=1)

132. 0.007 0.013 ↑ 1.0 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
133. 0.006 0.006 ↑ 1.0 16 1

Seq Scan on fiyatkonum ""Extent49"" (cost=0.00..1.16 rows=16 width=38) (actual time=0.003..0.006 rows=16 loops=1)

134. 0.038 0.068 ↑ 1.0 108 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
135. 0.030 0.030 ↑ 1.0 108 1

Seq Scan on acenta ""Extent46"" (cost=0.00..8.08 rows=108 width=66) (actual time=0.003..0.030 rows=108 loops=1)

136. 0.018 0.018 ↑ 1.0 1 18

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

  • Index Cond: (""Extent51"".pazarid = id)
137. 0.010 0.024 ↑ 1.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
138. 0.014 0.014 ↑ 1.0 5 1

Seq Scan on odeme ""Extent52"" (cost=0.00..1.05 rows=5 width=43) (actual time=0.013..0.014 rows=5 loops=1)

139. 0.007 0.386 ↑ 9.0 1 1

Subquery Scan on "*SELECT* 2_1" (cost=4.60..48.88 rows=9 width=2,189) (actual time=0.380..0.386 rows=1 loops=1)

140. 0.007 0.379 ↑ 9.0 1 1

Nested Loop Left Join (cost=4.60..48.77 rows=9 width=2,185) (actual time=0.372..0.379 rows=1 loops=1)

  • Join Filter: (""Extent66"".kdvid = ""Extent70"".id)
  • Rows Removed by Join Filter: 1
141. 0.005 0.357 ↑ 9.0 1 1

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

142. 0.004 0.343 ↑ 9.0 1 1

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

143. 0.004 0.313 ↑ 9.0 1 1

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

144. 0.004 0.299 ↑ 9.0 1 1

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

145. 0.003 0.251 ↑ 1.0 1 1

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

146. 0.005 0.243 ↑ 1.0 1 1

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

147. 0.004 0.197 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.194..0.197 rows=1 loops=1)

148. 0.004 0.193 ↑ 1.0 1 1

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

  • Join Filter: (""Extent55"".tumbilbordid = ""Extent62"".id)
  • Rows Removed by Join Filter: 10
149. 0.003 0.087 ↑ 1.0 1 1

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

  • Join Filter: (""Extent59"".id = ""Extent60"".id)
  • Rows Removed by Join Filter: 10
150. 0.003 0.077 ↑ 1.0 1 1

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

  • Join Filter: (""Extent55"".tumbilbordid = ""Extent59"".id)
  • Rows Removed by Join Filter: 15
151. 0.003 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: (""Extent55"".id = ""Extent58"".id)
152. 0.002 0.054 ↑ 1.0 1 1

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

  • Join Filter: (""Extent55"".sirketid = ""Extent57"".id)
153. 0.002 0.047 ↑ 1.0 1 1

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

  • Join Filter: (""Extent55"".id = ""Extent56"".id)
154. 0.027 0.027 ↑ 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.026..0.027 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) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis) AND (NOT silinmis))
155. 0.018 0.018 ↑ 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.018..0.018 rows=1 loops=1)

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

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

157. 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)
158. 0.009 0.009 ↓ 1.5 15 1

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

159. 0.007 0.007 ↑ 1.0 10 1

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

160. 0.015 0.102 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent62"".id = ""Extent63"".id)
161. 0.027 0.076 ↑ 1.0 10 1

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

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

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

163. 0.038 0.045 ↓ 1.5 15 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
164. 0.007 0.007 ↓ 1.5 15 1

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

165. 0.007 0.011 ↑ 1.0 10 1

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

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

167. 0.041 0.041 ↑ 1.0 1 1

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

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

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

  • Index Cond: (""Extent64"".faturaid = id)
169. 0.044 0.044 ↑ 9.0 1 1

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk ""Extent66"" (cost=0.29..1.03 rows=9 width=153) (actual time=0.043..0.044 rows=1 loops=1)

  • Index Cond: (""Extent64"".id = folioid)
170. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (""Extent66"".depkodid = id)
171. 0.026 0.026 ↑ 1.0 1 1

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

  • Index Cond: (""Extent66"".kaynakfolioid = id)
172. 0.009 0.009 ↑ 1.0 1 1

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

  • Index Cond: (""Extent66"".dovizid = id)
173. 0.007 0.015 ↑ 1.5 2 1

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

174. 0.008 0.008 ↑ 1.5 2 1

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

175. 0.004 0.190 ↑ 2.0 1 1

Subquery Scan on "*SELECT* 2" (cost=32.18..35.01 rows=2 width=2,374) (actual time=0.187..0.190 rows=1 loops=1)

176. 0.030 0.186 ↑ 2.0 1 1

Hash Join (cost=32.18..34.99 rows=2 width=2,374) (actual time=0.184..0.186 rows=1 loops=1)

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

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

178. 0.006 0.141 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
179. 0.002 0.135 ↑ 1.0 1 1

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

180. 0.003 0.133 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.130..0.133 rows=1 loops=1)

181. 0.003 0.130 ↑ 1.0 1 1

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

  • Join Filter: (""Extent71"".tumbilbordid = ""Extent78"".id)
  • Rows Removed by Join Filter: 10
182. 0.003 0.068 ↑ 1.0 1 1

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

  • Join Filter: (""Extent75"".id = ""Extent76"".id)
  • Rows Removed by Join Filter: 10
183. 0.003 0.062 ↑ 1.0 1 1

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

  • Join Filter: (""Extent71"".tumbilbordid = ""Extent75"".id)
  • Rows Removed by Join Filter: 15
184. 0.002 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: (""Extent71"".id = ""Extent74"".id)
185. 0.002 0.040 ↑ 1.0 1 1

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

  • Join Filter: (""Extent71"".sirketid = ""Extent73"".id)
186. 0.002 0.035 ↑ 1.0 1 1

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

  • Join Filter: (""Extent71"".id = ""Extent72"".id)
187. 0.011 0.011 ↑ 1.0 1 1

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

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

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

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

190. 0.011 0.011 ↑ 1.0 1 1

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

  • Index Cond: (id = 2896917)
191. 0.006 0.006 ↓ 1.5 15 1

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

192. 0.003 0.003 ↑ 1.0 10 1

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

193. 0.016 0.059 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent78"".id = ""Extent79"".id)
194. 0.016 0.035 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent77"".id = ""Extent78"".id)
195. 0.010 0.010 ↑ 1.0 10 1

Seq Scan on tumbilbordek ""Extent77"" (cost=0.00..1.10 rows=10 width=24) (actual time=0.008..0.010 rows=10 loops=1)

196. 0.005 0.009 ↓ 1.5 15 1

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

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

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

198. 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
199. 0.004 0.004 ↑ 1.0 10 1

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