## F.29. online-analyze

The `online_analyze` module provides set of features, which immediately update stats after INSERT, UPDATE, DELETE or SELECT INTO operations applied for affected tables.

### F.29.1. Module loading

To use `online_analyze` module the first thing you need is to load shared library:

            LOAD 'online_analyze';

### F.29.2. Module configuration

Custom variables (default values are shown):

- online_analyze.enable = on

  Enables online analyze

- online_analyze.verbose = on

  Execute ANALYZE VERBOSE

- online_analyze.scale_factor = 0.1

  Fraction of table size to start online analyze (similar to autovacuum_analyze_scale_factor)

- online_analyze.threshold = 50

  Min number of row updates before online analyze (similar to autovacuum_analyze_threshold)

- online_analyze.min_interval = 10000

  Minimum time interval between analyze call per table (in milliseconds)

- online_analyze.table_type = "all"

  Type(s) of tables for online analyze: all, persistent, temporary, none

- online_analyze.exclude_tables = ""

  List of tables to exclude from online analyze

- online_analyze.include_tables = ""

  List of tables to include in online analyze (online_analyze.include_tables overrides online_analyze.exclude_tables).

### F.29.3. Authors

Teodor Sigaev `<teodor@sigaev.ru>`