njnu-seafish opened a new issue, #18437: URL: https://github.com/apache/dolphinscheduler/issues/18437
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar feature requirement. ### Description Accessing the 'Task Instances' menu is extremely slow, with the backend API taking around 5 seconds to respond. This is really hurting the user experience. <img width="2559" height="721" alt="Image" src="https://github.com/user-attachments/assets/37498e02-a4e8-43c8-8e35-42f4791a22dd"; /> ----- 2451529 records SELECT COUNT(1) FROM t_ds_task_instance ----- The execution of the following SQL takes about 4 seconds SELECT id, NAME, task_type, workflow_instance_id, workflow_instance_name, project_code, task_code, task_definition_version, state, submit_time, start_time, end_time, HOST, execute_path, log_path, alert_flag, retry_times, pid, app_link, flag, retry_interval, max_retry_times, task_instance_priority, worker_group, environment_code, executor_id, executor_name, first_submit_time, delay_time, task_params, var_pool, dry_run, task_group_id, cpu_quota, memory_max, task_execute_type FROM t_ds_task_instance WHERE project_code = 175568922056192 ORDER BY submit_time DESC LIMIT 10 OFFSET 0; ----- The execution of the following SQL takes about 5 seconds SELECT id, NAME, task_type, workflow_instance_id, workflow_instance_name, project_code, task_code, task_definition_version, state, submit_time, start_time, end_time, HOST, execute_path, log_path, alert_flag, retry_times, pid, app_link, flag, retry_interval, max_retry_times, task_instance_priority, worker_group, environment_code, executor_id, executor_name, first_submit_time, delay_time, task_params, var_pool, dry_run, task_group_id, cpu_quota, memory_max, task_execute_type FROM t_ds_task_instance WHERE project_code = 175568922056192 AND start_time >= '2026-07-20 00:00:00' AND start_time <= '2026-07-23 23:59:59' ORDER BY submit_time DESC LIMIT 10 OFFSET 0; ### Are you willing to submit a PR? - [x] 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
