db_get_table_info
You can run the db_get_table_info script to obtain metadata for the table(s) provided.
The metadata includes the following data in 3 parts:
- Table Information: row count, table size, compression ratio
- Table Skew Information: skew ratio
- Table Column Information: column name, datatype, the average length of the sorted data, etc.
Usage
db_get_table_info [-h] [-host HOST] [-db DB] [-dsn DSN] [-schema SCHEMA] [-table TABLE] [-user USER] [-pw PW]Generic command option
- -h | --help
- Displays help for the command.
Optional arguments
- -host HOST
- Specifies the hostname of which you want to obtain details . The default is
localhost. - -db DB
- Specifies the database for which you want to get statistics. The default is
BLUDB. - -dsn DSN
- An alternative to the -host and -db options.
- -schema SCHEMA
- Specifies the schema under which the table exists. If not specified, it considers all user-defined schemas and tables that are under the schema. The -table parameter is ignored.
- -table TABLE
- Specifies the table for which statistics are being looked up.
- -user USER
- Specifies the database user.
- -pw PW
- Specifies database password.