explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M2rC

Settings
# exclusive inclusive rows x rows loops node
1. 0.860 1,399.723 ↓ 1.1 57 1

Sort (cost=66,027.02..66,027.15 rows=52 width=2,229) (actual time=1,399.721..1,399.723 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"".""C98"", ""UnionAll3"".""C107"", ""UnionAll3"".""C125"", ""UnionAll3"".""C141"", ""UnionAll3"".""C159"", ""UnionAll3"".""C174"", ""UnionAll3"".""C184"", ""UnionAll3"".""C192"", ""UnionAll3"".""C212"", ""UnionAll3"".""C221"", ""UnionAll3"".""C241"
  • Sort Method: quicksort Memory: 81kB
2. 0.015 1,398.863 ↓ 1.1 57 1

Append (cost=34.17..66,025.54 rows=52 width=2,229) (actual time=0.300..1,398.863 rows=57 loops=1)

3. 0.108 1,398.663 ↓ 1.1 56 1

Subquery Scan on "UnionAll3" (cost=34.17..65,990.52 rows=50 width=2,235) (actual time=0.299..1,398.663 rows=56 loops=1)

4. 0.012 1,398.555 ↓ 1.1 56 1

Append (cost=34.17..65,990.02 rows=50 width=2,235) (actual time=0.298..1,398.555 rows=56 loops=1)

5. 0.013 1,398.281 ↓ 1.3 55 1

Append (cost=34.17..65,940.73 rows=41 width=1,940) (actual time=0.297..1,398.281 rows=55 loops=1)

6. 0.026 0.298 ↑ 3.0 1 1

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

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

Hash Join (cost=1.99..5.61 rows=126 width=75) (actual time=0.069..0.133 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.016 0.034 ↑ 1.0 44 1

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

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

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

11. 0.005 0.139 ↑ 1.0 1 1

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

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

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

13. 0.003 0.134 ↑ 1.0 1 1

Limit (cost=3.31..32.15 rows=1 width=278) (actual time=0.131..0.134 rows=1 loops=1)

14. 0.002 0.131 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

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

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

  • Join Filter: (""Extent1"".id = ""Extent2"".id)
20. 0.024 0.024 ↑ 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.024..0.024 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))
21. 0.015 0.015 ↑ 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.015..0.015 rows=1 loops=1)

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

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

23. 0.008 0.008 ↑ 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.008..0.008 rows=1 loops=1)

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

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

25. 0.004 0.004 ↑ 1.0 10 1

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

26. 0.015 0.055 ↑ 1.0 10 1

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

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

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

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

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

29. 0.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
30. 0.004 0.004 ↓ 1.5 15 1

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

31. 0.004 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
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.000 0.123 ↓ 0.0 0 1

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

34. 0.001 0.123 ↓ 0.0 0 1

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

35. 0.002 0.108 ↑ 1.0 1 1

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

36. 0.002 0.106 ↑ 1.0 1 1

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

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

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

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

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

  • Join Filter: (""Extent12"".id = ""Extent13"".id)
42. 0.014 0.014 ↑ 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.014..0.014 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))
43. 0.008 0.008 ↑ 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.008..0.008 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.002..0.003 rows=1 loops=1)

45. 0.009 0.009 ↑ 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.009..0.009 rows=1 loops=1)

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

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

47. 0.003 0.003 ↑ 1.0 10 1

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

48. 0.016 0.056 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent19"".id = ""Extent20"".id)
49. 0.017 0.031 ↑ 1.0 10 1

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

  • Hash Cond: (""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.010..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.006 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
54. 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)

55. 0.014 0.014 ↓ 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.014..0.014 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. 21.315 1,397.847 ↓ 2.6 54 1

Hash Join (cost=40,122.26..65,835.29 rows=21 width=1,793) (actual time=508.997..1,397.847 rows=54 loops=1)

  • Hash Cond: (""Extent32"".rezid = ""Alias39"".id)
58. 131.925 1,376.417 ↓ 1.0 243,211 1

