16601746291 opened a new issue, #20110: URL: https://github.com/apache/doris/issues/20110
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description In doris, i created 2 catalogs ,then i want to query a PG table count in doris , but in doris query take 1min，but in PG is just 90 ms, screenshot is like below:    I also tried other queries, such as group by, which took several minutes, which was too long ### Solution What I'm curious about is that for cross-db queries, I think they are run on PG engine, so the result data no more than 5000 records, so why doris take such a long response time? Is it a problem in my use? Could you please help explain the underlying operation mechanism of doris？ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
