table | description |
---|---|
account | List of accounts with access to DES Portal and SmartGrid.API. |
account__device | Just the mapping table between Account and Device tables. |
account__permission_role | Just the mapping table between Account and PermissionRole tables. |
adapter | List of device adapters. |
alerts | Triggered alerts per device. |
apikey | SmartGrid.Api API keys. |
automat_group_internal_beats | Cron expressions per group of devices |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
relname AS objectname, | |
relkind AS objecttype, | |
reltuples AS "#entries", pg_size_pretty(relpages::bigint*8*1024) AS size | |
FROM pg_class | |
WHERE relpages >= 8 | |
ORDER BY relpages DESC; |