Hash Left Join (cost=40,090.09..64,892.20 rows=242,854 width=434) (actual time=288.347..1,376.417 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".pansiyonid = ""Extent37"".id)
59. 129.346 1,244.477 ↓ 1.0 243,211 1

Hash Left Join (cost=40,088.93..63,868.04 rows=242,854 width=395) (actual time=288.305..1,244.477 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".fiyatkonumid = ""Extent36"".id)
60. 125.376 1,115.114 ↓ 1.0 243,211 1

Hash Join (cost=40,087.57..63,215.68 rows=242,854 width=357) (actual time=288.274..1,115.114 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".odakonumid = ""Extent35"".id)
61. 120.204 989.718 ↓ 1.0 243,211 1

Hash Left Join (cost=40,086.21..62,407.97 rows=242,854 width=306) (actual time=288.240..989.718 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".odaid = ""Extent34"".id)
62. 112.509 869.120 ↓ 1.0 243,211 1

Hash Left Join (cost=40,040.11..61,721.17 rows=242,854 width=229) (actual time=287.831..869.120 rows=243,211 loops=1)

  • Hash Cond: (""Extent32"".acentaid = ""Extent33"".id)
63. 237.253 756.519 ↓ 1.0 243,211 1

Hash Right Join (cost=40,030.68..61,049.23 rows=242,854 width=163) (actual time=287.709..756.519 rows=243,211 loops=1)

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

Hash Join (cost=29,677.08..41,992.12 rows=242,854 width=86) (actual time=204.999..437.229 rows=242,854 loops=1)

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

Seq Scan on gecelememusteri ""Extent38"" (cost=0.00..4,456.54 rows=242,854 width=33) (actual time=0.011..47.501 rows=242,854 loops=1)

66. 107.932 204.147 ↓ 1.0 353,896 1

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

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

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

68. 41.375 82.037 ↑ 1.0 112,160 1

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

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

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

70. 0.033 0.092 ↑ 1.0 108 1

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

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

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

72. 0.173 0.394 ↑ 1.0 538 1

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

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

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

74. 0.011 0.020 ↑ 1.0 16 1

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

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

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

76. 0.007 0.017 ↑ 1.0 16 1

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

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

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

78. 0.008 0.015 ↓ 1.1 8 1

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

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

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

80. 0.004 0.115 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
81. 0.000 0.111 ↑ 1.0 1 1

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

82. 0.003 0.111 ↑ 1.0 1 1

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

83. 0.001 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: (""Extent23"".tumbilbordid = ""Extent30"".id)
  • Rows Removed by Join Filter: 10
84. 0.002 0.041 ↑ 1.0 1 1

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

  • Join Filter: (""Extent27"".id = ""Extent28"".id)
  • Rows Removed by Join Filter: 10
85. 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
86. 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)
87. 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: (""Extent23"".sirketid = ""Extent25"".id)
88. 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: (""Extent23"".id = ""Extent24"".id)
89. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (id = 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))
90. 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
91. 0.003 0.003 ↑ 1.0 1 1

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

92. 0.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)
93. 0.005 0.005 ↓ 1.5 15 1

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

94. 0.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)

95. 0.015 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: (""Extent30"".id = ""Extent31"".id)
96. 0.031 0.044 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent29"".id = ""Extent30"".id)
97. 0.003 0.003 ↑ 1.0 10 1

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

98. 0.005 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
99. 0.005 0.005 ↓ 1.5 15 1

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

100. 0.004 0.007 ↑ 1.0 10 1

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

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

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

102. 0.006 0.262 ↑ 9.0 1 1

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

103. 0.020 0.256 ↑ 9.0 1 1

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

  • Join Filter: (""Extent51"".kdvid = ""Extent55"".id)
  • Rows Removed by Join Filter: 1
104. 0.004 0.224 ↑ 9.0 1 1

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

105. 0.003 0.211 ↑ 9.0 1 1

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

106. 0.005 0.197 ↑ 9.0 1 1

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

