[local]:wyatt=# explain analyze select * from files where dataset = 1 and upload_time > '2019-01-02' and retention_policy = (select min(id) from retention_policies);
                                                                    QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
 Result  (cost=0.22..0.22 rows=0 width=0) (actual time=0.003..0.004 rows=0 loops=1)
   One-Time Filter: false
   InitPlan 2 (returns $1)
     ->  Result  (cost=0.21..0.22 rows=1 width=4) (never executed)
           InitPlan 1 (returns $0)
             ->  Limit  (cost=0.15..0.21 rows=1 width=4) (never executed)
                   ->  Index Only Scan using retention_policies_pkey on retention_policies  (cost=0.15..70.27 rows=1264 width=4) (never executed)
                         Index Cond: (id IS NOT NULL)
                         Heap Fetches: 0
 Planning Time: 0.555 ms
 Execution Time: 0.069 ms
(11 rows)

Time: 1.472 ms