pg_postmaster_start_time()

A function returning the start time of the main server process

pg_postmaster_start_time() is a system function returning the start time of the main server process as data type TIMESTAMP WITH TIME ZONE.

pg_postmaster_start_time() was added in PostgreSQL 8.1.

Usage

pg_postmaster_start_time() → timestamp with time zone

pg_postmaster_start_time() returns the start time of PostgreSQL itself.

To obtain the start time of individual backends, see the backend_start column of pg_stat_activity or pg_stat_get_backend_start().

postgres=# SELECT pg_postmaster_start_time();
   pg_postmaster_start_time    
-------------------------------
 2020-09-12 13:39:35.376203+00
(1 row)