dimabory

---

Request:

GET /api/history/?auth_key={auth_key}&event={0|1|2}[&album={[0-9]+}&offset={[0-9]+}&limit={[0-9]+}&from_datetime={from_timestamp}&to_datetime={to_timestamp}]

Query Params

auth_key - required, string 

event - required, integer, one of [0, 1, 2], 0 - DELETED, 1 - CHANGED, 2 - ADDED

dimabory

 SELECT blocked_locks.pid     AS blocked_pid,
         blocked_activity.usename  AS blocked_user,
         blocking_locks.pid     AS blocking_pid,
         blocking_activity.usename AS blocking_user,
         blocked_activity.query    AS blocked_statement,
         blocking_activity.query   AS current_statement_in_blocking_process
   FROM  pg_catalog.pg_locks         blocked_locks
    JOIN pg_catalog.pg_stat_activity blocked_activity  ON blocked_activity.pid = blocked_locks.pid
    JOIN pg_catalog.pg_locks         blocking_locks
        ON blocking_locks.locktype = blocked_locks.locktype