新集群查询半小时查不出来,无法输出explain analyze执行计划,老集群的explain analyze执行计划如下
TopN_24 10.00 10 root time:133.3ms, loops:2 partnerhubanalytics.subscription_analytics.day:asc, offset:0, count:10 12.1 KB N/A
└─PartitionUnion_28 70.00 70 root time:133.3ms, loops:8 N/A N/A
├─Projection_44 10.00 10 root time:72.2ms, loops:2, Concurrency:OFF partnerhubanalytics.subscription_analytics.day, partnerhubanalytics.subscription_analytics.partner_org_id, partnerhubanalytics.subscription_analytics.partner_name, partnerhubanalytics.subscription_analytics.customer_org_id, partnerhubanalytics.subscription_analytics.customer_name, partnerhubanalytics.subscription_analytics.offer_code, partnerhubanalytics.subscription_analytics.external_subscription_id, partnerhubanalytics.subscription_analytics.subscription_start_date, partnerhubanalytics.subscription_analytics.subscription_end_date, partnerhubanalytics.subscription_analytics.is_trial, partnerhubanalytics.subscription_analytics.is_auto_renew, partnerhubanalytics.subscription_analytics.available_licenses, partnerhubanalytics.subscription_analytics.assigned_licenses, partnerhubanalytics.subscription_analytics.actively_used_licenses, partnerhubanalytics.subscription_analytics.capacity, partnerhubanalytics.subscription_analytics.trial_duration, partnerhubanalytics.subscription_analytics.license_status, partnerhubanalytics.subscription_analytics.license_id, partnerhubanalytics.subscription_analytics.workload, partnerhubanalytics.subscription_analytics.daily_actively_used_licenses, partnerhubanalytics.subscription_analytics.weekly_actively_used_licenses, partnerhubanalytics.subscription_analytics.is_sa_display, partnerhubanalytics.subscription_analytics.decrypted_customer_name 12.4 KB N/A
│ └─IndexLookUp_43 10.00 10 root time:72.2ms, loops:2, index_task: {total_time: 1.67ms, fetch_handle: 1.67ms, build: 2.31µs, wait: 1.83µs}, table_task: {total_time: 9.45ms, num: 1, concurrency: 4} limit embedded(offset:0, count:10) 24.2 KB N/A
│ ├─Limit_42(Build) 10.00 10 cop[tikv] time:1.67ms, loops:1, cop_task: {num: 1, max: 1.54ms, proc_keys: 32, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.54ms, copr_cache: disabled}, tikv_task:{time:1ms, loops:1} offset:0, count:10 N/A N/A
│ │ └─IndexFullScan_40 10.00 32 cop[tikv] table:sa, partition:p0, index:PRIMARY(day, partner_org_id, customer_org_id, offer_code, external_subscription_id, license_id) tikv_task:{time:1ms, loops:1} keep order:true N/A N/A
│ └─TableRowIDScan_41(Probe) 10.00 10 cop[tikv] table:sa, partition:p0 time:1.54ms, loops:2, cop_task: {num: 5, max: 1.46ms, min: 737.4µs, avg: 1.04ms, p95: 1.46ms, max_proc_keys: 3, p95_proc_keys: 3, tot_proc: 2ms, tot_wait: 1ms, rpc_num: 5, rpc_time: 5.16ms, copr_cache: disabled}, tikv_task:{proc max:1ms, min:0s, p80:1ms, p95:1ms, iters:5, tasks:5} keep order:false, stats:pseudo N/A N/A
├─Projection_64 10.00 10 root time:78.4ms, loops:2, Concurrency:OFF partnerhubanalytics.subscription_analytics.day, partnerhubanalytics.subscription_analytics.partner_org_id, partnerhubanalytics.subscription_analytics.partner_name, partnerhubanalytics.subscription_analytics.customer_org_id, partnerhubanalytics.subscription_analytics.customer_name, partnerhubanalytics.subscription_analytics.offer_code, partnerhubanalytics.subscription_analytics.external_subscription_id, partnerhubanalytics.subscription_analytics.subscription_start_date, partnerhubanalytics.subscription_analytics.subscription_end_date, partnerhubanalytics.subscription_analytics.is_trial, partnerhubanalytics.subscription_analytics.is_auto_renew, partnerhubanalytics.subscription_analytics.available_licenses, partnerhubanalytics.subscription_analytics.assigned_licenses, partnerhubanalytics.subscription_analytics.actively_used_licenses, partnerhubanalytics.subscription_analytics.capacity, partnerhubanalytics.subscription_analytics.trial_duration, partnerhubanalytics.subscription_analytics.license_status, partnerhubanalytics.subscription_analytics.license_id, partnerhubanalytics.subscription_analytics.workload, partnerhubanalytics.subscription_analytics.daily_actively_used_licenses, partnerhubanalytics.subscription_analytics.weekly_actively_used_licenses, partnerhubanalytics.subscription_analytics.is_sa_display, partnerhubanalytics.subscription_analytics.decrypted_customer_name 12.4 KB N/A
│ └─IndexLookUp_63 10.00 10 root time:78.4ms, loops:2, index_task: {total_time: 2.5ms, fetch_handle: 2.5ms, build: 1.65µs, wait: 1.14µs}, table_task: {total_time: 12.3ms, num: 1, concurrency: 4} limit embedded(offset:0, count:10) 32.5 KB N/A
│ ├─Limit_62(Build) 10.00 10 cop[tikv] time:2.49ms, loops:1, cop_task: {num: 1, max: 2.5ms, proc_keys: 32, rpc_num: 1, rpc_time: 2.49ms, copr_cache: disabled}, tikv_task:{time:0s, loops:1} offset:0, count:10 N/A N/A
│ │ └─IndexFullScan_60 10.00 32 cop[tikv] table:sa, partition:p1, index:PRIMARY(day, partner_org_id, customer_org_id, offer_code, external_subscription_id, license_id) tikv_task:{time:0s, loops:1} keep order:true N/A N/A
│ └─TableRowIDScan_61(Probe) 10.00 10 cop[tikv] table:sa, partition:p1 time:1.62ms, loops:2, cop_task: {num: 4, max: 1.55ms, min: 659.2µs, avg: 1.06ms, p95: 1.55ms, max_proc_keys: 3, p95_proc_keys: 3, tot_proc: 3ms, rpc_num: 4, rpc_time: 4.16ms, copr_cache: disabled}, tikv_task:{proc max:1ms, min:0s, p80:1ms, p95:1ms, iters:4, tasks:4} keep order:false, stats:pseudo N/A N/A
├─Projection_84 10.00 10 root time:75.8ms, loops:2, Concurrency:OFF partnerhubanalytics.subscription_analytics.day, partnerhubanalytics.subscription_analytics.partner_org_id, partnerhubanalytics.subscription_analytics.partner_name, partnerhubanalytics.subscription_analytics.customer_org_id, partnerhubanalytics.subscription_analytics.customer_name, partnerhubanalytics.subscription_analytics.offer_code, partnerhubanalytics.subscription_analytics.external_subscription_id, partnerhubanalytics.subscription_analytics.subscription_start_date, partnerhubanalytics.subscription_analytics.subscription_end_date, partnerhubanalytics.subscription_analytics.is_trial, partnerhubanalytics.subscription_analytics.is_auto_renew, partnerhubanalytics.subscription_analytics.available_licenses, partnerhubanalytics.subscription_analytics.assigned_licenses, partnerhubanalytics.subscription_analytics.actively_used_licenses, partnerhubanalytics.subscription_analytics.capacity, partnerhubanalytics.subscription_analytics.trial_duration, partnerhubanalytics.subscription_analytics.license_status, partnerhubanalytics.subscription_analytics.license_id, partnerhubanalytics.subscription_analytics.workload, partnerhubanalytics.subscription_analytics.daily_actively_used_licenses, partnerhubanalytics.subscription_analytics.weekly_actively_used_licenses, partnerhubanalytics.subscription_analytics.is_sa_display, partnerhubanalytics.subscription_analytics.decrypted_customer_name 12.4 KB N/A
│ └─IndexLookUp_83 10.00 10 root time:75.8ms, loops:2, index_task: {total_time: 1.94ms, fetch_handle: 1.93ms, build: 1.75µs, wait: 1.09µs}, table_task: {total_time: 9.83ms, num: 1, concurrency: 4} limit embedded(offset:0, count:10) 24.6 KB N/A
│ ├─Limit_82(Build) 10.00 10 cop[tikv] time:1.93ms, loops:1, cop_task: {num: 1, max: 1.87ms, proc_keys: 32, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.86ms, copr_cache: disabled}, tikv_task:{time:1ms, loops:1} offset:0, count:10 N/A N/A
│ │ └─IndexFullScan_80 10.00 32 cop[tikv] table:sa, partition:p2, index:PRIMARY(day, partner_org_id, customer_org_id, offer_code, external_subscription_id, license_id) tikv_task:{time:1ms, loops:1} keep order:true N/A N/A
│ └─TableRowIDScan_81(Probe) 10.00 10 cop[tikv] table:sa, partition:p2 time:1.27ms, loops:2, cop_task: {num: 4, max: 1.14ms, min: 566.7µs, avg: 841.9µs, p95: 1.14ms, max_proc_keys: 4, p95_proc_keys: 4, tot_proc: 1ms, tot_wait: 2ms, rpc_num: 4, rpc_time: 3.35ms, copr_cache: disabled}, tikv_task:{proc max:1ms, min:0s, p80:1ms, p95:1ms, iters:4, tasks:4} keep order:false, stats:pseudo N/A N/A
├─Projection_104 10.00 10 root time:80.7ms, loops:2, Concurrency:OFF partnerhubanalytics.subscription_analytics.day, partnerhubanalytics.subscription_analytics.partner_org_id, partnerhubanalytics.subscription_analytics.partner_name, partnerhubanalytics.subscription_analytics.customer_org_id, partnerhubanalytics.subscription_analytics.customer_name, partnerhubanalytics.subscription_analytics.offer_code, partnerhubanalytics.subscription_analytics.external_subscription_id, partnerhubanalytics.subscription_analytics.subscription_start_date, partnerhubanalytics.subscription_analytics.subscription_end_date, partnerhubanalytics.subscription_analytics.is_trial, partnerhubanalytics.subscription_analytics.is_auto_renew, partnerhubanalytics.subscription_analytics.available_licenses, partnerhubanalytics.subscription_analytics.assigned_licenses, partnerhubanalytics.subscription_analytics.actively_used_licenses, partnerhubanalytics.subscription_analytics.capacity, partnerhubanalytics.subscription_analytics.trial_duration, partnerhubanalytics.subscription_analytics.license_status, partnerhubanalytics.subscription_analytics.license_id, partnerhubanalytics.subscription_analytics.workload, partnerhubanalytics.subscription_analytics.daily_actively_used_licenses, partnerhubanalytics.subscription_analytics.weekly_actively_used_licenses, partnerhubanalytics.subscription_analytics.is_sa_display, partnerhubanalytics.subscription_analytics.decrypted_customer_name 12.4 KB N/A
│ └─IndexLookUp_103 10.00 10 root time:80.7ms, loops:2, index_task: {total_time: 792.9µs, fetch_handle: 790.1µs, build: 1.52µs, wait: 1.2µs}, table_task: {total_time: 5.28ms, num: 1, concurrency: 4} limit embedded(offset:0, count:10) 22.1 KB N/A
│ ├─Limit_102(Build) 10.00 10 cop[tikv] time:786.2µs, loops:1, cop_task: {num: 1, max: 755.5µs, proc_keys: 32, rpc_num: 1, rpc_time: 750.6µs, copr_cache: disabled}, tikv_task:{time:0s, loops:1} offset:0, count:10 N/A N/A
│ │ └─IndexFullScan_100 10.00 32 cop[tikv] table:sa, partition:p3, index:PRIMARY(day, partner_org_id, customer_org_id, offer_code, external_subscription_id, license_id) tikv_task:{time:0s, loops:1} keep order:true N/A N/A
│ └─TableRowIDScan_101(Probe) 10.00 10 cop[tikv] table:sa, partition:p3 time:1.26ms, loops:2, cop_task: {num: 5, max: 1.19ms, min: 739.9µs, avg: 906.8µs, p95: 1.19ms, max_proc_keys: 4, p95_proc_keys: 4, tot_proc: 2ms, rpc_num: 5, rpc_time: 4.49ms, copr_cache: disabled}, tikv_task:{proc max:1ms, min:0s, p80:1ms, p95:1ms, iters:5, tasks:5} keep order:false, stats:pseudo N/A N/A
├─Projection_124 10.00 10 root time:52.4ms, loops:2, Concurrency:OFF partnerhubanalytics.subscription_analytics.day, partnerhubanalytics.subscription_analytics.partner_org_id, partnerhubanalytics.subscription_analytics.partner_name, partnerhubanalytics.subscription_analytics.customer_org_id, partnerhubanalytics.subscription_analytics.customer_name, partnerhubanalytics.subscription_analytics.offer_code, partnerhubanalytics.subscription_analytics.external_subscription_id, partnerhubanalytics.subscription_analytics.subscription_start_date, partnerhubanalytics.subscription_analytics.subscription_end_date, partnerhubanalytics.subscription_analytics.is_trial, partnerhubanalytics.subscription_analytics.is_auto_renew, partnerhubanalytics.subscription_analytics.available_licenses, partnerhubanalytics.subscription_analytics.assigned_licenses, partnerhubanalytics.subscription_analytics.actively_used_licenses, partnerhubanalytics.subscription_analytics.capacity, partnerhubanalytics.subscription_analytics.trial_duration, partnerhubanalytics.subscription_analytics.license_status, partnerhubanalytics.subscription_analytics.license_id, partnerhubanalytics.subscription_analytics.workload, partnerhubanalytics.subscription_analytics.daily_actively_used_licenses, partnerhubanalytics.subscription_analytics.weekly_actively_used_licenses, partnerhubanalytics.subscription_analytics.is_sa_display, partnerhubanalytics.subscription_analytics.decrypted_customer_name 12.4 KB N/A
│ └─IndexLookUp_123 10.00 10 root time:52.4ms, loops:2, index_task: {total_time: 1.65ms, fetch_handle: 1.64ms, build: 2.61µs, wait: 1.15µs}, table_task: {total_time: 9.39ms, num: 1, concurrency: 4} limit embedded(offset:0, count:10) 27.2 KB N/A
│ ├─Limit_122(Build) 10.00 10 cop[tikv] time:1.64ms, loops:1, cop_task: {num: 1, max: 1.5ms, proc_keys: 32, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.5ms, copr_cache: disabled}, tikv_task:{time:1ms, loops:1} offset:0, count:10 N/A N/A
│ │ └─IndexFullScan_120 10.00 32 cop[tikv] table:sa, partition:p4, index:PRIMARY(day, partner_org_id, customer_org_id, offer_code, external_subscription_id, license_id) tikv_task:{time:1ms, loops:1} keep order:true N/A N/A
│ └─TableRowIDScan_121(Probe) 10.00 10 cop[tikv] table:sa, partition:p4 time:1.75ms, loops:2, cop_task: {num: 5, max: 1.64ms, min: 714.4µs, avg: 1.16ms, p95: 1.64ms, max_proc_keys: 4, p95_proc_keys: 4, tot_proc: 1ms, tot_wait: 1ms, rpc_num: 5, rpc_time: 5.77ms, copr_cache: disabled}, tikv_task:{proc max:1ms, min:0s, p80:1ms, p95:1ms, iters:5, tasks:5} keep order:false, stats:pseudo N/A N/A
├─Projection_144 10.00 10 root time:56ms, loops:2, Concurrency:OFF partnerhubanalytics.subscription_analytics.day, partnerhubanalytics.subscription_analytics.partner_org_id, partnerhubanalytics.subscription_analytics.partner_name, partnerhubanalytics.subscription_analytics.customer_org_id, partnerhubanalytics.subscription_analytics.customer_name, partnerhubanalytics.subscription_analytics.offer_code, partnerhubanalytics.subscription_analytics.external_subscription_id, partnerhubanalytics.subscription_analytics.subscription_start_date, partnerhubanalytics.subscription_analytics.subscription_end_date, partnerhubanalytics.subscription_analytics.is_trial, partnerhubanalytics.subscription_analytics.is_auto_renew, partnerhubanalytics.subscription_analytics.available_licenses, partnerhubanalytics.subscription_analytics.assigned_licenses, partnerhubanalytics.subscription_analytics.actively_used_licenses, partnerhubanalytics.subscription_analytics.capacity, partnerhubanalytics.subscription_analytics.trial_duration, partnerhubanalytics.subscription_analytics.license_status, partnerhubanalytics.subscription_analytics.license_id, partnerhubanalytics.subscription_analytics.workload, partnerhubanalytics.subscription_analytics.daily_actively_used_licenses, partnerhubanalytics.subscription_analytics.weekly_actively_used_licenses, partnerhubanalytics.subscription_analytics.is_sa_display, partnerhubanalytics.subscription_analytics.decrypted_customer_name 12.4 KB N/A
│ └─IndexLookUp_143 10.00 10 root time:56ms, loops:2, index_task: {total_time: 1.03ms, fetch_handle: 1.02ms, build: 2.55µs, wait: 3.86µs}, table_task: {total_time: 8.22ms, num: 1, concurrency: 4} limit embedded(offset:0, count:10) 24.1 KB N/A
│ ├─Limit_142(Build) 10.00 10 cop[tikv] time:1.02ms, loops:1, cop_task: {num: 1, max: 971.7µs, proc_keys: 32, rpc_num: 1, rpc_time: 968.1µs, copr_cache: disabled}, tikv_task:{time:0s, loops:1} offset:0, count:10 N/A N/A
│ │ └─IndexFullScan_140 10.00 32 cop[tikv] table:sa, partition:p5, index:PRIMARY(day, partner_org_id, customer_org_id, offer_code, external_subscription_id, license_id) tikv_task:{time:0s, loops:1} keep order:true N/A N/A
│ └─TableRowIDScan_141(Probe) 10.00 10 cop[tikv] table:sa, partition:p5 time:3.18ms, loops:2, cop_task: {num: 4, max: 3.11ms, min: 580.1µs, avg: 1.38ms, p95: 3.11ms, max_proc_keys: 4, p95_proc_keys: 4, rpc_num: 4, rpc_time: 5.49ms, copr_cache: disabled}, tikv_task:{proc max:0s, min:0s, p80:0s, p95:0s, iters:4, tasks:4} keep order:false, stats:pseudo N/A N/A
└─Projection_164 10.00 10 root time:54.7ms, loops:2, Concurrency:OFF partnerhubanalytics.subscription_analytics.day, partnerhubanalytics.subscription_analytics.partner_org_id, partnerhubanalytics.subscription_analytics.partner_name, partnerhubanalytics.subscription_analytics.customer_org_id, partnerhubanalytics.subscription_analytics.customer_name, partnerhubanalytics.subscription_analytics.offer_code, partnerhubanalytics.subscription_analytics.external_subscription_id, partnerhubanalytics.subscription_analytics.subscription_start_date, partnerhubanalytics.subscription_analytics.subscription_end_date, partnerhubanalytics.subscription_analytics.is_trial, partnerhubanalytics.subscription_analytics.is_auto_renew, partnerhubanalytics.subscription_analytics.available_licenses, partnerhubanalytics.subscription_analytics.assigned_licenses, partnerhubanalytics.subscription_analytics.actively_used_licenses, partnerhubanalytics.subscription_analytics.capacity, partnerhubanalytics.subscription_analytics.trial_duration, partnerhubanalytics.subscription_analytics.license_status, partnerhubanalytics.subscription_analytics.license_id, partnerhubanalytics.subscription_analytics.workload, partnerhubanalytics.subscription_analytics.daily_actively_used_licenses, partnerhubanalytics.subscription_analytics.weekly_actively_used_licenses, partnerhubanalytics.subscription_analytics.is_sa_display, partnerhubanalytics.subscription_analytics.decrypted_customer_name 12.4 KB N/A
└─IndexLookUp_163 10.00 10 root time:54.7ms, loops:2, index_task: {total_time: 898.2µs, fetch_handle: 895.2µs, build: 1.54µs, wait: 1.41µs}, table_task: {total_time: 5.42ms, num: 1, concurrency: 4} limit embedded(offset:0, count:10) 22.7 KB N/A
├─Limit_162(Build) 10.00 10 cop[tikv] time:892.1µs, loops:1, cop_task: {num: 1, max: 808.6µs, proc_keys: 32, rpc_num: 1, rpc_time: 803.6µs, copr_cache: disabled}, tikv_task:{time:0s, loops:1} offset:0, count:10 N/A N/A
│ └─IndexFullScan_160 10.00 32 cop[tikv] table:sa, partition:p6, index:PRIMARY(day, partner_org_id, customer_org_id, offer_code, external_subscription_id, license_id) tikv_task:{time:0s, loops:1} keep order:true N/A N/A
└─TableRowIDScan_161(Probe) 10.00 10 cop[tikv] table:sa, partition:p6 time:1.11ms, loops:2, cop_task: {num: 8, max: 1.05ms, min: 747.1µs, avg: 870.7µs, p95: 1.05ms, max_proc_keys: 3, p95_proc_keys: 3, tot_proc: 1ms, rpc_num: 8, rpc_time: 6.92ms, copr_cache: disabled}, tikv_task:{proc max:1ms, min:0s, p80:0s, p95:1ms, iters:8, tasks:8} keep order:false, stats:pseudo N/A N/A