explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TgJU : Optimization for: Optimization for: Optimization for: plan #VQxf; plan #Jro3; plan #YtDJ

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2,272.090 29,464.640 ↑ 1.7 57,308 1

Hash Left Join (cost=154,534.25..186,479,851.55 rows=99,452 width=824) (actual time=5,485.418..29,464.640 rows=57,308 loops=1)

  • Hash Cond: (artmeas."SurfaceLocationId" = surfacelocation."Id")
2.          

CTE sections

3. 13.950 171.272 ↓ 1.0 15,149 1

WindowAgg (cost=39,071.46..39,333.77 rows=14,989 width=60) (actual time=152.642..171.272 rows=15,149 loops=1)

4. 14.161 157.322 ↓ 1.0 15,149 1

Sort (cost=39,071.46..39,108.93 rows=14,989 width=104) (actual time=152.625..157.322 rows=15,149 loops=1)

  • Sort Key: sec."Number
  • Sort Method: quicksort Memory: 1568kB
5. 9.262 143.161 ↓ 1.0 15,149 1

Hash Left Join (cost=2,146.40..38,031.85 rows=14,989 width=104) (actual time=37.780..143.161 rows=15,149 loops=1)

  • Hash Cond: (ob."Id" = ddoc."DiagnosticObjectId")
6. 1.825 98.363 ↓ 1.0 15,149 1

Nested Loop (cost=189.68..36,013.87 rows=14,989 width=28) (actual time=2.053..98.363 rows=15,149 loops=1)

7. 3.652 5.644 ↓ 1.0 15,149 1

Bitmap Heap Scan on "DiagnosticObject" ob (cost=189.25..10,636.83 rows=15,139 width=16) (actual time=2.028..5.644 rows=15,149 loops=1)

  • Recheck Cond: ("DiagnosticTargetId" = '6847248f-37c1-4f72-ad7a-357e4491c28a'::uuid)
  • Heap Blocks: exact=157
8. 1.992 1.992 ↓ 1.0 15,149 1

Bitmap Index Scan on "IX_DiagnosticSection_DiagnosticTargetId" (cost=0.00..185.47 rows=15,139 width=0) (actual time=1.992..1.992 rows=15,149 loops=1)

  • Index Cond: ("DiagnosticTargetId" = '6847248f-37c1-4f72-ad7a-357e4491c28a'::uuid)
9. 90.894 90.894 ↑ 1.0 1 15,149

Index Scan using "PK_Section" on "Section" sec (cost=0.43..1.67 rows=1 width=28) (actual time=0.005..0.006 rows=1 loops=15,149)

  • Index Cond: ("Id" = ob."Id")
10. 16.930 35.536 ↑ 1.0 49,232 1

