Commande sql pour obtenir le pourcentage de tuples morts :

SELECT
 relname AS TableName,
 pg_stat_get_live_tuples(c.oid) AS Tuples_vivants,
 pg_stat_get_dead_tuples(c.oid) AS Tuples_morts,
ROUND(100*(CAST(pg_stat_get_dead_tuples(c.oid) as FLOAT)/CAST((pg_stat_get_live_tuples(c.oid)+pg_stat_get_dead_tuples(c.oid)) as FLOAT))) AS Pourcentage_de_morts
FROM pg_class c
WHERE pg_stat_get_dead_tuples(c.oid) > 0
ORDER BY Tuples_morts DESC LIMIT 25;