excution time for plpgsql function and subfunction

From: Rémi Cura <remi(dot)cura(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: excution time for plpgsql function and subfunction
Date: 2014-01-10 09:10:28
Message-ID: CAJvUf_usW+NM+zyD+jpJ9EgwyVyTq=JzLSrbGch1RJq0ihr-kg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey List,
kind of a simple question :

I'm using the postgis_topology extension,
and I'm trying to figure where the slowness comes from when importing data.

It involves plpgsql function calling other plpgsql functions, insert,
update, etc etc.

I know I can use explain analyze for one querry, but I don't know how to
get details of how much time takes each sub-function called by a main
function.

Thus it is very difficult to guess where is the bottleneck.

Thanks ,cheers,

Rémi-C

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Voras 2014-01-10 10:25:01 Re: Consistent file-level backup of pg data directory
Previous Message Luca Ferrari 2014-01-10 09:01:42 Re: wal archive peak during pg_dump