Updated on 2024-06-03 GMT+08:00

GV_INSTANCE

GV_INSTANCE displays information about the current database instance. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in the PG_CATALOG and SYS schemas.

Table 1 GV_INSTANCE columns

Name

Type

Description

inst_id

oid

OID of the current database.

instance_number

oid

OID of the current database.

instance_name

character varying(16)

Name of the current database.

host_name

character varying(64)

Not supported. Set it to NULL.

version

character varying(17)

Not supported. Set it to NULL.

version_legacy

character varying(17)

Not supported. Set it to NULL.

version_full

character varying(17)

Not supported. Set it to NULL.

startup_time

date

Not supported. Set it to NULL.

status

character varying(12)

Not supported. Set it to NULL.

parallel

character varying(3)

Not supported. Set it to NULL.

thread#

numeric

Not supported. Set it to NULL.

archiver

character varying(7)

Not supported. Set it to NULL.

log_switch_wait

character varying(15)

Not supported. Set it to NULL.

logins

character varying(10)

Not supported. Set it to NULL.

shutdown_pending

character varying(3)

Not supported. Set it to NULL.

database_status

character varying(17)

Not supported. Set it to NULL.

instance_role

character varying(18)

Not supported. Set it to NULL.

active_state

character varying(9)

Not supported. Set it to NULL.

blocked

character varying(3)

Not supported. Set it to NULL.

con_id

numeric

Not supported. Set it to NULL.

instance_mode

character varying(11)

Not supported. Set it to NULL.

edition

character varying(7)

Not supported. Set it to NULL.

family

character varying(80)

Not supported. Set it to NULL.

database_type

character varying(15)

Not supported. Set it to NULL.