Query: db_running_queries

SELECT * FROM "users_select_or_insert"($1,$2,$3,$4,$5,$6);

-- BLOCK set_session
INSERT INTO
  user_sessions (session_id, user_id, data, updated_at, expires_at)
VALUES
  (
    $1,
    $2,
    $3::jsonb,
    now(),
    $4
  )
ON CONFLICT (session_id) DO UPDATE
SET
  user_id = $2,
  data = $3::jsonb,
  updated_at = now(),
  expires_at = $4;

SELECT * FROM "users_select_or_insert"($1,$2,$3,$4,$5,$6);

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;

-- BLOCK select_active_prairietest_reservation
WITH
  active_reservations AS (
    SELECT
      r.session_id,
      -- We consider a session to be "active" if either of the following is true:
      (
        -- The reservation is checked in but hasn't had their access start yet.
        -- We'll consider the reservation active for the first hour after check-in.
        r.checked_in IS NOT NULL
        AND r.access_start IS NULL
        AND r.access_end IS NULL
        AND $1 BETWEEN r.checked_in AND r.checked_in  + '1 hour'::interval
      )
      OR (
        -- The reservation has had their access start at some point, and the current
        -- time is within the access window.
        r.access_start IS NOT NULL
        AND $1 >= r.access_start
        AND (
          r.access_end IS NULL
          OR $1 < r.access_end
        )
      ) AS reservation_active,
      (
        -- PrairieTest accepts reports only while access is open.
        r.access_start IS NOT NULL
        AND $1 >= r.access_start