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 <s...@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! > > > > -- 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
