From: Leticia Larrosa <leticia@tesla.cujae.edu.cu>
To: pgsql-admin@postgresql.org
Subject: configuration related to statistics
Date: Thu, 19 Feb 2009 21:07:46 -0500
Message-ID: <00b801c99300$0654e5c0$12feb140$@cujae.edu.cu> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: leticia@tesla.cujae.edu.cu
Subject: Re: configuration related to statistics
In-Reply-To: <00b801c99300$0654e5c0$12feb140$@cujae.edu.cu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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