chaoyli opened a new issue #3689:
URL: https://github.com/apache/incubator-doris/issues/3689
Doris is absent of query monitor. It is not convenient when analyzing the
query workload.
A query monitor should cover such features.
```
1. It can exhibit running queries at present.
2. If can analysis the query latency(mean/99 percentile) at defined interval.
For example, DBA will want to about the mean latency between 11:00 and
11:05.
3. It can observe the query profile of queries over a period of time.
For example, how much resource a query consumed is critical for analysis
the hot spot.
```
To address the above problem, Doris should support query details for outside
monitor to collect and analysis.
```
create table query_detail (
query_id varchar(100),
start_time datetime,
end_time datetime,
latency int comment "unit is milliseconds",
state varchar(20) comment "RUNNING/FINISHED/FAILED"
)
duplicate key (query_id)
distributed by hash(query_id) buckets 10;
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
