This topic is under construction for the 25.3 (March 2025) release.
Two links from
> Site > Admin Console > Diagnostics give administrators and troubleshooters insight into activity on the underlying Postgres database. These utilities can help when troubleshooting slow, blocked, or deadlocked queries.
Postgres Activity
Exposes Postgres's
pg_stat_activity view. This provides a listing of all database server processes with information about the current activity of that process. The
Query and
Threads and Requests links are provided when available to connect with activity within LabKey Server. The
Blocked By, State and Wait Event columns can help determine which other queries might be blocking or otherwise interfering with progress.
In cases where long running queries lock up the database, they can be stopped from this view. Note that this is only to be used in extreme cases. To delete a connection, use the checkbox to select only the relevant row, and click
. This action will kill that selected Postgres connection, terminating its operation. This action cannot be undone.
Postgres Locks
View the
pg_locks table, listing all locks held by active processes within the database.
Related Topics
