RealGrayRabbit commented on issue #1523: URL: https://github.com/apache/cloudberry/issues/1523#issuecomment-3758851044
> 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: > > ``` > 1. The results of "explain analyze", which can be used to analyze which operator is further slow > 2. Turn on the following GUCs, and place the output as attached file of both GP6 and Cloudberry 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; > ``` I've already run with different configuration under GP6 and CBDB 2 cluster. Please refer to attached log file. [cbdb_on.log](https://github.com/user-attachments/files/24666902/cbdb_on.log) [gp6_on.log](https://github.com/user-attachments/files/24666901/gp6_on.log) [cbdb_off.log](https://github.com/user-attachments/files/24666903/cbdb_off.log) [gp6_off.log](https://github.com/user-attachments/files/24666900/gp6_off.log) -- 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]
