explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VQxf

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.023 56,561.875 ↑ 1.0 200 1

Limit (cost=397,935,968.64..397,935,969.14 rows=200 width=908) (actual time=56,561.818..56,561.875 rows=200 loops=1)

2.          

CTE sections

3. 8.727 182.066 ↓ 1.0 15,149 1

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

4. 11.019 173.339 ↓ 1.0 15,149 1

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

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

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

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

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

7. 5.029 6.845 ↓ 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.866..6.845 rows=15,149 loops=1)

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

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

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

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

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

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

12.          

CTE marker

13. 2.483 194.816 ↑ 87.9 182 1

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

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

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

15. 2.771 5.079 ↑ 1.0 8,292 1

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

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

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

17. 71.666 56,561.852 ↑ 572.6 200 1

Sort (cost=397,895,652.63..397,895,938.95 rows=114,527 width=908) (actual time=56,561.816..56,561.852 rows=200 loops=1)

  • Sort Key: "*SELECT* 1"."Distance", (1)
  • Sort Method: top-N heapsort Memory: 114kB
18. 474.539 56,490.186 ↑ 1.6 72,639 1

WindowAgg (cost=397,885,262.82..397,890,702.85 rows=114,527 width=908) (actual time=56,167.287..56,490.186 rows=72,639 loops=1)

19. 558.937 56,015.647 ↑ 1.6 72,639 1

HashAggregate (cost=397,885,262.82..397,886,408.09 rows=114,527 width=844) (actual time=55,906.106..56,015.647 rows=72,639 loops=1)

  • Group Key: "*SELECT* 1"."ObjectType", "*SELECT* 1"."ObjectTypePOF", (1), "*SELECT* 1"."Distance", "*SELECT* 1"."Number", (''::text), (''::text), "*SELECT* 1"."SectNumber", "*SELECT* 1"."PipeType", "*SELECT* 1"."SectionLength", "*SELECT* 1"."AxialWeldStartAngle", "*SELECT* 1"."AverageWallThickness", (''::text), (NULL::numeric), (''::text), (''::text), (''::text), (''::text), (''::text), (NULL::double precision), "*SELECT* 1"."NextDistance", (NULL::double precision), (NULL::double precision), "*SELECT* 1"."Psw", (NULL::integer), "*SELECT* 1"."Lat", "*SELECT* 1"."Lon", "*SELECT* 1"."Alt", (NULL::integer), (NULL::double precision), (NULL::integer), (NULL::double precision), (NULL::text), (NULL::numeric), ((NULL::numeric)::double precision), (NULL::text), "*SELECT* 1"."Coordinates", "*SELECT* 1"."BeforMarkerNumber", "*SELECT* 1"."BeforMarkerDistanse", "*SELECT* 1"."AfterMarkerNumber", "*SELECT* 1"."AfterMarkerDistanse
20. 23.373 55,456.710 ↑ 1.6 72,639 1

Append (cost=2,272.13..397,873,523.80 rows=114,527 width=844) (actual time=249.532..55,456.710 rows=72,639 loops=1)

21. 18.326 4,550.423 ↓ 1.0 15,149 1

Subquery Scan on *SELECT* 1 (cost=2,272.13..25,630,120.16 rows=14,989 width=806) (actual time=249.531..4,550.423 rows=15,149 loops=1)

22. 282.212 4,532.097 ↓ 1.0 15,149 1

Hash Left Join (cost=2,272.13..25,629,932.80 rows=14,989 width=830) (actual time=249.523..4,532.097 rows=15,149 loops=1)

  • Hash Cond: (sect."Id" = diagobjcoord."DiagnosticObjectId")
23. 10.882 351.833 ↓ 1.0 15,149 1

Hash Left Join (cost=192.33..43,667.15 rows=14,989 width=224) (actual time=3.221..351.833 rows=15,149 loops=1)

  • Hash Cond: (sect."PipeTypeId" = pt."Id")
24. 8.230 340.929 ↓ 1.0 15,149 1

