Autovacuum

From wikieduonline
Jump to navigation Jump to search
select category,name,setting,unit,source,min_val,max_val from pg_settings where category = 'Autovacuum';
  category  |                name                 |  setting  | unit |       source       | min_val |  max_val
------------+-------------------------------------+-----------+------+--------------------+---------+------------
 Autovacuum | autovacuum                          | on        |      | default            |         |
 Autovacuum | autovacuum_analyze_scale_factor     | 0.05      |      | configuration file | 0       | 100
 Autovacuum | autovacuum_analyze_threshold        | 50        |      | default            | 0       | 2147483647
 Autovacuum | autovacuum_freeze_max_age           | 200000000 |      | default            | 100000  | 2000000000
 Autovacuum | autovacuum_max_workers              | 3         |      | configuration file | 1       | 262143
 Autovacuum | autovacuum_multixact_freeze_max_age | 400000000 |      | default            | 10000   | 2000000000
 Autovacuum | autovacuum_naptime                  | 15        | s    | configuration file | 1       | 2147483
 Autovacuum | autovacuum_vacuum_cost_delay        | 2         | ms   | default            | -1      | 100
 Autovacuum | autovacuum_vacuum_cost_limit        | 200       |      | configuration file | -1      | 10000
 Autovacuum | autovacuum_vacuum_scale_factor      | 0.1       |      | configuration file | 0       | 100
 Autovacuum | autovacuum_vacuum_threshold         | 50        |      | default            | 0       | 2147483647
(11 rows)


select category,name,setting,unit,source,min_val,max_val from pg_settings where category = 'Autovacuum';
  category  |                name                 |  setting  | unit | source  | min_val |  max_val
------------+-------------------------------------+-----------+------+---------+---------+------------
 Autovacuum | autovacuum                          | on        |      | default |         |
 Autovacuum | autovacuum_analyze_scale_factor     | 0.1       |      | default | 0       | 100
 Autovacuum | autovacuum_analyze_threshold        | 50        |      | default | 0       | 2147483647
 Autovacuum | autovacuum_freeze_max_age           | 200000000 |      | default | 100000  | 2000000000
 Autovacuum | autovacuum_max_workers              | 3         |      | default | 1       | 262143
 Autovacuum | autovacuum_multixact_freeze_max_age | 400000000 |      | default | 10000   | 2000000000
 Autovacuum | autovacuum_naptime                  | 60        | s    | default | 1       | 2147483
 Autovacuum | autovacuum_vacuum_cost_delay        | 2         | ms   | default | -1      | 100
 Autovacuum | autovacuum_vacuum_cost_limit        | -1        |      | default | -1      | 10000
 Autovacuum | autovacuum_vacuum_scale_factor      | 0.2       |      | default | 0       | 100
 Autovacuum | autovacuum_vacuum_threshold         | 50        |      | default | 0       | 2147483647
(11 rows)


select count(*) from pg_stat_activity where query like 'autovacuum:%';
 count
-------
     0
(1 row)
SELECT
  schemaname, relname,
  last_vacuum, last_autovacuum,
  vacuum_count, autovacuum_count
FROM pg_stat_user_tables;

Activites[edit]

Related terms[edit]

LOG:  autovacuum launcher started
postgres: autovacuum launcher

See also[edit]

Advertising: