Re: tup_returned/ tup_fetched

Sebastian Böhm <seb(at)exse(dot)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!