See https://www.datadoghq.com/blog/postgresql-vacuum-monitoring/ Query to retrieve number of dead rows: SELECT relname, n_dead_tup FROM pg_stat_user_tables;