I have used this code to get the query plan of my function. It didn't create any logs . It ran successfully and result is coming. Can any one help me to get the query plan of query inside the function. I used this script to get the query plan.
LOAD 'auto_explain';
SET auto_explain.log_min_duration = 0;
SET auto_explain.log_analyze = true;
SET auto_explain.log_nested_statements = on;
select get_report('{"fromDate":"2019-01-22","toDate":"2019-11-29","storeId":1}');
To get the plans of nested statements logged,
SET auto_explain.log_nested_statements = on;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With