Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 989DF9FBF13 for ; Tue, 15 May 2007 19:42:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 17360-05 for ; Tue, 15 May 2007 19:41:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.234]) by postgresql.org (Postfix) with ESMTP id 13E519FBEF2 for ; Tue, 15 May 2007 19:42:02 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id i28so1995449wxd for ; Tue, 15 May 2007 15:42:01 -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=pqxXZjTqqz73i/8a09zoXh3RrAIl7tZkqOaOqvnQdpWNmf8LJFzDckQ5/YV/Ed5wun5nxgR3sfNrfLGHu9hU+jLcwi8pw3GZcdUuK9oIl20QnBxtrH2rjQ9dhYoMmEEyApoUusx4ppIK7H7ldwjUud0mJ3bqpb032wzJXQ8oQu0= 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=Jz+oXZu8Ao8CAFSivikQPGrNC+lDISkZaTbxvW3gqD2PccXzCh74svxiQZDG/UOzcum+ICbauItSWuqM3OCd4IRAfJgD1aYYOD+Q+mcXcWXN8zoWNq4efea8q39ufwxH8kQBVv5RuvthYYvlbjVv8bE3tc0k6XRTIJtBFDtuuUY= Received: by 10.70.31.6 with SMTP id e6mr12383442wxe.1179268921821; Tue, 15 May 2007 15:42:01 -0700 (PDT) Received: by 10.100.6.20 with HTTP; Tue, 15 May 2007 15:42:01 -0700 (PDT) Message-ID: Date: Tue, 15 May 2007 15:42:01 -0700 From: "Y Sidhu" To: pgsql-performance@postgresql.org Subject: How to Run a pg_stats Query MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_16022_2117513.1179268921771" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/276 X-Sequence-Number: 24666 ------=_Part_16022_2117513.1179268921771 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I turned on all the stats in the conf file (below) and restarted the server. Question is, what's the name of the database and how do I run a simple select query? stats_start_collector = true stats_command_string = true stats_block_level = true stats_row_level = true stats_reset_on_server_start = true -- Yudhvir Singh Sidhu 408 375 3134 cell ------=_Part_16022_2117513.1179268921771 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I turned on all the stats in the conf file (below) and restarted the server. Question is, what's the name of the database and how do I run a simple select query?

stats_start_collector = true
stats_command_string = true
stats_block_level = true
stats_row_level = true
stats_reset_on_server_start = true

--
Yudhvir Singh Sidhu
408 375 3134 cell ------=_Part_16022_2117513.1179268921771--