postgres-list-active-queries

About

The postgres-list-active-queries tool retrieves information about currently active queries in a Postgres database. It’s compatible with any of the following sources:

• alloydb-postgres
• cloud-sql-postgres
• postgres

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.

Example

tools:
  list_active_queries:
    kind: 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:

{
  "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