YWZkZDk5MmM2MjJjOWVkMTFlYjg4ZDBhYjE3MzgyMDNjOTQ0MTQ4NTMyOWQxMDhmNDI2OGI0YTk3N2E2MzY5Zg.msfho9iz.eyJ1cmwiOiIvcGwvYWRtaW5pc3RyYXRvci9xdWVyeS9kYl9ydW5uaW5nX3F1ZXJpZXMiLCJhdXRobl91c2VyX2lkIjoiMSJ9
Skip to main content Accessibility guide
PrairieLearn Go home
  • Home
  • →
  • Global Admin
Load from disk
  • Dev User
    Course Requests Settings Log out
  • Administrators
  • Institutions
  • Courses
  • Requests
  • Queries
  • Workspaces
  • Features
  • Batched migrations
  • Settings

Query: db_running_queries

— Queries currently running in the DB.
Query ran at: 2026-08-05 01:40:35 (UTC)
1 row JSON CSV
pidageusenameclientstatequery
24911 {"milliseconds":2.491} postgres172.18.0.3:52522active
SELECT
  pid,
  age (clock_timestamp(), query_start),
  usename,
  host(client_addr) || ':' || client_port AS client,
  state,
  query
FROM
  pg_stat_activity
WHERE
  state != 'idle'
ORDER BY
  age DESC;
Recent query runs
Date Params User name User UID
2026-08-05 01:40:35 (UTC)
{}
Dev User dev@example.com
2026-08-04 21:36:04 (UTC)
{}
Dev User dev@example.com