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 (commit f5835b4b).

Usage

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.

Examples

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

Categories

System function

See also

pg_conf_load_time()