How do I query the service tablespace usage on ServiceCenter?

Hello, dear!

Have a nice day!

You can query the service tablespace usage on ServiceCenter by performing the following steps:

Step 1 Use PuTTY and the floating IP address of ServiceCenter to log in to the ServiceCenter node as user galaxmanager.
           Default password of user galaxmanager: Huawei@CLOUD8
Step 2 Run the following command to enter the engineering mode:
           gotoEngineerMode
           Default password: Huawei@CLOUD8!
           Run the following command to disable logout on timeout:
          TMOUT=0
Step 3 Run the following command to switch to user dbadmin:
           su dbadmin
Step 4 Run the following command to access the database:
           gsql -W Manager@123
Step 5 Run the following commands to query the service tablespace usage:
           SELECT nspname || '.' || relname AS "relation",
           pg_size_pretty(pg_total_relation_size(C.oid)) AS "size"
           FROM pg_class C
           LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
           WHERE nspname NOT IN ('PG_CATALOG','PG_TOAST','INFORMATION_SCHEMA')
           ORDER BY pg_total_relation_size(C.oid) DESC;
The following figure shows an example of the query result.

Any further questions, let us know!