On 10/27/2012 01:43 AM, D T wrote: > Hi, > I have many functions which i want to finetune. Is there any profiler > available which i can use to check performance of function and finetune it. Since you haven't specified your PostgreSQL version, platform, the language the functions are written in, etc it's rather hard to say. For PL/PgSQL check out the PL/PgSQL debugger. There's also the `auto_explain` contrib module. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general