用户资源查询

1. 查询所有用户的资源限额和资源使用情况。

   1	SELECT * FROM PG_TOTAL_USER_RESOURCE_INFO;

   例如，当前所有用户的资源使用情况如下：

   1234567

   username | used_memory | total_memory | used_cpu | total_cpu | used_space | total_space | used_temp_space | total_temp_space | used_spill_space | total_spill_space | read_kbytes | write_kbytes | read_counts | write_counts | read_speed | write_speed----------+-------------+--------------+----------+-----------+------------+-------------+-----------------+------------------+------------------+-------------------+-------------+--------------+-------------+--------------+------------+-------------perfadm | 0 | 17250 | 0 | 0 | 0 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 usern | 0 | 17250 | 0 | 48 | 0 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 userg | 34 | 15525 | 23.53 | 48 | 0 | -1 | 0 | -1 | 814955731 | -1 | 6111952 | 1145864 | 763994 | 143233 | 42678 | 8001 userg1 | 34 | 13972 | 23.53 | 48 | 0 | -1 | 0 | -1 | 814972419 | -1 | 6111952 | 1145864 | 763994 | 143233 | 42710 | 8007 (4 rows)

2. 查询具体某个用户的资源限额和资源使用情况。

   1	SELECT * FROM GS_WLM_USER_RESOURCE_INFO('username');

   例如，查询Tom的资源使用情况：

   12345

   SELECT * FROM GS_WLM_USER_RESOURCE_INFO('Tom');userid | used_memory | total_memory | used_cpu | total_cpu | used_space | total_space | used_temp_space | total_temp_space | used_spill_space | total_spill_space | read_kbytes | write_kbytes | read_counts | write_counts | read_speed | write_speed-------+-------------+--------------+----------+-----------+------------+-------------+-----------------+------------------+------------------+-------------------+-------------+--------------+-------------+--------------+------------+------------- 16523 | 18 | 2831 | 0 | 19 | 0 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0(1 row)

3. 查询具体某个用户的IO资源使用情况。

   1	SELECT * FROM pg_user_iostat('username');

   例如，查询Tom的IO资源使用情况：

   12345

   SELECT * FROM pg_user_iostat('Tom');userid | min_curr_iops | max_curr_iops | min_peak_iops | max_peak_iops | io_limits | io_priority-------+---------------+---------------+---------------+---------------+-----------+------------- 16523 | 0 | 0 | 0 | 0 | 0 | None(1 row)