How to find out hit count or read activities on functions in postgresql 8.4.6

From: Jenish Vyas <jenishvyas(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to find out hit count or read activities on functions in postgresql 8.4.6
Date: 2011-07-14 10:17:10
Message-ID: CANqFkjFep9kWRvODGwwCZYa64H4S32jXALAkeBhvzcHRdTYX4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

Can you guide me how to find out the read activities for stored functions in
database?

(How many times function called in specific time frame)

Catalog tables give the read count for Tables and Index. Do we have any
catalog table for functions as well?

Thanks & regards,
JENISH VYAS

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christoph Anton Mitterer 2011-07-14 11:27:30 how to make PostgreSQL using "all" memory and chaching the DB completely there
Previous Message jenopob 2011-07-14 01:45:08 Re: How to auto switch the roles of master and standby