Re: tup_returned/ tup_fetched

El Martes, 16 de Diciembre de 2008 04:02:09 Sebastian Böhm escribió:
> 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.
>
From 8.2 docs

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

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

--
No imprima este correo si no es necesario. El medio ambiente está en nuestras manos.
__________________________________________

Clist UAH a.k.a Angel
__________________________________________
"Te has metido en un hipoteca de 70M y encima te roban una panda de Ninjas... Crisis Ninja para Dummies