Created
August 20, 2013 15:12
-
-
Save alq666/6282734 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=168.22..2116.29 rows=148 width=362) (actual time=22.134..256.531 rows=10858 loops=1) | |
| Buffers: shared hit=44967 | |
| -> Index Scan using x_pkey on x (cost=0.00..8.27 rows=1 width=37) (actual time=0.071..0.073 rows=1 loops=1) | |
| Index Cond: (id = 1) | |
| Buffers: shared hit=4 | |
| -> Nested Loop (cost=168.22..2106.54 rows=148 width=329) (actual time=22.060..242.406 rows=10858 loops=1) | |
| Buffers: shared hit=44963 | |
| -> HashAggregate (cost=168.22..170.22 rows=200 width=4) (actual time=21.529..32.820 rows=11215 loops=1) | |
| -> Values Scan on "*VALUES*" (cost=0.00..140.19 rows=11215 width=4) (actual time=0.005..9.527 rows=11215 loops=1) | |
| -> Index Scan using context_pkey on context c (cost=0.00..9.67 rows=1 width=329) (actual time=0.015..0.016 rows=1 loops=11215) | |
| Index Cond: (c.key = "*VALUES*".column1) | |
| Filter: ((c.tags @> '{blah}'::text[]) AND (c.x_id = 1)) | |
| Buffers: shared hit=44963 | |
| Total runtime: 263.639 ms |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment