SHOW STATS

SHOW STATS语句显示最近STATS作业收集的图空间统计信息。

图空间统计信息包含：

  • 点的总数
  • 边的总数
  • 每个Tag关联的点的总数
  • 每个Edge type关联的边的总数

前提条件

在需要查看统计信息的图空间中执行SUBMIT JOB STATS。详情请参见SUBMIT JOB STATS。

Caution

SHOW STATS的结果取决于最后一次执行的SUBMIT JOB STATS。如果发生过新的写入或者更改，必须再次执行SUBMIT JOB STATS，否则统计数据有错误。

语法

  1. SHOW STATS;

示例

  1. # 选择图空间。
  2. nebula> USE basketballplayer;
  4. # 执行SUBMIT JOB STATS。
  5. nebula> SUBMIT JOB STATS;
  6. +------------+
  7. | New Job Id |
  8. +------------+
  9. | 98         |
  10. +------------+
  12. # 确认作业执行成功。
  13. nebula> SHOW JOB 98;
  14. +----------------+---------------+------------+------------+------------+
  15. | Job Id(TaskId) | Command(Dest) | Status     | Start Time | Stop Time  |
  16. +----------------+---------------+------------+------------+------------+
  17. | 98             | "STATS"       | "FINISHED" | 1606552675 | 1606552675 |
  18. +----------------+---------------+------------+------------+------------+
  19. | 0              | "storaged2"   | "FINISHED" | 1606552675 | 1606552675 |
  20. +----------------+---------------+------------+------------+------------+
  21. | 1              | "storaged0"   | "FINISHED" | 1606552675 | 1606552675 |
  22. +----------------+---------------+------------+------------+------------+
  23. | 2              | "storaged1"   | "FINISHED" | 1606552675 | 1606552675 |
  24. +----------------+---------------+------------+------------+------------+
  26. # 显示图空间统计信息。
  27. nebula> SHOW STATS;
  28. +---------+------------+-------+
  29. | Type    | Name       | Count |
  30. +---------+------------+-------+
  31. | "Tag"   | "player"   | 51    |
  32. +---------+------------+-------+
  33. | "Tag"   | "team"     | 30    |
  34. +---------+------------+-------+
  35. | "Edge"  | "like"     | 81    |
  36. +---------+------------+-------+
  37. | "Edge"  | "serve"    | 152   |
  38. +---------+------------+-------+
  39. | "Space" | "vertices" | 81    |
  40. +---------+------------+-------+
  41. | "Space" | "edges"    | 233   |
  42. +---------+------------+-------+

最后更新: June 23, 2021