Display user quota in "user-info"

[beatrizserrano]

When users request quota increase I check their actual disk usage with this very useful command:

gxadmin report user-info EMAIL

It would be cool to see also their current quota, which would help to check whether the quota was properly increased. Is it something that could be easily added? Or maybe: Is there a better way to check the quota for a specific user?

Thank you :)

[hexylena]

Definitely a good feature request! The quota tables are ... gross. to say the least, so, it may be difficult.

[hexylena]

e.g. you need to do math and handle the = + and - operations and their precedence, it's possible, just no fun.

galaxy=> select pg_size_pretty(bytes), operation, deleted from quota limit 10;
 pg_size_pretty | operation | deleted
----------------+-----------+---------
 2048 GB        | =         | t
 2048 GB        | =         | f
 -1 bytes       | =         | f
 250 GB         | =         | f
 11 GB          | =         | f
 500 GB         | =         | f
 750 GB         | =         | f
 1024 GB        | +         | f
 512 GB         | +         | f
 750 GB         | +         | f
(10 rows)