Guest User

Untitled

a guest
Apr 7th, 2015
245
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sort (cost=3002118.64..3002143.64 rows=10000 width=40) (actual time=7573.930..7574.303 rows=10000 loops=1)
  2. Sort Key: t.user_id, t.event_type, t.ts
  3. Sort Method: quicksort Memory: 1166kB
  4. Buffers: shared hit=9909
  5. CTE t
  6. -> WindowAgg (cost=0.29..854.26 rows=10000 width=24) (actual time=0.025..21.393 rows=10000 loops=1)
  7. Buffers: shared hit=9909
  8. -> Index Scan using events_fast_idx on events (cost=0.29..654.26 rows=10000 width=24) (actual time=0.016..9.437 rows=10000 loops=1)
  9. Buffers: shared hit=9909
  10. -> Nested Loop (cost=300.01..3000600.00 rows=10000 width=40) (actual time=28.542..7571.192 rows=10000 loops=1)
  11. Buffers: shared hit=9909
  12. -> CTE Scan on t (cost=0.00..200.00 rows=10000 width=32) (actual time=0.027..1.120 rows=10000 loops=1)
  13. Buffers: shared hit=3
  14. -> Limit (cost=300.01..300.01 rows=1 width=16) (actual time=0.756..0.756 rows=1 loops=10000)
  15. Buffers: shared hit=9906
  16. -> Sort (cost=300.01..300.01 rows=1 width=16) (actual time=0.756..0.756 rows=1 loops=10000)
  17. Sort Key: tt.ts
  18. Sort Method: quicksort Memory: 25kB
  19. Buffers: shared hit=9906
  20. -> CTE Scan on t tt (cost=0.00..300.00 rows=1 width=16) (actual time=0.374..0.755 rows=2 loops=10000)
  21. Filter: ((user_id = t.user_id) AND (event_type = t.event_type) AND (ts >= (t.ts - '30 days'::interval)))
  22. Rows Removed by Filter: 9998
  23. Buffers: shared hit=9906
  24. Planning time: 0.314 ms
  25. Execution time: 7574.815 ms
RAW Paste Data