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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin