Confusion with run time cap of resource pool

If you are using system table resource_pools : runtimecap - If you see value 3 , it is 3 days , if you see value 03:00 it is three hours, if you see value 00:03 it is 3 minutes and if you see value 00:00:03 it is 3 seconds .

If you created resource pool with runtime cap of '3' it is three days. I will check documentation and open JIRA if needed. Let me know if you have more questions.

recovery3=> create resource pool test RUNTIMECAP '3 days';
CREATE RESOURCE POOL
recovery3=> select * from resource_pools where name = 'test';
pool_id | name | is_internal | memorysize | maxmemorysize | executionparallelism | priority | runtimepriority | runtimeprioritythreshold | queuetimeout | plannedconcurrency | maxconcurrency | runtimecap | singleinitiator | cpuaffinityset | cpuaffinitymode | cascadeto
-------------------+------+-------------+------------+---------------+----------------------+----------+-----------------+--------------------------+--------------+--------------------+----------------+------------+-----------------+----------------+-----------------+-----------
45035996275593772 | test | f | 0% | | AUTO | 0 | MEDIUM | 2 | 00:05 | AUTO | | 3 | f | | ANY |
(1 row)

recovery3=> alter resource pool test RUNTIMECAP '3 minutes';
ALTER RESOURCE POOL
recovery3=> select * from resource_pools where name = 'test';
pool_id | name | is_internal | memorysize | maxmemorysize | executionparallelism | priority | runtimepriority | runtimeprioritythreshold | queuetimeout | plannedconcurrency | maxconcurrency | runtimecap | singleinitiator | cpuaffinityset | cpuaffinitymode | cascadeto
-------------------+------+-------------+------------+---------------+----------------------+----------+-----------------+--------------------------+--------------+--------------------+----------------+------------+-----------------+----------------+-----------------+-----------
45035996275593772 | test | f | 0% | | AUTO | 0 | MEDIUM | 2 | 00:05 | AUTO | | 00:03 | f | | ANY |
(1 row)

recovery3=> alter resource pool test RUNTIMECAP '3 hours';
ALTER RESOURCE POOL
recovery3=> select * from resource_pools where name = 'test';
pool_id | name | is_internal | memorysize | maxmemorysize | executionparallelism | priority | runtimepriority | runtimeprioritythreshold | queuetimeout | plannedconcurrency | maxconcurrency | runtimecap | singleinitiator | cpuaffinityset | cpuaffinitymode | cascadeto
-------------------+------+-------------+------------+---------------+----------------------+----------+-----------------+--------------------------+--------------+--------------------+----------------+------------+-----------------+----------------+-----------------+-----------
45035996275593772 | test | f | 0% | | AUTO | 0 | MEDIUM | 2 | 00:05 | AUTO | | 03:00 | f | | ANY |
(1 row)

recovery3=> alter resource pool test RUNTIMECAP '3 seconds';
ALTER RESOURCE POOL
recovery3=> select * from resource_pools where name = 'test';
pool_id | name | is_internal | memorysize | maxmemorysize | executionparallelism | priority | runtimepriority | runtimeprioritythreshold | queuetimeout | plannedconcurrency | maxconcurrency | runtimecap | singleinitiator | cpuaffinityset | cpuaffinitymode | cascadeto
-------------------+------+-------------+------------+---------------+----------------------+----------+-----------------+--------------------------+--------------+--------------------+----------------+------------+-----------------+----------------+-----------------+-----------
45035996275593772 | test | f | 0% | | AUTO | 0 | MEDIUM | 2 | 00:05 | AUTO | | 00:00:03 | f | | ANY |
(1 row)

recovery3=> alter resource pool test RUNTIMECAP '3';
ALTER RESOURCE POOL
recovery3=> select * from resource_pools where name = 'test';
pool_id | name | is_internal | memorysize | maxmemorysize | executionparallelism | priority | runtimepriority | runtimeprioritythreshold | queuetimeout | plannedconcurrency | maxconcurrency | runtimecap | singleinitiator | cpuaffinityset | cpuaffinitymode | cascadeto
-------------------+------+-------------+------------+---------------+----------------------+----------+-----------------+--------------------------+--------------+--------------------+----------------+------------+-----------------+----------------+-----------------+-----------
45035996275593772 | test | f | 0% | | AUTO | 0 | MEDIUM | 2 | 00:05 | AUTO | | 3 | f | | ANY |
(1 row)

Thanks but this info is not in Docs , It would be really helpful if this info will be in documentation

agreed ! i have filed doc enhancement request.

Thanks