Projects::DeploymentsController#show fails with 500 error due to database statement timeout

This error is occurring while trying to view a specific deployment within the web UI at a path similar to: https://gitlab.com/group/subgroup/project/-/environments/ENVIRONMENT_ID/deployments/DEPLOYMENT_ID

• Sentry Issue: GITLABCOM-9KCP
• Kibana: Link

PG::QueryCanceled: ERROR:  canceling statement due to statement timeout (PG::QueryCanceled)
  lib/gitlab/database/load_balancing/connection_proxy.rb:111:in `public_send'
    connection.public_send(...)
  lib/gitlab/database/load_balancing/connection_proxy.rb:111:in `block in read_using_load_balancer'
    connection.public_send(...)
  lib/gitlab/database/load_balancing/load_balancer.rb:65:in `read'
    return yield connection
  lib/gitlab/database/load_balancing/connection_proxy.rb:110:in `read_using_load_balancer'
    @load_balancer.read do |connection|
  lib/gitlab/database/load_balancing/connection_proxy.rb:48:in `select_all'
    read_using_load_balancer(:select_all, arel, name, binds)
...
(208 additional frame(s) were not displayed)

ActiveRecord::QueryCanceled: PG::QueryCanceled: ERROR:  canceling statement due to statement timeout (ActiveRecord::QueryCanceled)