How to view the current settings of Autovacuum in Postgres?

Question

I've found a million examples of how to set Autovacuum's configuration settings, but can't seem to find how to list the current configuration.

Postgres 9.1 is the version I'm most interested in.

Answer 1

For the general settings use:

select *
from pg_settings 
where name like 'autovacuum%'

for table specific settings, check out the column reloptions in pg_class:

select relname, reloptions
from pg_class

(you probably want to join that to pg_namespace to limit this to a specific schema).