Created
March 19, 2013 21:33
-
-
Save zain/5200350 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| QUERY PLAN | |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| Limit (cost=471953.26..471953.38 rows=50 width=77) (actual time=2523.902..2524.063 rows=50 loops=1) | |
| -> Sort (cost=471953.26..472037.42 rows=33664 width=77) (actual time=2523.898..2523.952 rows=50 loops=1) | |
| Sort Key: (max(date)) | |
| Sort Method: top-N heapsort Memory: 36kB | |
| -> GroupAggregate (cost=461030.36..470834.96 rows=33664 width=77) (actual time=2230.769..2520.320 rows=1681 loops=1) | |
| Filter: bool_or(is_inbox) | |
| -> Sort (cost=461030.36..461616.85 rows=234595 width=77) (actual time=1158.555..1430.159 rows=215157 loops=1) | |
| Sort Key: thread_id | |
| Sort Method: external merge Disk: 17288kB | |
| -> Bitmap Heap Scan on mail_email (cost=7671.08..440104.71 rows=234595 width=77) (actual time=71.234..570.075 rows=215157 loops=1) | |
| Recheck Cond: (account_id = 2) | |
| -> Bitmap Index Scan on mail_email_account_id (cost=0.00..7612.43 rows=234595 width=0) (actual time=41.919..41.919 rows=219611 loops=1) | |
| Index Cond: (account_id = 2) | |
| Total runtime: 2528.705 ms |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment