命令收集

查看数据库运行时长

test=# select date_trunc('second',current_timestamp - sys_postmaster_start_time()) as uptime;
     uptime      
-----------------
 00:23:12.000000
(1 行记录)
test=#

test=# select sysdate;
        date         
---------------------
 2022-04-01 22:54:42
(1 行记录)
test=# 
test=# select get_license_validdays();          
 get_license_validdays 
-----------------------
                    78
(1 行记录)
test=# select sysdate - get_license_validdays();
      ?column?       
---------------------
 2022-01-13 22:54:50
(1 行记录)
test=#