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.