Hash (cost=1,341.32..1,341.32 rows=49,232 width=92) (actual time=35.536..35.536 rows=49,232 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6519kB
11. 18.606 18.606 ↑ 1.0 49,232 1

Seq Scan on "DiagnosticObjectCoordinate" ddoc (cost=0.00..1,341.32 rows=49,232 width=92) (actual time=0.012..18.606 rows=49,232 loops=1)

12.          

CTE marker

13. 2.346 9.246 ↑ 87.9 182 1

Hash Join (cost=292.57..982.24 rows=16,000 width=54) (actual time=4.877..9.246 rows=182 loops=1)

  • Hash Cond: (sections_1."Id" = mar."SectionId")
14. 2.163 2.163 ↓ 1.0 15,149 1

CTE Scan on sections sections_1 (cost=0.00..299.78 rows=14,989 width=24) (actual time=0.002..2.163 rows=15,149 loops=1)

15. 2.783 4.737 ↑ 1.0 8,292 1

Hash (cost=188.92..188.92 rows=8,292 width=70) (actual time=4.737..4.737 rows=8,292 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 974kB
16. 1.954 1.954 ↑ 1.0 8,292 1

Seq Scan on "Marker" mar (cost=0.00..188.92 rows=8,292 width=70) (actual time=0.015..1.954 rows=8,292 loops=1)

17. 44.005 7,937.038 ↑ 1.7 57,308 1

Hash Left Join (cost=114,217.13..749,597.35 rows=99,452 width=1,403) (actual time=5,475.382..7,937.038 rows=57,308 loops=1)

  • Hash Cond: (sect."Id" = diagobjcoord."DiagnosticObjectId")
18. 59.014 7,862.009 ↑ 1.7 57,308 1

Nested Loop Left Join (cost=112,137.33..747,110.75 rows=99,452 width=1,343) (actual time=5,443.913..7,862.009 rows=57,308 loops=1)

19. 38.589 7,802.995 ↑ 1.7 57,308 1

Hash Left Join (cost=112,136.90..693,914.92 rows=99,452 width=554) (actual time=5,443.898..7,802.995 rows=57,308 loops=1)

  • Hash Cond: (artifactaddonpof."POFAnomalyClassId" = pofanomalyclass."Id")
20. 44.910 7,764.388 ↑ 1.7 57,308 1

Hash Left Join (cost=112,135.75..692,680.03 rows=99,452 width=565) (actual time=5,443.869..7,764.388 rows=57,308 loops=1)

  • Hash Cond: (artifactclass."DefectTypeId" = defecttype."Id")
21. 62.017 7,719.219 ↑ 1.7 57,308 1

Hash Left Join (cost=112,124.55..691,612.45 rows=99,452 width=577) (actual time=5,443.578..7,719.219 rows=57,308 loops=1)

  • Hash Cond: (artifact."Id" = sac."ArtifactId")
22. 41.408 6,316.186 ↑ 1.7 57,308 1

Hash Left Join (cost=43,995.11..623,086.35 rows=99,452 width=577) (actual time=4,100.661..6,316.186 rows=57,308 loops=1)

  • Hash Cond: (artifactaddonpof."POFArtifactIdentification" = pofartifactidentification."Id")
23. 51.646 6,274.710 ↑ 1.7 57,308 1

Nested Loop Left Join (cost=43,991.85..621,723.72 rows=99,452 width=553) (actual time=4,100.581..6,274.710 rows=57,308 loops=1)

24. 42.826 5,764.600 ↑ 1.7 57,308 1

Hash Left Join (cost=43,991.42..571,135.98 rows=99,452 width=308) (actual time=4,100.557..5,764.600 rows=57,308 loops=1)

  • Hash Cond: (artifactaddonpof."POFArtifactTypeId" = pofartifacttype."Id")
25. 67.874 5,721.749 ↑ 1.7 57,308 1

Nested Loop Left Join (cost=43,989.97..569,767.07 rows=99,452 width=295) (actual time=4,100.516..5,721.749 rows=57,308 loops=1)

26. 47.233 5,195.411 ↑ 1.7 57,308 1

Hash Left Join (cost=43,989.53..521,217.64 rows=99,452 width=247) (actual time=4,100.484..5,195.411 rows=57,308 loops=1)

  • Hash Cond: (artifact."ClassId" = artifactclass."Id")
27. 34.056 5,147.997 ↑ 1.7 57,308 1

Hash Left Join (cost=43,979.78..519,840.43 rows=99,452 width=191) (actual time=4,100.286..5,147.997 rows=57,308 loops=1)

  • Hash Cond: (pipelinesect."PipeInstallationId" = pipeinstallation."Id")
28. 78.506 5,113.928 ↑ 1.7 57,308 1

Nested Loop Left Join (cost=43,940.52..519,426.96 rows=99,452 width=203) (actual time=4,100.238..5,113.928 rows=57,308 loops=1)

29. 2,663.568 4,405.034 ↑ 1.7 57,308 1

Hash Join (cost=43,940.08..471,456.03 rows=99,452 width=161) (actual time=4,100.193..4,405.034 rows=57,308 loops=1)

  • Hash Cond: (artifact."DiagnosticObjectId" = diagobj."Id")
30. 1,361.397 1,361.397 ↑ 1.0 9,530,948 1

Seq Scan on "Artifact" artifact (cost=0.00..390,544.77 rows=9,593,777 width=89) (actual time=0.012..1,361.397 rows=9,530,948 loops=1)

31. 9.120 380.069 ↓ 1.0 15,149 1

Hash (cost=43,750.84..43,750.84 rows=15,139 width=104) (actual time=380.069..380.069 rows=15,149 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1845kB
32. 17.887 370.949 ↓ 1.0 15,149 1

Nested Loop Left Join (cost=10,830.98..43,750.84 rows=15,139 width=104) (actual time=168.912..370.949 rows=15,149 loops=1)

33. 5.271 292.466 ↓ 1.0 15,149 1

Nested Loop Left Join (cost=10,830.55..36,772.87 rows=15,139 width=104) (actual time=168.887..292.466 rows=15,149 loops=1)

34. 5.931 211.450 ↓ 1.0 15,149 1

Hash Left Join (cost=10,830.12..11,395.82 rows=15,139 width=52) (actual time=168.877..211.450 rows=15,149 loops=1)

  • Hash Cond: (diagobj."DiagnosticTargetId" = "innerDiagnosticTarget"."Id")
35. 11.129 205.460 ↓ 1.0 15,149 1

Hash Right Join (cost=10,826.07..11,183.61 rows=15,139 width=64) (actual time=168.796..205.460 rows=15,149 loops=1)

  • Hash Cond: (sections."Id" = diagobj."Id")
36. 178.239 178.239 ↓ 1.0 15,149 1

CTE Scan on sections (cost=0.00..299.78 rows=14,989 width=48) (actual time=152.647..178.239 rows=15,149 loops=1)

37. 6.036 16.092 ↓ 1.0 15,149 1

Hash (cost=10,636.83..10,636.83 rows=15,139 width=32) (actual time=16.092..16.092 rows=15,149 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1075kB
38. 6.570 10.056 ↓ 1.0 15,149 1

Bitmap Heap Scan on "DiagnosticObject" diagobj (cost=189.25..10,636.83 rows=15,139 width=32) (actual time=3.546..10.056 rows=15,149 loops=1)

  • Recheck Cond: ("DiagnosticTargetId" = '6847248f-37c1-4f72-ad7a-357e4491c28a'::uuid)
  • Filter: ("vrDeleted" IS FALSE)
  • Heap Blocks: exact=157
39. 3.486 3.486 ↓ 1.0 15,149 1

Bitmap Index Scan on "IX_DiagnosticSection_DiagnosticTargetId" (cost=0.00..185.47 rows=15,139 width=0) (actual time=3.486..3.486 rows=15,149 loops=1)

  • Index Cond: ("DiagnosticTargetId" = '6847248f-37c1-4f72-ad7a-357e4491c28a'::uuid)
40. 0.003 0.059 ↑ 1.0 1 1

Hash (cost=4.05..4.05 rows=1 width=20) (actual time=0.059..0.059 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
41. 0.022 0.056 ↑ 1.0 1 1

Hash Right Join (cost=2.38..4.05 rows=1 width=20) (actual time=0.051..0.056 rows=1 loops=1)

  • Hash Cond: ("constructiveDiameter"."Id" = "innerDiagnosticTarget"."DiameterId")
42. 0.019 0.019 ↑ 1.0 48 1

Seq Scan on "ConstructiveDiameter" "constructiveDiameter" (cost=0.00..1.48 rows=48 width=8) (actual time=0.014..0.019 rows=48 loops=1)

43. 0.003 0.015 ↑ 1.0 1 1

Hash (cost=2.36..2.36 rows=1 width=20) (actual time=0.015..0.015 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
44. 0.012 0.012 ↑ 1.0 1 1

Index Scan using "PK_InnerDiagnosticTarget" on "InnerDiagnosticTarget" "innerDiagnosticTarget" (cost=0.14..2.36 rows=1 width=20) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ("Id" = '6847248f-37c1-4f72-ad7a-357e4491c28a'::uuid)
45. 75.745 75.745 ↑ 1.0 1 15,149

Index Scan using "PK_Section" on "Section" sect (cost=0.43..1.67 rows=1 width=52) (actual time=0.005..0.005 rows=1 loops=15,149)

  • Index Cond: ("Id" = diagobj."Id")
46. 60.596 60.596 ↑ 1.0 1 15,149

Index Scan using "PK_Section" on "Section" pipelinesect (cost=0.42..0.45 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=15,149)

  • Index Cond: ("Id" = sect."PipelineSectionId")
47. 630.388 630.388 ↑ 1.0 1 57,308

Index Scan using "PK_ArtifactAddonMeasured" on "ArtifactAddonMeasured" artmeas (cost=0.43..0.47 rows=1 width=58) (actual time=0.011..0.011 rows=1 loops=57,308)

  • Index Cond: ("Id" = artifact."Id")
48. 0.000 0.013 ↓ 0.0 0 1

Hash (cost=29.89..29.89 rows=750 width=20) (actual time=0.013..0.013 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
49. 0.001 0.013 ↓ 0.0 0 1

Hash Left Join (cost=2.08..29.89 rows=750 width=20) (actual time=0.013..0.013 rows=0 loops=1)

  • Hash Cond: (pipeinstallation."ConstructiveDiameterId" = constructivediameter."Id")
50. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on "PipeInstallation" pipeinstallation (cost=0.00..17.50 rows=750 width=20) (actual time=0.012..0.012 rows=0 loops=1)

51. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.48..1.48 rows=48 width=8) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Seq Scan on "ConstructiveDiameter" constructivediameter (cost=0.00..1.48 rows=48 width=8) (never executed)

53. 0.097 0.181 ↑ 1.0 211 1

Hash (cost=7.11..7.11 rows=211 width=72) (actual time=0.181..0.181 rows=211 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
54. 0.084 0.084 ↑ 1.0 211 1

Seq Scan on "ArtifactClass" artifactclass (cost=0.00..7.11 rows=211 width=72) (actual time=0.009..0.084 rows=211 loops=1)

55. 458.464 458.464 ↑ 1.0 1 57,308

Index Scan using "PK_ArtifactAddonPOF" on "ArtifactAddonPOF" artifactaddonpof (cost=0.43..0.48 rows=1 width=64) (actual time=0.008..0.008 rows=1 loops=57,308)

  • Index Cond: ("Id" = artifact."Id")
56. 0.013 0.025 ↑ 1.0 20 1

Hash (cost=1.20..1.20 rows=20 width=45) (actual time=0.025..0.025 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
57. 0.012 0.012 ↑ 1.0 20 1

Seq Scan on "POFArtifactType" pofartifacttype (cost=0.00..1.20 rows=20 width=45) (actual time=0.007..0.012 rows=20 loops=1)

58. 458.464 458.464 ↑ 1.0 1 57,308

Index Scan using "PK_ArtifactAddonData" on "ArtifactAddonData" artifactaddondata (cost=0.43..0.50 rows=1 width=261) (actual time=0.007..0.008 rows=1 loops=57,308)

  • Index Cond: ("Id" = artifact."Id")
59. 0.046 0.068 ↑ 1.0 56 1

Hash (cost=2.56..2.56 rows=56 width=56) (actual time=0.068..0.068 rows=56 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
60. 0.022 0.022 ↑ 1.0 56 1

Seq Scan on "POFArtifactIdentification" pofartifactidentification (cost=0.00..2.56 rows=56 width=56) (actual time=0.009..0.022 rows=56 loops=1)

61. 78.244 1,341.016 ↑ 1.0 228,709 1

Hash (cost=65,270.58..65,270.58 rows=228,709 width=32) (actual time=1,341.016..1,341.016 rows=228,709 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 16343kB
62. 868.304 1,262.772 ↑ 1.0 228,709 1

Hash Right Join (cost=10,551.21..65,270.58 rows=228,709 width=32) (actual time=459.878..1,262.772 rows=228,709 loops=1)

  • Hash Cond: ((calcart."CalculationId" = calc."Id") AND (calcart."ArtifactId" = sac."ArtifactId"))
63. 212.901 212.901 ↑ 1.0 2,036,536 1

Seq Scan on "CalculationArtifact" calcart (cost=0.00..39,399.36 rows=2,036,536 width=48) (actual time=0.012..212.901 rows=2,036,536 loops=1)

64. 68.046 181.567 ↑ 1.0 228,709 1

Hash (cost=7,120.57..7,120.57 rows=228,709 width=32) (actual time=181.567..181.567 rows=228,709 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 16343kB
65. 84.888 113.521 ↑ 1.0 228,709 1

Hash Left Join (cost=6.74..7,120.57 rows=228,709 width=32) (actual time=0.116..113.521 rows=228,709 loops=1)

  • Hash Cond: (sac."CalculationId" = calc."Id")
66. 28.542 28.542 ↑ 1.0 228,709 1

Seq Scan on "ActiveCalculation" sac (cost=0.00..3,969.09 rows=228,709 width=32) (actual time=0.013..28.542 rows=228,709 loops=1)

67. 0.035 0.091 ↑ 1.0 166 1

Hash (cost=4.66..4.66 rows=166 width=16) (actual time=0.091..0.091 rows=166 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
68. 0.056 0.056 ↑ 1.0 166 1

Seq Scan on "Calculation" calc (cost=0.00..4.66 rows=166 width=16) (actual time=0.008..0.056 rows=166 loops=1)

69. 0.059 0.259 ↑ 1.0 145 1

Hash (cost=9.38..9.38 rows=145 width=20) (actual time=0.259..0.259 rows=145 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
70. 0.073 0.200 ↑ 1.0 145 1

Hash Left Join (cost=4.04..9.38 rows=145 width=20) (actual time=0.124..0.200 rows=145 loops=1)

  • Hash Cond: (defecttype."Id" = "defectTypeDefectGroupRef"."DefectTypeId")
71. 0.037 0.037 ↑ 1.0 145 1

Seq Scan on "DefectType" defecttype (cost=0.00..3.45 rows=145 width=16) (actual time=0.017..0.037 rows=145 loops=1)

72. 0.057 0.090 ↑ 1.0 135 1

Hash (cost=2.35..2.35 rows=135 width=20) (actual time=0.090..0.090 rows=135 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
73. 0.033 0.033 ↑ 1.0 135 1

Seq Scan on "DefectTypeDefectGroupRef" "defectTypeDefectGroupRef" (cost=0.00..2.35 rows=135 width=20) (actual time=0.010..0.033 rows=135 loops=1)

74. 0.008 0.018 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=21) (actual time=0.018..0.018 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
75. 0.010 0.010 ↑ 1.0 7 1

Seq Scan on "POFAnomalyClass" pofanomalyclass (cost=0.00..1.07 rows=7 width=21) (actual time=0.008..0.010 rows=7 loops=1)

76. 0.000 0.000 ↓ 0.0 0 57,308

Index Scan using "CalculationResult_PK" on "CalculationResult" res (cost=0.43..0.52 rows=1 width=821) (actual time=0.000..0.000 rows=0 loops=57,308)

  • Index Cond: (calcart."Id" = "Id")
77. 16.914 31.024 ↑ 1.0 49,232 1

Hash (cost=1,464.40..1,464.40 rows=49,232 width=92) (actual time=31.024..31.024 rows=49,232 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6519kB
78. 14.110 14.110 ↑ 1.0 49,232 1

Seq Scan on "DiagnosticObjectCoordinate" diagobjcoord (cost=0.00..1,464.40 rows=49,232 width=92) (actual time=0.012..14.110 rows=49,232 loops=1)

  • Filter: ("CoordinateSystemId" = '72b16dc7-f56e-4203-ba60-7b369f444c88'::uuid)
79. 0.007 0.024 ↑ 1.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
80. 0.017 0.017 ↑ 1.0 5 1

Seq Scan on "SurfaceLocation" surfacelocation (cost=0.00..1.05 rows=5 width=29) (actual time=0.014..0.017 rows=5 loops=1)

81.          

SubPlan (forHash Left Join)

82. 57.308 5,329.644 ↑ 1.0 1 57,308

Limit (cost=466.67..466.67 rows=1 width=8) (actual time=0.093..0.093 rows=1 loops=57,308)

83. 1,318.084 5,272.336 ↑ 5,333.0 1 57,308

Sort (cost=466.67..480.00 rows=5,333 width=8) (actual time=0.092..0.092 rows=1 loops=57,308)

  • Sort Key: marker."MarkerDistanse" DESC
  • Sort Method: top-N heapsort Memory: 25kB
84. 3,954.252 3,954.252 ↑ 50.3 106 57,308

CTE Scan on marker (cost=0.00..440.00 rows=5,333 width=8) (actual time=0.002..0.069 rows=106 loops=57,308)

  • Filter: (((sect."Distance")::real + artmeas."Distance") > "MarkerDistanse")
  • Rows Removed by Filter: 76
85. 0.000 4,871.180 ↑ 1.0 1 57,308

Limit (cost=466.67..466.67 rows=1 width=4) (actual time=0.085..0.085 rows=1 loops=57,308)

86. 1,088.852 4,871.180 ↑ 5,333.0 1 57,308

Sort (cost=466.67..480.00 rows=5,333 width=4) (actual time=0.085..0.085 rows=1 loops=57,308)

  • Sort Key: marker_1."MarkerDistanse" DESC
  • Sort Method: top-N heapsort Memory: 25kB
87. 3,782.328 3,782.328 ↑ 50.3 106 57,308

CTE Scan on marker marker_1 (cost=0.00..440.00 rows=5,333 width=4) (actual time=0.001..0.066 rows=106 loops=57,308)

  • Filter: (((sect."Distance")::real + artmeas."Distance") > "MarkerDistanse")
  • Rows Removed by Filter: 76
88. 0.000 4,584.640 ↑ 1.0 1 57,308

Limit (cost=466.67..466.67 rows=1 width=8) (actual time=0.080..0.080 rows=1 loops=57,308)

89. 859.620 4,584.640 ↑ 5,333.0 1 57,308

Sort (cost=466.67..480.00 rows=5,333 width=8) (actual time=0.080..0.080 rows=1 loops=57,308)

  • Sort Key: marker_2."MarkerDistanse
  • Sort Method: quicksort Memory: 25kB
90. 3,725.020 3,725.020 ↑ 70.2 76 57,308

CTE Scan on marker marker_2 (cost=0.00..440.00 rows=5,333 width=8) (actual time=0.035..0.065 rows=76 loops=57,308)

  • Filter: (((sect."Distance")::real + artmeas."Distance") < "MarkerDistanse")
  • Rows Removed by Filter: 106
91. 57.308 4,470.024 ↑ 1.0 1 57,308

Limit (cost=466.67..466.67 rows=1 width=4) (actual time=0.078..0.078 rows=1 loops=57,308)

92. 745.004 4,412.716 ↑ 5,333.0 1 57,308

Sort (cost=466.67..480.00 rows=5,333 width=4) (actual time=0.077..0.077 rows=1 loops=57,308)

  • Sort Key: marker_3."MarkerDistanse
  • Sort Method: quicksort Memory: 25kB
93. 3,667.712 3,667.712 ↑ 70.2 76 57,308

CTE Scan on marker marker_3 (cost=0.00..440.00 rows=5,333 width=4) (actual time=0.035..0.064 rows=76 loops=57,308)

  • Filter: (((sect."Distance")::real + artmeas."Distance") < "MarkerDistanse")
  • Rows Removed by Filter: 106