Ory is the largest open source community in the world for cloud software application security. We maintain advanced open source security software solving authentication, authorization, access control, application network security, and delegation. Ory implements a variety of industry and best-practice standards including OAuth 2.0 / OAuth 2.1, OpenID Connect, Zero Trust Networking, Google Zanzibar Policy Framework, FIDO2 U2F, WebAuthn, TOTP, and more.

Ory Community

```SELECT hydra_oauth2_consent_request_handled.authenticated_at, hydra_oauth2_consent_request_handled.challenge, hydra_oauth2_consent_request_handled.error, hydra_oauth2_consent_request_handled.granted_at_audience, hydra_oauth2_consent_request_handled.granted_scope, hydra_oauth2_consent_request_handled.handled_at, hydra_oauth2_consent_request_handled.remember, hydra_oauth2_consent_request_handled.remember_for, hydra_oauth2_consent_request_handled.requested_at, hydra_oauth2_consent_request_handled.session_access_token, hydra_oauth2_consent_request_handled.session_id_token, hydra_oauth2_consent_request_handled.was_used FROM hydra_oauth2_consent_request_handled AS hydra_oauth2_consent_request_handled JOIN hydra_oauth2_consent_request AS r ON hydra_oauth2_consent_request_handled.challenge = r.challenge WHERE r.subject = $1 AND r.client_id = $2 AND r.skip=FALSE AND (hydra_oauth2_consent_request_handled.error='{}' AND hydra_oauth2_consent_request_handled.remember=TRUE) ORDER BY hydra_oauth2_consent_request_handled.requested_at DESC LIMIT 1```
The above query is consuming too much cpu

<@U03RZ334K2A> maybe you can run `EXPLAIN` on it and see what the problem is.