elixir_agent icon indicating copy to clipboard operation
elixir_agent copied to clipboard

Add support for Slow Queries

Open andrewhr opened this issue 3 years ago • 6 comments

Is your feature request related to a problem? Please describe.

Current Agent export database queries, but they are only available as part of the Transaction traces. For other agents, like Ruby, we can also use the "Databases" tab, which includes query entries and can be really useful to diagnose issues in a way that the current support can't.

Describe the solution you'd like

Would be great if Elixir agent exports all data required for that section to work out-of-the-box. There is not specification AFAICT, otherwise we can work together to contribute a patch with that feature support.

Describe alternatives you've considered

Create custom instrumentation around Telemetry. It works, but doesn't integrate with overall NR experience.

andrewhr avatar Jun 14 '21 18:06 andrewhr

This is fully supported in the agent already, what version are you running?

binaryseed avatar Jun 14 '21 18:06 binaryseed

The latest, but there is no slow queries on the panel. Maybe it's a flag I didn't activated?

andrewhr avatar Jun 14 '21 18:06 andrewhr

Here's an app I run, do you see all this data on yours?

Cursor_and_Api_Key_Service__production____New_Relic_One

binaryseed avatar Jun 14 '21 18:06 binaryseed

I definitely didn't expressed that very well, sorry for the confusion.

Yes I do see this information. On the right panel, bellow the "Time consumption by caller" there is a "Slow queries" table which aggregates all slow queries for that entry. On a Ruby application we have, that works as expected - includes many queries and help to find spots where DBEs can work directly.

No Elixir app we have here (and most of them are Elixir) present data on that table, which I assume is not exported by the Agent.

It's more clear what I'm missing from the tool? Sorry again for the confusion! :bow:

andrewhr avatar Jun 14 '21 19:06 andrewhr

Ahh yes, I see, you are asking specifically for "Slow Query" support which you are correct is not yet implemented in the agent.

binaryseed avatar Jun 14 '21 19:06 binaryseed

Thank you helping me clarify that, I appreciate 🙇!

andrewhr avatar Jun 14 '21 20:06 andrewhr