2007/8/6, Lewis Cunningham <lewisc@xxxxxxxxxxxxxx>: > Hi all, > > What is the best tool for an app to profile procedural code in > postgres? I want to instrument my code and trace it so that I can > see which code bits are sucking up the cpu and time. I know I can > stick messages in the code and gather my own stats but I was > wondering is there are any good tools to automate this. > > Specifically working with pl/pgSQL and 8.2 (on Linux or windows) if > that helps. > > Thanks, > > LewisC > pgfouine is the best Regards Pavel Stehule ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
