Average Self

563ms

Average calls

1x

Total Self

563ms

Total Children

0ms

Total runtime

563ms

        WITH t_ascent_crags AS (
          SELECT ascents.user_id,
                 COUNT(DISTINCT ascents.released_at) AS count
          FROM ascents INNER JOIN crag_routes ON ascents.crag_route_id = crag_routes.id AND ascents.user_id != ?,
               ascents my_ascents INNER JOIN crag_routes my_crag_routes ON my_ascents.crag_route_id = my_crag_routes.id AND my_ascents.user_id = ?
          WHERE ascents.released_at = my_ascents.released_at
            AND ascents.user_id != ?
            AND crag_routes.crag_id = my_crag_routes.crag_id
            AND ascents.released_at > CURRENT_DATE - INTERVAL ? YEAR
            AND NOT EXISTS (SELECT * FROM follows WHERE follows.followable_type = ? AND follows.followable_id = ascents.user_id AND follows.user_id = ?)
          GROUP BY ascents.user_id
      ), t_ascent_gyms AS (
          SELECT ascents.user_id,
                 COUNT(DISTINCT ascents.released_at) AS count
          FROM ascents,
               ascents my_ascents
          WHERE ascents.released_at = my_ascents.released_at
            AND ascents.user_id != ?
            AND my_ascents.user_id = ?
            AND ascents.gym_id = my_ascents.gym_id
            AND ascents.released_at > CURRENT_DATE - INTERVAL ? MONTH
            AND NOT EXISTS (SELECT * FROM follows WHERE follows.followable_type = ? AND follows.followable_id = ascents.user_id AND follows.user_id = ?)
          GROUP BY ascents.user_id
      ), t_common_friends AS (
          SELECT follows.user_id, COUNT(*) AS count
          FROM follows, follows my_follows
          WHERE follows.followable_type = ?
            AND my_follows.followable_type = ?
            AND follows.followable_id = my_follows.followable_id
            AND follows.followable_id != ?
            AND my_follows.followable_id != ?
            AND follows.accepted_at IS NOT NULL
            AND my_follows.accepted_at IS NOT NULL
            AND follows.user_id NOT IN (?)
            AND my_follows.user_id = ?
          GROUP BY follows.user_id
      ), t_followed_crags AS (
          SELECT follows.user_id, COUNT(*) AS count
          FROM follows, follows my_follows
          WHERE follows.followable_type = ?
            AND my_follows.followable_type = ?
            AND follows.followable_id = my_follows.followable_id
            AND follows.accepted_at IS NOT NULL
            AND my_follows.accepted_at IS NOT NULL
            AND follows.user_id != ?
            AND my_follows.user_id = ?
            AND NOT EXISTS (SELECT * FROM follows my_friends WHERE my_friends.followable_type = ? AND my_friends.followable_id = follows.user_id AND my_friends.user_id = ?)
          GROUP BY follows.user_id
      ), t_followed_gyms AS (
          SELECT follows.user_id, COUNT(*) AS count
          FROM follows, follows my_follows
          WHERE follows.followable_type = ?
            AND my_follows.followable_type = ?
            AND follows.followable_id = my_follows.followable_id
            AND follows.accepted_at IS NOT NULL
            AND my_follows.accepted_at IS NOT NULL
            AND follows.user_id != ?
            AND my_follows.user_id = ?
            AND NOT EXISTS (SELECT * FROM follows my_friends WHERE my_friends.followable_type = ? AND my_friends.followable_id = follows.user_id AND my_friends.user_id = ?)
          GROUP BY follows.user_id
      )
      SELECT id,
             uuid,
             first_name,
             last_name,
             slug_name,
             t_ascent_crags.count AS ascent_crags,
             t_ascent_gyms.count AS ascent_gyms,
             t_common_friends.count AS common_friends,
             t_followed_crags.count AS followed_crags,
             t_followed_gyms.count AS followed_gyms,
             (
                 COALESCE(t_ascent_crags.count, ?) +
                 COALESCE(t_ascent_gyms.count, ?) +
                 COALESCE(t_common_friends.count, ?) * ? +
                 COALESCE(t_followed_crags.count, ?) / ? +
                 COALESCE(t_followed_gyms.count, ?) / ?
             ) AS proximity_points
      FROM users
               LEFT JOIN t_ascent_crags ON t_ascent_crags.user_id = users.id
               LEFT JOIN t_ascent_gyms ON t_ascent_gyms.user_id = users.id
               LEFT JOIN t_common_friends ON t_common_friends.user_id = users.id
               LEFT JOIN t_followed_crags ON t_followed_crags.user_id = users.id
               LEFT JOIN t_followed_gyms ON t_followed_gyms.user_id = users.id
      WHERE users.id != ?
        AND NOT EXISTS (SELECT * FROM follows my_friends WHERE my_friends.followable_type = ? AND my_friends.followable_id = users.id AND my_friends.user_id = ?)
      ORDER BY proximity_points DESC,
               users.last_activity_at DESC,
               users.id DESC
      LIMIT ? OFFSET ?
      

Average Self

14ms

Average calls

1x

Total Self

14ms

Total Children

571ms

Total runtime

585ms

        Api::V1::CurrentUsersController#suggested_friends
      

Average Self

1.3ms

Average calls

5x

Total Self

6.6ms

Total Children

0ms

Total runtime

6.6ms

        SELECT `users`.* FROM `users` WHERE `users`.`id` IN (?)
SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_type` = ? AND `active_storage_attachments`.`name` = ? AND `active_storage_attachments`.`record_id` IN (?)
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` IN (?)
      

Average Self

1.9ms

Average calls

0.99x

Total Self

1.9ms

Total Children

583ms

Total runtime

585ms

        Rails::Engine#call
      

Average Self

1.1ms

Average calls

1x

Total Self

1.1ms

Total Children

0ms

Total runtime

1.1ms

        SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
      

Average Self

1ms

Average calls

<0.01x

Total Self

<0.01ms

Total Children

2.5ms

Total runtime

2.5ms

        Rack::Head
      

Average Self

1ms

Average calls

<0.01x

Total Self

<0.01ms

Total Children

2.5ms

Total runtime

2.5ms

        Rails::Engine#call
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        Rack::ConditionalGet
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        Rails::Rack::Logger
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActionDispatch::SSL
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActionDispatch::Executor
      

Average Self

0ms

Average calls

0.02x

Total Self

0ms

Total Children

0ms

Total runtime

0ms

        read
write
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActionDispatch::RequestId
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        Rack::Sendfile
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActionDispatch::ShowExceptions
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActiveSupport::Cache::Strategy::LocalCache::Middleware
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActionDispatch::DebugExceptions
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        Rack::Cors
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        Rack::ETag
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        Rack::Runtime
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

0ms

Total runtime

0ms

        SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = ? LIMIT ?
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        RequestStore::Middleware
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActionDispatch::RemoteIp
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActionDispatch::ActionableExceptions
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActionDispatch::Callbacks
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActionDispatch::Cookies
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActionDispatch::HostAuthorization
      

Average Self

0ms

Average calls

<0.01x

Total Self

0ms

Total Children

2.5ms

Total runtime

2.5ms

        ActionDispatch::Session::CookieStore