a guest Apr 7th, 2015 207 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
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