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 dropdown to select a schema. All filter criteria except Database are optional.
- Database
- Select the name of the database to browse.
- Schema
- Enter the name of a schema to select only the tables that belong to that schema. The default is “All (except sys schemas)” where system schemas include:
pg_catalog
,pg_toast
,pg_bitmapindex
,pg_aoseg
,information_schema
, orgp_toolkit
.Click Advanced to display more search criteria for the database and the schema you have selected.
- Relation Name
- Enter the table name for your search. You may enter a
%
wildcard to match any characters.- Table Space
- Select the table space from the dropdown options.
- Table Size
- To select tables by size, select a ≤ (less than or equal) or ≥ (greater than or equal) operator, and enter a size number with a size unit (KB, MB, GB, TB).
- Owner
- Enter a role name to select only tables owned by the role.
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
, andLast 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 bystats_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 theapp.conf
file.Note: using the
gppersistentrebuild
utility might refresh theLast Accessed
table data even if the table has not been accessed by a query.Click the EXPORT ALL button, at the top right of the table results, to save the search results in a local file. The file is created in the background and when the export is ready, a notification is entered at the Notifications center, with a link to a CSV file, similar to:
If the export operation is greater than 1 million rows, an alert is raised.
You can change the sampling interval by setting the stats_check_interval
property in the $MASTER_DATA_DIRECTORY/gpmetrics/gpcc.conf
configuration file. Restart Command Center after updating the configuration file. See the gpmetrics Configuration File Reference for more information about the gpcc.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:
(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
. For
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.