Debian
dpkg-query -Wf '${Installed-Size} ${Package}\n' | sort -nr | numfmt --group | less
CentOS
rpm -qa --queryformat '%{size} %{name}\n' | sort -nr | numfmt --group | less
maybe will be necessary change locale to numfmt command work
LANG=pt_BR.utf8 numfmt --group 1234567 LANG=en_AG numfmt --group 1234567