Tables Browser

The CrateDB admin UI comes with a tables browser that allows you to inspect and query regular document tables as well as BLOB tables.

Table of Contents

Screenshots

Document Tables

Here’s what a simple document table looks like:

_images/tables-simple-1.png

Here you can see a number of table-level datapoints and settings are listed.

Below this, you will find information about the table schema:

_images/tables-simple-2.png

BLOB Tables

If you have BLOB tables, you can access them by selecting the Blob Tables menu item on the left-hand sub-navigation menu:

_images/tables-blobs-1.png

Like document tables, a number of table-level datapoints and settings are listed first, and then below that, you will find information about the table schema:

_images/tables-blobs-2.png

Features

Table-Level Information

The table overview displays the following table-level information:

Name:

The name of the table.

Health:

The health of the table.

Each table shard has a corresponding health status. The table-level health status always reflects the worst shard status. (Similarly, the cluster-level status always reflects the worst table-level status.)

Shards can be one of the following:

Green:The primary shard and all replica shards are allocated to a node.
Yellow:The primary shard is allocated, but not all replica shards are allocated to a node.
Red:This specific shard is not allocated to a node.
Configured Replicas:

The number of configured replicas.

Configured Shards:

The number of configured shards

Started Shards:

The number of started shards allocated to a node and available for querying.

Missing Shards:

The total number of known shards that are missing on disk.

Underrepl. Shards:

The total number of configured replica shards that are currently missing (i.e. not created or re-created yet).

Total Records:

The total number of records (i.e. rows) the table has.

Unavailable Records:

The total number of records that should exist in missing shards.

Underrepl. Records:

The total number of records that do not have the required number of replica copies.

Size:

The total size on disk used by all primary shards.

Recovery:

The percentage of the recovery process that is complete (i.e. when re-starting a cluster).

Schema Information

The table schema section displays information about each table column:

Name:The name of the table column.
Type:The column data type.

Other Features

Table type toggle:Document tables and BLOB tables can be shown or hidden by toggling the corresponding arrow button on the left-hand sub-navigation menu.
Table filter:The displayed list of tables can be filtered by entering text to match against the table name in the Filter tables text input.
Table querying:Each table can be queried directly by selecting the QUERY TABLE button. This will take you through to the SQL Console and pre-populate a basic query against the table. The query is not executed automatically.