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