I had a feeling AWS Redshift would perform better for a query performing a count, but didn't expect it to be as good as taking less than 1 second. I wrote up a comparison of MariaDB on RDS vs Redshift for a particular use case 

https://gordonmurray.com/aws/2022/06/25/redshift-for-fast-counts.html