---
title: "postgres-list-active-queries"
type: docs
weight: 1
description: >
  The "postgres-list-active-queries" tool lists currently active queries in a Postgres database.
---

## About

The `postgres-list-active-queries` tool retrieves information about currently
active queries in a Postgres database.

`postgres-list-active-queries` lists detailed information as JSON for currently
active queries. The tool takes the following input parameters:

- `min_duraton` (optional): Only show queries running at least this long (e.g.,
  '1 minute', '1 second', '2 seconds'). Default: '1 minute'.
- `exclude_application_names` (optional): A comma-separated list of application
  names to exclude from the query results. This is useful for filtering out
  queries from specific applications (e.g., 'psql', 'pgAdmin', 'DBeaver'). The
  match is case-sensitive. Whitespace around commas and names is automatically
  handled. If this parameter is omitted, no applications are excluded.
- `limit` (optional): The maximum number of rows to return. Default: `50`.

## Compatible Sources

{{< compatible-sources others="integrations/alloydb, integrations/cloud-sql-pg">}}

## Example

```yaml
kind: tool
name: list_active_queries
type: postgres-list-active-queries
source: postgres-source
description: List the top N (default 50) currently running queries (state='active') from pg_stat_activity, ordered by longest-running first. Returns pid, user, database, application_name, client_addr, state, wait_event_type/wait_event, backend/xact/query start times, computed query_duration, and the SQL text.
```

The response is a json array with the following elements:

```json
{
  "pid": "process id",
  "user": "database user name",
  "datname": "database name",
  "application_name": "connecting application name",
  "client_addr": "connecting client ip address",
  "state": "connection state",
  "wait_event_type": "connection wait event type",
  "wait_event": "connection wait event",
  "backend_start": "connection start time",
  "xact_start": "transaction start time",
  "query_start": "query start time",
  "query_duration": "query duration",
  "query": "query text"
}
```

## Reference

| **field**   | **type** | **required** | **description**                                    |
|-------------|:--------:|:------------:|----------------------------------------------------|
| type        |  string  |     true     | Must be "postgres-list-active-queries".            |
| source      |  string  |     true     | Name of the source the SQL should execute on.      |
| description |  string  |     true     | Description of the tool that is passed to the LLM. |
