CREATE EXTENSION pg_stat_monitor;
SELECT pg_stat_monitor_reset();
 pg_stat_monitor_reset 
-----------------------
 
(1 row)

SELECT * from pg_stat_monitor_settings where name='pg_stat_monitor.pgsm_histogram_max';
                name                | value  | default_value |          description          | minimum |  maximum   | options | restart 
------------------------------------+--------+---------------+-------------------------------+---------+------------+---------+---------
 pg_stat_monitor.pgsm_histogram_max | 100000 | 100000        | Sets the time in millisecond. |      10 | 2147483647 |         | yes
(1 row)

SELECT pg_stat_monitor_reset();
 pg_stat_monitor_reset 
-----------------------
 
(1 row)

SELECT * from pg_stat_monitor_settings where name='pg_stat_monitor.pgsm_histogram_max';
                name                | value | default_value |          description          | minimum |  maximum   | options | restart 
------------------------------------+-------+---------------+-------------------------------+---------+------------+---------+---------
 pg_stat_monitor.pgsm_histogram_max | 10    | 100000        | Sets the time in millisecond. |      10 | 2147483647 |         | yes
(1 row)

SELECT pg_stat_monitor_reset();
 pg_stat_monitor_reset 
-----------------------
 
(1 row)

SELECT * from pg_stat_monitor_settings where name='pg_stat_monitor.pgsm_histogram_max';
                name                | value | default_value |          description          | minimum |  maximum   | options | restart 
------------------------------------+-------+---------------+-------------------------------+---------+------------+---------+---------
 pg_stat_monitor.pgsm_histogram_max | 100   | 100000        | Sets the time in millisecond. |      10 | 2147483647 |         | yes
(1 row)

SELECT pg_stat_monitor_reset();
 pg_stat_monitor_reset 
-----------------------
 
(1 row)

SELECT * from pg_stat_monitor_settings where name='pg_stat_monitor.pgsm_histogram_max';
                name                | value | default_value |          description          | minimum |  maximum   | options | restart 
------------------------------------+-------+---------------+-------------------------------+---------+------------+---------+---------
 pg_stat_monitor.pgsm_histogram_max | 1000  | 100000        | Sets the time in millisecond. |      10 | 2147483647 |         | yes
(1 row)

Drop extension pg_stat_monitor;