GS_RESPLAN_PDB_METRIC
GS_RESPLAN_PDB_METRIC displays the resource usage statistics of all enabled PDBs in the last minute. 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.
Name |
Type |
Description |
---|---|---|
plan_name |
text |
Name of the resource plan that takes 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot