GET_DATA_COLLECTOR_POLICY
Retrieves a brief statement about the retention policy for the specified component.
Syntax
GET_DATA_COLLECTOR_POLICY( 'component' )
Parameters
component |
Returns the retention policy of the specified component. Query system table DATA_COLLECTOR for component names. For example: => SELECT DISTINCT component, description FROM data_collector WHERE component ilike '%Depot%' ORDER BY component; component | description ----------------+------------------------------- DepotEvictions | Files evicted from the Depot DepotFetches | Files fetched to the Depot DepotUploads | Files Uploaded from the Depot (3 rows) |
Privileges
None
Example
The following query returns the history of all resource acquisitions by specifying the ResourceAcquisitions
component:
=> SELECT get_data_collector_policy('ResourceAcquisitions'); get_data_collector_policy ---------------------------------------------- 1000KB kept in memory, 10000KB kept on disk. (1 row)