Nested Loop Left Join (cost=191.22..43,459.94 rows=14,989 width=206) (actual time=3.177..340.929 rows=15,149 loops=1)

25. 14.972 181.209 ↓ 1.0 15,149 1

Hash Left Join (cost=190.79..36,221.09 rows=14,989 width=62) (actual time=3.133..181.209 rows=15,149 loops=1)

  • Hash Cond: (sect."SectionTypeId" = st."Id")
26. 17.735 166.216 ↓ 1.0 15,149 1

Nested Loop (cost=189.68..36,013.87 rows=14,989 width=48) (actual time=3.089..166.216 rows=15,149 loops=1)

27. 9.170 12.140 ↓ 1.0 15,149 1

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

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

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

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

  • Index Cond: ("Id" = diagobj."Id")
30. 0.009 0.021 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=22) (actual time=0.021..0.021 rows=5 loops=1)

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

Seq Scan on "SectionType" st (cost=0.00..1.05 rows=5 width=22) (actual time=0.008..0.012 rows=5 loops=1)

32. 151.490 151.490 ↑ 1.0 1 15,149

Index Scan using "PK_SectionAddonData" on "SectionAddonData" sectionaddondata (cost=0.43..0.47 rows=1 width=160) (actual time=0.009..0.010 rows=1 loops=15,149)

  • Index Cond: ("Id" = sect."Id")
33. 0.015 0.022 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=26) (actual time=0.022..0.022 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.007 0.007 ↑ 1.0 5 1

Seq Scan on "PipeType" pt (cost=0.00..1.05 rows=5 width=26) (actual time=0.004..0.007 rows=5 loops=1)

35. 24.223 50.206 ↑ 1.0 49,232 1

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

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

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

  • Filter: ("CoordinateSystemId" = '72b16dc7-f56e-4203-ba60-7b369f444c88'::uuid)
37.          

SubPlan (forHash Left Join)

38. 30.298 1,196.771 ↑ 1.0 1 15,149

Limit (cost=426.67..426.67 rows=1 width=8) (actual time=0.078..0.079 rows=1 loops=15,149)

39. 287.831 1,166.473 ↑ 5,333.0 1 15,149

Sort (cost=426.67..440.00 rows=5,333 width=8) (actual time=0.077..0.077 rows=1 loops=15,149)

  • Sort Key: marker_12."MarkerDistanse" DESC
  • Sort Method: top-N heapsort Memory: 25kB
40. 878.642 878.642 ↑ 60.6 88 15,149

CTE Scan on marker marker_12 (cost=0.00..400.00 rows=5,333 width=8) (actual time=0.014..0.058 rows=88 loops=15,149)

  • Filter: ((sect."Distance")::real > "MarkerDistanse")
  • Rows Removed by Filter: 94
41. 0.000 863.493 ↑ 1.0 1 15,149

Limit (cost=426.67..426.67 rows=1 width=4) (actual time=0.057..0.057 rows=1 loops=15,149)

42. 242.384 863.493 ↑ 5,333.0 1 15,149

Sort (cost=426.67..440.00 rows=5,333 width=4) (actual time=0.057..0.057 rows=1 loops=15,149)

  • Sort Key: marker_13."MarkerDistanse" DESC
  • Sort Method: top-N heapsort Memory: 25kB
43. 621.109 621.109 ↑ 60.6 88 15,149

CTE Scan on marker marker_13 (cost=0.00..400.00 rows=5,333 width=4) (actual time=0.001..0.041 rows=88 loops=15,149)

  • Filter: ((sect."Distance")::real > "MarkerDistanse")
  • Rows Removed by Filter: 94
44. 15.149 908.940 ↑ 1.0 1 15,149

Limit (cost=426.67..426.67 rows=1 width=8) (actual time=0.059..0.060 rows=1 loops=15,149)

45. 257.533 893.791 ↑ 5,333.0 1 15,149

Sort (cost=426.67..440.00 rows=5,333 width=8) (actual time=0.059..0.059 rows=1 loops=15,149)

  • Sort Key: marker_14."MarkerDistanse
  • Sort Method: quicksort Memory: 25kB
46. 636.258 636.258 ↑ 56.7 94 15,149

CTE Scan on marker marker_14 (cost=0.00..400.00 rows=5,333 width=8) (actual time=0.017..0.042 rows=94 loops=15,149)

  • Filter: ((sect."Distance")::real < "MarkerDistanse")
  • Rows Removed by Filter: 88
47. 15.149 878.642 ↑ 1.0 1 15,149

Limit (cost=426.67..426.67 rows=1 width=4) (actual time=0.057..0.058 rows=1 loops=15,149)

48. 227.235 863.493 ↑ 5,333.0 1 15,149

Sort (cost=426.67..440.00 rows=5,333 width=4) (actual time=0.057..0.057 rows=1 loops=15,149)

  • Sort Key: marker_15."MarkerDistanse
  • Sort Method: quicksort Memory: 25kB
49. 636.258 636.258 ↑ 56.7 94 15,149

CTE Scan on marker marker_15 (cost=0.00..400.00 rows=5,333 width=4) (actual time=0.017..0.042 rows=94 loops=15,149)

  • Filter: ((sect."Distance")::real < "MarkerDistanse")
  • Rows Removed by Filter: 88
50. 165.814 50,817.713 ↑ 1.7 57,308 1

Subquery Scan on *SELECT* 2 (cost=114,218.24..372,085,340.79 rows=99,452 width=796) (actual time=6,221.238..50,817.713 rows=57,308 loops=1)

51. 2,546.688 50,651.899 ↑ 1.7 57,308 1

Hash Left Join (cost=114,218.24..372,083,600.38 rows=99,452 width=840) (actual time=6,221.224..50,651.899 rows=57,308 loops=1)

  • Hash Cond: (artmeas."SurfaceLocationId" = surfacelocation."Id")
52. 46.124 9,594.214 ↑ 1.7 57,308 1

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

  • Hash Cond: (sect_1."Id" = diagobjcoord_1."DiagnosticObjectId")
53. 69.271 9,517.172 ↑ 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,188.640..9,517.172 rows=57,308 loops=1)

