Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 5F3812E00D0 for ; Tue, 15 Jan 2008 11:19:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 91130-10 for ; Tue, 15 Jan 2008 11:19:48 -0400 (AST) Received: from hs-out-2122.google.com (hs-out-0708.google.com [64.233.178.245]) by postgresql.org (Postfix) with ESMTP id BD3CA2E0094 for ; Tue, 15 Jan 2008 11:19:48 -0400 (AST) Received: by hs-out-2122.google.com with SMTP id k27so2632532hsc.3 for ; Tue, 15 Jan 2008 07:19:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=WsVyaRvUQ+xaAc5487fKCuqmpc9ERbm8HzppRwr4ucQ=; b=j4ehrfy2UZ5xIh3Z2KZMAMUJXA5KvCJLY7gJdncrBHCSRcyPpI3H/wci2hXNSHZayVm/BHSFvVRwbgl3lT61oP14TbivjVzzU/5EEK+Vp5YTvc6SYVy3VuwD+3vHSOS2scBXvuRd4pZMcck/ibOV4kwZd6Sk4zL4dhOdSBFFPwU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=s9hCW89vrOw8Sj5HwwsFeNnjMAk2WVDq0Hqf7ZuhZ9E9NjB9+Q2H8p7NYuZiLK45uPCsWseiGi9bY0nftKW1lSt9dN1rV6FBddoJrLkTcDB+sqg3FZrJK41xYQ6uj6bBxu/+KrGUG4bWRGtqAlQKceizerWVbiDpBDQ89bWpev0= Received: by 10.114.195.19 with SMTP id s19mr4858583waf.57.1200410386245; Tue, 15 Jan 2008 07:19:46 -0800 (PST) Received: by 10.114.131.4 with HTTP; Tue, 15 Jan 2008 07:19:46 -0800 (PST) Message-ID: Date: Tue, 15 Jan 2008 09:19:46 -0600 From: "Scott Marlowe" To: "Bhella Paramjeet-PFCW67" Subject: Re: Pg_statio_user_tables view does not get populated Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/154 X-Sequence-Number: 27928 On Jan 14, 2008 6:43 PM, Bhella Paramjeet-PFCW67 wrote: > I have installed postgres 8.2.4 in my development environment. I have > the stats_command_string, stats_start_collector, stats_block_level, > stats_row_level options turned on in postgresql.conf file but still the > pg_statio_user_tables view does not get populated. Is there any other > option I need to enable? Please advice. Have you restarted postgresql since making those changes?