Statistics collecting problem

From: "Nikolay Mihaylov" <pg(at)nmmm(dot)nu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Statistics collecting problem
Date: 2004-03-19 08:23:44
Message-ID: 000501c40d8b$7ecff670$c8010101@nmmm.nu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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: postgre travelexpressus
1.1.1.1 idle

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message sachdev 2004-03-19 13:44:50 date style
Previous Message alvaro 2004-03-18 21:17:13 SOS ---- Could you help me with postgresql.....????