list installed packages by size

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