SELECT datname, usename, pid, state_change AS query_start,
                  CASE WHEN state='idle in transaction' THEN '<IDLE> in transaction' WHEN state = 'idle' THEN '<IDLE>' ELSE query END AS query
                FROM pg_catalog.pg_stat_activity
                WHERE datname='prebook'
                ORDER BY usename, pid