Anyone here who has deployed signoz on any cloud provider like aws on service like ECS and if yes then how can i manage the storage part of all the logs ingested as using EBS or EFS would be a costly option....Is storing in s3 and using athena to query an good option?

You can configure sigoz to store data in disk for a few days and then move to something like s3 https://signoz.io/docs/userguide/retention-period/#configuring-cold-storage---amazon-s3 You will be able to query the data present in s3, just be aware about the network cost.