Advertisement
Guest User

Untitled

a guest
Sep 20th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. > EXPLAIN ANALYZE SELECT "reblog_of_id" FROM "statuses" WHERE ("reblog_of_id" = 11 OR "reblog_of_id" IS NULL) AND "account_id" = 1 ORDER BY "id" DESC;
  2. QUERY PLAN
  3. -----------------------------------------------------------------------------------------------------------------------------------------------------------
  4. Sort (cost=5391.51..5393.22 rows=3402 width=16) (actual time=49741.632..49741.844 rows=2716 loops=1)
  5. Sort Key: id DESC
  6. Sort Method: quicksort Memory: 224kB
  7. -> Bitmap Heap Scan on statuses (cost=38.43..5351.60 rows=3402 width=16) (actual time=3130.508..49736.730 rows=2716 loops=1)
  8. Recheck Cond: (account_id = 1)
  9. Filter: ((reblog_of_id = 11) OR (reblog_of_id IS NULL))
  10. Rows Removed by Filter: 1167
  11. Heap Blocks: exact=1601
  12. -> Bitmap Index Scan on index_statuses_on_account_id_id (cost=0.00..38.26 rows=4114 width=0) (actual time=3130.144..3130.144 rows=3884 loops=1)
  13. Index Cond: (account_id = 1)
  14. Planning time: 0.204 ms
  15. Execution time: 49742.133 ms
  16. (12 rows)
  17.  
  18. Time: 50096.524 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement