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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
