Databases Page

On this page Carat arrow pointing down
CockroachDB v21.1 is no longer supported as of November 18, 2022. For more details, refer to the Release Support Policy.

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.

Tables view

The Tables view shows details of the system table as well as the tables in your databases.

To view table details, click on a table name.

DB Console Database Tables View

The following are displayed for each table:

Parameter Description
Table Name The name of the table.
Size Approximate disk size of all replicas of this table on the cluster.
Ranges The number of ranges in the table.
# of Columns The number of columns in the table.
# of Indices The number of indices for the table.

Table details

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

DB Console Database Tables View

  • 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 is the approximate disk size of all replicas of this table on the cluster.
    • Ranges is the number of ranges in this table.
    • Replicas is the number of replicas of this table on the cluster.
  • Grants displays the grants associated with the table.

Grants view

The Grants view shows the privileges granted to users for each database.

For more details about grants and privileges, see GRANT.

DB Console Database Grants View

See also

Yes No
On this page

Yes No