Help Center/ GaussDB/ Distributed_8.x/ Schemas/ DBE_PERF Schema/ Global Plan Cache/ LOCAL_PLANCACHE_STATUS
Updated on 2024-06-03 GMT+08:00
View PDF

LOCAL_PLANCACHE_STATUS

LOCAL_PLANCACHE_STATUS displays the status of the GPC plan cache on the current node, as described in Table 1.

Table 1 LOCAL_PLANCACHE_STATUS columns

Name

Type

Description

nodename

text

Name of the node that the plan cache belongs to.

query

text

Text of query statements.

refcount

integer

Number of times that the plan cache is referenced.

valid

bool

Specifies whether the plan cache is valid.

databaseid

oid

ID of the database that the plan cache belongs to.

schema_name

text

Schema that the plan cache belongs to.

params_num

integer

Number of parameters.

func_id

oid

OID of the stored procedure where the plan cache is located. If the plancache does not belong to the stored procedure, the value is 0.

stmt_id

integer

Sequence number of the statement plan in the stored procedure.
Parent topic: Global Plan Cache