-
Notifications
You must be signed in to change notification settings - Fork 663
Open
Description
I want to query the space usage of all users in the database, but why are there negative numbers?
SQL:
SELECT core_user.username, tenants_quotarow.path, tenants_quotarow.counter / (1024 * 1024 * 1024) AS counter_in_gb
FROM core_user
JOIN tenants_quotarow ON core_user.id = tenants_quotarow.user_id
ORDER BY tenants_quotarow.counter DESC;
Results:
+-------------------+----------------------+---------------+
| username | path | counter_in_gb |
+-------------------+----------------------+---------------+
| user1 | /files/files_temp | 392.4970 |
| user2 | /files/ | 347.2974 |
| user3 | /files/ | 320.8614 |
...
...
...
| user1001 | /files/files_temp | 0.0000 |
| user1002 | /files/files_temp | 0.0000 |
| user1003 | /files/files_temp | 0.0000 |
| user1004 | /files/files_temp | -0.0001 |
| user1005 | /files/files_temp | -0.0001 |
| user1006 | /files/ | -0.0002 |
| user1007 | /files/ | -1.8555 |
| user1008 | /files/ | -3.7923 |
| user1009 | /files/ | -10.6667 |
| user1010 | /files/ | -24.0484 |
| user1011 | /files/ | -381.7321 |
+-------------------+----------------------+---------------+
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels