ASP Report Information

Start Time

Start time.

End Time

End time.

Slot Count

Number of time segments for displaying indicators.

Elapsed Time

Time segment for generating a report.

Sample Count

Total number of samples for generating ASP report.

Slice Count

Total number of samplings.

Average Active Sessions

Average number of active sessions.

Boundary Time

Time point when samples in the memory and disk samples are split.

Data Source

Number of samples from memory and number of samples from disk in the samples for which the ASP report is generated.

Host Node Name

Node name.

CPUs

Total number of CPU cores.

Cores

Number of cores per CPU.

Sockets

Number of CPU slots.

Physical Memory

Memory size.

GaussDB Version

GaussDB Kernel version.

Client Addr

Client address.

User Id

User ID.

Application Name

Name of the client connection program.

%Activity

Percentage of activity (Total number of active sessions/Number of samples).

Avg Active Sessions

Average number of active sessions (Total number of active sessions/Number of aspects).

sample_time (x_axis)

Sampling time.

count (y_axis)

Number of sampled events.

Wait Status

Wait status name.

Wait Status Count

Number of wait statuses.

%Wait Status

Percentage of wait status (Number of wait status/Number of samples).

Avg Active Session

Average number of active wait status sessions (Number of wait status sessions/Number of aspects).

Event

Name of a wait event.

Event Count

Number of wait events.

smaple_time (x_axis)

Sampling time.

count (y_axis)

Number of sampled events.

Session Id

Session ID.

Session Start

Session start event.

Session Count

Number of active sessions.

%Activity

Percentage of activity (Total number of active sessions/Number of samples).

User Id

User ID.

Application Name

Name of the connection program.

Client Addr

Client address.

Client Port

Client port information.

Event

Active session event.

Event Count

Number of wait events of the session.

%Event

Percentage of session events (Number of events/Number of samples).

Slot time

Slot time.

Session Id

Session ID.

Session Start

Session start event.

Session Count

Number of session events.

%Activity

Percentage of activity (Total number of active sessions/Number of samples).

User Id

User ID.

Application Name

Name of the connection program.

Client Addr

Client address.

Client Port

Client port information.

Event

Active session event.

Event Count

Number of wait events of the session.

%Event

Percentage of session events (Number of events/Number of samples).

Session Id

Session ID.

Session Start

Session start event.

Session Count

Number of session events.

%Activity

Percentage of activity.

User Id

User ID.

Application Name

Name of the connection program.

Client Addr

Client address.

Client Port

Client port information.

SQL Id

SQL ID.

Node Id

Node ID.

SQL Text

SQL statement.

Slot Time

Slot time.

Session Id

Session ID.

Session Start

Session start event.

Session Count

Number of session events.

%Activity

Percentage of activity (Total number of active sessions/Number of samples).

User Id

User ID.

Application Name

Name of the connection program.

Client Addr

Client address.

Client Port

Client port information.

SQL Id

SQL ID.

Node Id

Node ID.

SQLText

SQL statement.

Slot Time

Slot time.

Final Blocking Session Id

ID of a blocked session.

Session Start

Start time of a session that holds a lock.

Blocked count

Number of sessions blocked by the session.

Blocked%Activity

Percentage of blocked sessions to active sessions (Total number of blocked sessions/Number of samples).

Event Caused

A wait event of final blocking session.

Event Caused Count

Number of wait events of final blocking session.

%Event

Percentage of wait events (Number of wait events/Number of samples).

PID

Thread ID.

User Id

User ID.

Application Name

Name of the connection program.

Client Addr

Client address.

Client Port

Client port information.

Xact Start Time

Start time of a transaction that holds a lock.

Global Session Id

Global session ID.

Slot Time

Slot time.

Lock Tag

Lock tag.

Lock Mode

Lock mode.

Waiting Session Count

Number of waiting sessions.

Waiting Session Id

ID of a session waiting for a lock.

Session Start

Start time of a session that waits for a lock.

Session Count

Number of sessions that waits for a lock.

Block Session Id

ID of a blocked session.

Final Block Session Id

Session ID in the header of the blocked queue.

PID

Thread ID.

User Id

User ID.

Application Name

Name of the connection program.

Client Addr

Client address.

Client Port

Client port information.

Xact Start Time

Start time of a transaction that holds a lock.

Global Session Id

Global session ID.

SQL Id

SQL ID.

Query Start

Start time of the SQL statement.

SQL Count

Number of SQL statements.

Node Id

Node ID.

SQL Text

SQL statement.

SQL Id

SQL ID.

Node Id

Node ID.

User Id

User ID.

Count

Number of session events.

%Activity

Percentage of activity (Total number of SQL sessions/Number of samples).

Event

Active session event.

Event Count

Number of wait events.

%Event

Percentage of session events (Number of SQL events/Number of samples).

SQL Text

SQL statement.

Slot Time

Slot time.

SQL Id

SQL ID.

Node Id

Node ID.

User Id

User ID.

Count

Number of session events.

%Activity

Percentage of activity (Total number of SQL sessions/Number of samples).

Event

Active session event.

Event Count

Number of wait events.

%Event

Percentage of session events (Number of SQL events/Number of samples).

SQL Text

SQL statement.

SQL Id

SQL ID.

Node Id

Node ID.

User Id

User ID.

SQL Text

SQL statement.