gistfile1.txt

Feb 01 20:44:11 haumea postgres[5389]: [5389] LOG:  duration: 6063.921 ms  execute dbdpg_p9466_10: SELECT eval.id, eval.jobset_id, eval.errormsg, eval.errortime, eval.timestamp, eval.checkouttime, eval.evaltime, eval.hasnewbuilds, eval.hash, eval.nrbuilds, eval.nrsucceeded, eval.flake, eval.nixexprinput, eval.nixexprpath FROM jobsetevalmembers me  JOIN jobsetevals eval ON eval.id = me.eval WHERE ( me.build = $1 )
Feb 01 20:44:11 haumea postgres[5389]: [5389] DETAIL:  parameters: $1 = '58545348'


hydra=# explain analyze verbose SELECT eval.id, eval.jobset_id, eval.errormsg, eval.errortime, eval.timestamp, eval.checkouttime, eval.evaltime, eval.hasnewbuilds, eval.hash, eval.nrbuilds, eval.nrsucceeded, eval.flake, eval.nixexprinput, eval.nixexprpath FROM jobsetevalmembers me  JOIN jobsetevals eval ON eval.id = me.eval WHERE ( me.build = '58535116' );
 Nested Loop  (cost=1.00..295.86 rows=110 width=218) (actual time=0.534..0.732 rows=2 loops=1)
   Output: eval.id, eval.jobset_id, eval.errormsg, eval.errortime, eval."timestamp", eval.checkouttime, eval.evaltime, eval.hasnewbuilds, eval.hash, eval.nrbuilds, eval.nrsucceeded, eval.flake, eval.nixexprinput, eval.nixexprpath
   Inner Unique: true
   ->  Index Scan using indexjobsetevalmembersonbuild on public.jobsetevalmembers me  (cost=0.58..4.91 rows=110 width=4) (actual time=0.519..0.710 rows=2 loops=1)
         Output: me.eval, me.build, me.isnew
         Index Cond: (me.build = 58534116)
   ->  Index Scan using jobsetevals_pkey on public.jobsetevals eval  (cost=0.43..2.65 rows=1 width=218) (actual time=0.009..0.009 rows=1 loops=2)
         Output: eval.id, eval.jobset_id, eval.errormsg, eval.errortime, eval."timestamp", eval.checkouttime, eval.evaltime, eval.hasnewbuilds, eval.hash, eval.nrbuilds, eval.nrsucceeded, eval.flake, eval.nixexprinput, eval.nixexprpath
         Index Cond: (eval.id = me.eval)
 Planning Time: 0.232 ms
 Execution Time: 0.751 ms
(11 rows)