索引失效

新集群查询半小时查不出来,无法输出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