Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c7joN-00037a-3B for pgsql-performance@arkaria.postgresql.org; Fri, 18 Nov 2016 14:06:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c7joM-00057L-ME for pgsql-performance@arkaria.postgresql.org; Fri, 18 Nov 2016 14:06:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1c7jmg-0002KE-I2 for pgsql-performance@postgresql.org; Fri, 18 Nov 2016 14:04:54 +0000 Received: from lb2-smtp-cloud2.xs4all.net ([194.109.24.25]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1c7jma-0003rB-EQ for pgsql-performance@postgresql.org; Fri, 18 Nov 2016 14:04:54 +0000 Received: from webmail.xs4all.nl ([194.109.20.209]) by smtp-cloud2.xs4all.net with ESMTP id 9S4m1u00E4WfiVN01S4mb6; Fri, 18 Nov 2016 15:04:47 +0100 Received: from mail.genj.nl ([77.242.116.162]) by webmail.xs4all.nl with HTTP (HTTP/1.1 POST); Fri, 18 Nov 2016 15:04:46 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Date: Fri, 18 Nov 2016 15:04:46 +0100 From: vinny To: Metatrader EA Cc: pgsql-performance@postgresql.org, pgsql-performance-owner@postgresql.org Subject: Re: DO I miss something ? In-Reply-To: References: Message-ID: <96622dd7e044b70c019de4987a68129d@xs4all.nl> X-Sender: vinny@xs4all.nl (MjS/FAsVljhQctWrmiUvSw==) User-Agent: XS4ALL Webmail X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 2016-11-18 14:52, Metatrader EA wrote: > Hi, > > Do I miss something? > Shouldn't I have some rows from this query ? > > Why is it empty? > > SELECT relname, idx_tup_fetch + seq_tup_read as TotalReads from > pg_stat_all_tables > WHERE idx_tup_fetch + seq_tup_read != 0 > order by TotalReads desc > LIMIT 10; > relname | totalreads > ---------+------------ > (0 rows) > > //Bill Is statistics collection enabled in the config? See: https://www.postgresql.org/docs/9.5/static/monitoring-stats.html -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance