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

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Jenish Vyas <jenishvyas(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to find out hit count or read activities on functions in postgresql 8.4.6
Date: 2011-07-15 08:04:25
Message-ID: CAL_0b1vq3zzq9r8NM_4gPMwkx0tkZYyO3fi2tGoQ6KvU5=Lx2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

On 14 July 2011 14:17, Jenish Vyas <jenishvyas(at)gmail(dot)com> wrote:
> 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)

I hope this will help you
http://www.postgresql.org/docs/current/interactive/pgstatstatements.html

> Catalog tables give the read count for  Tables and Index. Do we have any
> catalog table for functions as well?
>
> Thanks & regards,
> JENISH VYAS
>
>
>

--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray(dot)ru(at)gmail(dot)com / Skype: gray-hemp

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message lst_hoe02 2011-07-15 08:09:26 Re: Maximum insert per second
Previous Message saravanan 2011-07-15 07:11:48 Re: Importing the dump file in postgresql-7.4.23