active_waiting_queries

Active waiting queries

Dimensions:None

Available on:

Datadog (1)

Interface Metrics (1)

Datadog

postgresql.active_waiting_queries

Enabled with `collect_activity_metrics`. The number of waiting queries in this database in state active. This metric (by default) is tagged with db, app, user.

Dimensions:None

Sources

postgresql.active_waiting_queriesgithub.com

Technical Annotations (7)

Configuration Parameters (1)

lock_timeoutrecommended: 5s

Prevents queries from waiting indefinitely for locks

CLI Commands (3)

SELECT pid, usename, pg_blocking_pids(pid) AS blocked_by, query AS waiting_query, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event_type = 'Lock';

diagnostic

SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid IN (SELECT unnest(pg_blocking_pids(waiting_pid)));remediation

SELECT pg_cancel_backend(pid);remediation

Technical References (3)

pg_stat_activitycomponentpg_blocking_pidscomponentwait_event_typecomponent

Related Insights (1)

Queries blocked by lock contention wait indefinitely without timeoutwarning

▸