X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3545DD1EBAB for ; Thu, 18 Mar 2004 11:37:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 02487-07 for ; Thu, 18 Mar 2004 07:36:59 -0400 (AST) Received: from DELL.nmmm.nu (sofia.traveljungle.com [212.116.151.58]) by svr1.postgresql.org (Postfix) with SMTP id 5102DD1EBBA for ; Thu, 18 Mar 2004 07:36:53 -0400 (AST) Received: from localhost ([127.0.0.1]) by DELL.nmmm.nu (602Pro LAN SUITE 2003) id 3026bda2 for pgsql-admin@postgresql.org; Thu, 18 Mar 2004 13:35:27 +0200 From: "Nikolay Mihaylov" To: Subject: Statistics collecting problem Date: Thu, 18 Mar 2004 13:35:27 +0200 Message-ID: <000001c40cdd$1c5c4010$c8010101@nmmm.nu> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/251 X-Sequence-Number: 12820 Hello, Statistic collector not work! Where we do mistake. This worked before on 7.3.2: We have : travelexpressus=# select version(); version ------------------------------------------------------------------------ --------------------------------- PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1) (1 row) travelexpressus=# \x Expanded display is on. travelexpressus=# show STATS_START_COLLECTOR; -[ RECORD 1 ]---------+--- stats_start_collector | on travelexpressus=# show STATS_COMMAND_STRING; -[ RECORD 1 ]--------+--- stats_command_string | on travelexpressus=# show STATS_BLOCK_LEVEL; -[ RECORD 1 ]-----+--- stats_block_level | on travelexpressus=# show STATS_ROW_LEVEL; -[ RECORD 1 ]---+--- stats_row_level | on travelexpressus=# show STATS_RESET_ON_SERVER_START; -[ RECORD 1 ]---------------+--- stats_reset_on_server_start | on -------------- travelexpressus=# select * from pg_stat_activity; datid | datname | procpid | usesysid | usename | current_query | query_start -------+---------+---------+----------+---------+---------------+------- ------ (0 rows) travelexpressus=# select * from pg_stat_database ; datid | datname | numbackends | xact_commit | xact_rollback | blks_read | blks_hit -------+-----------------+-------------+-------------+---------------+-- ---------+---------- 17142 | travelexpressus | 0 | 0 | 0 | 0 | 0 1 | template1 | 0 | 0 | 0 | 0 | 0 17141 | template0 | 0 | 0 | 0 | 0 | 0 -------------------------------------- Conf file is like this one: (comments are removed) tcpip_socket = true max_connections = 512 STATS_START_COLLECTOR = TRUE STATS_COMMAND_STRING = TRUE STATS_BLOCK_LEVEL = TRUE STATS_ROW_LEVEL = TRUE STATS_RESET_ON_SERVER_START = TRUE -------------------------------- Process list is like: 30792 ? S 0:00 su - postgres -c /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data > /usr/loca 30793 ? S 0:00 \_ -bash -c /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data > /usr/local/pg 30827 ? S 0:00 \_ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data HOSTNAME=localhost.l 30829 ? S 0:00 \_ postgres: stats buffer process 30830 ? S 0:00 | \_ postgres: stats collector process 31026 ? S 0:00 \_ postgres: postgres travelexpressus 1.1.1.1 idle 31033 ? S 0:00 \_ postgres: postgres travelexpressus 1.1.1.1 idle 31147 ? S 0:00 \_ postgres: postgres travelexpressus 1.1.1.1 idle 31289 ? S 0:00 \_ postgres: postgres travelexpressus 1.1.1.1 idle 31295 ? S 0:00 \_ postgres: postgres travelexpressus 1.1.1.1 idle 31299 ? S 0:00 \_ postgres: postgres travelexpressus 1.1.1.1 idle 31322 ? S 0:00 \_ postgres: postgres travelexpressus 1.1.1.1 idle 31335 ? S 0:00 \_ postgres: postgres travelexpressus 1.1.1.1 idle