| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Rémi Cura <remi(dot)cura(at)gmail(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: excution time for plpgsql function and subfunction |
| Date: | 2014-01-13 11:24:20 |
| Message-ID: | 1389612260.3294.5.camel@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2014-01-10 at 10:10 +0100, Rémi Cura wrote:
> 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.
>
Shameless plug, but here is how I do it:
http://blog.guillaume.lelarge.info/index.php/post/2012/03/31/Profiling-PL/pgsql-functions
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rémi Cura | 2014-01-13 11:30:28 | Re: excution time for plpgsql function and subfunction |
| Previous Message | sramay | 2014-01-13 10:26:44 | Re: pg_largeobject related issue with 9.2 |