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.

Note: If you have deleted table rows recently, Management Console may not display the most recent row count. MC updates the row count when mergeout occurs. See Mergeout.

Projections Summary

The projections summary displays information about projections by schema:

Click a projections number to view a list of the specified projections and their details.