As the title says - does (and/or can) pgstattuple provide a breakdown by partition?
Partitions are tables, created via CREATE TABLE. I know from experience that it works on inheritance tables; what happens when you try pgstattuple() on a small test partition?