PostgreSQL 13でサーバーの起動時刻を取得する
環境
PostgreSQL 13.2
Windows 10 Home 64bit
構文
pg_postmaster_start_time()
pg_postmaster_start_time関数を使ってサーバーの起動時刻を取得します。
使用例
postgres=# SELECT pg_postmaster_start_time();
pg_postmaster_start_time
-------------------------------
2022-09-15 21:02:06.472061+09
(1 行)
postgres=# SELECT pg_postmaster_start_time();
pg_postmaster_start_time
-------------------------------
2022-09-15 21:02:06.472061+09
(1 行)
postgres=# SELECT pg_postmaster_start_time(); pg_postmaster_start_time ------------------------------- 2022-09-15 21:02:06.472061+09 (1 行)