Sebastian Böhm <seb@exse.net> writes:
> one question:
>
> what actually is tup_returned and tup_fetched ?
RTFM -- admittedly it's not so easy to find these since you have to know they
come from the following functions:
pg_stat_get_tuples_returned(oid) bigint Number of rows read by sequential
scans when argument is a table, or number of index entries returned when
argument is an index
pg_stat_get_tuples_fetched(oid) bigint Number of table rows fetched by bitmap
scans when argument is a table, or table rows fetched by simple index scans
using the index when argument is an index
From:
http://www.postgresql.org/docs/8.3/interactive/monitoring-stats.html
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!