pg_postmaster_start_time()

A system 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.

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