54. 41.736 9,447.901 ↑ 1.7 57,308 1

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

  • Hash Cond: (artifactaddonpof."POFAnomalyClassId" = pofanomalyclass."Id")
55. 44.900 9,406.147 ↑ 1.7 57,308 1

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

  • Hash Cond: (artifactclass."DefectTypeId" = defecttype."Id")
56. 69.896 9,361.011 ↑ 1.7 57,308 1

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

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

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

  • Hash Cond: (artifactaddonpof."POFArtifactIdentification" = pofartifactidentification."Id")
58. 77.299 7,829.060 ↑ 1.7 57,308 1

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

59. 48.940 7,178.681 ↑ 1.7 57,308 1

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

  • Hash Cond: (artifactaddonpof."POFArtifactTypeId" = pofartifacttype."Id")
60. 52.824 7,129.704 ↑ 1.7 57,308 1

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

61. 42.141 6,389.184 ↑ 1.7 57,308 1

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

  • Hash Cond: (artifact."ClassId" = artifactclass."Id")
62. 35.121 6,346.881 ↑ 1.7 57,308 1

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

  • Hash Cond: (pipelinesect."PipeInstallationId" = pipeinstallation."Id")
63. 117.430 6,311.745 ↑ 1.7 57,308 1

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

64. 3,415.726 5,220.079 ↑ 1.7 57,308 1

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

  • Hash Cond: (artifact."DiagnosticObjectId" = diagobj_1."Id")
65. 1,584.517 1,584.517 ↑ 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.018..1,584.517 rows=9,530,948 loops=1)

66. 10.657 219.836 ↓ 1.0 15,149 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1845kB
67. 13.900 209.179 ↓ 1.0 15,149 1

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

68. 12.512 119.534 ↓ 1.0 15,149 1

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

