PostgreSQL 9.3 - pg_stat_database - tup_returned got "too high" value

From: Borys Gogulski <me(at)bwgg(dot)pl>
To: pgsql-admin(at)postgresql(dot)org
Subject: PostgreSQL 9.3 - pg_stat_database - tup_returned got "too high" value
Date: 2014-10-20 09:24:48
Message-ID: CAN8+4G221YmgOzOJyB7VbTWwqW97resLOKRp65qFkHGBq1MFQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I've got a "problem" with stats at PostgreSQL 9.3. Problem can coupe(?)
sources:
a) I do not understand what values should tup_returned contain
b) tup_returned contains something else than can be understood by reading
official docs
c) something is wrong with our database "server"

According to docs (
http://www.postgresql.org/docs/9.3/static/monitoring-stats.html)
tup_returned bigint Number of rows returned by queries in
this database

Imagine following query and result:

pgsql=# SELECT datname, connections, queries, tup_returned FROM
pg_stat_database WHERE datname = 'dbname';
datname | connections | queries | tup_returned
----------+-------------+---------+--------------
dbname | 0 | 1 | 39824
(1 row)

What's my problem? This (test) database isn't used by any user/script,
password was set randomly and I don't even know it. Database is left
untouched, tup_returned climbs quite high at rate ~ 65k per hour. btw.
there's only one table with 2 rows inside.
Same thing happens for all 9.3 instances in all databases configured in our
environment.

I'd be very glad if someone could explain to me what should I expect from
tup_returned or how can I meter "rows returned from database".

Best regards,
Borys Gogulski

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ferrell, Denise CTR NSWCDD, Z11 2014-10-20 18:43:07 DBLINK - PostgreSQL to ORACLE
Previous Message jayknowsunix 2014-10-18 20:28:41 Re: Unable to connect remotely