I see.. but I agree with you
From: [email protected] [mailto:[email protected]] Sent: 14 October 2015 11:20 AM To: [email protected] Subject: Re: [firebird-support] How can I see which query within a stored procedure execution takes the longest time? 'Louis van Alphen' [email protected] [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: [email protected] > [mailto:[email protected]] > Sent: 13 October 2015 05:31 PM > To: [email protected] > 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" <[email protected]> > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > 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 > > > [Non-text portions of this message have been removed]
