PostgreSQL 10 Administration Cookbook
上QQ阅读APP看书,第一时间看更新

How to do it…

Issue the following SQL from any interface:

postgres=# SELECT date_trunc('second', 
current_timestamp - pg_postmaster_start_time()) as uptime;

You should get output as follows:

     uptime 
--------------------------------------
2 days 02:48:04