I think a tool like FBTraceManager from Thomas (Upscene) can do that for you
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]