stat-activity-autovacuum

SELECT
  SPLIT_PART(query, '.', 2) AS relname,
  EXTRACT(EPOCH FROM xact_start) AS timestamp_seconds
FROM
  pg_catalog.pg_stat_activity
WHERE
  query LIKE 'autovacuum:%'

pg_stat_activity_autovacuum_timestamp_seconds{relname="users"} 1638360125
pg_stat_activity_autovacuum_timestamp_seconds{relname="orders"} 1638360200

time() - pg_stat_activity_autovacuum_timestamp_seconds

# Autovacuum running longer than 1 hour
time() - pg_stat_activity_autovacuum_timestamp_seconds > 3600

# Count of active autovacuum processes
count(pg_stat_activity_autovacuum_timestamp_seconds)

autovacuum: VACUUM public.table_name
autovacuum: VACUUM ANALYZE public.table_name

SELECT name, setting, unit 
FROM pg_settings 
WHERE name LIKE 'autovacuum%';

SELECT 
  pid,
  now() - xact_start as duration,
  query
FROM pg_stat_activity
WHERE query LIKE 'autovacuum:%'
ORDER BY xact_start;