Skip to content
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

Closed
firebird-automations opened this issue Feb 2, 2011 · 8 comments

Comments

@firebird-automations
Copy link
Collaborator

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.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

security: Managers [ 10013 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

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.
Is this still pending to be implemented?

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

It will be available in Beta 1.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: 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.
See also core-4710.

@firebird-automations
Copy link
Collaborator Author

Modified by: @cincuranet

Link: This issue block progress on DNET864 [ DNET864 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: 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 also core-4710.

=>

See tests for COREs: 4498 4318 5236 5070 5598 6218 et al. All of them use explained plan in expected* sections.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants