marklr

SELECT blocked_locks.pid         AS blocked_pid,
       blocked_activity.usename  AS blocked_user,
	   now() - blocked_activity.query_start
		                         AS blocked_duration,
       blocking_locks.pid        AS blocking_pid,
       blocking_activity.usename AS blocking_user,
	   now() - blocking_activity.query_start
                                 AS blocking_duration,
       blocked_activity.query    AS blocked_statement,
       blocking_activity.query   AS blocking_statement

marklr

http {
    # ...
    # 51Degrees data file; should be updated regularly.
    51D_filePath  /data/51Degrees-PremiumV3_2.dat;
    51D_cache 0;  # crucial - otherwise crashes might occur

    lua_need_request_body on;
    upstream backend {
        least_conn;
        keepalive 32;