gistfile1.txt

select 
  relname,
  greatest(last_vacuum, last_autovacuum) as timestamp,
  case
    when last_autovacuum is not null then 'autovacuum'
    else 'vacuum'
  end as type
from 
  pg_stat_user_tables 
where 
  greatest(last_vacuum, last_autovacuum) > now() - interval '299 seconds';