Databases Page

Note:

On a secure cluster, this area of the DB Console can only be accessed by an admin user. See DB Console access.

The Databases page of the DB Console provides details of the following:

  • The databases configured.
  • The tables in each database.
  • The grants assigned to each user.

To view this page, access the DB Console and click Databases in the left-hand navigation.

Databases list

The Databases list shows the databases on the cluster.

The following information is displayed for each database:

Parameter Description
Database Name The name of the database.
Size Approximate disk size across all table replicas in the database.
Tables The number of tables in this database.
Range count The number of ranges across all tables in this database.
Regions/nodes The regions and nodes on which the tables in this database are located. This is not displayed on a single-node cluster.

Click any database name to open the Tables page.

Tables view

The Tables view shows details of the system table as well as the tables in your databases. On the Tables page, make sure that View: Tables is selected in the pulldown menu.

The following information is displayed for each table:

Parameter Description
Table Name The name of the table.
Replication Size The approximate disk size of all replicas of this table on the cluster.
Ranges The number of ranges in the table.
Columns The number of columns in the table.
Indexes The number of indexes in the table.
Regions The regions and nodes on which the table data is stored. This is not displayed on a single-node cluster.

Click any table name to view table details.

Table details

Click any table name in Tables view to display details for that table.

  • Overview displays the SQL statements used to create and define the table, as well as partitioning info, zone configurations, constraints, and lease preferences. In addition, the following metrics are displayed:
    • Size displays the approximate disk size of all replicas of this table on the cluster.
    • Ranges displays the number of ranges in this table.
    • Replicas displays the number of replicas of this table on the cluster.
    • Regions/nodes displays the regions and nodes on which the table data is stored. This is not displayed on a single-node cluster.
    • Database displays the database on which the table is found.
    • Indexes displays the names of the indexes in the table.
  • Grants displays the grants associated with the table.

Grants view

The Grants view shows the privileges granted to users for each database. On the Tables page, make sure that View: Grants is selected in the pulldown menu.

The following information is displayed for each table:

Parameter Description
Table Name The name of the table.
Users The number of users of the table.
Roles The list of roles on the table.
Grants The list of grants of the table.

For more details about grants and privileges, see GRANT.

See also

YesYes NoNo