1 Module makes an analyze call immediately after INSERT/UPDATE/DELETE/SELECT INTO
4 Supported versions of PostgreSQL: 8.4.*, 9.0.*, 9.1.*, 9.2.*, 9.3.*, 9.4*, 9.5*,
7 Usage: LOAD 'online_analyze';
9 Custom variables (defaults values are shown):
10 online_analyze.enable = on
11 Enables on-line analyze
13 online_analyze.local_tracking = off
14 Per backend tracking for temp tables (do not use system statistic)
16 online_analyze.verbose = on
17 Execute ANALYZE VERBOSE
19 online_analyze.scale_factor = 0.1
20 Fraction of table size to start on-line analyze (similar to
21 autovacuum_analyze_scale_factor)
23 online_analyze.threshold = 50
24 Min number of row updates before on-line analyze (similar to
25 autovacuum_analyze_threshold)
27 online_analyze.min_interval = 10000
28 Minimum time interval between analyze call per table (in milliseconds)
30 online_analyze.lower_limit = 0
31 Min number of rows in table to analyze
33 online_analyze.table_type = "all"
34 Type(s) of table for online analyze: all, persistent, temporary, none
36 online_analyze.exclude_tables = ""
37 List of tables which will not online analyze
39 online_analyze.include_tables = ""
40 List of tables which will online analyze
41 online_analyze.include_tables overwrites online_analyze.exclude_tables.
43 online_analyze.capacity_threshold = 100000
44 Maximum number of temporary tables to store in local cache
46 Author: Teodor Sigaev <teodor@sigaev.ru>