Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace SqlBucket

Sql bucket type object.

Properties

Functions

Properties

bucketId

bucketId: string

SQL Bucket ID, examples <= 3 secs, 3-10 secs, 10-60 secs, 1-5 min, > 5 min Example: {@code "<= 3 secs"}

Optional cpuTimeInSec

cpuTimeInSec: undefined | number

Total CPU time Example: {@code 1046} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional databaseType

databaseType: undefined | string

Operations Insights internal representation of the database type.

Optional executionsCount

executionsCount: undefined | number

Total number of executions Example: {@code 60} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional ioTimeInSec

ioTimeInSec: undefined | number

Total IO time Example: {@code 5810} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional otherWaitTimeInSec

otherWaitTimeInSec: undefined | number

Total other wait time Example: {@code 24061} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

planHash

planHash: number

Plan hash value for the SQL Execution Plan Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

sqlIdentifier

sqlIdentifier: string

Unique SQL_ID for a SQL Statement.

timeCollected

timeCollected: Date

Collection timestamp Example: {@code "2020-03-31T00:00:00.000Z"}

Optional totalTimeInSec

totalTimeInSec: undefined | number

Total time Example: {@code 30917} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional version

version: undefined | number

Version Example: {@code 1} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Functions

getDeserializedJsonObj

  • getDeserializedJsonObj(obj: SqlBucket): object

getJsonObj