Datadog Tracing SQL not working

[monwolf]

Preflight checklist

• [X] I could not find a solution in the existing issues, docs, nor discussions.
• [X] I agree to follow this project's Code of Conduct.
• [X] I have read and am following this repository's Contribution Guidelines.
• [ ] This issue affects my Ory Cloud project.
• [ ] I have joined the Ory Community Slack.
• [ ] I am signed up to the Ory Security Patch Newsletter.

Describe the bug

Hey,

I'm doing some troubleshooting with datadog in my hydra's pg instance, but I can't see instrumented SQL statements.

I can see "sql-prepare" and "sql-stmt-close" spans, but a hole between them:

So I can't know which query is spending this time on our infrastructure.

We are using hydra v1.10.5.

Reproducing the bug

We are using the following env vars to setup the tracing:

        TRACING_PROVIDER = "datadog"
        DD_SERVICE = "sec-hydra-rest"
        DD_AGENT_HOST = "host01"
        DD_TRACE_HEALTH_METRICS_ENABLED = "true"
        DD_ENV = "production"
        DD_TRACE_DEBUG = "false"

Relevant log output

No response

Relevant configuration

No response

Version

v1.10.5

On which operating system are you observing this issue?

Linux

In which environment are you deploying?

Docker

Additional Context

No response