Visualize data table

Information related to MatrixDB clusters, such as databases, data tables, and the size, type, access time of each table, is important information for understanding and managing the cluster. This information can be obtained through catalog tables such as pg_database, pg_class.

In order to see this information more conveniently and intuitively, MatrixDB also provides a visual data table function, which can directly obtain the meta information of the data table through the UI interface.

1. Data table basic information list

The MatrixDB management platform is installed on the master node by default and accessed through port 8240. Click the "Data Table" column on the left to enter the data table page:

Then select the database to view from the database list: Data Table

You can see a list of statistical information for all tables in the library, including table names, database names, schemas, partition counts, sizes, owners, estimated row counts, last access time, last modification time and last statistical time: Data Table

2. Data table details

Click on a specific table and you will enter the table's details page. The detailed information page is divided into two parts: basic information and structural information.

The basic information is basically the same as the content on the list page, and the lower part is the statistical information: Data Table

Table structure: Data Table

For the partition table, you can see the specific information of each partition: Data Table