GS_RESPLAN_PDB_METRIC_HISTORY

GS_RESPLAN_PDB_METRIC_HISTORY displays the resource usage statistics per minute of all enabled PDBs. A maximum of 60 rows of data in the last hour can be returned. 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_METRIC_HISTORY columns
Name	Type	Description
plan_name	text	Name of the resource plan that is taking effect when the collection ends.
pdb_name	name	For a CDB, the value is cdb. For a PDB, the value is the PDB name.
begin_time	timestamp(3) without time zone	Collection start time.
end_time	timestamp(3) without time zone	Collection end time.
interval_msec	integer	Interval for collecting statistics, in milliseconds.
cpu_consumed_time	bigint	CPU usage time in the current period, in milliseconds. The usage time of multiple cores is accumulated.
avg_cpu_utilization	numeric(12,7)	CPU usage. The formula is as follows: cpu_consumed_time/interval_msec/Number of CPU cores of CDB.
iops	numeric(12,7)	IOPS in the current period.
used_dynamic_memory	integer	Dynamic memory used when the collection ends, in KB.
used_shared_memory	integer	Shared cache used when the collection ends, in KB.
used_connections	integer	Number of connections in use.
logical_decoder_used_memory	integer	Dynamic memory used by a logical decoding task when the collection ends, in KB.