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

GS_SPM_SQL

GS_SPM_SQL is a system catalog in the SPM feature. Currently, this feature is not supported in the distributed system. It is a system catalog used to store SPM information. Users with sysadmin permissions can read the system catalog, but only initial users can write the system catalog.

Table 1 GS_SPM_SQL columns

Name

Type

Description

sql_namespace

oid

Schema OID.

sql_hash

bigint

Unique ID of the SQL statement in the SPM.

sql_text

text

SQL text string.

param_num

integer

Number of parameters required for SQL execution.

user

oid

OID of the login user.

creation_time

timestamp with time zone

Time when a record is created.