Current size of a PostgreSQL table (vs disk space used)
There are two extensions that may be helpful


pgstattuple provides various functions to obtain tuple-level statistics,
pg_freespacemap  provides a means for examining the free space map (FSM).