--- /dev/null
+select
+ hosts.name,
+ shares.name,
+ backups.num,
+ date::abstime
+from backups
+ join hosts on hosts.id = hostid
+ join shares on shares.id = shareid
+where backups.id not in (select backup_id from backup_parts) and inc_size != -1
+order by hosts.name, shares.name ;
+