[Feature] Add user field to information_schema.active_queries and information_schema.backend_active_tasks tables. Additionally, add sql content and start_time fields to the information_schema.backend_active_tasks table.

[jiezi2026]

Search before asking

• I had searched in the issues 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

• I agree to follow this project's Code of Conduct