gistfile1.txt

hydra=> explain analyze verbose select count(1) from builds;


QUERY PLAN                                                                                                                                                                                   
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Finalize Aggregate  (cost=8301759.17..8301759.18 rows=1 width=8) (actual time=1076414.408..1076416.606 rows=1 loops=1)
   Output: count(1)
   ->  Gather  (cost=8301758.96..8301759.17 rows=2 width=8) (actual time=1076414.325..1076416.599 rows=3 loops=1)
         Output: (PARTIAL count(1))
         Workers Planned: 2
         Workers Launched: 2
         ->  Partial Aggregate  (cost=8300758.96..8300758.97 rows=1 width=8) (actual time=1076412.596..1076412.597 rows=1 loops=3)
               Output: PARTIAL count(1)
               Worker 0: actual time=1076411.866..1076411.867 rows=1 loops=1
               Worker 1: actual time=1076411.812..1076411.813 rows=1 loops=1
               ->  Parallel Seq Scan on public.builds  (cost=0.00..8165283.77 rows=54190077 width=0) (actual time=0.030..1073703.122 rows=43419746 loops=3)
                     Output: id, finished, "timestamp", project, jobset, job, nixname, description, drvpath, system, license, homepage, maintainers, iscurrent, nixexprinput, nixexprpath, maxsilent, timeout, priority, starttime, stoptime, iscachedbuild, buildstatus, size, closuresize, releasename, keep, globalpriority, ischannel, notificationpendingsince, jobset_id
                     Worker 0: actual time=0.030..1073732.535 rows=42713128 loops=1
                     Worker 1: actual time=0.050..1073686.412 rows=43780208 loops=1
 Planning Time: 0.106 ms
 Execution Time: 1076417.192 ms
(16 rows)