Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 804569FB930 for ; Wed, 6 Jun 2007 18:07:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 80128-02-2 for ; Wed, 6 Jun 2007 18:07:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id D2AF29FB303 for ; Wed, 6 Jun 2007 18:07:24 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id u2so585379uge for ; Wed, 06 Jun 2007 14:07:23 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=kZm8CtblOWX7IkbWuqYa0kfgbywsa/8wz48YmX7GxNYBeRRcug7rG0TYvBinQMEvJrQtRu1qq2WTIBirkio5u5OMwjikKvrutn9BE3l5Jmx1PLuoUzlyfFAQR2s7x4XoSyRc76OHjNb2pRJn/+hGA+gx7mGsFozsLHQZPT0zYNg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=MX3LeHJ1WH63x8I7j5xLUGPFjdNmyXiAcLdmf3yVpoqIetbzYWDbfl8kKvmyQJ42lzRVXT4xT6nnj05Wezd/7EHar9sENL/1AvkIkKn8IvTNwVYUuK4gJlluj/L55Y4pMKxotNM0AelpBEqRMWupfekypLyf0dnuOLLoy6jtZNs= Received: by 10.78.170.17 with SMTP id s17mr424356hue.1181164043197; Wed, 06 Jun 2007 14:07:23 -0700 (PDT) Received: by 10.78.201.16 with HTTP; Wed, 6 Jun 2007 14:07:23 -0700 (PDT) Message-ID: <1d219a6f0706061407l12a6f4dcka1e4affcf0d04cba@mail.gmail.com> Date: Wed, 6 Jun 2007 17:07:23 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org Admin" Subject: How to tell how long server has been up? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_37704_17716341.1181164043182" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.266 tagged_above=0 required=5 tests=AWL=-1.087, BAYES_50=0.001, HTML_10_20=1.351, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200706/47 X-Sequence-Number: 25715 ------=_Part_37704_17716341.1181164043182 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_37704_17716341.1181164043182 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
------=_Part_37704_17716341.1181164043182--