Notes

(postgres@[local]:5432) [postgres] > select folder_id, bo1.name as "Folder Name", base_object_type as "Folder Type", a.portal_id, bo2.name as "Portal Name", a.owner_id, bo3.name as "Owner Name", folder_size, total_files, current_snapshot_id, a.is_deleted, s.* from (select fs.* from (select * from folders_statistics where is_deleted = false and (folder_size != 0 or total_files != 0)) as fs left join snapshots s on fs.current_snapshot_id = s.id and s.is_temp=false and s.current=true where s.id is null) as a left join base_objects bo1 on a.folder_id = bo1.uid left join base_objects bo2 on a.portal_id = bo2.uid left join base_objects bo3 on a.owner_id = bo3.uid left join snapshots s on a.current_snapshot_id = s.id;
-[ RECORD 1 ]-------+--------------------------------
folder_id | 36
Folder Name | IMImages
Folder Type | com.ctera.db.objects.CloudDrive
portal_id | 8
Portal Name | KofaxLATM
owner_id | 16
Owner Name | gateway
folder_size | 296494462
total_files | 3869
current_snapshot_id | 21898127
is_deleted | f
id | 21898127
timestamp | 2023-06-05 15:31:31
cloud_folder_id | 36
is_temp | t
current_id | 4093476244
modified_time | 2023-06-28 17:40:11.75871
end_time |
current | t
changed | f
completed |
error |
-[ RECORD 2 ]-------+--------------------------------
folder_id | 93
Folder Name | JABOImages
Folder Type | com.ctera.db.objects.CloudDrive
portal_id | 8
Portal Name | KofaxLATM
owner_id | 16
Owner Name | gateway
folder_size | 11476936808
total_files | 157620
current_snapshot_id | 4968899
is_deleted | f
id | 4968899
timestamp | 2023-06-02 20:21:20
cloud_folder_id | 93
is_temp | t
current_id | 4077097103
modified_time | 2023-06-28 17:59:17.92926
end_time |
current | t
changed | f
completed |
error |

Time: 42.189 ms