launchpad_dogfood=# EXPLAIN (ANALYZE ON, BUFFERS ON) SELECT 1 FROM (SELECT branch.id FROM branch, product WHERE branch.product = product.id AND product.name = 'launchpad' AND branch.lifecycle_status IN (10, 30, 50) LIMIT 1) AS "_tmp" LIMIT 1;
                                                                             QUERY PLAN                                                                              
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=0.71..80.34 rows=1 width=0) (actual time=0.150..0.151 rows=1 loops=1)
   Buffers: shared hit=92
   ->  Subquery Scan on _tmp  (cost=0.71..80.34 rows=1 width=0) (actual time=0.150..0.150 rows=1 loops=1)
         Buffers: shared hit=92
         ->  Limit  (cost=0.71..80.33 rows=1 width=4) (actual time=0.149..0.149 rows=1 loops=1)
               Buffers: shared hit=92
               ->  Nested Loop  (cost=0.71..398.78 rows=5 width=4) (actual time=0.149..0.149 rows=1 loops=1)
                     Buffers: shared hit=92
                     ->  Index Scan using product_name_key on product  (cost=0.29..8.31 rows=1 width=4) (actual time=0.014..0.014 rows=1 loops=1)
                           Index Cond: (name = 'launchpad'::text)
                           Buffers: shared hit=3
                     ->  Index Scan using branch__product__owner__name__key on branch  (cost=0.42..389.66 rows=81 width=8) (actual time=0.128..0.128 rows=1 loops=1)
                           Index Cond: (product = product.id)
                           Filter: (lifecycle_status = ANY ('{10,30,50}'::integer[]))
                           Rows Removed by Filter: 87
                           Buffers: shared hit=89
 Total runtime: 0.231 ms
(17 rows)