Monitoring Table Utilization and Projections
The Table Utilization activity page helps you monitor tables and projections in your database by schema.
You can use the table utilization charts on this page to identify outliers among your tables, such as those that are large or overused. The projections summary can help identify if projections are evenly distributed across nodes.
Table Visualizations
To specify a schema to view, choose one from the Schemas menu at the top of the activity page. The summary of tables and projections in that schema appear on the page.
MC visualizes your available tables by schema in a table chart or as a treemap chart.
The Table chart provides flexible sorting to help you find tables you are interested in, especially if you have a large number of tables. You can use the Treemap chart for an at-a-glance graphical visualization of the relative size of your tables.
To choose how to visualize your table data, click Table or Map from the Show As menu. By default, MC displays the Table visualization. The current visualization is highlighted in blue in the Show As menu.
The Table chart, shown below, displays each table's row count, usage (percentage of time the table is queried), and a bar representing both row count and usage. The length of the bar indicates row count; a darker color indicates higher usage.
Hover over a bar in the chart to view details about that table, or click the table name to view its Table Details page.
In the Treemap visualization, tables are represented by boxes nested by size and colored by usage. Darker colors indicate higher table usage.
Depending on the number of tables in your database, the chart may be crowded. Use the Show Only filter at the top of the page to display only the largest or smallest 100 tables.
Hover over a table to view more details, or click to view its Table Details page.
The Table Details page displays information on the table's properties and columns, and about projections for the table. To the right, bar charts provide information, by node, on the amount of storage, number of deleted rows, and number of deleted vectors.
Projections Summary
The projections summary displays information about projections by schema:
- Total projections.
- Segmented projections, the number of projections segmented across multiple nodes.
- Unsegmented projections, the number of projections that are not segmented across multiple nodes.
- Projections Showing Distribution Skew, the number of projections unevenly distributed across nodes. Tables with fewer than 1000 rows are not counted. Move the slider to configure filter by distribution skew percentage.
- The number of projections with more than the specified number of containers per node. Move the slider to configure the minimum number of containers.
- Unsafe projections, the number of projections with a K-safety less than the database's K-safety.
- Unused projections.
Click a projections number to view a list of the specified projections and their details.