wasted_file table
This table stores the paths to the current wasted files in the environment, as well as properties of the files such as last modification or file size.
Data Object |
Type |
Nullable |
Primary |
Description |
Reference |
---|---|---|---|---|---|
path |
text |
True |
False |
The file path. |
|
file_size_kb |
bigint |
True |
False |
The file size. |
|
modification_time |
timestamp with time zone |
True |
False |
When the file was last modified. |
|
storage_oid |
bigint |
True |
False |
The ID of the storage that contains the file. |
|
storage_name |
text |
True |
False |
The name of the storage (denormalized for reporting). |
Sample use cases
Get information about storage files for a data store:
The query returns the storage name, the file path, the site of the file and the last modified time for each file of a data store. The query accepts the $storage_oid as a parameter.
SELECT storage_name as "Datastore",
path as "File Path",
file_size_kb as "File Size",
modification_time as "Last Modified Time"
FROM wasted_file
WHERE file_size_kb >= 0
AND ARRAY[storage_oid]::text[] && Array['$storage_oid']::text[]
ORDER BY 3 DESC