--- /dev/null
+LOAD 'online_analyze';
+SET online_analyze.enable = on;
+SET "online_analyze.verbose" = on;
+SET online_analyze.table_type = "all";
+SHOW online_analyze.enable;
+ online_analyze.enable
+-----------------------
+ on
+(1 row)
+
+SHOW "online_analyze.verbose";
+ online_analyze.verbose
+------------------------
+ on
+(1 row)
+
+SHOW online_analyze.table_type;
+ online_analyze.table_type
+---------------------------
+ all
+(1 row)
+
+CREATE TABLE oa_tbl(
+ foo int,
+ bar text
+);
+SHOW online_analyze.exclude_tables;
+ online_analyze.exclude_tables
+-------------------------------
+
+(1 row)
+
+SET online_analyze.exclude_tables = "oa_tbl";
+SHOW online_analyze.exclude_tables;
+ online_analyze.exclude_tables
+-------------------------------
+ public.oa_tbl
+(1 row)
+
+DROP TABLE oa_tbl;
+SHOW online_analyze.exclude_tables;
+ online_analyze.exclude_tables
+-------------------------------
+
+(1 row)
+
+SET online_analyze.enable = off;