OTRhODk2YzQyMmUwYTRiMzlkMmNhOTJjMGYzZTAxYzQ3OTc4YWVjM2NkOTYwZmUwNDEzZDM4MWE0ZmE3MjM3MQ.msfcj634.eyJ1cmwiOiIvcGwvYWRtaW5pc3RyYXRvci9xdWVyaWVzIiwiYXV0aG5fdXNlcl9pZCI6IjEifQ
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

Queries

course_instance_active_enrollments Course instances that are active within a given date range.
course_instance_compute_time Course instances compute time within a given date range.
course_instances_usage Course instances usage data.
current_activity_by_assessment Assessments that have had submissions within a recent time interval.
current_activity_by_course_instance Course instances that have had submissions within a recent time interval.
db_query_cancel Cancel a running query (graceful kill).
db_query_terminate Terminate a running query (hard kill).
db_running_queries Queries currently running in the DB.
find_courses_by_user Finds users and their courses.
generate_and_enroll_users Generate random users and enroll them in a course instance
generate_assessment_instances Simulates all students enrolled in a course starting an assessment. For group assessments, groups must have been created.
generate_submissions Creates a random submission for each assessment instance in an assessment. Assessment instances must already exist and be open. Submission is saved, but not graded.
institutions_usage Institutions usage data.
instructors_by_institution Return a list of instructors by institution
lti13_roster_sync_readiness Inventory active LTI 1.3 instances, institution identity prerequisites, and UIN backfill gaps before roster-sync rollout.
select_or_insert_user Select or insert a user from the users table.
workspace_hosts_update_state Update the state of a workspace host.