[Feature] Sort performers and studios by size of files on disk

[ryosaeba75]

Is your feature request related to a problem? Please describe.
I'd like to be able to sort Performers and Studios by file size on disks. In particular for scenes, but It can be extended to gallery and images to.

Describe the solution you'd like
Right now you can sort by scene count/gallery count/image count, this feature would add, the following options "Scenes size on disk", "Galleries size on disk" and "Images size on disk" and would display the total size instead of the scene/gallery/image count in the card/row of the corresponding view

See the following examples :

Describe alternatives you've considered
At least for the scenes (I don't really use gallery/image right now), I've made some graphql (with sql query) that will display performers/studios order by total file size but having it directly in the stash webui would be better.

Additional context
Add any other context or screenshots about the feature request here.

[doneisenhower]

Hi there, I was searching for a similar feature and found your issue. Would you mind sharing your GraphQL query please?

[ryosaeba75]

Hi there, I was searching for a similar feature and found your issue. Would you mind sharing your GraphQL query please?

Those are the query that I used. They are probably not perfect, but they do the job.

Filesize per performer:

{"query":"mutation ($sql: String!) {\n  querySQL(sql: $sql) {\n    columns\n    rows\n  }\n}","variables":{"sql":"SELECT sum(C.size)/(1024*1024*1024) as fileSize , E.name FROM scenes as A, scenes_files as B, files as C , performers_scenes AS D, performers as E WHERE A.id = B.scene_id AND B.file_id = C.id  AND A.id = D.scene_id AND E.id = D.performer_id GROUP BY D.performer_id ORDER BY fileSize DESC"},"operationName":null}

Filesize per studio

{"query":"mutation ($sql: String!) {\n  querySQL(sql: $sql) {\n    columns\n    rows\n  }\n}","variables":{"sql":"SELECT sum(C.size)/(1024*1024*1024) as fileSize , D.name FROM scenes as A, scenes_files as B, files as C , studios AS D WHERE A.id = B.scene_id AND B.file_id = C.id  AND A.studio_id = D.id GROUP BY D.id ORDER BY fileSize DESC"},"operationName":null}