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;