Skip to content

Instantly share code, notes, and snippets.

@ashu210890

ashu210890/gist:c39cd7a38ce37f4baab2f58e1ade1403 Secret

Created May 31, 2018 12:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ashu210890/c39cd7a38ce37f4baab2f58e1ade1403 to your computer and use it in GitHub Desktop.
Save ashu210890/c39cd7a38ce37f4baab2f58e1ade1403 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
blocked_pid | blocked_user | blocking_pid | blocking_user | blocked_statement | current_statement_in_blocking_process
-------------+--------------+--------------+---------------+------------------------------------------------------------------------+------------------------------------------------------------------------
22379 | deploy | 22310 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22359 | deploy | 22310 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22339 | deploy | 22310 | deploy | SET application_name='puma: cluster worker 2: 24835 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22378 | deploy | 22310 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22313 | deploy | 22310 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22312 | deploy | 22310 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22379 | deploy | 22312 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22359 | deploy | 22312 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22339 | deploy | 22312 | deploy | SET application_name='puma: cluster worker 2: 24835 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22378 | deploy | 22312 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22313 | deploy | 22312 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22310 | deploy | 22312 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22379 | deploy | 22313 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22359 | deploy | 22313 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22339 | deploy | 22313 | deploy | SET application_name='puma: cluster worker 2: 24835 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22378 | deploy | 22313 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22310 | deploy | 22313 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22312 | deploy | 22313 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22379 | deploy | 22339 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 24835 [20180531113013]';
22359 | deploy | 22339 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 24835 [20180531113013]';
22378 | deploy | 22339 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 24835 [20180531113013]';
22313 | deploy | 22339 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 24835 [20180531113013]';
22310 | deploy | 22339 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 24835 [20180531113013]';
22312 | deploy | 22339 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 24835 [20180531113013]';
22379 | deploy | 22359 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22339 | deploy | 22359 | deploy | SET application_name='puma: cluster worker 2: 24835 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22378 | deploy | 22359 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22313 | deploy | 22359 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22310 | deploy | 22359 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22312 | deploy | 22359 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 1: 29036 [20180531113013]';
22379 | deploy | 22378 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22359 | deploy | 22378 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22339 | deploy | 22378 | deploy | SET application_name='puma: cluster worker 2: 24835 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22313 | deploy | 22378 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22310 | deploy | 22378 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22312 | deploy | 22378 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 2: 29036 [20180531113013]';
22359 | deploy | 22379 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22339 | deploy | 22379 | deploy | SET application_name='puma: cluster worker 2: 24835 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22378 | deploy | 22379 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22313 | deploy | 22379 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22310 | deploy | 22379 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22312 | deploy | 22379 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | SET application_name='puma: cluster worker 0: 29036 [20180531113013]';
22379 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22359 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22339 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 2: 24835 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22378 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22313 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22310 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22312 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22379 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22359 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22339 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 2: 24835 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22378 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22313 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 2: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22310 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 1: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
22312 | deploy | 18317 | deploy | SET application_name='puma: cluster worker 0: 29036 [20180531113013]'; | ALTER TABLE fb_revenues ALTER COLUMN id TYPE bigint;
@ashu210890
Copy link
Author

Query:

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
        AND blocking_locks.DATABASE IS NOT DISTINCT FROM blocked_locks.DATABASE
        AND blocking_locks.relation IS NOT DISTINCT FROM blocked_locks.relation
        AND blocking_locks.page IS NOT DISTINCT FROM blocked_locks.page
        AND blocking_locks.tuple IS NOT DISTINCT FROM blocked_locks.tuple
        AND blocking_locks.virtualxid IS NOT DISTINCT FROM blocked_locks.virtualxid
        AND blocking_locks.transactionid IS NOT DISTINCT FROM blocked_locks.transactionid
        AND blocking_locks.classid IS NOT DISTINCT FROM blocked_locks.classid
        AND blocking_locks.objid IS NOT DISTINCT FROM blocked_locks.objid
        AND blocking_locks.objsubid IS NOT DISTINCT FROM blocked_locks.objsubid
        AND blocking_locks.pid != blocked_locks.pid
 
    JOIN pg_catalog.pg_stat_activity blocking_activity ON blocking_activity.pid = blocking_locks.pid
   WHERE NOT blocked_locks.GRANTED;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment