# Suppression de la procédure getRange pour la méthode native ST_DISTANCE_SPHERE



- **Revision:** bf6c9607e971821853676c44d8e73e41a329303b
- **Author:** clucien
- **Period:** 2026-06-04 18:12:07 UTC – 2026-06-05 09:24:57 UTC
- **Duration:** 15 hours, 12 minutes, and 50 seconds

## Requests

- **95P:** 80.6 ms
- **Throughput:** 84.72 /min
- **Errors:** 0.05043%

| Name | 95P ms | Throughput /min | Impact |
| ---- | -----: | --------------: | -----: |
| Api::V1::CragsController#geo_json | 929 | 0.72 | 10.0% |
| Api::V1::CragsController#show | 119 | 10.08 | 8.6% |
| Api::V1::PartnersController#partners_around | 176 | 2.08 | 5.9% |
| Api::V1::PublicationsController#my_publication_feed | 355 | 0.97 | 5.7% |
| Api::V1::GymRoutesController#paginated | 127 | 3.15 | 5.7% |
| Api::V1::CommonsController#figures | 2851 | 0.08 | 5.0% |
| Api::V1::CurrentUsersController#suggested_friends | 1060 | 0.15 | 3.3% |
| Api::V1::GymsController#ascent_scores | 913 | 0.18 | 3.0% |
| Api::V1::GymsController#show | 71 | 2.67 | 3.0% |
| ActiveStorage::RepresentationsController#show | 182 | 0.82 | 2.7% |
| Api::V1::TownsController#show | 26 | 10.18 | 2.4% |
| Api::V1::CurrentUsersController#show | 57 | 1.93 | 1.8% |
| Api::V1::CragRoutesController#index | 76 | 1.64 | 1.8% |
| Api::V1::GymSectorsController#show | 30 | 5.12 | 1.7% |
| Api::V1::PublicationViewsController#my_unread_count | 114 | 0.88 | 1.5% |
| Api::V1::TownsController#geo_json | 82 | 1.13 | 1.5% |
| Api::V1::AscentGymRoutesController#index | 77 | 1.25 | 1.4% |
| Api::V1::UsersController#show | 81 | 0.8 | 1.2% |
| Api::V1::GymsController#geo_json | 428 | 0.12 | 1.1% |
| Api::V1::ClimbingSessionsController#index | 281 | 0.19 | 1.0% |
| Api::V1::GuideBookPapersController#crags_figures | 160 | 0.35 | 1.0% |
| Api::V1::AscentGymRoutesController#create | 79 | 0.79 | 1.0% |
| Api::V1::GymSpacesController#groups | 64 | 1.12 | 1.0% |
| Api::V1::VideosController#create | 1642 | 0.03 | 1.0% |

## Jobs

- **95P:** 496.9 ms
- **Throughput:** 0.31 /min
- **Errors:** 0.00000%

| Name | 95P ms | Throughput /min | Impact |
| ---- | -----: | --------------: | -----: |
| ActiveStorage::AnalyzeJob | 618 | 0.18 | 63.5% |
| SendPublicationsEmailsJob | 19756 | 0.0 | 17.1% |
| ActiveStorage::PurgeJob | 247 | 0.05 | 9.2% |
| EmailNotificationWorker | 111 | 0.04 | 3.5% |
| ActionMailer::MailDeliveryJob | 142 | 0.02 | 2.0% |
| HistorizeCragStaticMapWorker | 2150 | 0.0 | 1.9% |
| HistorizeTownWorker | 124 | 0.03 | 1.7% |

## Errors
| Exception | Message | Location | Count | Last |
| --------- | ------- | -------- | ----: | ---- |
| **NoMethodError** | undefined method `boulder_ranking' for nil:NilClass | app/models/gym_route.rb:61 | 24 | 04 Jun 19:35 |
| **TypeError** | no implicit conversion of Symbol into Integer | app/controllers/api/v1/ascent_gym_routes_controller.rb:207 | 5 | 04 Jun 21:07 |
| **NoMethodError** | undefined method `first' for nil:NilClass | app/models/color.rb:7 | 3 | 05 Jun 07:23 |
| **NoMethodError** | undefined method `level_color' for nil:NilClass | app/controllers/api/v1/climbing_sessions_controller.rb:111 | 3 | 04 Jun 20:22 |
| **NoMethodError** | undefined method `+' for nil:NilClass | app/controllers/api/v1/gyms_controller.rb:175 | 2 | 05 Jun 02:11 |
| **NoMethodError** | undefined method `to_sym' for nil:NilClass | app/controllers/api/v1/gyms_controller.rb:173 | 2 | 04 Jun 20:56 |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135627/deployments/65759)