Analyzing JSON records
You can use a jq command to extract information about recommendations in JSON. Then, you can rerun the query, take a look at the plan, and see which materialized view was used, and other information.
The jq command that you can use for analyzing JSON records looks something like this:
jq -r `.recommended_views | .name, .queries < out_dir/ALL-FULL.json`
In this example, output includes the original query submitted by the user. The output also includes the optimized sql that uses the materialized view. Output looks something like this:
This optimized SQL above matches the information in the plan.