question related to pg_stat_database

From: Arvind Singh <arvindps(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: question related to pg_stat_database
Date: 2011-10-29 09:39:22
Message-ID: BLU164-W463A94422A660892908830CAD00@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello pg_users,

we have just migrated an application from mysql to postgresql

we use csharp+npgsql to develo application

I need to monitor Postgresql statistics at regular intervals.

I came across pg_stat_database and especially the columns tulip_fetched and tup_returned.

Is there anything to worry , when comparing both figures.

For ex. my server reports

tulip_fetched = 736555240

tulip_returned = 99888791 (almost 10% of fetched)



thanx.



Browse pgsql-general by date

  From Date Subject
Next Message Szymon Guz 2011-10-29 10:53:08 PostgreSQL Naming Rules - another question
Previous Message Gavin Flower 2011-10-29 05:53:00 Re: nextval skips values between consecutive calls