Re: tup_returned/ tup_fetched

sorry I was not very precise.

My question is what does it actually mean in the end for these two
functions:

pg_stat_get_db_tuples_returned(oid) bigint Number of tuples returned
for database
pg_stat_get_db_tuples_fetched(oid) bigint Number of tuples fetched for
database

I read the description below, but I don't completely understand the
difference.

I want to plot a realtime graph: "tuples read from buffers or disk"
is it both combined ?

Thanks
Sebastian

Am 15.12.2008 um 04:28 schrieb Gregory Stark:

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