explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 2,250.533 30,809.904 ↑ 1.7 57,308 1

Hash Left Join (cost=154,534.25..186,479,851.55 rows=99,452 width=824) (actual time=6,537.872..30,809.904 rows=57,308 loops=1)

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

CTE sections

3. 13.064 215.300 ↓ 1.0 15,149 1

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

4. 13.869 202.236 ↓ 1.0 15,149 1

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

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

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

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

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

7. 3.854 5.720 ↓ 1.0 15,149 1

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

  • Recheck Cond: ("DiagnosticTargetId" = '6847248f-37c1-4f72-ad7a-357e4491c28a'::uuid)
  • Heap Blocks: exact=157
8. 1.866 1.866 ↓ 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.866..1.866 rows=15,149 loops=1)

  • Index Cond: ("DiagnosticTargetId" = '6847248f-37c1-4f72-ad7a-357e4491c28a'::uuid)
9. 121.192 121.192 ↑ 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.008..0.008 rows=1 loops=15,149)

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

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

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

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

12.          

CTE marker

13. 3.106 14.565 ↑ 87.9 182 1

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

  • Hash Cond: (sections_1."Id" = mar."SectionId")
14. 4.786 4.786 ↓ 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..4.786 rows=15,149 loops=1)

15. 4.159 6.673 ↑ 1.0 8,292 1

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

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

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

17. 38.196 9,418.481 ↑ 1.7 57,308 1

Hash Left Join (cost=114,217.13..749,597.35 rows=99,452 width=1,403) (actual time=6,522.400..9,418.481 rows=57,308 loops=1)

  • Hash Cond: (sect."Id" = diagobjcoord."DiagnosticObjectId")
18. 62.579 9,350.802 ↑ 1.7 57,308 1

Nested Loop Left Join (cost=112,137.33..747,110.75 rows=99,452 width=1,343) (actual time=6,492.436..9,350.802 rows=57,308 loops=1)

19. 39.879 9,288.223 ↑ 1.7 57,308 1

Hash Left Join (cost=112,136.90..693,914.92 rows=99,452 width=554) (actual time=6,492.422..9,288.223 rows=57,308 loops=1)

  • Hash Cond: (artifactaddonpof."POFAnomalyClassId" = pofanomalyclass."Id")
20. 42.858 9,248.326 ↑ 1.7 57,308 1

Hash Left Join (cost=112,135.75..692,680.03 rows=99,452 width=565) (actual time=6,492.379..9,248.326 rows=57,308 loops=1)

  • Hash Cond: (artifactclass."DefectTypeId" = defecttype."Id")
21. 61.347 9,205.224 ↑ 1.7 57,308 1

Hash Left Join (cost=112,124.55..691,612.45 rows=99,452 width=577) (actual time=6,492.086..9,205.224 rows=57,308 loops=1)

  • Hash Cond: (artifact."Id" = sac."ArtifactId")
22. 41.822 7,742.348 ↑ 1.7 57,308 1

Hash Left Join (cost=43,995.11..623,086.35 rows=99,452 width=577) (actual time=5,088.708..7,742.348 rows=57,308 loops=1)

  • Hash Cond: (artifactaddonpof."POFArtifactIdentification" = pofartifactidentification."Id")
23. 64.255 7,700.460 ↑ 1.7 57,308 1

Nested Loop Left Join (cost=43,991.85..621,723.72 rows=99,452 width=553) (actual time=5,088.635..7,700.460 rows=57,308 loops=1)

24. 46.981 7,120.433 ↑ 1.7 57,308 1

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

  • Hash Cond: (artifactaddonpof."POFArtifactTypeId" = pofartifacttype."Id")
25. 40.497 7,073.424 ↑ 1.7 57,308 1

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

26. 46.718 6,402.539 ↑ 1.7 57,308 1

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

  • Hash Cond: (artifact."ClassId" = artifactclass."Id")