69. 5.468 31.277 ↓ 1.0 15,149 1

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

  • Hash Cond: (diagobj_1."DiagnosticTargetId" = "innerDiagnosticTarget"."Id")
70. 8.985 25.724 ↓ 1.0 15,149 1

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

  • Hash Cond: (sections."Id" = diagobj_1."Id")
71. 6.449 6.449 ↓ 1.0 15,149 1

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

72. 4.328 10.290 ↓ 1.0 15,149 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1075kB
73. 4.389 5.962 ↓ 1.0 15,149 1

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
76. 0.038 0.080 ↑ 1.0 1 1

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

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

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

78. 0.006 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
79. 0.022 0.022 ↑ 1.0 1 1

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

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

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

  • Index Cond: ("Id" = diagobj_1."Id")
81. 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_1."PipelineSectionId")
82. 974.236 974.236 ↑ 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.017..0.017 rows=1 loops=57,308)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
84. 0.002 0.015 ↓ 0.0 0 1

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

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

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

86. 0.000 0.000 ↓ 0.0 0

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

87. 0.000 0.000 ↓ 0.0 0

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

88. 0.084 0.162 ↑ 1.0 211 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
89. 0.078 0.078 ↑ 1.0 211 1

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

90. 687.696 687.696 ↑ 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.012..0.012 rows=1 loops=57,308)

  • Index Cond: ("Id" = artifact."Id")
91. 0.021 0.037 ↑ 1.0 20 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
92. 0.016 0.016 ↑ 1.0 20 1

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

93. 573.080 573.080 ↑ 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.009..0.010 rows=1 loops=57,308)

  • Index Cond: ("Id" = artifact."Id")
94. 0.024 0.050 ↑ 1.0 56 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
95. 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.010..0.026 rows=56 loops=1)

96. 77.564 1,417.608 ↑ 1.0 228,709 1

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

  • Buckets: 262144 Batches: 1 Memory Usage: 16343kB
97. 919.027 1,340.044 ↑ 1.0 228,709 1

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

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

99. 65.745 182.900 ↑ 1.0 228,709 1

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

  • Buckets: 262144 Batches: 1 Memory Usage: 16343kB
100. 87.114 117.155 ↑ 1.0 228,709 1

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

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

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

102. 0.038 0.097 ↑ 1.0 166 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
103. 0.059 0.059 ↑ 1.0 166 1

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

104. 0.036 0.236 ↑ 1.0 145 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
105. 0.093 0.200 ↑ 1.0 145 1

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

  • Hash Cond: (defecttype."Id" = "defectTypeDefectGroupRef"."DefectTypeId")
106. 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)

107. 0.039 0.070 ↑ 1.0 135 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
108. 0.031 0.031 ↑ 1.0 135 1

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

109. 0.009 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
110. 0.009 0.009 ↑ 1.0 7 1

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

111. 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")
112. 16.308 30.918 ↑ 1.0 49,232 1

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

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

Seq Scan on "DiagnosticObjectCoordinate" diagobjcoord_1 (cost=0.00..1,464.40 rows=49,232 width=92) (actual time=0.010..14.610 rows=49,232 loops=1)

  • Filter: ("CoordinateSystemId" = '72b16dc7-f56e-4203-ba60-7b369f444c88'::uuid)
114. 0.008 0.021 ↑ 1.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
115. 0.013 0.013 ↑ 1.0 5 1

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

116.          

SubPlan (forHash Left Join)

117. 114.616 5,616.184 ↑ 1.0 1 57,308

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

118. 1,260.776 5,501.568 ↑ 5,333.0 1 57,308

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

  • Sort Key: marker_4."MarkerDistanse" DESC
  • Sort Method: top-N heapsort Memory: 25kB
119. 4,240.792 4,240.792 ↑ 50.3 106 57,308

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

  • Filter: (((sect_1."Distance")::real + artmeas."Distance") > "MarkerDistanse")
  • Rows Removed by Filter: 76
120. 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)

121. 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_5."MarkerDistanse" DESC
  • Sort Method: top-N heapsort Memory: 25kB
