PostgreSQL pg_conf_load_time() Function

The PostgreSQL pg_conf_load_time() function returns the last time the server configuration file was loaded (with timezone information).

pg_conf_load_time() Syntax

Here is the syntax of the PostgreSQL pg_conf_load_time() function:

pg_conf_load_time() -> timestamp with time zone

Parameters

The PostgreSQL pg_conf_load_time() function does not require any parameters.

Return value

The PostgreSQL pg_conf_load_time() function returns a time with timezone information, which is the last time the server configuration file was loaded. If the current session is active at the time, this will be when the session itself re-reads the configuration file. So the value will be different in different sessions.

pg_conf_load_time() Examples

To get the process ID of the server process to which the current session is connected, use the following statement with the pg_conf_load_time() function:

SELECT pg_conf_load_time();

       pg_conf_load_time
-------------------------------
 2022-07-13 13:40:56.669089+08

Note that your values ​​may vary.