my-ship-it commented on issue #1523: URL: https://github.com/apache/cloudberry/issues/1523#issuecomment-3742947793
Thank you for providing the plan! Based on the query plan, the difference between the two mainly lies in the Aggregation part below, which may be due to cost estimation issues. Could you please help provide two more pieces of information: The results of "explain analyze", which can be used to analyze which operator is further slow Turn on the following switch, and place the output as attached file for further diagnosis: SET client_min_messages=log; SET optimizer_print_memo_after_optimization=on; SET optimizer_print_optimization_context=on; SET optimizer_print_memo_after_exploration=on; SET optimizer_print_memo_after_implementation=on; -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
