Vertica Analytics Platform Version 9.2.x Documentation

DATABASES

Provides information about the databases in this Vertica installation.

Column Name Data Type Description
DATABASE_ID

INTEGER

The database's internal ID number

DATABASE_NAME

VARCHAR

The database's name

OWNER_ID

INTEGER

The database owner's ID

OWNER_NAME

INTEGER

The database owner's name

START_TIME

TIMESTAMPTZ

The date and time the database last started

COMPLIANCE_MESSAGE

VARCHAR

Message describing the current state of the database's license compliance.

EXPORT_SUBNET

VARCHAR

Can be either of the following: 

  • The subnet (on the public network) used by the database for import/export.
  • The public address of the subnet that the Vertica native load balancing uses for load balancing.
LOAD_BALANCE_POLICY
VARCHAR The current native connection load balance policy, which controls whether client connection requests are redirected to other hosts in the database. See About Native Connection Load Balancing in the Administrator's Guide.
BACKEND_ADRESS_FAMILY VARCHAR The TCP/IP addressing standard used for internode communications. Either "ipv4" or "ipv6".

Example

This example queries the databases table from a master database.

=> SELECT * FROM DATABASES;
-[ RECORD 1 ]----------+-------------------------------------------------------------
database_id | 45035996273704976
database_name | VMart
owner_id | 45035996273704962
owner_name | dbadmin
start_time | 2017-10-22 05:16:22.066961-04
compliance_message | The database is in compliance with respect to raw data size.
export_subnet | 0
load_balance_policy | none
backend_address_family | ipv4