Help Center/ GaussDB/ Developer Guide(Distributed_3.x)/ Schemas/ DBE_PERF Schema/ Global Plan Cache/ LOCAL_PLANCACHE_STATUS
Updated on 2024-05-07 GMT+08:00
View PDF
Share

LOCAL_PLANCACHE_STATUS

LOCAL_PLANCACHE_STATUS displays the status of the GPC plan cache on the current node.

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

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