Guest User

Untitled

a guest
Jan 3rd, 2012
40
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. db=# explain analyze SELECT "Threads"."Id" FROM "Threads" WHERE "Threads"."BoardId" = 33 ORDER BY "Threads"."IsAnnouncement" DESC, "Threads"."LastPostId" DESC LIMIT 40 OFFSET 0;
  2. QUERY PLAN
  3.  
  4. -------------------------------------------------------------------------------------------------------------------------------------------------------------------
  5. Limit (cost=0.00..19.12 rows=40 width=10) (actual time=0.060..0.290 rows=40 loops=1)
  6. -> Index Scan using "Threads_IsAnnouncement_LastPostId_idx" on "Threads" (cost=0.00..37730.25 rows=78921 width=10) (actual time=0.058..0.284 rows=40 loops=1)
  7. Filter: ("BoardId" = 33)
  8. Total runtime: 0.332 ms
  9. (4 rows)
  10.  
  11.  
  12. db=#
RAW Paste Data