[YSQL] Collect catalog tables mutation counts

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.

https://www.yugabyte.com

Other

8.87k stars 1.05k forks source link

[YSQL] Collect catalog tables mutation counts #22104

Closed yifanguan closed 4 days ago

yifanguan commented 4 months ago

Jira Link: DB-11037

Description

For auto-analyze service, we should make sure we collect catalogs' table mutation counts from DDL statements. Accurate stats on catalogs help query optimizer chooses optimal plan for system queries.

Issue Type

kind/new-feature

Warning: Please confirm that this issue does not contain any sensitive information

[X] I confirm this issue does not contain any sensitive information.

yifanguan commented 1 month ago

Currently, we collect mutations from direct DMLs on catalog tables, but not from DDLs. For example, a simple CREATE TABLE does not increase the mutation count of pg_class.

yifanguan commented 4 days ago

issue is resolved by commit ee639f4