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