pg_conf_load_time()

A system function which shows the last time the configuration was successfully reloaded

pg_conf_load_time() is a system function which shows the last time the configuration was successfully reloaded.

pg_conf_load_time() was added in PostgreSQL 8.4 (commit 600da67f).

Source code

pg_conf_load_time() reports the value of the global variable PgReloadTime, which is defined in src/include/utils/timestamp.h and contained in src/backend/utils/adt/timestamp.c.

It is set in src/backend/utils/misc/guc-file.l when the configuration is successfully applied following startup, restart or receipt of SIGHUP.

Examples

postgres=# SELECT pg_conf_load_time();
       pg_conf_load_time       
-------------------------------
 2019-07-15 22:07:31.472888+01
(1 row)

postgres=# SELECT pg_reload_conf();
 pg_reload_conf 
----------------
 t
(1 row)

postgres=# SELECT pg_conf_load_time();
       pg_conf_load_time       
-------------------------------
 2019-07-15 22:08:16.900608+01
(1 row)

Categories

Configuration, System function

See also

pg_reload_conf(), pg_postmaster_start_time()