configuration related to statistics

From: "Leticia Larrosa" <leticia(at)tesla(dot)cujae(dot)edu(dot)cu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: configuration related to statistics
Date: 2009-02-20 02:07:46
Message-ID: 00b801c99300$0654e5c0$12feb140$@cujae.edu.cu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 Energa Renovable, Ahorro de Energa y Educacin Energtica
9 - 12 de Junio 2009, Palacio de las Convenciones
...Por una cultura energtica sustentable
www.ciercuba.com

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2009-02-20 05:02:47 very, very slow performance
Previous Message Scott Marlowe 2009-02-19 20:11:37 Re: vacuum full...