AWS AmazonRDS: Document worker_threads_cpu_usage_percent column in aurora_stat_resource_usage
Summary
Adds documentation for a new worker_threads_cpu_usage_percent output column of the aurora_stat_resource_usage function, including version availability and updated example output.
Security assessment
The change only documents an additional CPU-usage monitoring column and its version availability; it introduces no authentication, encryption, or access-control content and has no security implications.
Evidence
+ * worker_threads_cpu_usage_percent - CPU usage percentage of the worker threads (all threads except the main thread) of the process. For backend processes that don't use worker threads, this value is 0.
Diff
diff --git a/AmazonRDS/latest/AuroraUserGuide/aurora_stat_resource_usage.md b/AmazonRDS/latest/AuroraUserGuide/aurora_stat_resource_usage.md index 7dee234..c006c1f 100644 --- a//AmazonRDS/latest/AuroraUserGuide/aurora_stat_resource_usage.md +++ b//AmazonRDS/latest/AuroraUserGuide/aurora_stat_resource_usage.md @@ -32 +32,3 @@ SETOF record with columns: - * cpu_usage_percent - CPU usage percentage of the process + * cpu_usage_percent - CPU usage percentage of the process (all threads) + + * worker_threads_cpu_usage_percent - CPU usage percentage of the worker threads (all threads except the main thread) of the process. For backend processes that don't use worker threads, this value is 0. @@ -55,0 +58,17 @@ This function is available starting with the following Aurora PostgreSQL version +The `worker_threads_cpu_usage_percent` column is available starting with the following Aurora PostgreSQL versions: + + * Aurora PostgreSQL 18.6 and higher 18 versions + + * Aurora PostgreSQL 17.11 and higher 17 versions + + * Aurora PostgreSQL 16.15 and higher 16 versions + + * Aurora PostgreSQL 15.19 and higher 15 versions + + * Aurora PostgreSQL 14.24 and higher 14 versions + + + + +In earlier versions, the function returns only the first four columns. + @@ -62,12 +81,10 @@ The following example shows the output of the `aurora_stat_resource_usage` funct - pid | allocated_memory | used_memory | cpu_usage_percent - ------+------------------+-------------+----------------------- - 666 | 1074032 | 333544 | 0.00729274882897963 - 667 | 787312 | 287360 | 0.0029263928146372746 - 668 | 3076776 | 1563488 | 0.006013116835953961 - 684 | 803744 | 307480 | 0.002226855426881142 - 2401 | 1232992 | 943144 | 0 - 647 | 8000 | 944 | 0.48853387812429855 - 659 | 319344 | 243000 | 0.0004135602076683591 - 663 | 262000 | 185736 | 0.008181301476644002 - 664 | 9024 | 1216 | 0.10992313082653653 - (9 rows) + pid | allocated_memory | used_memory | cpu_usage_percent | worker_threads_cpu_usage_percent + ------+------------------+-------------+-----------------------+---------------------------------- + 666 | 1074032 | 333544 | 0.00729274882897963 | 0 + 668 | 3076776 | 1563488 | 0.006013116835953961 | 0 + 2401 | 1232992 | 943144 | 0 | 0 + 664 | 1161616 | 797584 | 81.19999999999999 | 67.8 + 671 | 1087888 | 789352 | 62.4 | 52.4 + (5 rows) + +_The last two rows show backend processes whose worker threads consume CPU. For backend processes that don't use worker threads, the value is 0._