New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Provide more detailed information about the query execution plan [CORE3332] #3698
Comments
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 1 [ 10331 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: Robert (rjm1102) I see the first part of this new feature is implemented in 3.0 alpha 1 (and ISQL), but what about the second part of this request, i.e. adding an unlimited version of the plan text in the MON$STATEMENTS table. I don't see an additional column in MON$STATEMENTS, also not in alpha 2. |
Commented by: @dyemanov It will be available in Beta 1. |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: Deferred Test Details: Implementation deferred until output of explained plan will have stable set of tokens. Currently some of them can be changed. |
Modified by: @cincuranet |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: Deferred => Covered by another test(s) Test Details: Implementation deferred until output of explained plan will have stable set of tokens. Currently some of them can be changed. => See tests for COREs: 4498 4318 5236 5070 5598 6218 et al. All of them use explained plan in expected* sections. |
Submitted by: @dyemanov
Block progress on DNET864
Details could be found here: http://sourceforge.net/mailarchive/message.php?msg_id=24546633
The new information tag (isc_info_sql_explain_plan) can be used to retrieve the detailed textual output. Please note that it's still limited to 64KB, due to the API restrictions, so the output could be truncated. An unlimited version of the text would be available via the MON$STATEMENTS table.
Commits: 6449c94
====== Test Details ======
See tests for COREs: 4498 4318 5236 5070 5598 6218 et al. All of them use explained plan in expected* sections.
The text was updated successfully, but these errors were encountered: