Can oal data use visual TopList to present data

[AllenArbiter]

I used oal to collect data and TopList to show data failed

• name: aws_connector_execute_time
  exp: aws_connector_execute_time.avg(['service', 'name']) The visual component Line can be displayed normally ，But with TopList, you can't，Is there a use example

[wu-sheng]

Could you explain a little about TopList? I don't remember if we supported that. cc @kezhenxu94

[AllenArbiter]

[AllenArbiter]

I was able to display my data using Line, but not using TopList So I wonder if it's because my data collection came from oal

[wu-sheng]

But that is time series data. How a list helps?

[AllenArbiter]

I don't know how to collect the data of topList and show it. I think it is the same as I collected the data of line before, but I can't find relevant documents. Could you please give me an example It is best to use oal collection and then use topList display

[wu-sheng]

TopList is to ordering the value.

[wu-sheng]

@Fine0830 Is this asking a sorted metric or something?

[Fine0830]

Here is an example for the topList.

{ "data": { "expression0": { "type": "SORTED_LIST", "results": [ { "metric": { "labels": [] }, "values": [ { "name": "19f4d9836c914f9b8dfd9d0c994681e2@10.116.1.213", "value": "100", "refId": null }, { "name": "1d7d178cce68440ea69e5a8b5f513947@10.116.1.221", "value": "100", "refId": null }, { "name": "1f4523e4e39c4f5692a1464b81ebe585@10.116.1.198", "value": "100", "refId": null }, { "name": "ed8033374d8646bdb4b30066ac81d529@10.116.5.30", "value": "100", "refId": null } ] } ], "error": null } } }

[wu-sheng]

Just a thing that, if you have labeled, it can't be sorted. You need to aggregate them through MAL.
Nothing special.

What @Fine0830 provided is query format, which is for me.

[AllenArbiter]

I'm still a little confused，This is the way I use it now

MeterFactory
			.counter("sql-count")
			.mode(CounterMode.RATE)
			.build()
                         .increment(100)

I used the MeterFactory counter to collect data and then went to MAL

  - name: sql-count
    exp: sql-count.sum(['service'])

I can show it in TopList, but if we don't let tag, how can we bring up the corresponding number of sql, or what kind of API can be used to collect such data? This data is very consistent with our situation, we can change the value of name to SQL to achieve a query SQL corresponding return data amount，Then use TopN to show it

{
"data": {
"expression0": {
"type": "SORTED_LIST",
"results": [
{
"metric": {
"labels": []
},
"values": [
{
"name": "select *from orguser",
"value": "100",
"refId": null
},
{
"name": "select * from wfh_task",
"value": "3111",
"refId": null
},
{
"name": "select * from cdk_io",
"value": "211",
"refId": null
},
{
"name": "select * from wfh_task_detail",
"value": "211",
"refId": null
}
]
}
],
"error": null
}
}
}

[wu-sheng]

There is no such case on our side for this. Slow SQLs are usually sampled through logs(such as MySQL Server monitoring), and only ordered, but not aggregated. But you are trying to run statistics based on SQL statements?

[AllenArbiter]

Yes,sir. We have a requirement to display query SQL return quantity monitoring，I can now intercept my client server's query SQL code，He then reports the number of queries he returns to Skywalking, I used Line before and everything worked fine，But our boss found that you have a very slow SQL monitoring works very well，We want to do a [query data volume SQL sort] to monitor the data

This makes me completely confused, I don't know how to collect the above JSON data

[wu-sheng]

If you are confused, how can I understand better than you do? We have already provided both ways, a) sampled slow SQL, 2) MAL to run any statistics on any labels(in your case, maybe it is SQL statement oriented).
I can't see what I can do more to help.