Updated on 2024-05-07 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 both PG_CATALOG and SYS schema.

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. Its value is NULL.

version

character varying(17)

Not supported. Its value is NULL.

version_legacy

character varying(17)

Not supported. Its value is NULL.

version_full

character varying(17)

Not supported. Its value is NULL.

startup_time

timestamp(0) without time zone

Not supported. Its value is NULL.

status

character varying(12)

Not supported. Its value is NULL.

parallel

character varying(3)

Not supported. Its value is NULL.

thread#

numeric

Not supported. Its value is NULL.

archiver

character varying(7)

Not supported. Its value is NULL.

log_switch_wait

character varying(15)

Not supported. Its value is NULL.

logins

character varying(10)

Not supported. Its value is NULL.

shutdown_pending

character varying(3)

Not supported. Its value is NULL.

database_status

character varying(17)

Not supported. Its value is NULL.

instance_role

character varying(18)

Not supported. Its value is NULL.

active_state

character varying(9)

Not supported. Its value is NULL.

blocked

character varying(3)

Not supported. Its value is NULL.

con_id

numeric

Not supported. Its value is NULL.

instance_mode

character varying(11)

Not supported. Its value is NULL.

edition

character varying(7)

Not supported. Its value is NULL.

family

character varying(80)

Not supported. Its value is NULL.

database_type

character varying(15)

Not supported. Its value is NULL.