---
title: Performance tables
---

This cheat sheet provides quick access to common commands for querying performance tables. For more detailed information, see the [Monitoring Queries guide](../performance/monitor-queries.md).

## Query Operation Performance Log

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

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

## Update Performance Log

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

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

## Persistent Query State Log

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

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

## Process Event Log

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

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

## Performance overview function

```python
# 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")
```

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

// By worker name
performanceOverviewByWorkerName("worker_12")

// By PQ name
performanceOverviewByPqName("PqName")
```