Advertisement
chrissharp123

Untitled

Mar 10th, 2017
280
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. explain analyze select id from asset.copy;
  2. QUERY PLAN
  3. --------------------------------------------------------------------------------------------------------------------------
  4. Append (cost=0.00..557613.50 rows=16244050 width=8) (actual time=0.014..8145.281 rows=15345529 loops=1)
  5. -> Seq Scan on copy (cost=0.00..557601.90 rows=16243890 width=8) (actual time=0.014..5387.758 rows=15345529 loops=1)
  6. -> Seq Scan on unit (cost=0.00..11.60 rows=160 width=8) (actual time=0.006..0.006 rows=0 loops=1)
  7. Planning time: 0.343 ms
  8. Execution time: 9683.594 ms
  9. (5 rows)
  10.  
  11. Time: 9684.805 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement