Thread: Function Profiler in Postgre

Function Profiler in Postgre

From
D T
Date:
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.

Regards
Ds

Re: Function Profiler in Postgre

From
Craig Ringer
Date:
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