topic mavg query timeout when called through the REST api in Wavefront by VMware Discussions https://communities.vmware.com/t5/Wavefront-by-VMware-Discussions/mavg-query-timeout-when-called-through-the-REST-api/m-p/1849258#M518 <HTML><HEAD></HEAD><BODY><P>I am running following wavefront query to get `SINGLE&nbsp; VALUE` which is Average over the given time range for which the query is being called. This works fine in the dashboard but it times out when called through the REST API. Can this query be optimized:<BR /><SPAN style="color: #000000; font-family: '.AppleSystemUIFont', serif; font-size: 14.6667px;">&nbsp;&nbsp;&nbsp;&nbsp; <EM>mavg(1vw, avg(ts(telegraf.response.times.99.percentile , accountid="123" and env="prod" and <EM style="color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px;">myvar</EM>!="true”)))</EM><BR />I tried with following but does not help<BR /></SPAN></P><P class="c-message_kit__gutter" style="padding: 8px 20px; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; background-color: #f8f8f8;"><EM>mavg(1vw, avg(align(900s, mean, ts(telegraf.response.times.99.percentile , accountid=“123” and env=“prod” and myvar!=“true”))))</EM></P><DIV class="c-message_kit__gutter__right" data-qa="message_content" style="padding: 8px 8px 8px 16px; margin: -12px -8px -16px -16px;"><DIV class="c-message_kit__blocks c-message_kit__blocks--rich_text" style="margin-bottom: 4px;"><DIV class="c-message__message_blocks c-message__message_blocks--rich_text"><DIV class="p-block_kit_renderer" data-qa="block-kit-renderer"><DIV class="p-block_kit_renderer__block_wrapper--first p-block_kit_renderer__block_wrapper"><DIV class="p-rich_text_block"><DIV class="p-rich_text_section"><P></P></DIV></DIV></DIV></DIV></DIV></DIV></DIV><P class="c-message__actions c-message_actions__container" style="padding: 2px; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px;"><BUTTON class="c-button-unstyled c-icon_button--light c-icon_button--size_small c-message_actions__button c-icon_button" data-qa="add_reaction_action" style="padding: unset; background-position: initial; text-align: initial;" type="button"></BUTTON></P></BODY></HTML> Fri, 31 Jan 2020 23:51:24 GMT kuldeepjain 2020-01-31T23:51:24Z mavg query timeout when called through the REST api https://communities.vmware.com/t5/Wavefront-by-VMware-Discussions/mavg-query-timeout-when-called-through-the-REST-api/m-p/1849258#M518 <HTML><HEAD></HEAD><BODY><P>I am running following wavefront query to get `SINGLE&nbsp; VALUE` which is Average over the given time range for which the query is being called. This works fine in the dashboard but it times out when called through the REST API. Can this query be optimized:<BR /><SPAN style="color: #000000; font-family: '.AppleSystemUIFont', serif; font-size: 14.6667px;">&nbsp;&nbsp;&nbsp;&nbsp; <EM>mavg(1vw, avg(ts(telegraf.response.times.99.percentile , accountid="123" and env="prod" and <EM style="color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px;">myvar</EM>!="true”)))</EM><BR />I tried with following but does not help<BR /></SPAN></P><P class="c-message_kit__gutter" style="padding: 8px 20px; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px; background-color: #f8f8f8;"><EM>mavg(1vw, avg(align(900s, mean, ts(telegraf.response.times.99.percentile , accountid=“123” and env=“prod” and myvar!=“true”))))</EM></P><DIV class="c-message_kit__gutter__right" data-qa="message_content" style="padding: 8px 8px 8px 16px; margin: -12px -8px -16px -16px;"><DIV class="c-message_kit__blocks c-message_kit__blocks--rich_text" style="margin-bottom: 4px;"><DIV class="c-message__message_blocks c-message__message_blocks--rich_text"><DIV class="p-block_kit_renderer" data-qa="block-kit-renderer"><DIV class="p-block_kit_renderer__block_wrapper--first p-block_kit_renderer__block_wrapper"><DIV class="p-rich_text_block"><DIV class="p-rich_text_section"><P></P></DIV></DIV></DIV></DIV></DIV></DIV></DIV><P class="c-message__actions c-message_actions__container" style="padding: 2px; color: #1d1c1d; font-family: Slack-Lato, appleLogo, sans-serif; font-size: 15px;"><BUTTON class="c-button-unstyled c-icon_button--light c-icon_button--size_small c-message_actions__button c-icon_button" data-qa="add_reaction_action" style="padding: unset; background-position: initial; text-align: initial;" type="button"></BUTTON></P></BODY></HTML> Fri, 31 Jan 2020 23:51:24 GMT https://communities.vmware.com/t5/Wavefront-by-VMware-Discussions/mavg-query-timeout-when-called-through-the-REST-api/m-p/1849258#M518 kuldeepjain 2020-01-31T23:51:24Z Re: mavg query timeout when called through the REST api https://communities.vmware.com/t5/Wavefront-by-VMware-Discussions/mavg-query-timeout-when-called-through-the-REST-api/m-p/1849259#M519 <HTML><HEAD></HEAD><BODY><P>Interesting - I'd expect the API call to return faster than the UI (because there's no need to render anything). What parameters are you using for the API call?</P></BODY></HTML> Mon, 03 Feb 2020 19:47:21 GMT https://communities.vmware.com/t5/Wavefront-by-VMware-Discussions/mavg-query-timeout-when-called-through-the-REST-api/m-p/1849259#M519 humphrey_wf 2020-02-03T19:47:21Z