27. 32.138 6,355.653 ↑ 1.7 57,308 1

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

  • Hash Cond: (pipelinesect."PipeInstallationId" = pipeinstallation."Id")
28. 103.949 6,323.503 ↑ 1.7 57,308 1

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

29. 3,358.158 5,474.550 ↑ 1.7 57,308 1

Hash Join (cost=43,940.08..471,456.03 rows=99,452 width=161) (actual time=5,088.189..5,474.550 rows=57,308 loops=1)

  • Hash Cond: (artifact."DiagnosticObjectId" = diagobj."Id")
30. 1,671.624 1,671.624 ↑ 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.021..1,671.624 rows=9,530,948 loops=1)

31. 10.816 444.768 ↓ 1.0 15,149 1

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

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

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

33. 9.823 345.482 ↓ 1.0 15,149 1

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

34. 6.094 259.914 ↓ 1.0 15,149 1

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

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

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

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

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

37. 8.015 20.473 ↓ 1.0 15,149 1

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

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

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

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

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

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

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

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

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

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

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

43. 0.004 0.028 ↑ 1.0 1 1

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

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

Index Scan using "PK_InnerDiagnosticTarget" on "InnerDiagnosticTarget" "innerDiagnosticTarget" (cost=0.14..2.36 rows=1 width=20) (actual time=0.024..0.024 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. 75.745 75.745 ↑ 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.005..0.005 rows=1 loops=15,149)

  • Index Cond: ("Id" = sect."PipelineSectionId")
47. 745.004 745.004 ↑ 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.013..0.013 rows=1 loops=57,308)

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

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

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

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

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

Seq Scan on "PipeInstallation" pipeinstallation (cost=0.00..17.50 rows=750 width=20) (actual time=0.010..0.010 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.080 0.168 ↑ 1.0 211 1

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

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

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

55. 630.388 630.388 ↑ 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.011..0.011 rows=1 loops=57,308)

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

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

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

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

58. 515.772 515.772 ↑ 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.008..0.009 rows=1 loops=57,308)

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

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

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

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

61. 77.072 1,401.529 ↑ 1.0 228,709 1

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

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

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

  • Hash Cond: ((calcart."CalculationId" = calc."Id") AND (calcart."ArtifactId" = sac."ArtifactId"))
63. 249.829 249.829 ↑ 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.013..249.829 rows=2,036,536 loops=1)

64. 67.739 186.388 ↑ 1.0 228,709 1

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

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

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

  • Hash Cond: (sac."CalculationId" = calc."Id")
66. 30.561 30.561 ↑ 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..30.561 rows=228,709 loops=1)

67. 0.042 0.095 ↑ 1.0 166 1

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

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

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

69. 0.041 0.244 ↑ 1.0 145 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
70. 0.092 0.203 ↑ 1.0 145 1

Hash Left Join (cost=4.04..9.38 rows=145 width=20) (actual time=0.133..0.203 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.018..0.037 rows=145 loops=1)

72. 0.046 0.074 ↑ 1.0 135 1

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

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

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

74. 0.007 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.011 0.011 ↑ 1.0 7 1

Seq Scan on "POFAnomalyClass" pofanomalyclass (cost=0.00..1.07 rows=7 width=21) (actual time=0.008..0.011 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.098 29.483 ↑ 1.0 49,232 1

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

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

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

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

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

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

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

81.          

SubPlan (forHash Left Join)

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

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

83. 1,260.776 5,215.028 ↑ 5,333.0 1 57,308

Sort (cost=466.67..480.00 rows=5,333 width=8) (actual time=0.091..0.091 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. 57.308 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,031.544 4,813.872 ↑ 5,333.0 1 57,308

Sort (cost=466.67..480.00 rows=5,333 width=4) (actual time=0.084..0.084 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. 57.308 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. 802.312 4,527.332 ↑ 5,333.0 1 57,308

Sort (cost=466.67..480.00 rows=5,333 width=8) (actual time=0.079..0.079 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,412.716 ↑ 1.0 1 57,308

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

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

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

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

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

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