I see.. but I agree with you



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 14 October 2015 11:20 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How can I see which query within a stored
procedure execution takes the longest time?





'Louis van Alphen' louis@... [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" <louis@...>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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]