Top
Enterprise Postgres 18 Knowledge DataManagement FeatureUser's Guide

5.5.2 Tables/Views

pgx_models table

It can only be referenced as the return value of the pgx_list_model_metadata function and the pgx_get_model_metadata function.

Column

Type

Constraint

Description

id

bigint

PRIMARY KEY

ID assigned to the model

name

text

UNIQUE

NOT NULL

Name of the imported model

function

text

NOT NULL

The process executed by the imported model. Only embedding can be specified.

metadata

jsonb

NOT NULL

Metadata of the imported model

model_file_oid

oid

NOT NULL

The oid of the model file imported as a large object

file_size

bigint

NOT NULL

Size of the imported model file

owner

oid

NOT NULL

Model owner

pgx_model_load_requests table

It can only be referenced as the return value of the pgx_list_model_load_requests function and the pgx_get_model_load_request function.

Column

Type

Constraint

Description

id

bigint

PRIMARY KEY

FOREIGN KEY (id) REFERENCES model_metadata ON DELETE CASCADE

Model ID

request

text

Request sent to the model

last_updated

timestamp with timezone

NOT NULL

DEFAULT clock_timestamp()

The time the request was sent

pgx_triton_model_status view

Column

Type

Constraint

Description

id

bigint

PRIMARY KEY

FOREIGN KEY (id) REFERENCES model_metadata ON DELETE CASCADE

Model ID

is_available

boolean

NOT NULL

Whether the model is available or not
TRUE: Available
FALSE: Not Available

reason

text

Reasons why the model is available or unavailable