Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find out hit count or read activities on functions in postgresql 8.4.6 - Mailing list pgsql-admin

From Sergey Konoplev
Subject Re: How to find out hit count or read activities on functions in postgresql 8.4.6
Date
Msg-id CAL_0b1vq3zzq9r8NM_4gPMwkx0tkZYyO3fi2tGoQ6KvU5=Lx2w@mail.gmail.com
Whole thread Raw
In response to How to find out hit count or read activities on functions in postgresql 8.4.6  (Jenish Vyas <jenishvyas@gmail.com>)
List pgsql-admin
Tree view 
Hi,

On 14 July 2011 14:17, Jenish Vyas <jenishvyas@gmail.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.ru@gmail.com / Skype: gray-hemp

pgsql-admin by date:

Previous
From: saravanan
Date:
Subject: Re: Importing the dump file in postgresql-7.4.23
Next
From: lst_hoe02@kwsoft.de
Date:
Subject: Re: Maximum insert per second