pid   | usename | datname | application_name | client_addr | state  |          query_start          |    duration     | wait_event_type | wait_event |                                                                                                               query                                                                                                                
---------+---------+---------+------------------+-------------+--------+-------------------------------+-----------------+-----------------+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 2883506 | hydra   | hydra   | hydra-server     | 10.0.40.2   | active | 2026-07-07 09:09:03.753775+00 | 00:12:07.250573 |                 |            | SELECT me.id, me.finished, me.timestamp, me.stoptime, me.jobset_id, me.job, me.nixname, me.system, me.buildstatus, me.releasename FROM builds me WHERE ( ( finished = $1 AND me.jobset_id = $2 ) ) ORDER BY stoptime DESC LIMIT $3
 2873792 | hydra   | hydra   | hydra-server     | 10.0.40.2   | active | 2026-07-07 09:09:10.72368+00  | 00:12:00.280668 |                 |            | SELECT me.id, me.finished, me.timestamp, me.stoptime, me.jobset_id, me.job, me.nixname, me.system, me.buildstatus, me.releasename FROM builds me WHERE ( ( finished = $1 AND me.jobset_id = $2 ) ) ORDER BY stoptime DESC LIMIT $3
 2883919 | hydra   | hydra   | hydra-server     | 10.0.40.2   | active | 2026-07-07 09:09:13.184196+00 | 00:11:57.820152 |                 |            | SELECT me.id, me.finished, me.timestamp, me.stoptime, me.jobset_id, me.job, me.nixname, me.system, me.buildstatus, me.releasename FROM builds me WHERE ( ( finished = $1 AND me.jobset_id = $2 ) ) ORDER BY stoptime DESC LIMIT $3
 2880936 | hydra   | hydra   | hydra-server     | 10.0.40.2   | active | 2026-07-07 09:09:28.558658+00 | 00:11:42.44569  |                 |            | SELECT me.id, me.finished, me.timestamp, me.stoptime, me.jobset_id, me.job, me.nixname, me.system, me.buildstatus, me.releasename FROM builds me WHERE ( ( finished = $1 AND me.jobset_id = $2 ) ) ORDER BY stoptime DESC LIMIT $3
 2882318 | hydra   | hydra   | hydra-server     | 10.0.40.2   | active | 2026-07-07 09:09:43.869771+00 | 00:11:27.134577 |                 |            | SELECT me.id, me.finished, me.timestamp, me.stoptime, me.jobset_id, me.job, me.nixname, me.system, me.buildstatus, me.releasename FROM builds me WHERE ( ( finished = $1 AND me.jobset_id = $2 ) ) ORDER BY stoptime DESC LIMIT $3
 2886527 | hydra   | hydra   | hydra-server     | 10.0.40.2   | active | 2026-07-07 09:10:06.176828+00 | 00:11:04.82752  |                 |            | SELECT me.id, me.finished, me.timestamp, me.stoptime, me.jobset_id, me.job, me.nixname, me.system, me.buildstatus, me.releasename FROM builds me WHERE ( ( finished = $1 AND me.jobset_id = $2 ) ) ORDER BY stoptime DESC LIMIT $3
 2875052 | hydra   | hydra   | hydra-server     | 10.0.40.2   | active | 2026-07-07 09:10:25.579051+00 | 00:10:45.425297 |                 |            | SELECT me.id, me.finished, me.timestamp, me.stoptime, me.jobset_id, me.job, me.nixname, me.system, me.buildstatus, me.releasename FROM builds me WHERE ( ( finished = $1 AND me.jobset_id = $2 ) ) ORDER BY stoptime DESC LIMIT $3
 2888877 | hydra   | hydra   | hydra-server     | 10.0.40.2   | active | 2026-07-07 09:10:49.780288+00 | 00:10:21.22406  |                 |            | SELECT me.id, me.finished, me.timestamp, me.stoptime, me.jobset_id, me.job, me.nixname, me.system, me.buildstatus, me.releasename FROM builds me WHERE ( ( finished = $1 AND me.jobset_id = $2 ) ) ORDER BY stoptime DESC LIMIT $3
 2927864 | hydra   | hydra   | hydra-server     | 10.0.40.2   | active | 2026-07-07 09:21:10.981574+00 | 00:00:00.022774 |                 |            | SELECT MAX( me.shortrevlength ) FROM jobsetevalinputs me WHERE ( uri = $1 )
 2930630 | hydra   | hydra   | hydra-server     |             | active | 2026-07-07 09:21:10.981574+00 | 00:00:00.022774 |                 |            | SELECT MAX( me.shortrevlength ) FROM jobsetevalinputs me WHERE ( uri = $1 )
 2930631 | hydra   | hydra   | hydra-server     |             | active | 2026-07-07 09:21:10.981574+00 | 00:00:00.022774 |                 |            | SELECT MAX( me.shortrevlength ) FROM jobsetevalinputs me WHERE ( uri = $1 )
 2930632 | hydra   | hydra   | hydra-server     |             | active | 2026-07-07 09:21:10.981574+00 | 00:00:00.022774 |                 |            | SELECT MAX( me.shortrevlength ) FROM jobsetevalinputs me WHERE ( uri = $1 )
 2930629 | hydra   | hydra   | hydra-server     |             | active | 2026-07-07 09:21:10.981574+00 | 00:00:00.022774 |                 |            | SELECT MAX( me.shortrevlength ) FROM jobsetevalinputs me WHERE ( uri = $1 )

hydra=# EXPLAIN (ANALYZE, BUFFERS)
SELECT
  id, finished, timestamp, stoptime, jobset_id, job, nixname,
  system, buildstatus, releasename
FROM builds
WHERE finished = 0
  AND jobset_id = 123
ORDER BY stoptime DESC
LIMIT 50;
                                                                        QUERY PLAN                                                                         
-----------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=0.57..14185.53 rows=50 width=120) (actual time=114.857..114.858 rows=0.00 loops=1)
   Buffers: shared hit=78753
   ->  Index Scan using indexbuildsonfinishedstoptime on builds  (cost=0.57..68939.47 rows=243 width=120) (actual time=114.857..114.857 rows=0.00 loops=1)
         Index Cond: (finished = 0)
         Filter: (jobset_id = 123)
         Rows Removed by Filter: 196472
         Index Searches: 1
         Buffers: shared hit=78753
 Planning:
   Buffers: shared hit=324
 Planning Time: 1.515 ms
 Execution Time: 114.872 ms

                                                                           QUERY PLAN                                                                           
----------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=0.57..51.01 rows=50 width=120) (actual time=0.306..0.372 rows=50.00 loops=1)
   Buffers: shared hit=53 read=1
   ->  Index Scan using builds_jobset_finished_stoptime_idx on builds  (cost=0.57..27046.02 rows=26812 width=120) (actual time=0.306..0.369 rows=50.00 loops=1)
         Index Cond: ((jobset_id = 318) AND (finished = 0))
         Index Searches: 1
         Buffers: shared hit=53 read=1
 Planning:
   Buffers: shared hit=16
 Planning Time: 0.476 ms
 Execution Time: 0.380 ms

CREATE INDEX CONCURRENTLY builds_jobset_finished_stoptime_idx
ON builds (jobset_id, finished, stoptime DESC);