test=# select edb_get_sys_stats();
edb_get_sys_stats
-------------------------------------------------------------------------
(35960,210,67270,24741680,77930,1019808,65432,954376,397528,708,112392)
(1 row)
cpu_user:35960
cpu_nice:210
cpu_sys 67270
cpu_idle:24741680
cpu_wait: 77930
ram_total : 1019808
ram_free : 65432
ram_used : 954376
ram_active : 397528
physical_io : 708
cached_io : 112392
#OS version 확인 함수 제공
test=# select edb_get_server_os_version();
edb_get_server_os_version
---------------------------
2.6.32-220.el6.x86_64
(1 row)
#서버 process 정보
test=# select edb_get_server_processes();
edb_get_server_processes
-----------------------------------------------------------------------------------------
-----------------------
(5863,enterprisedb,edb,localhost,"16-MAY-14 01:39:13.232268 +09:00",,,"",f)
(3205,enterprisedb,test,localhost,"15-MAY-14 18:45:26.035252 +09:00",,,"select edb_get_s
erver_processes();",f)
(2 rows)
#cpu 정보 함수
test=# select edb_get_cpu_stats();
edb_get_cpu_stats
----------------------------------
(36540,210,70030,25517020,80390)
(1 row)
usercpu:36540
nice_cpu:210
sys_spu:70030
idle_cpu:25517020
wait_cpu:80390
#process 사용률
test=# select * from edb_get_process_utilizations();
pid | cpu_utilization | mem_utilization
------+-----------------+-----------------
2222 | 0 | 6016
(1 row)