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

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.