SHOW STATS

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

图空间统计信息包含:

  • 点的总数
  • 边的总数
  • 每个标签关联的点的总数
  • 每个边类型关联的边的总数

前提条件

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

说明SHOW STATS的结果取决于最近一次执行的SUBMIT JOB STATS,如果您需要更新结果,请再次执行SUBMIT JOB STATS

语法

  1. SHOW STATS;

示例

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