Anonymous

koji=# explain SELECT task.id, state, create_time, completion_time, channel_id, host_id, parent, label, waiting, awaited, owner, method, arch, priority, weight, request, result, users.name, users.usertype
koji-#   FROM task
koji-#   JOIN users ON task.owner = users.id
koji-#
koji-#  ORDER BY completion_time DESC;
                                QUERY PLAN
---------------------------------------------------------------------------
 Sort  (cost=370374.23..371505.34 rows=452444 width=1002)
   Sort Key: task.completion_time
   ->  Hash Join  (cost=12.48..95066.58 rows=452444 width=1002)
         Hash Cond: ("outer"."owner" = "inner".id)
         ->  Seq Scan on task  (cost=0.00..88267.44 rows=452444 width=988)
         ->  Hash  (cost=10.98..10.98 rows=598 width=18)
               ->  Seq Scan on users  (cost=0.00..10.98 rows=598 width=18)