122. 3,782.328 3,782.328 ↑ 50.3 106 57,308

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

  • Filter: (((sect_1."Distance")::real + artmeas."Distance") > "MarkerDistanse")
  • Rows Removed by Filter: 76
123. 57.308 4,641.948 ↑ 1.0 1 57,308

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

124. 802.312 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_6."MarkerDistanse
  • Sort Method: quicksort Memory: 25kB
125. 3,782.328 3,782.328 ↑ 70.2 76 57,308

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

  • Filter: (((sect_1."Distance")::real + artmeas."Distance") < "MarkerDistanse")
  • Rows Removed by Filter: 106
126. 0.000 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)

127. 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_7."MarkerDistanse
  • Sort Method: quicksort Memory: 25kB
128. 3,667.712 3,667.712 ↑ 70.2 76 57,308

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

  • Filter: (((sect_1."Distance")::real + artmeas."Distance") < "MarkerDistanse")
  • Rows Removed by Filter: 106
129. 57.308 5,100.412 ↑ 1.0 1 57,308

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

130. 1,146.160 5,043.104 ↑ 5,333.0 1 57,308

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

  • Sort Key: marker_8."MarkerDistanse" DESC
  • Sort Method: top-N heapsort Memory: 25kB
131. 3,896.944 3,896.944 ↑ 50.3 106 57,308

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

  • Filter: (((sect_1."Distance")::real + artmeas."Distance") > "MarkerDistanse")
  • Rows Removed by Filter: 76
132. 57.308 4,928.488 ↑ 1.0 1 57,308

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

133. 1,031.544 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_9."MarkerDistanse" DESC
  • Sort Method: top-N heapsort Memory: 25kB
134. 3,839.636 3,839.636 ↑ 50.3 106 57,308

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

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

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

136. 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_10."MarkerDistanse
  • Sort Method: quicksort Memory: 25kB
137. 3,725.020 3,725.020 ↑ 70.2 76 57,308

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

  • Filter: (((sect_1."Distance")::real + artmeas."Distance") < "MarkerDistanse")
  • Rows Removed by Filter: 106
138. 0.000 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)

139. 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_11."MarkerDistanse
  • Sort Method: quicksort Memory: 25kB
140. 3,667.712 3,667.712 ↑ 70.2 76 57,308

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

  • Filter: (((sect_1."Distance")::real + artmeas."Distance") < "MarkerDistanse")
  • Rows Removed by Filter: 106
141. 0.263 65.201 ↓ 2.1 182 1

Subquery Scan on *SELECT* 3 (cost=482.67..158,062.86 rows=86 width=840) (actual time=6.960..65.201 rows=182 loops=1)

142. 3.947 64.938 ↓ 2.1 182 1

Nested Loop Left Join (cost=482.67..158,061.78 rows=86 width=864) (actual time=6.928..64.938 rows=182 loops=1)

143. 0.348 15.491 ↓ 2.1 182 1

Nested Loop (cost=482.25..11,226.02 rows=86 width=74) (actual time=6.472..15.491 rows=182 loops=1)

  • Join Filter: (mark."SectionId" = sect_2."Id")
144. 2.352 12.777 ↓ 2.1 182 1

Hash Join (cost=481.82..11,081.65 rows=86 width=70) (actual time=6.444..12.777 rows=182 loops=1)

  • Hash Cond: (diagobj_2."Id" = mark."SectionId")
145. 4.166 5.695 ↓ 1.0 15,149 1

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

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

  • Index Cond: ("DiagnosticTargetId" = '6847248f-37c1-4f72-ad7a-357e4491c28a'::uuid)
147. 2.725 4.730 ↑ 1.0 8,292 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 832kB
148. 2.005 2.005 ↑ 1.0 8,292 1

Seq Scan on "Marker" mark (cost=0.00..188.92 rows=8,292 width=54) (actual time=0.013..2.005 rows=8,292 loops=1)

149. 2.366 2.366 ↑ 1.0 1 182

