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.
| 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. |
