Description
In watson, views now have exposed query timing stats. Some specifics:
- These stats are maintained on per design doc level across each node individually.
- Stats track the query requests to view-engine i.e. it accounts for all the overhead because of scatter and gather operations(to be more specific it tracks the GET requests to each view node and not the POST calls as part of subqueries).
- Sample url to access these stats for any design document:
http://<node_ip>:8092/_set_view/<bucket_name>/_design/<design_doc_name>/_get_query_stats
|
Sample example:
curl http://10.142.200.101:8092/_set_view/default/_design/ddoc1/_get_query_stats -s | python -m json.tool
|
{
|
"query_timing_in_ms": {
|
"_design/ddoc1": {
|
"view1": {
|
"1": 0,
|
"10": 16,
|
"100": 0,
|
"1000": 0,
|
"10000": 0,
|
"100000": 0
|
},
|
"view2": {
|
"1": 0,
|
"10": 14,
|
"100": 0,
|
"1000": 0,
|
"10000": 0,
|
"100000": 0
|
}
|
}
|
}
|
}
|
Note: Please mention this as a *private/unsupported* api to be used for debugging purpose and it can change in future without any notice.
Attachments
Issue Links
- blocks
-
MB-18268 Stat improvements for View queries.
- Resolved