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