Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7DA0C6330C3 for ; Thu, 19 Feb 2009 22:16:57 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 37365-10 for ; Thu, 19 Feb 2009 22:16:53 -0400 (AST) X-Greylist: delayed 00:08:36.724388 by SQLgrey-1.7.6 Received: from mx1.cujae.edu.cu (mx1.cujae.edu.cu [200.55.139.24]) by mail.postgresql.org (Postfix) with ESMTP id 5203D632DCF for ; Thu, 19 Feb 2009 22:16:52 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by mx1.cujae.edu.cu (Postfix) with ESMTP id 7A6451A606 for ; Thu, 19 Feb 2009 20:56:36 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at cujae.edu.cu Received: from mx1.cujae.edu.cu ([127.0.0.1]) by localhost (mx1.cujae.edu.cu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id aUKcM1wdTEAe for ; Thu, 19 Feb 2009 20:56:30 -0500 (EST) Received: from newton.cujae.edu.cu (newton.cujae.edu.cu [10.8.1.69]) by mx1.cujae.edu.cu (Postfix) with ESMTP id 32C231A45A for ; Thu, 19 Feb 2009 20:56:30 -0500 (EST) Received: by newton.cujae.edu.cu (Postfix, from userid 1002) id B3E2A1D5468; Thu, 19 Feb 2009 22:16:07 -0500 (CST) Received: from tesla.cujae.edu.cu (tesla.cujae.edu.cu [10.8.1.34]) by newton.cujae.edu.cu (Postfix) with ESMTP id B9F1E1D5465 for ; Thu, 19 Feb 2009 22:16:06 -0500 (CST) DKIM-Signature: a=rsa-sha1; c=simple; d=tesla.cujae.edu.cu; s=MDaemon; t=1235095685; x=1235700485; q=dns; h=DomainKey-Signature: Received:From:To:Subject:Date:Message-ID:MIME-Version: Content-Type:Content-Transfer-Encoding:Thread-Index: Content-Language; b=tSM2FsYKJHBHMOEQFNH8zZLYisHtzZTAIRT0DgfLK6Ae FLvXbHoDdNJTpFrTexLEmaCVp4F/0Y7mTxqS6yrtRQizgUuGJbrjKY7OTMf/uxXE oy+xznFwCaEVdCPLzCXPMQdZEZofwxqr/v/aTvj+IYnU544xwsGDJ8h8hg9fWjc= DomainKey-Signature: a=rsa-sha1; s=MDaemon; d=tesla.cujae.edu.cu; c=simple; q=dns; h=from:message-id; b=UCdNSOQY5KtaxoXRwiX3pYP3X9or9qFOXcWkW4M18dZNuuqrflJviqxvMdJB QyENkpFNmCI8DbyHpJg6aI0z3YzYQ9QkL6Xm2bfqYP1tDWfBJ8v/XYuB7 yVy4R04xPu1u+0fnrwPAgI1+NlzqS4UV/nNnxUcO1U+aFuT0RFzm3Q=; Received: from aicitel by tesla.cujae.edu.cu (MDaemon PRO v9.0.4) with ESMTP id 13-md50000050839.msg for ; Thu, 19 Feb 2009 21:08:04 -0500 From: "Leticia Larrosa" To: Subject: configuration related to statistics Date: Thu, 19 Feb 2009 21:07:46 -0500 Message-ID: <00b801c99300$0654e5c0$12feb140$@cujae.edu.cu> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcmTAAR/py6AvPEZRB+bocNU85mc/A== Content-Language: en-us X-Authenticated-Sender: leticia@tesla.cujae.edu.cu X-MDRemoteIP: 10.8.2.226 X-Return-Path: leticia@tesla.cujae.edu.cu X-MDaemon-Deliver-To: pgsql-admin@postgresql.org X-Spam-Processed: tesla.cujae.edu.cu, Thu, 19 Feb 2009 21:08:05 -0500 X-MDAV-Processed: tesla.cujae.edu.cu, Thu, 19 Feb 2009 21:08:05 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.796 tagged_above=0 required=5 tests=WEIRD_QUOTING=2.796 X-Spam-Level: ** X-Archive-Number: 200902/149 X-Sequence-Number: 31370 Hello I want to see statistics about the use of my postgresql 8.3 in Ubuntu 8.04.1 (Hardy) Server. In my postgresql.conf I have the follow configuration related to statistics: """ #--------------------------------------------------------------------------- --- # RUNTIME STATISTICS #--------------------------------------------------------------------------- --- # - Query/Index Statistics Collector - #track_activities = on #track_counts = on #update_process_title = on # - Statistics Monitoring - log_parser_stats = on #log_planner_stats = off #log_executor_stats = off #log_statement_stats = off """" But when I execute this command "select * from pg_stat_all_tables;" I get all the rows with the values (except the 3 first values) set to 0: """ relid | schemaname | relname | seq_scan | seq_tup_read | idx_scan | idx_tup_fetch | n_tup_ins | n_tup_upd | n_tup_del | n_tup_hot_upd | n_live_tup | n_dead_tup | last_vacuum | last_autovacuum | last_analyze | last_autoanalyze --------+--------------------+-------------------------------------+-------- --+--------------+----------+---------------+-----------+-----------+------- ----+---------------+------------+------------+-------------+--------------- --+--------------+------------------ 11444 | information_schema | sql_packages | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | | | | 11431 | pg_toast | pg_toast_11429 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 153470 | pg_toast | pg_toast_153466 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 153207 | pg_toast | pg_toast_153204 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | """ What I need to do to obtain the values updated in pg_stat_all_tables? Or the statistic are stored in other place? Any help will be appreciated. Thanks in advanced. Leticia Larrosa VI Conferencia Internacional de Energía Renovable, Ahorro de Energía y Educación Energética 9 - 12 de Junio 2009, Palacio de las Convenciones ...Por una cultura energética sustentable www.ciercuba.com