How to analyze function performance

From: "Mindaugas" <mind(at)bi(dot)lt>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: How to analyze function performance
Date: 2006-06-15 12:16:32
Message-ID: 016401c69075$8a35e8c0$f20214ac@bite.lt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Hello,

Is it possible to somehow analyze function performance? E.g.
we are using function cleanup() which takes obviously too much time
to execute but I have problems trying to figure what is slowing things
down.

When I explain analyze function lines step by step it show quite
acceptable performance.

PostgreSQL 8.0 is running on two dual core Opterons.

Thanks,

Mindaugas

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2006-06-15 13:03:25 Re: How to analyze function performance
Previous Message jody brownell 2006-06-15 12:15:10 Re: Postgres consuming way too much memory???