Greenplum Database Table Browser
Command Center users with Basic permission can view details about the tables in a Greenplum database.
Select Table Browser to view the Command Center Table Browser.
On the Table Browser view, choose a database and then use the filters to select the tables you want to browse. All filter criteria except Database are optional.
- Database
- Choose the name of the database to browse.
- Owner
- Enter a role name to select only tables owned by the role.
- Schema
- Enter the name of a schema to select only the tables that belong to that schema. The default is to select tables in all schemas except
pg_catalog
,pg_toast
,pg_bitmapindex
,pg_aoseg
,information_schema
, orgp_toolkit
. To see tables in one of these schemas, enter the schema name in this field.- Size
- Choose a ≤ (less than or equal) or ≥ (greater than or equal) operator, enter a number, and choose the size unit (KB, MB, GB, TB) to select tables by size.
Click SEARCH to display tables matching the criteria you have entered.
Table Browser statistics are updated every 300 seconds by default. Activity that occurs between updates is not displayed in the Table Browser view until Command Center updates the table statistics at the end of the sampling interval. This means that, for example, it can take up to five minutes for a new table to appear in the Table Browser. The times displayed for Last Analyzed
, Last Vacuumed
, and Last Accessed
are the time that Command Center updates the table statistics after the event has been detected, not the actual time of the event. The actual event could have occurred at any point in the previous five minutes (or in the time period specified by stats_check_interval
, if you have modified the parameter).
You can change the sampling interval by setting the stats_check_interval
parameter in the $GPCC_HOME/conf/app.conf
configuration file. Restart Command Center after updating the configuration file. See Command Center Console Parameters for more information about the app.conf
file.
Table List
The Table Browser table list displays these columns:
0
.0
. AUTOVACUUM
.) The actual event occurred at some point during the preceding sampling interval.SELECT
, INSERT
, UPDATE
, DELETE
, or TRUNCATE
operations.) The actual event occurred at some point during the preceding sampling interval.Table Details
Click the name of a table in the Relation Name column to view details for that table.
The Table Detail view displays this information:
Details Section
(key1, key2, key3, ...)
, Randomly
, or Replicated
.Show
to list up to 100 partitions. The list includes the partition’s name, table size, partition criteria, storage type, and compression parameters. Middle-level partitions are displayed with a different background color.ZLIB
, ZSTD
, QUICKLZ
, RLE_TYPE
. ZLIB
, the level is 1 (fastest compression) to 9 (highest compression ratio). For ZSTD
, the level is 1 (fastest compression) to 19 (highest compression ratio). For QUICKLZ
, the level is 1. For RLE_TYPE
the compression level is 1 (fastest compression) to 4 (highest compression ratio).Usage Section
AUTOVACUUM
.)SELECT
, INSERT
, UPDATE
, DELETE
, or TRUNCATE
operations.)Recent Queries Section
This section lists the five most recent queries in the query history to access the table. The list is limited to queries that executed in the last 30 days and that ran for ten seconds or more.
Click a Query ID to view the Query History Details for the query.
Table Contents Tab
A list of the table’s columns, types, constraints, and compression types.
Plain
is for fixed-length values such as integer
and is inline, uncompressed. Main
is for inline, compressible data. Toast
is for data that exceeds the size of a data block and is stored in chunks in a separate table associated with the user table. Extended
is for external, compressed data. Extended
is the default for most data types that support non-plain storage. none
, ZLIB
, ZSTD
, QUICKLZ
, RLE_TYPE
. ZLIB
, the level is 1 (fastest compression) to 9 (highest compression ratio). For QUICKLZ
, the level is 1. For ZSTD
, the level is 1 (fastest compression) to 19 (highest compression ratio). For RLE_TYPE
the compression level is 1 (fastest compression) to 4 (highest compression ratio).DDL Tab
Click the DDL tab to display the CREATE TABLE
statement for the table.