# MV\_AGGREGATED\_COLUMN\_USAGE

This view provides a summary of `mv_query_column_usage`, aggregating over the columns over all queries run.

| Column name         | Description                                                                                                                                                          |
| ------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `database_name`     | The name of the database, or`NULL`if none could be assigned.                                                                                                         |
| `table_name`        | The name of the table to which the column belongs.                                                                                                                   |
| `column_name`       | The aggregated column information is displayed for this column.                                                                                                      |
| `equijoins`         | The number of equijoins this column has been involved in over all queries run over the table.                                                                        |
| `inequality_joins`  | The number of inequality joins this column has been involved in over all queries run over the table.                                                                 |
| `equality_preds`    | The number of equality predicates in the`WHERE`or`ON`clause this column has been involved in all queries run on the table.                                           |
| `inequality_preds`  | The number of inequality predicates in the`WHERE`or`ON`clause this column has been involved in all queries run on the table.                                         |
| `groupbys`          | The number of`GROUP BY`clause in the column involved in all queries run on the table.                                                                                |
| `reshuffles`        | The number of reshuffle key in the column, involved in all queries run on the table.                                                                                 |
| `orderbys`          | The number of`ORDER BY`clause in the column involved in all queries run on the table.                                                                                |
| `outputs`           | The number of times the column was returned as the result of a query.                                                                                                |
| `query_appearances` | The number of distinct queries the column appears in all queries run on the table, which is equivalent to the number of times the column appears in the first table. |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/management/mv-aggregated-column-usage/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-aggregated-column-usage/)

(An index of the documentation is available at /llms.txt)