How to find the site collections and their size in a content Database in SharePoint 2010 ?

Use the below PowerShell Command to find the site collections and their size in a content Database.

Get-SPSite -Limit All -ContentDatabase ContentDBName | select url, @{label="Size";Expression={$_.usage.storage}}