Facility to export Profiler query log
When investigating queries using Profile it would be beneficial to be able to export the log of queries for further investigation.
Scott Schmidt
shared this idea
-
Christian
commented
The "profiler" tab in Atlas is very nice -- it gives a really nice over-all view of slow queries, with the ability to drill down into the individual calls.
However, I don't check this page every day, and so it is sometimes hard to find out when we actually do have slow queries or commands pop up on it if it is not affecting our cluster.
We use datadog as the central point for all of our monitoring. We have the Atlas <--> Datadog integration set up, which exports a number of useful stats. It would be very nice for the profiler results to be auto-exported to datadog via the integration, because then we could:
- configure datadog to keep them for as long as we want
- configure alerts and/or dashboards on this data as we see fitI do know that one work-around for this is to manually wire up something to query the profiler REST endpoints and push that to datadog. This is likely what I will end up doing now, but it would make things a lot easier if I (and all other customers using this integration) got this data in datadog "for free" (free in terms of effort).
-
Hi Scott,
You can pull logs programmatically via the Atlas Admin
API https://docs.atlas.mongodb.com/reference/api/logs/Cheers
-Andrew -
Aram
commented
Currently there doesn't seem to be a way to set up custom alerts and monitoring on specific metrics such as when the size of documents returned form a query exceeds a certain limit, even though that information is available through the Profiler when looking at query samples.
It would be very useful to be able to either configure these metrics to be sent to an external service like Loggly for better monitoring and alerts or allowing to create customized alerts/webhooks within Atlas that would be triggered based on a custom-specified condition.
