Oblyk API

.MD

/api/v1/gyms/3/gym_spaces/277/gym_routes/paginated.json?order_by=sector&direction=asc&page=1&dismounted=false&filters[]=%7B%22type%22:%22sector%22,%22value%22:%222051%22%7D

11 May 20:40

total runtime

227ms

Most impactful sections

code90%
sql10%

code app/controllers/api/v1/gym_routes_controller.rb:84	89%
Average Self 201ms Calls 1x Total Self 201ms Total Children 23ms Total runtime 224ms `Api::V1::GymRoutesController#paginated`
sql app/controllers/api/v1/gym_routes_controller.rb:142	6%
Average Self 7ms Calls 2x Total Self 14ms Total Children 0ms Total runtime 14ms SELECT DISTINCT gym_sectors.order, gym_sectors.name, gym_sectors.id, gym_routes.anchor_number, gym_routes.min_grade_value, gym_routes.id AS alias_0, `gym_routes`.`id` FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_routes`.`gym_sector_id` = `gym_sectors`.`id` INNER JOIN `gym_sectors` `gym_sectors_gym_routes` ON `gym_sectors_gym_routes`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) LEFT OUTER JOIN `gym_route_openers` ON `gym_route_openers`.`gym_route_id` = `gym_routes`.`id` LEFT OUTER JOIN `gym_openers` ON `gym_openers`.`id` = `gym_route_openers`.`gym_opener_id` LEFT OUTER JOIN `gym_sectors` `gym_sectors_gym_routes_join` ON `gym_sectors_gym_routes_join`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) LEFT OUTER JOIN `gym_spaces` ON `gym_spaces`.`id` = `gym_sectors_gym_routes_join`.`gym_space_id` AND (`gym [TRUNCATED]
sql app/models/gym_route_ascents_mapper.rb:26	1%
Average Self 3ms Calls 1x Total Self 3ms Total Children 0ms Total runtime 3ms SELECT COUNT(*) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`gym_route_id` IN (?)
code /var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525	1%
Average Self 3ms Calls 1x Total Self 3ms Total Children 224ms Total runtime 227ms `Rails::Engine#call`
sql app/controllers/api/v1/api_controller.rb:73	<1%
Average Self 2ms Calls 1x Total Self 2ms Total Children 0ms Total runtime 2ms SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
sql app/controllers/api/v1/gym_routes_controller.rb:413	<1%
Average Self 2ms Calls 1x Total Self 2ms Total Children 0ms Total runtime 2ms SELECT `gym_spaces`.* FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`id` = ? ORDER BY `gym_spaces`.`order` ASC LIMIT ?
sql app/controllers/concerns/gymable.rb:16	<1%
Average Self 2ms Calls 1x Total Self 2ms Total Children 0ms Total runtime 2ms SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` = ? LIMIT ?

Server

	Load	CPU	RAM	Swap	Disk
oblyk-api	Load avg 4%	CPU 5%	RAM 61%	Swap <1%	Disk 88%

Deployment

Même correctif quand précédement mais dans le détail des points

clucien

29 Apr 16:51