Last active
December 21, 2015 09:08
-
-
Save alq666/6282566 to your computer and use it in GitHub Desktop.
This file contains 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
Nested Loop (cost=6923.33..11770.59 rows=1 width=362) (actual time=17128.188..22109.283 rows=10858 loops=1) | |
Buffers: shared hit=83494 | |
-> Bitmap Heap Scan on context c (cost=6923.33..11762.31 rows=1 width=329) (actual time=17128.121..22031.783 rows=10858 loops=1) | |
Recheck Cond: ((tags @> '{blah}'::text[]) AND (x_key = 1)) | |
Filter: (key = ANY ('{15368196,(a lot more keys here)}'::integer[])) | |
Buffers: shared hit=50919 | |
-> BitmapAnd (cost=6923.33..6923.33 rows=269 width=0) (actual time=132.910..132.910 rows=0 loops=1) | |
Buffers: shared hit=1342 | |
-> Bitmap Index Scan on context_tags_idx (cost=0.00..1149.61 rows=15891 width=0) (actual time=64.614..64.614 rows=264777 loops=1) | |
Index Cond: (tags @> '{blah}'::text[]) | |
Buffers: shared hit=401 | |
-> Bitmap Index Scan on context_x_id_source_type_id_idx (cost=0.00..5773.47 rows=268667 width=0) (actual time=54.648..54.648 rows=267659 loops=1) | |
Index Cond: (x_id = 1) | |
Buffers: shared hit=941 | |
-> Index Scan using x_pkey on x (cost=0.00..8.27 rows=1 width=37) (actual time=0.003..0.004 rows=1 loops=10858) | |
Index Cond: (x.key = 1) | |
Buffers: shared hit=32575 | |
Total runtime: 22117.417 ms |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Used for blog post