explain analyze SELECT max(standard_buildroot.create_event) FROM buildroot_listing JOIN standard_buildroot ON buildroot_listing.buildroot_id = standard_buildroot.buildroot_id WHERE buildroot_listing.rpm_id IN (849093, 849094);
                                                                          QUERY PLAN                                                                          
--------------------------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=282987.68..282987.69 rows=1 width=4) (actual time=2269.508..2269.508 rows=1 loops=1)
   ->  Hash Join  (cost=174746.48..282779.51 rows=83267 width=4) (actual time=2009.133..2269.493 rows=7 loops=1)
         Hash Cond: (buildroot_listing.buildroot_id = standard_buildroot.buildroot_id)
         ->  Index Scan using buildroot_listing_rpms on buildroot_listing  (cost=0.58..85733.35 rows=83267 width=4) (actual time=0.020..0.050 rows=7 loops=1)
               Index Cond: (rpm_id = ANY ('{849093,849094}'::integer[]))
         ->  Hash  (cost=90382.29..90382.29 rows=5142129 width=8) (actual time=1921.891..1921.891 rows=5146457 loops=1)
               Buckets: 131072  Batches: 8  Memory Usage: 25146kB
               ->  Seq Scan on standard_buildroot  (cost=0.00..90382.29 rows=5142129 width=8) (actual time=0.005..820.152 rows=5146457 loops=1)
 Planning time: 0.309 ms
 Execution time: 2274.669 ms

020-01-21 13:37:01 UTC [14464]: [147-1] user=brew,db=brew LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp14464.102", size 17998736
2020-01-21 13:37:01 UTC [14464]: [148-1] user=brew,db=brew STATEMENT:  explain analyze SELECT max(standard_buildroot.create_event) FROM buildroot_listing JOIN standard_buildroot ON buildroot_listing.buildroot_id = standard_buildroot.buildroot_id WHERE buildroot_listing.rpm_id IN (849093, 849094);

 explain analyze SELECT max(create_event) FROM standard_buildroot where buildroot_id in (select buildroot_id from buildroot_listing WHERE rpm_id IN (849093, 849094));                                                                             QUERY PLAN                                                                             
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=86017.53..86017.54 rows=1 width=4) (actual time=0.251..0.251 rows=1 loops=1)
   ->  Nested Loop  (cost=85941.95..85954.91 rows=25051 width=4) (actual time=0.163..0.246 rows=7 loops=1)
         ->  HashAggregate  (cost=85941.52..85941.54 rows=2 width=4) (actual time=0.122..0.125 rows=7 loops=1)
               Group Key: buildroot_listing.buildroot_id
               ->  Index Scan using buildroot_listing_rpms on buildroot_listing  (cost=0.58..85733.35 rows=83267 width=4) (actual time=0.070..0.112 rows=7 loops=1)
                     Index Cond: (rpm_id = ANY ('{849093,849094}'::integer[]))
         ->  Index Scan using standard_buildroot_pkey on standard_buildroot  (cost=0.43..6.67 rows=1 width=8) (actual time=0.015..0.016 rows=1 loops=7)
               Index Cond: (buildroot_id = buildroot_listing.buildroot_id)
 Planning time: 0.461 ms
 Execution time: 0.313 ms