[ https://issues.apache.org/jira/browse/OAK-10527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17782462#comment-17782462 ]
Thomas Mueller commented on OAK-10527: -------------------------------------- PR for review https://github.com/apache/jackrabbit-oak/pull/1187 > Improve readability of the explain query output > ----------------------------------------------- > > Key: OAK-10527 > URL: https://issues.apache.org/jira/browse/OAK-10527 > Project: Jackrabbit Oak > Issue Type: Improvement > Components: query > Reporter: Thomas Mueller > Assignee: Thomas Mueller > Priority: Major > > Currently the output "explain query" of Oak (the query plan) is hard to > interpret. > A more human-readable output would be better. Example: > Old: > {noformat} > [nt:base] as [nt:base] /* > lucene:slingResourceResolver-1(/oak:index/slingResourceResolver-1) > sling:vanityPath:[* TO *] sync:(sling:vanityPath is not null) where > ([nt:base].[sling:vanityPath] is not null) and > (first([nt:base].[sling:vanityPath]) > '') */ > {noformat} > New: > {noformat} > [nt:base] as [nt:base] /* lucene:slingResourceResolver-1 > indexDefinition: /oak:index/slingResourceResolver-1 > estimatedEntries: 46 > luceneQuery: sling:vanityPath:[* TO *] > synchronousPropertyCondition: sling:vanityPath is not null > */ > {noformat} > Also, the formatting of the logged query statement should be improved: > instead of one single line with the whole statement, the statement should > contain line breaks before the important keywords. Example: > Old: > {noformat} > Parsing JCR-SQL2 statement: explain SELECT [sling:vanityPath], > [sling:redirect], [sling:redirectStatus] FROM [nt:base] WHERE NOT > isdescendantnode('/jcr:system') AND [sling:vanityPath] IS NOT NULL AND > FIRST([sling:vanityPath]) > '' ORDER BY FIRST([sling:vanityPath]) > {noformat} > New: > {noformat} > Parsing JCR-SQL2 statement: explain SELECT [sling:vanityPath], > [sling:redirect], [sling:redirectStatus] > FROM [nt:base] > WHERE NOT isdescendantnode('/jcr:system') > AND [sling:vanityPath] IS NOT NULL > AND FIRST([sling:vanityPath]) > '' > ORDER BY FIRST([sling:vanityPath]) > {noformat} -- This message was sent by Atlassian Jira (v8.20.10#820010)