blocker Delay   |      57079 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |      29113 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1
blocker Delay   |       1746 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1
blocker Delay   |       1247 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Delay   |        668 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X
blocker Delay   |        419 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X
blocker Delay   |        260 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |        257 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Delay   |        224 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
blocker Delay   |        201 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |        189 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%')
blocker Delay   |        187 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC
blocker Delay   |        176 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |        158 COPY public.runvars (flight, job, name, val, synth) TO stdout;
blocker Delay   |        152 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Delay   |        137 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Delay   |        112 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Delay   |         93 COMMIT
blocker Delay   |         89 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
blocker Delay   |         84 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout;
blocker Delay   |         79 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |         71 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |         50 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |         41 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
blocker Delay   |         41 UPDATE tasks SET live = 'f' WHERE taskid = 366548
blocker Delay   |         34 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t'
blocker Delay   |         34 commit
blocker Delay   |         30 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1;
blocker Delay   |         27 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | <IDLE> in transaction
blocker Delay   |         21 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t')
blocker Delay   |         20 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |         20 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14
blocker Delay   |         20 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | <IDLE> in transaction
blocker Delay   |         20 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Delay   |         16 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5
blocker Delay   |         15 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X
blocker Delay   |         13 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13
blocker Delay   |         13 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Delay   |         13 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1
blocker Delay   |         13 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING')
blocker Delay   |         12 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X)
blocker Delay   |         12 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Delay   |         12 autovacuum: ANALYZE pg_catalog.pg_depend
blocker Delay   |         10 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Delay   |         10 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
blocker Delay   |          9 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X
blocker Delay   |          8 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |          8 autovacuum: VACUUM public.tasks
blocker Delay   |          7 commit | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |          6 <command string not enabled> | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |          6 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6
blocker Delay   |          5 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Delay   |          4 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING')
blocker Delay   |          3 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |          3 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1
blocker Delay   |          2 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |          1 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |          0 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING')
blocker Delay   |          0 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
blocker Delay   |          0 UPDATE tasks SET live = 'f' WHERE taskid = 366700
blocker Delay   |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3
blocker Delay   |          0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1
blocker Delay   |          0 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |          0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Delay   |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Delay   |          0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Delay   |          0 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |          0 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |          0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
blocker Delay   |          0 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend
blocker Delay   |          0 <command string not enabled>
blocker Delay   |          0 BEGIN
blocker Delay   |          0 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL )
blocker Delay   |          0 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing'
blocker Delay   |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13
blocker Delay   |          0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check')
blocker Delay   |          0 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING')
blocker Delay   |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC
blocker Delay   |          0 SELECT hostflag FROM hostflags WHERE hostname=$X
blocker Delay   |          0 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass'
blocker Delay   |          0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | <IDLE> in transaction
blocker Delay   |          0 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Delay   |          0 commit | <IDLE> in transaction
blocker Delay   |          0 SELECT blessing FROM flights WHERE flight=$X
blocker Delay   |          0 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X
blocker Delay   |          0 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
blocker Delay   |          0 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3
blocker Delay   |          0 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X
blocker Delay   |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
blocker Delay   |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20
blocker Delay   |          0 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | <IDLE> in transaction
blocker Delay   |         -1 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | <IDLE> in transaction
blocker Delay   |         -1 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | <IDLE> in transaction
blocker Delay   |         -1 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100
blocker Delay   |         -1 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | <IDLE> in transaction
blocker Delay   |         -2 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%'
blocker Delay   |         -2 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | <IDLE> in transaction
blocker Delay   |         -2 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | <IDLE> in transaction
blocker Delay   |         -2 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno
blocker Delay   |         -3 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
blocker Delay   |         -3 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | <IDLE> in transaction
blocker Delay   |         -4 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X
blocker Delay   |         -6 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | <IDLE> in transaction
blocker Delay   |         -6 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val
blocker Delay   |         -8 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | <IDLE> in transaction
blocker Delay   |        -12 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC
blocker Delay   |        -14 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
blocker Delay   |        -15 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | <IDLE> in transaction
blocker Delay   |        -29 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob'
blocker Delay   |        -93 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate'
blocker Delay   |        -96 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC
blocker Delay   |       -142 <UNKNOWN> | <IDLE> in transaction
blocker Delay   |      -3372 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid
blocker Tasks   |       6702 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid
blocker Tasks   |       4188 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |       1253 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1
blocker Tasks   |        880 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1;
blocker Tasks   |        360 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Tasks   |        323 <UNKNOWN> | <IDLE> in transaction
blocker Tasks   |        196 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC
blocker Tasks   |        187 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate'
blocker Tasks   |         90 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC
blocker Tasks   |         61 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob'
blocker Tasks   |         48 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |         44 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1
blocker Tasks   |         39 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |         39 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Tasks   |         34 COMMIT
blocker Tasks   |         29 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
blocker Tasks   |         29 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Tasks   |         29 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | <IDLE> in transaction
blocker Tasks   |         29 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Tasks   |         24 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |         21 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Tasks   |         19 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | <IDLE> in transaction
blocker Tasks   |         18 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%')
blocker Tasks   |         17 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |         16 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X
blocker Tasks   |         16 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
blocker Tasks   |         16 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X
blocker Tasks   |         13 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1
blocker Tasks   |         11 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | <IDLE> in transaction
blocker Tasks   |         10 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val
blocker Tasks   |         10 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
blocker Tasks   |         10 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          9 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X
blocker Tasks   |          9 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC
blocker Tasks   |          9 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Tasks   |          9 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
blocker Tasks   |          8 commit
blocker Tasks   |          8 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
blocker Tasks   |          7 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          6 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | <IDLE> in transaction
blocker Tasks   |          5 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%'
blocker Tasks   |          5 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | <IDLE> in transaction
blocker Tasks   |          5 COPY public.runvars (flight, job, name, val, synth) TO stdout;
blocker Tasks   |          5 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno
blocker Tasks   |          5 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Tasks   |          5 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout;
blocker Tasks   |          4 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | <IDLE> in transaction
blocker Tasks   |          4 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
blocker Tasks   |          4 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X
blocker Tasks   |          4 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100
blocker Tasks   |          4 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          4 <command string not enabled> | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          4 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | <IDLE> in transaction
blocker Tasks   |          4 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | <IDLE> in transaction
blocker Tasks   |          3 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Tasks   |          3 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1
blocker Tasks   |          3 <command string not enabled>
blocker Tasks   |          2 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t')
blocker Tasks   |          2 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X
blocker Tasks   |          2 autovacuum: VACUUM public.tasks
blocker Tasks   |          2 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | <IDLE> in transaction
blocker Tasks   |          2 SELECT blessing FROM flights WHERE flight=$X
blocker Tasks   |          2 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | <IDLE> in transaction
blocker Tasks   |          2 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
blocker Tasks   |          2 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Tasks   |          1 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          1 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | <IDLE> in transaction
blocker Tasks   |          1 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC
blocker Tasks   |          1 autovacuum: ANALYZE pg_catalog.pg_depend
blocker Tasks   |          1 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Tasks   |          1 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X)
blocker Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5
blocker Tasks   |          1 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Tasks   |          1 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          1 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING')
blocker Tasks   |          1 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13
blocker Tasks   |          1 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING')
blocker Tasks   |          1 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend
blocker Tasks   |          1 UPDATE tasks SET live = 'f' WHERE taskid = 366548
blocker Tasks   |          1 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
blocker Tasks   |          1 commit | <IDLE> in transaction
blocker Tasks   |          1 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING')
blocker Tasks   |          1 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | <IDLE> in transaction
blocker Tasks   |          1 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
blocker Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6
blocker Tasks   |          1 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass'
blocker Tasks   |          1 BEGIN
blocker Tasks   |          1 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check')
blocker Tasks   |          1 UPDATE tasks SET live = 'f' WHERE taskid = 366700
blocker Tasks   |          1 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Tasks   |          1 commit | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Tasks   |          1 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3
blocker Tasks   |          1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | <IDLE> in transaction
blocker Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3
blocker Tasks   |          1 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          1 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          1 SELECT hostflag FROM hostflags WHERE hostname=$X
blocker Tasks   |          1 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing'
blocker Tasks   |          1 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13
blocker Tasks   |          1 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X
blocker Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20
blocker Tasks   |          1 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1
blocker Tasks   |          1 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
blocker Tasks   |          1 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X
blocker Tasks   |          1 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t'
blocker Tasks   |          1 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL )
blocker Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14
blocker Tasks   |          1 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Tasks   |          1 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING')
blocker Tasks   |          0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |       4188 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |        359 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Waiters |         48 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |         39 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |         39 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Waiters |         29 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Waiters |         24 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |         21 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Waiters |         17 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |         10 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          9 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Waiters |          7 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          5 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Waiters |          4 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          4 <command string not enabled> | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          1 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          1 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Waiters |          1 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Waiters |          1 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          1 commit | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE
blocker Waiters |          1 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          1 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          1 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          1 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
blocker Waiters |          0 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t')
blocker Waiters |          0 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X
blocker Waiters |          0 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | <IDLE> in transaction
blocker Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC
blocker Waiters |          0 autovacuum: ANALYZE pg_catalog.pg_depend
blocker Waiters |          0 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%'
blocker Waiters |          0 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X
blocker Waiters |          0 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X
blocker Waiters |          0 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X)
blocker Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5
blocker Waiters |          0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC
blocker Waiters |          0 autovacuum: VACUUM public.tasks
blocker Waiters |          0 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING')
blocker Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
blocker Waiters |          0 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13
blocker Waiters |          0 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING')
blocker Waiters |          0 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend
blocker Waiters |          0 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid
blocker Waiters |          0 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | <IDLE> in transaction
blocker Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Waiters |          0 commit
blocker Waiters |          0 UPDATE tasks SET live = 'f' WHERE taskid = 366548
blocker Waiters |          0 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val
blocker Waiters |          0 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
blocker Waiters |          0 commit | <IDLE> in transaction
blocker Waiters |          0 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | <IDLE> in transaction
blocker Waiters |          0 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | <IDLE> in transaction
blocker Waiters |          0 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING')
blocker Waiters |          0 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | <IDLE> in transaction
blocker Waiters |          0 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
blocker Waiters |          0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1
blocker Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6
blocker Waiters |          0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1
blocker Waiters |          0 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
blocker Waiters |          0 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass'
blocker Waiters |          0 BEGIN
blocker Waiters |          0 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
blocker Waiters |          0 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | <IDLE> in transaction
blocker Waiters |          0 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X
blocker Waiters |          0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC
blocker Waiters |          0 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X
blocker Waiters |          0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check')
blocker Waiters |          0 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100
blocker Waiters |          0 <UNKNOWN> | <IDLE> in transaction
blocker Waiters |          0 UPDATE tasks SET live = 'f' WHERE taskid = 366700
blocker Waiters |          0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
blocker Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Waiters |          0 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3
blocker Waiters |          0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | <IDLE> in transaction
blocker Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3
blocker Waiters |          0 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1
blocker Waiters |          0 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1
blocker Waiters |          0 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | <IDLE> in transaction
blocker Waiters |          0 SELECT hostflag FROM hostflags WHERE hostname=$X
blocker Waiters |          0 SELECT blessing FROM flights WHERE flight=$X
blocker Waiters |          0 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing'
blocker Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13
blocker Waiters |          0 <command string not enabled>
blocker Waiters |          0 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X
blocker Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20
blocker Waiters |          0 COMMIT
blocker Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1
blocker Waiters |          0 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
blocker Waiters |          0 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X
blocker Waiters |          0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | <IDLE> in transaction
blocker Waiters |          0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
blocker Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Waiters |          0 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob'
blocker Waiters |          0 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t'
blocker Waiters |          0 COPY public.runvars (flight, job, name, val, synth) TO stdout;
blocker Waiters |          0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | <IDLE> in transaction
blocker Waiters |          0 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | <IDLE> in transaction
blocker Waiters |          0 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno
blocker Waiters |          0 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1;
blocker Waiters |          0 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC
blocker Waiters |          0 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
blocker Waiters |          0 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL )
blocker Waiters |          0 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%')
blocker Waiters |          0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate'
blocker Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14
blocker Waiters |          0 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING')
blocker Waiters |          0 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | <IDLE> in transaction
blocker Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
blocker Waiters |          0 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout;
blocker Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
blocker Waiters |          0 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | <IDLE> in transaction
direct  Delay   |      57079 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |      29113 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1
direct  Delay   |       1746 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1
direct  Delay   |       1247 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Delay   |        668 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X
direct  Delay   |        419 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X
direct  Delay   |        260 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |        257 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Delay   |        224 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
direct  Delay   |        201 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |        189 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%')
direct  Delay   |        187 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC
direct  Delay   |        176 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |        158 COPY public.runvars (flight, job, name, val, synth) TO stdout;
direct  Delay   |        152 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Delay   |        137 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Delay   |        112 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Delay   |         93 COMMIT
direct  Delay   |         89 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
direct  Delay   |         84 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout;
direct  Delay   |         79 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |         71 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |         50 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |         41 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
direct  Delay   |         41 UPDATE tasks SET live = 'f' WHERE taskid = 366548
direct  Delay   |         34 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t'
direct  Delay   |         34 commit
direct  Delay   |         30 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1;
direct  Delay   |         27 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | <IDLE> in transaction
direct  Delay   |         21 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t')
direct  Delay   |         20 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |         20 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14
direct  Delay   |         20 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | <IDLE> in transaction
direct  Delay   |         20 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Delay   |         16 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5
direct  Delay   |         15 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X
direct  Delay   |         13 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13
direct  Delay   |         13 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Delay   |         13 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1
direct  Delay   |         13 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING')
direct  Delay   |         12 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X)
direct  Delay   |         12 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Delay   |         12 autovacuum: ANALYZE pg_catalog.pg_depend
direct  Delay   |         10 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Delay   |         10 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
direct  Delay   |          9 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X
direct  Delay   |          8 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |          8 autovacuum: VACUUM public.tasks
direct  Delay   |          7 commit | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |          6 <command string not enabled> | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |          6 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6
direct  Delay   |          5 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Delay   |          4 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING')
direct  Delay   |          3 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |          3 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1
direct  Delay   |          2 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |          1 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |          0 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING')
direct  Delay   |          0 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
direct  Delay   |          0 UPDATE tasks SET live = 'f' WHERE taskid = 366700
direct  Delay   |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3
direct  Delay   |          0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1
direct  Delay   |          0 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |          0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Delay   |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Delay   |          0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Delay   |          0 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |          0 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |          0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
direct  Delay   |          0 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend
direct  Delay   |          0 <command string not enabled>
direct  Delay   |          0 BEGIN
direct  Delay   |          0 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL )
direct  Delay   |          0 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing'
direct  Delay   |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13
direct  Delay   |          0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check')
direct  Delay   |          0 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING')
direct  Delay   |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC
direct  Delay   |          0 SELECT hostflag FROM hostflags WHERE hostname=$X
direct  Delay   |          0 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass'
direct  Delay   |          0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | <IDLE> in transaction
direct  Delay   |          0 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Delay   |          0 commit | <IDLE> in transaction
direct  Delay   |          0 SELECT blessing FROM flights WHERE flight=$X
direct  Delay   |          0 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X
direct  Delay   |          0 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
direct  Delay   |          0 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3
direct  Delay   |          0 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X
direct  Delay   |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
direct  Delay   |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20
direct  Delay   |          0 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | <IDLE> in transaction
direct  Delay   |         -1 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | <IDLE> in transaction
direct  Delay   |         -1 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | <IDLE> in transaction
direct  Delay   |         -1 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100
direct  Delay   |         -1 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | <IDLE> in transaction
direct  Delay   |         -2 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%'
direct  Delay   |         -2 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | <IDLE> in transaction
direct  Delay   |         -2 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | <IDLE> in transaction
direct  Delay   |         -2 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno
direct  Delay   |         -3 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
direct  Delay   |         -3 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | <IDLE> in transaction
direct  Delay   |         -4 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X
direct  Delay   |         -6 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | <IDLE> in transaction
direct  Delay   |         -6 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val
direct  Delay   |         -8 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | <IDLE> in transaction
direct  Delay   |        -12 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC
direct  Delay   |        -14 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
direct  Delay   |        -15 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | <IDLE> in transaction
direct  Delay   |        -29 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob'
direct  Delay   |        -93 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate'
direct  Delay   |        -96 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC
direct  Delay   |       -142 <UNKNOWN> | <IDLE> in transaction
direct  Delay   |      -3372 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid
direct  Tasks   |       6702 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid
direct  Tasks   |       4188 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |       1253 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1
direct  Tasks   |        880 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1;
direct  Tasks   |        360 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Tasks   |        323 <UNKNOWN> | <IDLE> in transaction
direct  Tasks   |        196 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC
direct  Tasks   |        187 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate'
direct  Tasks   |         90 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC
direct  Tasks   |         61 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob'
direct  Tasks   |         48 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |         44 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1
direct  Tasks   |         39 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Tasks   |         39 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |         34 COMMIT
direct  Tasks   |         29 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
direct  Tasks   |         29 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Tasks   |         29 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | <IDLE> in transaction
direct  Tasks   |         29 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Tasks   |         24 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |         21 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Tasks   |         19 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | <IDLE> in transaction
direct  Tasks   |         18 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |         18 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%')
direct  Tasks   |         16 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X
direct  Tasks   |         16 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
direct  Tasks   |         16 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X
direct  Tasks   |         13 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1
direct  Tasks   |         11 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | <IDLE> in transaction
direct  Tasks   |         10 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val
direct  Tasks   |         10 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
direct  Tasks   |         10 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          9 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X
direct  Tasks   |          9 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC
direct  Tasks   |          9 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Tasks   |          9 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
direct  Tasks   |          8 commit
direct  Tasks   |          8 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
direct  Tasks   |          7 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          6 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | <IDLE> in transaction
direct  Tasks   |          5 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%'
direct  Tasks   |          5 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | <IDLE> in transaction
direct  Tasks   |          5 COPY public.runvars (flight, job, name, val, synth) TO stdout;
direct  Tasks   |          5 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno
direct  Tasks   |          5 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Tasks   |          5 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout;
direct  Tasks   |          4 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | <IDLE> in transaction
direct  Tasks   |          4 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
direct  Tasks   |          4 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X
direct  Tasks   |          4 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100
direct  Tasks   |          4 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          4 <command string not enabled> | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          4 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | <IDLE> in transaction
direct  Tasks   |          4 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | <IDLE> in transaction
direct  Tasks   |          3 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Tasks   |          3 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1
direct  Tasks   |          3 <command string not enabled>
direct  Tasks   |          2 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t')
direct  Tasks   |          2 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X
direct  Tasks   |          2 autovacuum: VACUUM public.tasks
direct  Tasks   |          2 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | <IDLE> in transaction
direct  Tasks   |          2 SELECT blessing FROM flights WHERE flight=$X
direct  Tasks   |          2 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          2 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | <IDLE> in transaction
direct  Tasks   |          2 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
direct  Tasks   |          2 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Tasks   |          1 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | <IDLE> in transaction
direct  Tasks   |          1 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC
direct  Tasks   |          1 autovacuum: ANALYZE pg_catalog.pg_depend
direct  Tasks   |          1 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Tasks   |          1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          1 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X)
direct  Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5
direct  Tasks   |          1 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Tasks   |          1 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          1 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING')
direct  Tasks   |          1 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13
direct  Tasks   |          1 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING')
direct  Tasks   |          1 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend
direct  Tasks   |          1 UPDATE tasks SET live = 'f' WHERE taskid = 366548
direct  Tasks   |          1 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
direct  Tasks   |          1 commit | <IDLE> in transaction
direct  Tasks   |          1 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING')
direct  Tasks   |          1 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | <IDLE> in transaction
direct  Tasks   |          1 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
direct  Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6
direct  Tasks   |          1 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass'
direct  Tasks   |          1 BEGIN
direct  Tasks   |          1 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check')
direct  Tasks   |          1 UPDATE tasks SET live = 'f' WHERE taskid = 366700
direct  Tasks   |          1 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Tasks   |          1 commit | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Tasks   |          1 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3
direct  Tasks   |          1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | <IDLE> in transaction
direct  Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3
direct  Tasks   |          1 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          1 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          1 SELECT hostflag FROM hostflags WHERE hostname=$X
direct  Tasks   |          1 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing'
direct  Tasks   |          1 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13
direct  Tasks   |          1 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X
direct  Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20
direct  Tasks   |          1 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1
direct  Tasks   |          1 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
direct  Tasks   |          1 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X
direct  Tasks   |          1 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t'
direct  Tasks   |          1 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL )
direct  Tasks   |          1 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14
direct  Tasks   |          1 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Tasks   |          1 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING')
direct  Waiters |       4188 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |        359 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Waiters |         48 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |         39 COMMIT | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Waiters |         39 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |         29 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Waiters |         24 <UNKNOWN> | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |         21 UPDATE tasks SET live = 'f' WHERE taskid = 366700 | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Waiters |         18 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |         10 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          9 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Waiters |          7 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          5 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Waiters |          4 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1 | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          4 <command string not enabled> | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          2 COMMIT | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          1 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Waiters |          1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          1 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          1 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Waiters |          1 autovacuum: VACUUM public.tasks | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          1 commit | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          1 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | LOCK TABLE resources IN EXCLUSIVE MODE
direct  Waiters |          1 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%') | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          1 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          1 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t') | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          1 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X | LOCK TABLE flights IN EXCLUSIVE MODE
direct  Waiters |          0 INSERT INTO runvars VALUES ($X,$X,$X,$X,'t')
direct  Waiters |          0 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X
direct  Waiters |          0 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X | <IDLE> in transaction
direct  Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND status = 'pass' AND branch = $X AND (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AND TRUE AND (TRUE) ORDER BY blessing, flights.started DESC
direct  Waiters |          0 autovacuum: ANALYZE pg_catalog.pg_depend
direct  Waiters |          0 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%'
direct  Waiters |          0 SELECT * FROM tasks WHERE taskid=$X AND type=$X AND refkey=$X
direct  Waiters |          0 SELECT * FROM hostflags WHERE hostname = $X AND hostflag = $X
direct  Waiters |          0 SELECT * FROM resources JOIN hostflags ON (restype='host' AND shareix=0 AND resname=hostname AND hostflag=$X)
direct  Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=5
direct  Waiters |          0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC
direct  Waiters |          0 autovacuum: VACUUM public.tasks
direct  Waiters |          0 INSERT INTO steps VALUES ('100648', 'test-amd64-i386-xl-qemut-winxpsp3', 13, 'ts-guest-localmigrate', 'running', 'STARTING')
direct  Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
direct  Waiters |          0 UPDATE steps SET testid='guest-destroy', started=1472443597 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=13
direct  Waiters |          0 INSERT INTO steps VALUES ('100637', 'test-amd64-amd64-qemuu-nested-intel', 19, 'ts-logs-capture', 'running', 'STARTING')
direct  Waiters |          0 autovacuum: VACUUM ANALYZE pg_catalog.pg_shdepend
direct  Waiters |          0 SELECT *, extract(epoch from a.backend_start) as osstest_backend_start, extract(epoch from a.xact_start) as osstest_xact_start, extract(epoch from a.query_start) as osstest_query_start FROM pg_locks l FULL JOIN pg_stat_activity a ON l.pid = a.procpid
direct  Waiters |          0 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | <IDLE> in transaction
direct  Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='libvirt') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Waiters |          0 commit
direct  Waiters |          0 UPDATE tasks SET live = 'f' WHERE taskid = 366548
direct  Waiters |          0 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val
direct  Waiters |          0 UPDATE steps SET testid='leak-check/basis/dst_host(14)', started=1472225729 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
direct  Waiters |          0 commit | <IDLE> in transaction
direct  Waiters |          0 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100 | <IDLE> in transaction
direct  Waiters |          0 SELECT * FROM runvars WHERE flight=$X AND job=$X AND name LIKE E'built\_revision\_%' | <IDLE> in transaction
direct  Waiters |          0 INSERT INTO steps VALUES ('100632', 'test-amd64-i386-pair', 11, 'ts-host-ping-check', 'running', 'STARTING')
direct  Waiters |          0 <UNKNOWN> | LOCK TABLE flights IN EXCLUSIVE MODE | LOCK TABLE resources IN EXCLUSIVE MODE | <IDLE> in transaction
direct  Waiters |          0 UPDATE steps SET testid='leak-check/check', started=1472414727 WHERE flight='FFFFF' AND job='JJJJJ' AND stepno=14
direct  Waiters |          0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1
direct  Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=6
direct  Waiters |          0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM flights_harness_touched t WHERE harness != $X AND t.flight = flights.flight) AND EXISTS (SELECT * FROM flights_harness_touched t WHERE t.flight = flights.flight) ORDER BY flight DESC LIMIT 1
direct  Waiters |          0 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
direct  Waiters |          0 SELECT val FROM runvars WHERE flight=FFFFF AND job='JJJJJ' AND name='pause_on_pass'
direct  Waiters |          0 BEGIN
direct  Waiters |          0 SELECT * FROM flights f WHERE EXISTS ( SELECT 1 FROM runvars r WHERE name=$X AND val=$X AND r.flight=f.flight AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') ) AND ( (TRUE) AND (blessing='real' OR blessing='adhoc' OR blessing='play') ) AND (branch=$X) ORDER BY flight DESC LIMIT 1
direct  Waiters |          0 SELECT flight, job, name, val FROM runvars WHERE (name = 'host' or name like '%_host') AND (val =...) AND (flight > FFFFF) AND (TRUE) ORDER BY flight DESC LIMIT (200 * 3 + 100) * $X | <IDLE> in transaction
direct  Waiters |          0 SELECT count(*) FROM jobs WHERE flight=$X AND job=$X
direct  Waiters |          0 SELECT flights.flight, steps.status, (NOT EXISTS (SELECT * FROM steps check_steps WHERE check_steps.flight = flights.flight AND check_steps.status = 'broken')) AS notbroken FROM flights JOIN steps USING (flight) WHERE job = $X AND testid = $X AND blessing = $X AND (status = 'fail' OR status = 'pass') AND branch = $X AND TRUE AND (TRUE) ORDER BY notbroken DESC, flights.started DESC
direct  Waiters |          0 SELECT flight, val FROM runvars WHERE name like '%job' AND val like '%.%' AND flight >= $X
direct  Waiters |          0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate' AND finished <= (SELECT finished FROM tsteps WHERE tsteps.testid = 'migrate-support-check')
direct  Waiters |          0 SELECT * FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 100
direct  Waiters |          0 <UNKNOWN> | <IDLE> in transaction
direct  Waiters |          0 UPDATE tasks SET live = 'f' WHERE taskid = 366700
direct  Waiters |          0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
direct  Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.6-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Waiters |          0 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = 'pg_extension'::regclass AND deptype = 'e' ORDER BY 3
direct  Waiters |          0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') )) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name; | <IDLE> in transaction
direct  Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=3
direct  Waiters |          0 SELECT finished, testid, status AS laststepstatus FROM steps WHERE flight=$X AND job=$X AND finished IS NOT NULL ORDER BY finished DESC LIMIT 1
direct  Waiters |          0 SELECT * FROM flights JOIN jobs j USING (flight) WHERE j.job=$X AND j.status='pass' AND (blessing='real' OR blessing='real-bisect') AND (TRUE) AND 0 = ( SELECT count(*) FROM ( SELECT name,val FROM runvars WHERE runvars.flight = flights.flight AND job=$X AND synth='f' ) o FULL OUTER JOIN bisection_runvars want USING (name) WHERE (o.val = want.val) IS NOT TRUE ) ORDER BY flights.started desc LIMIT 1
direct  Waiters |          0 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob' | <IDLE> in transaction
direct  Waiters |          0 SELECT hostflag FROM hostflags WHERE hostname=$X
direct  Waiters |          0 SELECT blessing FROM flights WHERE flight=$X
direct  Waiters |          0 UPDATE flights SET blessing='running' WHERE flight=FFFFF AND blessing='constructing'
direct  Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=13
direct  Waiters |          0 <command string not enabled>
direct  Waiters |          0 SELECT val FROM runvars WHERE flight=$X AND job=$X AND name=$X
direct  Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=20
direct  Waiters |          0 COMMIT
direct  Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real' OR blessing='real-bisect') ) LIMIT 1
direct  Waiters |          0 SELECT val FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
direct  Waiters |          0 SELECT * FROM resource_properties WHERE restype='host' AND resname=$X
direct  Waiters |          0 SELECT f.flight AS flight, f.started AS started, j.status AS status FROM flights f JOIN jobs j USING (flight) JOIN runvars r ON f.flight=r.flight AND r.name=$X WHERE j.job=r.job AND f.blessing=$X AND f.branch=$X AND j.job=$X AND r.val=$X AND (j.status='pass' OR j.status='fail' OR j.status='truncated') AND f.started IS NOT NULL AND f.started >= $X ORDER BY f.started DESC | <IDLE> in transaction
direct  Waiters |          0 SELECT DISTINCT name FROM runvars JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) AND flight >= COALESCE( ( SELECT flight FROM jobs JOIN flights USING (flight) WHERE (job = $X AND ( (TRUE) AND (blessing='real') ) AND branch = $X) ORDER BY flight DESC LIMIT 1 OFFSET 99 ), 0) ORDER BY name;
direct  Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-unstable') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Waiters |          0 SELECT name || '= ' AS why, val AS job FROM runvars WHERE flight = $X AND job = $X AND name LIKE '%buildjob'
direct  Waiters |          0 DELETE FROM runvars WHERE flight=$X AND job=$X AND name=$X AND synth='t'
direct  Waiters |          0 COPY public.runvars (flight, job, name, val, synth) TO stdout;
direct  Waiters |          0 SELECT * FROM flights WHERE (branch = $X) AND (blessing=$X) AND NOT EXISTS (SELECT * FROM runvars r WHERE (name = $X OR name = $X) AND val != '' AND NOT (val = $X OR val LIKE $X) AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight) AND EXISTS (SELECT * FROM runvars r WHERE name = $X AND ( (CASE WHEN (r.job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') AND r.flight = flights.flight AND val != '') ORDER BY flight DESC LIMIT 1 | <IDLE> in transaction
direct  Waiters |          0 SELECT flight, job, val FROM runvars WHERE flight=$X AND job=$X AND name=$X AND ( (CASE WHEN (job) LIKE 'build-%-prev' THEN 'xprev' ELSE '' END) = '') GROUP BY flight, job, val | <IDLE> in transaction
direct  Waiters |          0 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno
direct  Waiters |          0 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1;
direct  Waiters |          0 SELECT f.flight AS flight FROM steps s JOIN flights f ON s.flight=f.flight WHERE s.job=$X AND f.blessing=$X AND f.branch=$X AND s.finished IS NOT NULL AND f.started IS NOT NULL AND f.started >= $X ORDER BY s.finished DESC
direct  Waiters |          0 SELECT * FROM resource_properties WHERE restype = $X AND resname = $X AND name = $X
direct  Waiters |          0 CREATE TEMP TABLE tmp_build_info ( use varchar NOT NULL, name varchar NOT NULL, val varchar NOT NULL, job varchar NOT NULL )
direct  Waiters |          0 SELECT refkey AS dbname, username, comment FROM tasks WHERE type = 'xdbref' AND live AND username LIKE ($X || '@%')
direct  Waiters |          0 WITH tsteps AS ( SELECT * FROM steps WHERE flight='FFFFF' AND job='JJJJJ' ) SELECT sum(finished-started) AS duration FROM tsteps WHERE step != 'ts-hosts-allocate'
direct  Waiters |          0 UPDATE steps SET status='pass', finished=FINISHED WHERE flight=FFFFF AND job='JJJJJ' AND stepno=14
direct  Waiters |          0 INSERT INTO steps VALUES ('100630', 'build-i386-rumpuserxen', 6, 'ts-xen-build', 'running', 'STARTING')
direct  Waiters |          0 SELECT flight, job, val, status FROM flights f JOIN jobs j USING (flight) JOIN runvars r USING (flight,job) WHERE j.job=$X AND f.blessing=$X AND f.branch=$X AND r.name=$X AND r.val IN ( SELECT hostname FROM hostflags WHERE hostflag IN ( SELECT hostflag FROM hostflags WHERE hostname=$X AND hostflag LIKE 'equiv-%' ) ) ORDER BY f.started DESC LIMIT 1; | <IDLE> in transaction
direct  Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1 | <IDLE> in transaction
direct  Waiters |          0 COPY public.steps (flight, job, stepno, step, status, testid, started, finished) TO stdout;
direct  Waiters |          0 SELECT * FROM flights JOIN steps USING (flight) WHERE (branch='xen-4.5-testing') AND job=$X and testid=$X and status='pass' AND ( (TRUE) AND (blessing='real') ) LIMIT 1
direct  Waiters |          0 SELECT * FROM steps WHERE flight=$X AND job=$X AND status!='pass' ORDER BY stepno | <IDLE> in transaction