Updated on 2025-05-29 GMT+08:00

GS_RESPLAN_PDB_INFO

GS_RESPLAN_PDB_INFO displays the real-time resource usage of all PDBs. You can compare the resource usage of each PDB. Each PDB occupies a row of data.

When resources change, the shared cache counted by used_shared_memory starts from 0. As services are running, the value of used_shared_memory increases, and the statistics become normal. During this period, the performance is not affected.

Table 1 GS_RESPLAN_PDB_INFO columns

Name

Type

Description

plan_name

text

Name of a resource plan that is taking effect.

pdb_name

name

For a CDB, the value is cdb. For a PDB, the value is the PDB name.

cpu_consumed_time

bigint

CPU usage time, which is the sum of the usage time of multiple cores. The unit is ms.

iops

numeric(12,7)

IOPS of the last second.

used_dynamic_memory

integer

Dynamic memory in use, in KB.

used_shared_memory

integer

Shared cache in use, in KB.

used_connections

integer

Number of connections in use.

logical_decoder_used_memory

integer

Dynamic memory used by the logical decoding task, in KB.