Re: Function Profiler in Postgre

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: D T <devso444(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Function Profiler in Postgre
Date: 2012-10-27 11:21:03
Message-ID: 508BC39F.9040005@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Xiong He 2012-10-27 12:21:22 Re: PostgresQL intallation error
Previous Message Gavin Flower 2012-10-27 10:43:21 Re: PostgresQL intallation error