Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- > 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;
- QUERY PLAN
- -----------------------------------------------------------------------------------------------------------------------------------------------------------
- Sort (cost=5391.51..5393.22 rows=3402 width=16) (actual time=49741.632..49741.844 rows=2716 loops=1)
- Sort Key: id DESC
- Sort Method: quicksort Memory: 224kB
- -> Bitmap Heap Scan on statuses (cost=38.43..5351.60 rows=3402 width=16) (actual time=3130.508..49736.730 rows=2716 loops=1)
- Recheck Cond: (account_id = 1)
- Filter: ((reblog_of_id = 11) OR (reblog_of_id IS NULL))
- Rows Removed by Filter: 1167
- Heap Blocks: exact=1601
- -> 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)
- Index Cond: (account_id = 1)
- Planning time: 0.204 ms
- Execution time: 49742.133 ms
- (12 rows)
- Time: 50096.524 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement