Question : How long do most people visit Cagliari?
Answer : Of course you're not most people, but if you were, you'd stay roughly two weeks.
Question : Is price more important than specific travel days for you?
Answer : Tuesday is your cheapest day to fly in August. Having flexibility in your travel plans means you can save more, so be sure to plan ahead when possible.