'Louis van Alphen' lo...@nucleo.co.za [firebird-support] schrieb am 14.10.2015 10:09:
> I think a tool like FBTraceManager from Thomas (Upscene) can do that for you Unfortunately not. The Trace API does not provide that level of granularity for PSQL code modules. This has been a long discussion in firebird-devel in the past, people basically argued that the Trace API isn't the right place for that sort of granularity, but more appropriate for a debugging/profiling feature. I still believe in the Trace API being a good profiling tool though. ;-) -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > > > > From: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Sent: 13 October 2015 05:31 PM > To: firebird-support@yahoogroups.com > Subject: [firebird-support] How can I see which query within a stored > procedure execution takes the longest time? > > > > > > Greetings All, > > > > Firebird 2.5.4 > > I would like to know if there is any way that I can retrieve the execution > time of each SQL SELECT or EXECUTE PROCEDURE within a stored procedure? > > Any tool to accomplish this? > > Thanks, > > Mike > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > Posted by: "Louis van Alphen" <lo...@nucleo.co.za> > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > >