Re: How to tell how long server has been up?

Поиск
Список
Период
Сортировка
От Benjamin Krajmalnik
Тема Re: How to tell how long server has been up?
Дата
Msg-id F4E6A2751A2823418A21D4A160B6898807A53E@fletch.stackdump.local
обсуждение исходный текст
Ответ на How to tell how long server has been up?  ("Chris Hoover" <revoohc@gmail.com>)
Список pgsql-admin
select pg_postmaster_start_time()
 


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Chris Hoover
Sent: Wednesday, June 06, 2007 3:07 PM
To: pgsql-admin@postgresql.org Admin
Subject: [ADMIN] How to tell how long server has been up?

Maybe I'm blind (wouldn't be the first time), but I can't see a way to find out how long postgres has been running.  Is there a way to tell this from a query?  I am working with some of the stat views and would like to correlate them to how long the server has been running.

Thanks,

Chris

В списке pgsql-admin по дате отправления:

Предыдущее
От: Dan Harris
Дата:
Сообщение: reclaiming disk space after major updates
Следующее
От: Raul Retamozo
Дата:
Сообщение: copying data into another database ? (replication)