excution time for plpgsql function and subfunction - Mailing list pgsql-general

From Rémi Cura
Subject excution time for plpgsql function and subfunction
Date
Msg-id CAJvUf_usW+NM+zyD+jpJ9EgwyVyTq=JzLSrbGch1RJq0ihr-kg@mail.gmail.com
Whole thread Raw
Responses Re: excution time for plpgsql function and subfunction
Re: excution time for plpgsql function and subfunction
List 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 

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: wal archive peak during pg_dump
Next
From: Ivan Voras
Date:
Subject: Re: Consistent file-level backup of pg data directory