F.32. online_analyze#
F.32. online_analyze #
Module runs analyze immediately after
INSERT, UPDATE, DELETE
or SELECT INTO for affected table.
Usage: LOAD 'online_analyze';
F.32.1. Configuration #
Parameters (defaults values are shown):
Enables
online_analyze
online_analyze.enable = on
Enables per-backend tracking for temp tables. If
offthen will be used the default system statistics for temporary tables.
online_analyze.local_tracking = off
Execute
ANALYZE VERBOSE
online_analyze.verbose = on
Fraction of table size to start on-line analyze (similar to autovacuum_analyze_scale_factor)
online_analyze.scale_factor = 0.1
Min number of row updates before on-line analyze (similar to autovacuum_analyze_threshold)
online_analyze.threshold = 50
Minimum time interval between analyze call per table (in milliseconds)
online_analyze.min_interval = 10000
Min number of rows in table to analyze
online_analyze.lower_limit = 0
Types of table for online analyze:
all,persistent,temporary,none
online_analyze.table_type = "temporary"
List of tables which will not online analyze
online_analyze.exclude_tables = ""
List of tables which will online analyze
online_analyze.include_tablesoverwritesonline_analyze.exclude_tables.
online_analyze.include_tables = ""
Maximum number of temporary tables to store in local cache
online_analyze.capacity_threshold = 100000
F.32.2. Authors #
Author: Teodor Sigaev.