--
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 prometheus-users+unsubscribe@googlegroups.com.
To post to this group, send email to prometheus-users@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/8741d265-fecd-499d-b891-5ae344b51987%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
There's no query explain in Prometheus but if you set the stats parameter in the query request, you'll get some statistics:$ curl 'localhost:9090/api/v1/query?query=up&stats=true' | jq .{
"status": "success",
"data": {
"resultType": "vector",
"result": [...],"stats": {
"timings": {
"evalTotalTime": 9.0508e-05,
"resultSortTime": 0,
"queryPreparationTime": 5.3835e-05,
"innerEvalTime": 2.7971e-05,
"execQueueTime": 2.412e-06,
"execTotalTime": 0.000100271
}
}
}
}On Mon, Jul 9, 2018 at 4:53 PM, <mse...@gmail.com> wrote:Hello,there is a way to track the prometheus explain plan like sql servers?whats the best method to optimize queries in prometheus ?
--
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 prometheus-use...@googlegroups.com.
To post to this group, send email to promethe...@googlegroups.com.
Simon, can you tell a word or two about innerEvalTime and if you have any idea why it takes too long ?
stats":{"timings":{"evalTotalTime":6.500474902,"resultSortTime":0.000620076,"queryPreparationTime":0.021838381,"innerEvalTime":6.477876328,"resultAppendTime":0.000097736,"execQueueTime":0.000004624,"execTotalTime":6.500490179}}}}
here is the query i usedsum (rate (container_memory_rss{pod_name=~"^.*"}[2m])) by (pod_name)
On Tue, Jul 10, 2018 at 1:23 PM eldad marciano <mse...@gmail.com> wrote:
Ok thanks a lot
On Tue, Jul 10, 2018 at 10:49 AM Simon Pasquier <spas...@redhat.com> wrote:
There's no query explain in Prometheus but if you set the stats parameter in the query request, you'll get some statistics:$ curl 'localhost:9090/api/v1/query?query=up&stats=true' | jq .{
"status": "success",
"data": {
"resultType": "vector",
"result": [...],"stats": {
"timings": {
"evalTotalTime": 9.0508e-05,
"resultSortTime": 0,
"queryPreparationTime": 5.3835e-05,
"innerEvalTime": 2.7971e-05,
"execQueueTime": 2.412e-06,
"execTotalTime": 0.000100271
}
}
}
}On Mon, Jul 9, 2018 at 4:53 PM, <mse...@gmail.com> wrote:Hello,there is a way to track the prometheus explain plan like sql servers?whats the best method to optimize queries in prometheus ?
--
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 prometheus-users+unsubscribe@googlegroups.com.
To post to this group, send email to prometheus-users@googlegroups.com.
Ok thanks a lot
To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-use...@googlegroups.com.
To post to this group, send email to promethe...@googlegroups.com.
Simon,
I've run small benchmark for prometheus versions 2.2.1 vs 2.3.1using the same query with the same timestamp for start and end points, seems like it really have better performance
anyway, there is a way to log how many disk reads vs ram reads the query used ?
Ok thanks a lot
To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-users+unsubscribe@googlegroups.com.
To post to this group, send email to prometheus-users@googlegroups.com.
You received this message because you are subscribed to a topic in the Google Groups "Prometheus Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/prometheus-users/kZ2DvZnYHUA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to prometheus-use...@googlegroups.com.
To post to this group, send email to promethe...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/9b5519a8-7e50-4cec-b320-35192fcd2f89%40googlegroups.com.
For one, the query plan is exactly defined by the AST (i.e. the result of parsing the expression). In the case of your query, it will first look up all series that match the selector; then compute the rate over the last 2 minutes for each (which may require unpacking quite a bit more than the last 2 minutes worth of samples, because of the way the TSDB works); and finally sum those results by pod_name. There is no fancy query plan optimization going on, as you would have with a DBMS.
Second, 10k distinct values isn't all that much, but you have to consider other dimensions too. I.e. do you have 10k series matching your selector, or do you have 10k different values for the pod_name label but many more matching series (because of other labels)?And finally, if my guess is correct, container_memory_rss looks like a gauge (resident memory in use), so rate() is not the right function to use there. delta() might be more appropriate, but do you really care about the speed of change of memory utilization?
To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-users+unsubscribe@googlegroups.com.
To post to this group, send email to prometheus-users@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/9b5519a8-7e50-4cec-b320-35192fcd2f89%40googlegroups.com.
| Uptime | 2018-07-16 10:11:24.207324902 +0000 UTC |
|---|---|
| Working Directory | /prometheus |
| Number of goroutines | 2669 |
| GOMAXPROCS | 40 |
To unsubscribe from this group and all its topics, send an email to prometheus-users+unsubscribe@googlegroups.com.
To post to this group, send email to prometheus-users@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/9b5519a8-7e50-4cec-b320-35192fcd2f89%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Prometheus Users" group.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CAPVnq2Adu%3DvnQh6VXsazUS%2Bm%2BjX%3DYx1%3DBOGh8oaT4%2BZe-xdtaQ%40mail.gmail.com.To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-users+unsubscribe@googlegroups.com.
To post to this group, send email to prometheus-users@googlegroups.com.
To unsubscribe from this group and all its topics, send an email to prometheus-use...@googlegroups.com.
To post to this group, send email to promethe...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/9b5519a8-7e50-4cec-b320-35192fcd2f89%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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 prometheus-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CAPVnq2Adu%3DvnQh6VXsazUS%2Bm%2BjX%3DYx1%3DBOGh8oaT4%2BZe-xdtaQ%40mail.gmail.com.
Is that tunable it has some pool to control it ?
To unsubscribe from this group and all its topics, send an email to prometheus-users+unsubscribe@googlegroups.com.
To post to this group, send email to prometheus-users@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/9b5519a8-7e50-4cec-b320-35192fcd2f89%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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 prometheus-users+unsubscribe@googlegroups.com.
To unsubscribe from this group and all its topics, send an email to prometheus-use...@googlegroups.com.
To post to this group, send email to promethe...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/9b5519a8-7e50-4cec-b320-35192fcd2f89%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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 prometheus-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CAPVnq2Adu%3DvnQh6VXsazUS%2Bm%2BjX%3DYx1%3DBOGh8oaT4%2BZe-xdtaQ%40mail.gmail.com.
Changing it produce different results
So if its about calculation we didn't expect the results to be constant
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/6a468792-0110-44f1-acf9-745ae5f06f29%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CAPVnq2Bbpi6D1M3DJ%3DrKQu5MFD2mnWGehUMc%2Bvh6BjmpRPGBSw%40mail.gmail.com.
To unsubscribe from this group and all its topics, send an email to prometheus-users+unsubscribe@googlegroups.com.
To post to this group, send email to prometheus-users@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/6a468792-0110-44f1-acf9-745ae5f06f29%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to a topic in the Google Groups "Prometheus Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/prometheus-users/kZ2DvZnYHUA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to prometheus-users+unsubscribe@googlegroups.com.
To post to this group, send email to prometheus-users@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CAPVnq2Bbpi6D1M3DJ%3DrKQu5MFD2mnWGehUMc%2Bvh6BjmpRPGBSw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
--
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 prometheus-users+unsubscribe@googlegroups.com.
To post to this group, send email to prometheus-users@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CADbKFw82UT8YNxc%2BdDOX7Z6n3rQ%3DXbu2DZycCpzAMU_tk0Ruzw%40mail.gmail.com.
To unsubscribe from this group and all its topics, send an email to prometheus-use...@googlegroups.com.
To post to this group, send email to promethe...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/6a468792-0110-44f1-acf9-745ae5f06f29%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to a topic in the Google Groups "Prometheus Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/prometheus-users/kZ2DvZnYHUA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to prometheus-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CAPVnq2Bbpi6D1M3DJ%3DrKQu5MFD2mnWGehUMc%2Bvh6BjmpRPGBSw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
--
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 prometheus-use...@googlegroups.com.
To post to this group, send email to promethe...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CADbKFw82UT8YNxc%2BdDOX7Z6n3rQ%3DXbu2DZycCpzAMU_tk0Ruzw%40mail.gmail.com.