MTcyNGJjODdlMWJmNWVlMGUwYjkwNjJlM2I5OWEwOWYzZGEwNzEzNjhiYjFjZWRlY2I2MjJjNTY3YTk1NmVhMw.mu8cbwbp.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-09-19 11:15:42 (UTC)
1 row JSON CSV
pidageusenameclientstatequery
16405 {"milliseconds":1.591} postgres172.18.0.2:33948active
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-09-19 11:15:42 (UTC)
{}
Dev User dev@example.com
2026-09-19 03:13:30 (UTC)
{}
Dev User dev@example.com