Hello,
As far as I know, the top command displays three values for load averages: 1-second, 5-second, and 15-second intervals. However, in the output of the query below, it appears to show averages for 1, 5, and 10 seconds. Strangely, the value labeled as the '10-second average' in the output seems to match the 15-second average from top. Additionally, the load_avg_fifteen_minutes field in the query returns null. I suspect there's a bug here.
select * from pg_sys_load_avg_info();
load_avg_one_minute -->1.02
load_avg_five_minutes -->0.23
load_avg_ten_minutes -->0.07
load_avg_fifteen_minutes --> null
lsb_release -a
root@ataturk:/usr/share/postgresql/16/extension# lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 22.04.2 LTS
Release: 22.04
Codename: jammy
root@ataturk:/usr/share/postgresql/16/extension#
Hello,
As far as I know, the top command displays three values for load averages: 1-second, 5-second, and 15-second intervals. However, in the output of the query below, it appears to show averages for 1, 5, and 10 seconds. Strangely, the value labeled as the '10-second average' in the output seems to match the 15-second average from top. Additionally, the load_avg_fifteen_minutes field in the query returns null. I suspect there's a bug here.
select * from pg_sys_load_avg_info();
load_avg_one_minute -->1.02
load_avg_five_minutes -->0.23
load_avg_ten_minutes -->0.07
load_avg_fifteen_minutes --> null
lsb_release -a
root@ataturk:/usr/share/postgresql/16/extension# lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 22.04.2 LTS
Release: 22.04
Codename: jammy
root@ataturk:/usr/share/postgresql/16/extension#