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
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... |