I think the question was, "does sql_exporter include a metric for the execution time of a query"?
If it doesn't, and you're only doing a single query in the scrape job, then you could use prometheus' own *scrape_duration_seconds* metric as a rough proxy. On Monday, 27 March 2023 at 09:41:33 UTC+1 Stuart Clark wrote: > On 2023-03-24 14:01, Nunni wrote: > > Hello. > > > > I need is observe how long it takes to complete the execution of a > > particular mssql query. The query is executed once every hour, and I > > want to graph that for say a period of ten days. > > The query is up and running using sql_exporter and prometheus gets the > > results and correctly graphs it, but that’s not what I need. > > > > Unfortunately it isn't clear what you are asking for. From your > description it sounds like you are graphing the data, but you also say > it isn't what you need (but don't say how or what you are hoping for). > If you could describe what you are doing, what is happening & what you > are wanting instead someone might be able to suggest something... > > -- > Stuart Clark > -- You received this message because you are subscribed to the Google Groups "Prometheus Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/51f23a79-0351-46ff-aa79-cd13f807c11en%40googlegroups.com.
