jiezi2026 opened a new issue, #43056: URL: https://github.com/apache/doris/issues/43056
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description Currently, the information_schema.active_queries and information_schema.backend_active_tasks tables provide useful information about ongoing and active tasks in Doris. However, there are some limitations that can be addressed to enhance the visibility and traceability of these queries and tasks. User Field: Adding a user field to both information_schema.active_queries and information_schema.backend_active_tasks will help identify which user initiated the query or task. This is particularly useful for auditing and troubleshooting purposes. SQL Content: In the information_schema.backend_active_tasks table, adding an sql field will allow users to see the exact SQL query being executed. This is especially important when trying to understand the nature of the task and its impact on the system. Start Time: Adding a start_time field to the information_schema.backend_active_tasks table will provide the exact time when the task was initiated. This information is crucial for performance analysis and understanding the duration of tasks. ### Use case Auditing and Troubleshooting: Identify which user initiated a specific query or task. Track the SQL content of tasks running on the backend. Determine the start time of tasks to analyze performance and duration. Performance Analysis: Monitor long-running queries and tasks. Understand the impact of specific SQL queries on the system. Resource Management: Allocate resources more effectively based on user activity and query patterns. Prioritize tasks and queries based on their start time and user importance. ### Related issues _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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.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
