CREATE EXTENSION pg_track_optimizer;
SELECT * FROM pg_track_optimizer_reset();
 pg_track_optimizer_reset 
--------------------------
                        1
(1 row)

SELECT mode,entries_left,is_synced
FROM pg_track_optimizer_status;
  mode  | entries_left | is_synced 
--------+--------------+-----------
 forced |         8737 | f
(1 row)

\d pg_track_optimizer
                  View "public.pg_track_optimizer"
     Column      |       Type       | Collation | Nullable | Default 
-----------------+------------------+-----------+----------+---------
 queryid         | bigint           |           |          | 
 query           | text             |           |          | 
 avg_min         | double precision |           |          | 
 avg_max         | double precision |           |          | 
 avg_cnt         | double precision |           |          | 
 avg_avg         | double precision |           |          | 
 avg_dev         | double precision |           |          | 
 rms_min         | double precision |           |          | 
 rms_max         | double precision |           |          | 
 rms_cnt         | double precision |           |          | 
 rms_avg         | double precision |           |          | 
 rms_dev         | double precision |           |          | 
 twa_min         | double precision |           |          | 
 twa_max         | double precision |           |          | 
 twa_cnt         | double precision |           |          | 
 twa_avg         | double precision |           |          | 
 twa_dev         | double precision |           |          | 
 wca_min         | double precision |           |          | 
 wca_max         | double precision |           |          | 
 wca_cnt         | double precision |           |          | 
 wca_avg         | double precision |           |          | 
 wca_dev         | double precision |           |          | 
 blks_min        | double precision |           |          | 
 blks_max        | double precision |           |          | 
 blks_cnt        | double precision |           |          | 
 blks_avg        | double precision |           |          | 
 blks_dev        | double precision |           |          | 
 local_min       | double precision |           |          | 
 local_max       | double precision |           |          | 
 local_cnt       | double precision |           |          | 
 local_avg       | double precision |           |          | 
 local_dev       | double precision |           |          | 
 time_min        | double precision |           |          | 
 time_max        | double precision |           |          | 
 time_cnt        | double precision |           |          | 
 time_avg        | double precision |           |          | 
 time_dev        | double precision |           |          | 
 jf_min          | double precision |           |          | 
 jf_max          | double precision |           |          | 
 jf_cnt          | double precision |           |          | 
 jf_avg          | double precision |           |          | 
 jf_dev          | double precision |           |          | 
 lf_min          | double precision |           |          | 
 lf_max          | double precision |           |          | 
 lf_cnt          | double precision |           |          | 
 lf_avg          | double precision |           |          | 
 lf_dev          | double precision |           |          | 
 sp_min          | double precision |           |          | 
 sp_max          | double precision |           |          | 
 sp_cnt          | double precision |           |          | 
 sp_avg          | double precision |           |          | 
 sp_dev          | double precision |           |          | 
 nj_min          | double precision |           |          | 
 nj_max          | double precision |           |          | 
 nj_cnt          | double precision |           |          | 
 nj_avg          | double precision |           |          | 
 nj_dev          | double precision |           |          | 
 evaluated_nodes | integer          |           |          | 
 plan_nodes      | integer          |           |          | 
 nexecs          | bigint           |           |          | 

\df pg_track_optimizer_flush
                                 List of functions
 Schema |           Name           | Result data type | Argument data types | Type 
--------+--------------------------+------------------+---------------------+------
 public | pg_track_optimizer_flush | integer          |                     | func
(1 row)

\df pg_track_optimizer_reset
                                 List of functions
 Schema |           Name           | Result data type | Argument data types | Type 
--------+--------------------------+------------------+---------------------+------
 public | pg_track_optimizer_reset | integer          |                     | func
(1 row)

\d pg_track_optimizer_status
         View "public.pg_track_optimizer_status"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 mode         | text    |           |          | 
 entries_left | integer |           |          | 
 is_synced    | boolean |           |          | 

SELECT * FROM pg_track_optimizer_reset();
 pg_track_optimizer_reset 
--------------------------
                        6
(1 row)

DROP EXTENSION pg_track_optimizer;