pg_stat tables empty

Поиск
Список
Период
Сортировка
От Gavin Thompson
Тема pg_stat tables empty
Дата
Msg-id 1086854327.5633.164.camel@xenothanes
обсуждение исходный текст
Ответы Re: pg_stat tables empty  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi,

My statistics collector is not collecting any statistics and functions
such as pg_stat_get_tuples_fetched() return 0.

I have set run-time parameters thusly:

stats_command_string           | on
stats_reset_on_server_start    | on
stats_row_level                | on
stats_start_collector          | on

stats processes are running:

postgres  ... postgres: stats buffer process
postgres  ... postgres: stats collector process

I can't find any suspicious looking messages in syslog or postgres logs.

Any clues where to look next?


--
-------------------------------------------------------------------------
Gavin @ Catalyst .Net .NZ  Ltd,  PO Box 11-053,  Manners St,  Wellington
WEB: http://catalyst.net.nz/            PHYS: Level 2, 150-154 Willis St
DDI: +64 803-2206      MOB: +64(27)4707-815     OFFICE: +64(4)499-2267
-------------------------------------------------------------------------


В списке pgsql-admin по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: [JDBC] Trouble with locking tables - reg.
Следующее
От: Naomi Walker
Дата:
Сообщение: Re: "select * from groupes" didn't display any data