Contents
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()
.
Change history
- PostgreSQL 8.1
- added (commit f5835b4b)
Examples
postgres=# SELECT pg_postmaster_start_time(); pg_postmaster_start_time ------------------------------- 2020-09-12 13:39:35.376203+00 (1 row)
References
- PostgreSQL documentation: Session Information Functions