DBA Hub

📋Steps in this guide1/1

Find startup time and uptime postgres

-- Uptime of server

postgresql configurationintermediate
by PostgreSQL
14 views
1

Find startup time and uptime postgres

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- Uptime of server
postgres#
SELECT now() - pg_postmaster_start_time() "uptime";
uptime
------------------------
9 days 04:54:56.774981
(1 row)
-- Server startup time:
postgres#
SELECT pg_postmaster_start_time();
pg_postmaster_start_time
----------------------------------
26-SEP-20 11:13:08.283105 +03:00
(1 row)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!