Psu can’t show progress because the database handles the command and doesn’t provide progress. Psu can’t make up its own progress for the sake of progress.
SQLite takes the time it needs and psu is not a factor here.
A few posts back I’ve posted a script that allows you to disable the startup compacting. Then it’s your own task to compact regularly and when convenient for you. I recommend to do that every two weeks.