Advertisement
Guest User

Untitled

a guest
Jan 3rd, 2012
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. db=# explain analyze SELECT "Threads"."Id" FROM "Threads" WHERE "Threads"."BoardId" = 33 ORDER BY "Threads"."IsAnnouncement" DESC, "Threads"."LastPostId" DESC;
  2. QUERY PLAN
  3.  
  4. ------------------------------------------------------------------------------------------------------------------------
  5. Sort (cost=24114.75..24311.36 rows=78641 width=10) (actual time=350.795..387.558 rows=78889 loops=1)
  6. Sort Key: "IsAnnouncement", "LastPostId"
  7. Sort Method: external merge Disk: 1688kB
  8. -> Seq Scan on "Threads" (cost=0.00..16376.06 rows=78641 width=10) (actual time=0.031..154.760 rows=78889
  9. loops=1)
  10. Filter: ("BoardId" = 33)
  11. Total runtime: 399.372 ms
  12. (6 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement