Performance tables

This cheat sheet provides quick access to common commands for querying performance tables. For more detailed information, see the Monitoring Queries guide.

Query Operation Performance Log

// Query the Query Operation Performance Log for today's data
def qopl = db.liveTable("DbInternal", "QueryOperationPerformanceLogCoreV2").where("Date=today()")

# Query the Query Operation Performance Log for today's data
qopl = db.live_table("DbInternal", "QueryOperationPerformanceLogCoreV2").where(
    "Date=today()"
)

Update Performance Log

// Query the Update Performance Log for today's data
def upl = db.liveTable("DbInternal", "UpdatePerformanceLogCoreV2").where("Date=today()")

# Query the Update Performance Log for today's data
upl = db.live_table("DbInternal", "UpdatePerformanceLogCoreV2").where("Date=today()")

Persistent Query State Log

// Query the Persistent Query State Log for today's data
def pqsl = db.liveTable("DbInternal", "PersistentQueryStateLog").where("Date=today()")

# Query the Persistent Query State Log for today's data
pqsl = db.live_table("DbInternal", "PersistentQueryStateLog").where("Date=today()")

Process Event Log

// Query the Process Event Log for today's data
def pel = db.liveTable("DbInternal", "ProcessEventLog").where("Date=today()")

# Query the Process Event Log for today's data
pel = db.live_table("DbInternal", "ProcessEventLog").where("Date=today()")

Performance overview function

// By ProcessInfoID
performanceOverviewByPiid("52e806dd-af75-412c-a286-ec29aa5571d2")

// By worker name
performanceOverviewByWorkerName("worker_12")

// By PQ name
performanceOverviewByPqName("PqName")

# By ProcessInfoID
performance_overview("52e806dd-af75-412c-a286-ec29aa5571d2")

# By worker name
performance_overview(worker_name="worker_12")

# By PQ name
performance_overview(pq_name="PqName")