Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. GroupAggregate (cost=364639.91..387330.55 rows=206279 width=13) (actual time=11319.768..14212.760 rows=99996 loops=1)
  2. Group Key: _user, _session_id
  3. -> Sort (cost=364639.91..369796.87 rows=2062785 width=13) (actual time=11319.747..13626.636 rows=2062858 loops=1)
  4. Sort Key: _user, _session_id
  5. Sort Method: external merge Disk: 52400kB
  6. -> Seq Scan on view_page (cost=0.00..113037.85 rows=2062785 width=13) (actual time=0.007..897.178 rows=2062858 loops=1)
  7. Planning time: 0.189 ms
  8. Execution time: 14239.138 ms
  9.  
  10. EXPLAIN ANALYZE SELECT count(*)
  11. FROM
  12. "demo_ecommerce"."view_page"
  13. GROUP BY "_user", "_session_id"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement