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