nebula-dashboard icon indicating copy to clipboard operation
nebula-dashboard copied to clipboard

Manage slow queries / error queries

Open Reid00 opened this issue 3 years ago • 5 comments

Is your feature request related to a problem? Please describe. After building Dashboard, there are some slow queries/ error queries show up. i want to locate at which services or which queries happened, but there are no any method as i known to debug.

Describe the solution you'd like currently, no

Describe alternatives you've considered currently no

Additional context no

Reid00 avatar Sep 24 '21 06:09 Reid00

You can try modify nebula-stats-exporter's config, give service a unique name, and then, build query to locate it, https://github.com/vesoft-inc/nebula-stats-exporter

kqzh avatar Sep 29 '21 09:09 kqzh

You can try modify nebula-stats-exporter's config, give service a unique name, and then, build query to locate it, https://github.com/vesoft-inc/nebula-stats-exporter

I think what @Reid00 means is to find the slow queries. When he finds there are slow queries show in the chart, it's meaningful to find which query caused this.

It's nice suggestion, we'll research supporting this, thanks @Reid00

nianiaJR avatar Oct 12 '21 02:10 nianiaJR

Is your feature request related to a problem? Please describe. After building Dashboard, there are some slow queries/ error queries show up. i want to locate at which services or which queries happened, but there are no any method as i known to debug.

Describe the solution you'd like currently, no

Describe alternatives you've considered currently no

Additional context no

I find that our ngql has supportted showing the list of all queries, which may help you get the slow quries. Here's the link:https://docs.nebula-graph.io/2.5.1/3.ngql-guide/7.general-query-statements/6.show/18.show-queries/#syntax

nianiaJR avatar Oct 12 '21 03:10 nianiaJR

i do some tests on v2.5.1. It seems that just can query the running queries, if the query finished, output empty. In truly scenario, we cannot star at the slow queries. if queries can be logged to somewhere, may be more make sense.

image

Reid00 avatar Oct 14 '21 06:10 Reid00

i do some tests on v2.5.1. It seems that just can query the running queries, if the query finished, output empty. In truly scenario, we cannot star at the slow queries. if queries can be logged to somewhere, may be more make sense.

image

Not supporting this feature until now.😅

bazingame avatar Jun 19 '23 09:06 bazingame