SELECT#

F.33. online_analyze — statistic collection right after INSERT/UPDATE/DELETE/SELECT

F.33. online_analyze — statistic collection right after INSERT/UPDATE/DELETE/SELECT
Prev	Up	Appendix F. Additional Supplied Modules and Extensions	Home	Next

F.33. online_analyze — statistic collection right after INSERT/UPDATE/DELETE/SELECT #

Module runs analyze immediately after INSERT, UPDATE, DELETE or SELECT INTO for affected table.

Usage: LOAD 'online_analyze';

Parameters (defaults values are shown):

Enables online_analyze
```
online_analyze.enable = on  
```
Enables per-backend tracking for temp tables. If off then 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_tables overwrites online_analyze.exclude_tables.
```
online_analyze.include_tables = ""
```
Maximum number of temporary tables to store in local cache
```
online_analyze.capacity_threshold = 100000
```

Prev	Up	Next
F.32. oauth_validator — OAuth 2.0 Basic Token Validator for Tantor SE	Home	F.34. orafce — set of functions that provide compatibility with Oracle databases