Skip to content

Instantly share code, notes, and snippets.

@lfittl

lfittl/friends

Created September 3, 2009 17:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save lfittl/180412 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save lfittl/180412 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
friends
Limit (cost=0.00..620.06 rows=40 width=16) (actual time=1.187..55.320 rows=40 loops=1)
-> Index Scan Backward using posts_for_friendposts on posts (cost=0.00..2698009.85 rows=174048 width=16) (actual time=1.186..55.305 rows=40 loops=1)
Filter: (blog_id = ANY ('{10,168485,34010,153723,2328,50727,50227,151291,137223,16891,108471,42878,139618,115804,2664,79,122698,129025,119355,122050,27614,7,1,4,8,9,11,12,15,23,24,32,41,47,10470,56,60,67,70,82,1912,2093,2252,2292,4431,7359,13163,13454,17771,27687,28251,35620,11139,28895,22987,30864,864,35835,36914,19306,14356,2367,23299,48,871,27,35725,94511,53870,43202,69,64245,76507,43870,78181,55870,48082,57072,57187,63113,64,9542,36937,46332,56926,60464,8274,22585,9380,55473,60938,28799,37935,33073}'::bigint[]))
Total runtime: 55.364 ms
Raw
friends
Limit (cost=0.00..978.14 rows=40 width=16) (actual time=0.554..33.189 rows=40 loops=1)
-> Index Scan Backward using posts_for_friendposts on posts (cost=0.00..2291882.89 rows=93724 width=16) (actual time=0.554..33.178 rows=40 loops=1)
Filter: (blog_id = ANY ('{121329,48,55293,123579,4514,44615,45388,31604,35091,99765,82,14,8,32,26146,2,8599,2664,32749,27208,864,48869,876,40659,10869,23,44076,8448,5658}'::bigint[]))
Total runtime: 33.222 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment