planner: lower the priority of `mlog` tables in auto-analyze
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
Here is the user's workload:
1. totally there are around 20k tables
2. many of these tables have materialized views
3. for each materialized view we'll create a corresponding `mlog` table
Below are 100 auto-analyze jobs from the user's workload, and the problem is that `mlog` tables dominate the auto-analyze (because we delete/insert on them periodically so they are volatile), and other normal tables have a lower (or even no) chance to get analyzed:
```
2026-06-25 11:32:48 2026-06-25 11:32:48 2026-06-25 11:32:48 finished DB $mlog$tbl_records_2866 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:32:51 2026-06-25 11:32:51 2026-06-25 11:32:51 finished DB $mlog$tbl_records_2928 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:32:54 2026-06-25 11:32:54 2026-06-25 11:32:54 finished DB $mlog$tbl_records_3095 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:32:57 2026-06-25 11:32:57 2026-06-25 11:32:57 finished DB $mlog$tbl_records_3179 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:00 2026-06-25 11:33:00 2026-06-25 11:33:00 finished DB $mlog$tbl_records_2995 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:03 2026-06-25 11:33:03 2026-06-25 11:33:03 finished DB $mlog$tbl_records_1169 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:06 2026-06-25 11:33:06 2026-06-25 11:33:06 finished DB $mlog$tbl_records_3013 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:09 2026-06-25 11:33:09 2026-06-25 11:33:09 finished DB $mlog$tbl_records_3099 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:12 2026-06-25 11:33:12 2026-06-25 11:33:12 finished DB $mlog$tbl_records_2967 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:15 2026-06-25 11:33:15 2026-06-25 11:33:15 finished DB $mlog$tbl_records_292 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:18 2026-06-25 11:33:18 2026-06-25 11:33:18 finished DB $mlog$tbl_records_1063 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:21 2026-06-25 11:33:21 2026-06-25 11:33:21 finished DB $mlog$tbl_records_3335 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:24 2026-06-25 11:33:24 2026-06-25 11:33:24 finished DB $mlog$tbl_records_3163 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:27 2026-06-25 11:33:27 2026-06-25 11:33:27 finished DB $mlog$tbl_records_631 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:30 2026-06-25 11:33:30 2026-06-25 11:33:30 finished DB $mlog$tbl_records_2861 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:33 2026-06-25 11:33:33 2026-06-25 11:33:33 finished DB $mlog$tbl_records_3123 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:36 2026-06-25 11:33:36 2026-06-25 11:33:36 finished DB $mlog$tbl_records_3128 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:39 2026-06-25 11:33:39 2026-06-25 11:33:39 finished DB $mlog$tbl_records_526 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:42 2026-06-25 11:33:42 2026-06-25 11:33:42 finished DB $mlog$tbl_records_2975 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:46 2026-06-25 11:33:45 2026-06-25 11:33:46 finished DB $mlog$tbl_records_1159 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:48 2026-06-25 11:33:48 2026-06-25 11:33:48 finished DB $mlog$tbl_records_1250 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:51 2026-06-25 11:33:51 2026-06-25 11:33:51 finished DB $mlog$tbl_records_3305 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:55 2026-06-25 11:33:54 2026-06-25 11:33:55 finished DB bsummary_mv_3138 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:33:57 2026-06-25 11:33:57 2026-06-25 11:33:57 finished DB $mlog$tbl_records_1039 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:00 2026-06-25 11:34:00 2026-06-25 11:34:00 finished DB $mlog$tbl_records_656 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:03 2026-06-25 11:34:03 2026-06-25 11:34:03 finished DB $mlog$tbl_records_3365 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:06 2026-06-25 11:34:06 2026-06-25 11:34:06 finished DB $mlog$tbl_records_2830 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:09 2026-06-25 11:34:09 2026-06-25 11:34:09 finished DB $mlog$tbl_records_2932 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:12 2026-06-25 11:34:12 2026-06-25 11:34:12 finished DB $mlog$tbl_records_3196 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:15 2026-06-25 11:34:15 2026-06-25 11:34:15 finished DB $mlog$tbl_records_3225 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:18 2026-06-25 11:34:18 2026-06-25 11:34:18 finished DB $mlog$tbl_records_3192 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:22 2026-06-25 11:34:21 2026-06-25 11:34:22 finished DB $mlog$tbl_records_521 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:24 2026-06-25 11:34:24 2026-06-25 11:34:24 finished DB $mlog$tbl_records_2707 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:27 2026-06-25 11:34:27 2026-06-25 11:34:27 finished DB $mlog$tbl_records_3009 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:30 2026-06-25 11:34:30 2026-06-25 11:34:30 finished DB $mlog$tbl_records_2683 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:33 2026-06-25 11:34:33 2026-06-25 11:34:33 finished DB $mlog$tbl_records_3285 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:36 2026-06-25 11:34:36 2026-06-25 11:34:36 finished DB $mlog$tbl_records_2895 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:40 2026-06-25 11:34:39 2026-06-25 11:34:40 finished DB bsummary_mv_3015 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:43 2026-06-25 11:34:42 2026-06-25 11:34:43 finished DB bsummary_mv_2855 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:45 2026-06-25 11:34:45 2026-06-25 11:34:45 finished DB $mlog$tbl_records_3360 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:49 2026-06-25 11:34:48 2026-06-25 11:34:49 finished DB bsummary_mv_3099 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:51 2026-06-25 11:34:51 2026-06-25 11:34:51 finished DB $mlog$tbl_records_2675 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:54 2026-06-25 11:34:54 2026-06-25 11:34:54 finished DB $mlog$tbl_records_3015 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:34:57 2026-06-25 11:34:57 2026-06-25 11:34:57 finished DB $mlog$tbl_records_3033 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:00 2026-06-25 11:35:00 2026-06-25 11:35:00 finished DB $mlog$tbl_records_3185 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:03 2026-06-25 11:35:03 2026-06-25 11:35:03 finished DB $mlog$tbl_records_1190 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:06 2026-06-25 11:35:06 2026-06-25 11:35:06 finished DB $mlog$tbl_records_3303 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:09 2026-06-25 11:35:09 2026-06-25 11:35:09 finished DB $mlog$tbl_records_2857 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:13 2026-06-25 11:35:12 2026-06-25 11:35:13 finished DB bsummary_mv_360 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:16 2026-06-25 11:35:15 2026-06-25 11:35:16 finished DB bsummary_mv_3085 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:18 2026-06-25 11:35:18 2026-06-25 11:35:18 finished DB $mlog$tbl_records_3053 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:21 2026-06-25 11:35:21 2026-06-25 11:35:21 finished DB $mlog$tbl_records_1089 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:25 2026-06-25 11:35:24 2026-06-25 11:35:25 finished DB $mlog$tbl_records_726 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:27 2026-06-25 11:35:27 2026-06-25 11:35:27 finished DB $mlog$tbl_records_1130 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:30 2026-06-25 11:35:30 2026-06-25 11:35:30 finished DB $mlog$tbl_records_3017 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:33 2026-06-25 11:35:33 2026-06-25 11:35:33 finished DB $mlog$tbl_records_1209 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:37 2026-06-25 11:35:36 2026-06-25 11:35:37 finished DB $mlog$tbl_records_1207 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:39 2026-06-25 11:35:39 2026-06-25 11:35:39 finished DB $mlog$tbl_records_2663 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:43 2026-06-25 11:35:42 2026-06-25 11:35:43 finished DB $mlog$tbl_records_985 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:45 2026-06-25 11:35:45 2026-06-25 11:35:45 finished DB $mlog$tbl_records_3326 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:48 2026-06-25 11:35:48 2026-06-25 11:35:48 finished DB $mlog$tbl_records_1126 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:51 2026-06-25 11:35:51 2026-06-25 11:35:51 finished DB $mlog$tbl_records_3162 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:54 2026-06-25 11:35:54 2026-06-25 11:35:54 finished DB $mlog$tbl_records_1158 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:35:57 2026-06-25 11:35:57 2026-06-25 11:35:57 finished DB $mlog$tbl_records_3106 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:01 2026-06-25 11:36:00 2026-06-25 11:36:01 finished DB bsummary_mv_1306 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:03 2026-06-25 11:36:03 2026-06-25 11:36:03 finished DB $mlog$tbl_records_1255 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:07 2026-06-25 11:36:06 2026-06-25 11:36:07 finished DB $mlog$tbl_records_1051 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:09 2026-06-25 11:36:09 2026-06-25 11:36:09 finished DB $mlog$tbl_records_1192 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:12 2026-06-25 11:36:12 2026-06-25 11:36:12 finished DB $mlog$tbl_records_3111 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:15 2026-06-25 11:36:15 2026-06-25 11:36:15 finished DB $mlog$tbl_records_2772 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:18 2026-06-25 11:36:18 2026-06-25 11:36:18 finished DB $mlog$tbl_records_1232 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:22 2026-06-25 11:36:21 2026-06-25 11:36:22 finished DB $mlog$tbl_records_1172 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:24 2026-06-25 11:36:24 2026-06-25 11:36:24 finished DB $mlog$tbl_records_2972 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:27 2026-06-25 11:36:27 2026-06-25 11:36:27 finished DB $mlog$tbl_records_2922 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:30 2026-06-25 11:36:30 2026-06-25 11:36:30 finished DB $mlog$tbl_records_395 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:33 2026-06-25 11:36:33 2026-06-25 11:36:33 finished DB $mlog$tbl_records_3137 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:36 2026-06-25 11:36:36 2026-06-25 11:36:36 finished DB $mlog$tbl_records_2659 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:40 2026-06-25 11:36:40 2026-06-25 11:36:40 finished DB $mlog$tbl_records_1307 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:42 2026-06-25 11:36:42 2026-06-25 11:36:42 finished DB $mlog$tbl_records_1290 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:45 2026-06-25 11:36:45 2026-06-25 11:36:45 finished DB $mlog$tbl_records_3063 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:49 2026-06-25 11:36:48 2026-06-25 11:36:49 finished DB bsummary_mv_985 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:51 2026-06-25 11:36:51 2026-06-25 11:36:51 finished DB $mlog$tbl_records_3362 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:54 2026-06-25 11:36:54 2026-06-25 11:36:54 finished DB $mlog$tbl_records_3200 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:36:57 2026-06-25 11:36:57 2026-06-25 11:36:57 finished DB $mlog$tbl_records_3271 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:01 2026-06-25 11:37:00 2026-06-25 11:37:01 finished DB bsummary_mv_1235 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:03 2026-06-25 11:37:03 2026-06-25 11:37:03 finished DB $mlog$tbl_records_3012 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:06 2026-06-25 11:37:06 2026-06-25 11:37:06 finished DB $mlog$tbl_records_600 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:09 2026-06-25 11:37:09 2026-06-25 11:37:09 finished DB $mlog$tbl_records_2725 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:12 2026-06-25 11:37:12 2026-06-25 11:37:12 finished DB $mlog$tbl_records_3327 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:15 2026-06-25 11:37:15 2026-06-25 11:37:15 finished DB $mlog$tbl_records_2992 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:19 2026-06-25 11:37:18 2026-06-25 11:37:19 finished DB bsummary_mv_2718 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:21 2026-06-25 11:37:21 2026-06-25 11:37:21 finished DB $mlog$tbl_records_1070 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:24 2026-06-25 11:37:24 2026-06-25 11:37:24 finished DB $mlog$tbl_records_1279 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:27 2026-06-25 11:37:27 2026-06-25 11:37:27 finished DB $mlog$tbl_records_1092 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:31 2026-06-25 11:37:30 2026-06-25 11:37:31 finished DB $mlog$tbl_records_2686 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:34 2026-06-25 11:37:33 2026-06-25 11:37:34 finished DB bsummary_mv_1202 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:36 2026-06-25 11:37:36 2026-06-25 11:37:36 finished DB $mlog$tbl_records_3221 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:40 2026-06-25 11:37:39 2026-06-25 11:37:40 finished DB $mlog$tbl_records_3117 auto analyze table all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:43 2026-06-25 11:37:42 2026-06-25 11:37:43 finished DB bsummary_mv_3318 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
2026-06-25 11:37:47 2026-06-25 11:37:45 2026-06-25 11:37:47 finished DB bsummary_mv_1123 auto analyze table all indexes, all columns with 256 buckets, 100 topn, 1 samplerate NULL 10.107.2.168:4000 NULL
```
Below is a normal table, it was created 1 week ago, but it has never been analyzed:
`mlog` tables are volatile (we'll delete and insert rows periodically) and have no index, so it's safe and reasonable to lower the priority of it in auto-analyze.
Contributor guide
Research direction
No repository files, tests, or entry points are named. Start by locating the auto-analyze scheduling and planner code, then find tests covering analyze-job selection or prioritization. Done means mlog tables no longer dominate the queue while normal tables still receive analysis opportunities, with regression coverage for the reported workload.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go
- Domain
- databases, performance
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Quiet
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100