Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: gather 的表统计信息问题 #387

Open
Teingi opened this issue Aug 12, 2024 · 0 comments
Open

[Bug]: gather 的表统计信息问题 #387

Teingi opened this issue Aug 12, 2024 · 0 comments

Comments

@Teingi
Copy link
Contributor

Teingi commented Aug 12, 2024

Describe the bug

image

同一张表,数据有很多条

Environment

obdiag 2.x
ob 4.x

Fast reproduce steps

select /*+read_consistency(weak) QUERY_TIMEOUT(60000000) */ t1.svr_ip, t1.role, t1.tenant_id,t1.database_name,t1.table_name, ifnull(t2.data_size,0) / 1073741824 as total_data_size_gb from (select tenant_id, database_name, table_name, role, svr_ip, table_id, tablet_id from oceanbase.cdb_ob_table_locations) t1 left join (select tenant_id, tablet_id, data_size from oceanbase.cdb_ob_tablet_replicas) t2 on t1.tenant_id = t2.tenant_id and t1.tablet_id = t2.tablet_id order by total_data_size_gb desc limit 50;

Expected behavior

No response

Actual behavior

No response

Additional context

No response

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant