Chris McDonald
2013-02-27 10:30:26 UTC
Hi,
I have a complex plpgsql query which makes many SQL calls, other SP calls (also plpgsql) and on occasion recurses on itself also. Many of the SQL queries it contains make joins on multi-million row tables.
The SP performs well on some occasions (couple of seconds) but on others performs poorly (15-20 seconds). I know from the data-domain that the poor performance occurs when there is significantly larger data volumes to process.
Ideally I would like to see the individual queries being executed but pgadmin only shows me the top level SP executing. Is there a way that I can see the individual queries within the SP executing together with timings (and ideally plan details)?
Thanks very much in advance.
Chris
I have a complex plpgsql query which makes many SQL calls, other SP calls (also plpgsql) and on occasion recurses on itself also. Many of the SQL queries it contains make joins on multi-million row tables.
The SP performs well on some occasions (couple of seconds) but on others performs poorly (15-20 seconds). I know from the data-domain that the poor performance occurs when there is significantly larger data volumes to process.
Ideally I would like to see the individual queries being executed but pgadmin only shows me the top level SP executing. Is there a way that I can see the individual queries within the SP executing together with timings (and ideally plan details)?
Thanks very much in advance.
Chris