pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedStatistics collecting problem
3+ messages / 2 participants
[nested] [flat]
* Statistics collecting problem
@ 2004-03-18 11:35 Nikolay Mihaylov <pg@nmmm.nu>
0 siblings, 0 replies; 3+ messages in thread
From: Nikolay Mihaylov @ 2004-03-18 11:35 UTC (permalink / raw)
To: 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: postgres
travelexpressus 1.1.1.1 idle
^ permalink raw reply [nested|flat] 3+ messages in thread
* Statistics collecting problem
@ 2004-03-19 08:23 Nikolay Mihaylov <pg@nmmm.nu>
0 siblings, 1 reply; 3+ messages in thread
From: Nikolay Mihaylov @ 2004-03-19 08:23 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Statistics collecting problem
@ 2004-03-19 14:49 Tom Lane <tgl@sss.pgh.pa.us>
parent: Nikolay Mihaylov <pg@nmmm.nu>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2004-03-19 14:49 UTC (permalink / raw)
To: Nikolay Mihaylov <pg@nmmm.nu>; +Cc: pgsql-admin
"Nikolay Mihaylov" <pg@nmmm.nu> writes:
> Statistic collector not work!
> Where we do mistake. This worked before on 7.3.2:
Maybe some problem binding the UDP socket for statistics gathering?
Look at the first few lines of the postmaster's log to see if there's
any error messages concerning stats collector startup.
It seems possible also that the stats messages are being dropped due
to kernel packet filtering. (In fact, that's probably the most likely
theory, because I think stats_start_collector would be set false if
the postmaster had detected any problems with binding the socket.)
Take a look at your ipchains or iptables configuration.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-03-19 14:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-18 11:35 Statistics collecting problem Nikolay Mihaylov <pg@nmmm.nu>
2004-03-19 08:23 Statistics collecting problem Nikolay Mihaylov <pg@nmmm.nu>
2004-03-19 14:49 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox