Views the information about the instances that are running in a project. The information includes InstanceID, Owner, Type, StartTime, Progress, Status, Priority, RuntimeUsage (CPU/MEM), totalUsage (CPU/MEM), and QueueingInfo (POS/LEN).

Syntax

-- View the information about the running instances that are submitted by the current account in the current project. 
top instance;
-- Return the information about all or a specified number of running instances in the current project. 
top instance [-all][-limit <number>];

Parameters

  • -all: optional. Information about all jobs that are running in the current project is returned. By default, information about up to 50 jobs can be returned.
  • -limit number: optional. Information about a specified number of jobs that are running in the current project is returned.

Examples

-- Return the information about the first five instances that are running in the current project. 
top instance -limit 5;
The following result is returned: 
QueueingInstances: 0 total.

Related statements

  • SHOW: Views the information about an instance. The information includes StartTime (accurate to the second), RunTime (in seconds), Status, InstanceID, Owner, and Query statements.
  • STATUS: Views the status of the specified instance.
  • KILL: Stops a specific instance.
  • DESC INSTANCE: Obtains job information based on a specified instance ID. The information includes SQL, Owner, StartTime, EndTime, and Status.
  • WAIT: Obtains the run logs of jobs based on a specified instance ID. The return result includes the URL of Logview.