You may wonder, "How long is it since the server started?"
As in the previous recipe, we will find this out by asking the database server.
Issue the following SQL from any interface:
postgres=# SELECT date_trunc('second', current_timestamp - pg_postmaster_start_time()) as uptime;
You should get an output like the following:
uptime ───────────────── 2 days 02:48:04
Postgres stores the server start time, so we can access it directly, as follows:
postgres=# SELECT pg_postmaster_start_time(); pg_postmaster_start_time ─────────────────────────────── 2013-03-27 14:31:51.382106+00
Then, we can do a SQL query to get the uptime, like this:
postgres=# SELECT current_timestamp - pg_postmaster_start_time(); ?column? ─────────────────────── 2 days 02:50:02.23939
Finally, we apply some formatting:
postgres=# SELECT date_trunc('second', current_timestamp - pg_postmaster_start_time()) as uptime; uptime ───────────────── 2 days 02:51...