SHARE
TWEET

Untitled

a guest Sep 11th, 2019 107 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [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);  
  2.                                                                     QUERY PLAN                                                                    
  3. --------------------------------------------------------------------------------------------------------------------------------------------------
  4.  Result  (cost=0.22..0.22 rows=0 width=0) (actual time=0.003..0.004 rows=0 loops=1)
  5.    One-Time Filter: false
  6.    InitPlan 2 (returns $1)
  7.      ->  Result  (cost=0.21..0.22 rows=1 width=4) (never executed)
  8.            InitPlan 1 (returns $0)
  9.              ->  Limit  (cost=0.15..0.21 rows=1 width=4) (never executed)
  10.                    ->  Index Only Scan using retention_policies_pkey on retention_policies  (cost=0.15..70.27 rows=1264 width=4) (never executed)
  11.                          Index Cond: (id IS NOT NULL)
  12.                          Heap Fetches: 0
  13.  Planning Time: 0.555 ms
  14.  Execution Time: 0.069 ms
  15. (11 rows)
  16.  
  17. Time: 1.472 ms
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top