dutyu commented on PR #14100: URL: https://github.com/apache/doris/pull/14100#issuecomment-1309990269
> > > Why not just query slow queries with `select * from audit_table where time > 5000`? That would be more easy to use and no need to maintain to many tables. > > > > > > Many endpoint users are concerned with slow queries, hoping to analyze such queries in a more convenient way. The audit log table often has a very large amount of data, and the proportion of slow queries in it is very small. Therefore, slow queries are stored as a separate table for It is more reasonable for users with slow query analysis needs > > its beteer to set parittion with query_time for audit_table, this also can speed up slow query. but dynamic partition does not like support this😂. Maybe we can also create a `ROLLUP` and place `query_time` as the first key column to speed up queries (use `prefix index`). -- 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. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
