查询PostgreSQL数据库的运行时间

最新推荐文章于 2025-07-18 20:39:23 发布

原创最新推荐文章于 2025-07-18 20:39:23 发布 · 4.4k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#PostgreSQL #running #duration

PostgreSQL 专栏收录该内容

211 篇文章

订阅专栏

本文展示了如何使用psql客户端查询PostgreSQL数据库的版本信息、启动时间及当前运行时长等关键指标。通过几个简单的SQL查询命令，可以快速了解数据库实例的状态。

[pg104@dbserver ~]$ psql -d postgres
psql (10.4)
Type "help" for help.

postgres=# select version();
                                                 version                                                 
---------------------------------------------------------------------------------------------------------
 PostgreSQL 10.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
(1 row)

postgres=# select pg_postmaster_start_time();
   pg_postmaster_start_time    
-------------------------------
 2018-05-23 15:34:15.448087-04
(1 row)

postgres=# select current_timestamp;
       current_timestamp       
-------------------------------
 2018-05-24 01:57:24.582325-04
(1 row)

postgres=# select date_trunc('second', current_timestamp-pg_postmaster_start_time());
 date_trunc 
------------
 10:24:04
(1 row)

postgres=# select date_trunc('minute', current_timestamp-pg_postmaster_start_time());
 date_trunc 
------------
 10:24:00
(1 row)

postgres=# select date_trunc('hour', current_timestamp-pg_postmaster_start_time());
 date_trunc 
------------
 10:00:00
(1 row)

postgres=# select date_trunc('day', current_timestamp-pg_postmaster_start_time());
 date_trunc 
------------
 00:00:00
(1 row)

postgres=#

https://www.postgresql.org/docs/current/static/functions-info.html