Description
Looks like we have some strange Query in QAN :
SELECT service_name, database, schema, username, client_host, replication_set, cluster, service_type, service_id, environment,az,region,
node_model,node_id,node_name,node_type,machine_id,container_name,container_id,agent_id,agent_type,labels.key AS lkey,
labels.value AS lvalue FROM metrics LEFT ARRAY JOIN labels
WHERE period_start >= toDateTime(1574642098) AND period_start <= toDateTime(1582418098)
ORDER BY service_name, database, schema, username, client_host, replication_set, cluster, service_type, service_id,
environment,az,region,node_model,node_id,node_name,node_type, machine_id,container_name,container_id,
agent_id,agent_type,labels.key,labels.value
It's returning ALL possible data and very slow
In addition, it's overload backend
TODO: optimize it