Index Scan using "PK_Section" on "Section" sect_2 (cost=0.43..1.67 rows=1 width=36) (actual time=0.012..0.013 rows=1 loops=182)

  • Index Cond: ("Id" = diagobj_2."Id")
150. 1.456 1.456 ↓ 0.0 0 182

Index Scan using "PK_ObjectCoordinate" on "DiagnosticObjectCoordinate" diagnosticobjectcoordinatetable (cost=0.41..0.53 rows=1 width=92) (actual time=0.008..0.008 rows=0 loops=182)

  • Index Cond: (("DiagnosticObjectId" = diagobj_2."Id") AND ("CoordinateSystemId" = '72b16dc7-f56e-4203-ba60-7b369f444c88'::uuid))
151.          

SubPlan (forNested Loop Left Join)

152. 0.364 12.376 ↑ 1.0 1 182

Limit (cost=426.67..426.67 rows=1 width=8) (actual time=0.067..0.068 rows=1 loops=182)

153. 3.458 12.012 ↑ 5,333.0 1 182

Sort (cost=426.67..440.00 rows=5,333 width=8) (actual time=0.066..0.066 rows=1 loops=182)

  • Sort Key: marker."MarkerDistanse" DESC
  • Sort Method: top-N heapsort Memory: 25kB
154. 8.554 8.554 ↑ 59.3 90 182

CTE Scan on marker (cost=0.00..400.00 rows=5,333 width=8) (actual time=0.001..0.047 rows=90 loops=182)

  • Filter: ((sect_2."Distance")::real > "MarkerDistanse")
  • Rows Removed by Filter: 92
155. 0.182 10.556 ↑ 1.0 1 182

Limit (cost=426.67..426.67 rows=1 width=4) (actual time=0.058..0.058 rows=1 loops=182)

156. 2.912 10.374 ↑ 5,333.0 1 182

Sort (cost=426.67..440.00 rows=5,333 width=4) (actual time=0.057..0.057 rows=1 loops=182)

  • Sort Key: marker_1."MarkerDistanse" DESC
  • Sort Method: top-N heapsort Memory: 25kB
157. 7.462 7.462 ↑ 59.3 90 182

CTE Scan on marker marker_1 (cost=0.00..400.00 rows=5,333 width=4) (actual time=0.001..0.041 rows=90 loops=182)

  • Filter: ((sect_2."Distance")::real > "MarkerDistanse")
  • Rows Removed by Filter: 92
158. 0.000 10.738 ↑ 1.0 1 182

Limit (cost=426.67..426.67 rows=1 width=8) (actual time=0.059..0.059 rows=1 loops=182)

159. 2.912 10.738 ↑ 5,333.0 1 182

Sort (cost=426.67..440.00 rows=5,333 width=8) (actual time=0.059..0.059 rows=1 loops=182)

  • Sort Key: marker_2."MarkerDistanse
  • Sort Method: quicksort Memory: 25kB
160. 7.826 7.826 ↑ 58.0 92 182

CTE Scan on marker marker_2 (cost=0.00..400.00 rows=5,333 width=8) (actual time=0.018..0.043 rows=92 loops=182)

  • Filter: ((sect_2."Distance")::real < "MarkerDistanse")
  • Rows Removed by Filter: 90
161. 0.182 10.374 ↑ 1.0 1 182

Limit (cost=426.67..426.67 rows=1 width=4) (actual time=0.057..0.057 rows=1 loops=182)

162. 2.548 10.192 ↑ 5,333.0 1 182

Sort (cost=426.67..440.00 rows=5,333 width=4) (actual time=0.056..0.056 rows=1 loops=182)

  • Sort Key: marker_3."MarkerDistanse
  • Sort Method: quicksort Memory: 25kB
163. 7.644 7.644 ↑ 58.0 92 182

CTE Scan on marker marker_3 (cost=0.00..400.00 rows=5,333 width=4) (actual time=0.018..0.042 rows=92 loops=182)

  • Filter: ((sect_2."Distance")::real < "MarkerDistanse")
  • Rows Removed by Filter: 90