107. 0.003 0.180 ↑ 9.0 1 1

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

108. 0.003 0.160 ↑ 1.0 1 1

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

109. 0.003 0.156 ↑ 1.0 1 1

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

110. 0.006 0.141 ↑ 1.0 1 1

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

111. 0.003 0.135 ↑ 1.0 1 1

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

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

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

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

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

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

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

  • Join Filter: (""Extent40"".id = ""Extent43"".id)
115. 0.002 0.056 ↑ 1.0 1 1

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

  • Join Filter: (""Extent40"".sirketid = ""Extent42"".id)
116. 0.004 0.045 ↑ 1.0 1 1

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

  • Join Filter: (""Extent40"".id = ""Extent41"".id)
117. 0.031 0.031 ↑ 1.0 1 1

Index Scan using ""PK_public.rez"" on rez ""Extent40"" (cost=0.29..8.30 rows=1 width=66) (actual time=0.031..0.031 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))
118. 0.010 0.010 ↑ 1.0 1 1

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

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

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

120. 0.009 0.009 ↑ 1.0 1 1

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

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

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

122. 0.006 0.006 ↑ 1.0 10 1

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

123. 0.008 0.043 ↑ 1.0 10 1

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

  • Hash Cond: (""Extent47"".id = ""Extent48"".id)
124. 0.017 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: (""Extent46"".id = ""Extent47"".id)
125. 0.004 0.004 ↑ 1.0 10 1

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

126. 0.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
127. 0.004 0.004 ↓ 1.5 15 1

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

128. 0.003 0.006 ↑ 1.0 10 1

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

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

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

130. 0.012 0.012 ↑ 1.0 1 1

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

  • Index Cond: (rezid = ""Extent40"".id)
131. 0.001 0.001 ↓ 0.0 0 1

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

  • Index Cond: (""Extent49"".faturaid = id)
132. 0.017 0.017 ↑ 9.0 1 1

Index Scan using ""hrk_FolioIdIdxmauel"" on hrk ""Extent51"" (cost=0.29..1.03 rows=9 width=153) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: (""Extent49"".id = folioid)
133. 0.012 0.012 ↑ 1.0 1 1

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

  • Index Cond: (""Extent51"".depkodid = id)
134. 0.011 0.011 ↑ 1.0 1 1

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

  • Index Cond: (""Extent51"".kaynakfolioid = id)
135. 0.009 0.009 ↑ 1.0 1 1

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

  • Index Cond: (""Extent51"".dovizid = id)
136. 0.005 0.012 ↑ 1.5 2 1

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

137. 0.007 0.007 ↑ 1.5 2 1

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

138. 0.004 0.185 ↑ 2.0 1 1

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

139. 0.030 0.181 ↑ 2.0 1 1

Hash Join (cost=32.18..34.99 rows=2 width=2,102) (actual time=0.179..0.181 rows=1 loops=1)

  • Hash Cond: (""Extent65"".rezid = ""Alias77"".id)
140. 0.017 0.017 ↓ 1.3 73 1

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

141. 0.010 0.134 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
142. 0.001 0.124 ↑ 1.0 1 1

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

143. 0.005 0.123 ↑ 1.0 1 1

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

144. 0.003 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: (""Extent56"".tumbilbordid = ""Extent63"".id)
  • Rows Removed by Join Filter: 10
145. 0.002 0.065 ↑ 1.0 1 1

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

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

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

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

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

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

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

  • Join Filter: (""Extent56"".sirketid = ""Extent58"".id)
149. 0.002 0.026 ↑ 1.0 1 1

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

  • Join Filter: (""Extent56"".id = ""Extent57"".id)
150. 0.011 0.011 ↑ 1.0 1 1

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

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

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

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

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

153. 0.017 0.017 ↑ 1.0 1 1

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

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

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

155. 0.005 0.005 ↑ 1.0 10 1

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

156. 0.015 0.050 ↑ 1.0 10 1

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

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

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

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

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

159. 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
160. 0.004 0.004 ↓ 1.5 15 1

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

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

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