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.
Usage
pg_conf_load_time() → timestamp with time zone
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.
Change history
- PostgreSQL 8.4
- added (commit 600da67f)
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)
References
- PostgreSQL documentation: System Information Functions