Skip to content

Instantly share code, notes, and snippets.

@bgvo

bgvo/gist:4d7b75de6d5d9e8d39fbc170990ea974 Secret

Created May 17, 2017 16:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bgvo/4d7b75de6d5d9e8d39fbc170990ea974 to your computer and use it in GitHub Desktop.
Save bgvo/4d7b75de6d5d9e8d39fbc170990ea974 to your computer and use it in GitHub Desktop.
Download ZIP
Explain
Raw
gistfile1.txt
Aggregate (cost=5589.73..5589.74 rows=1 width=0) (actual time=3290.084..3290.084 rows=1 loops=1)
-> Bitmap Heap Scan on influencers (cost=36.65..5585.78 rows=1582 width=0) (actual time=120.348..3243.185 rows=279764 loops=1)
Recheck Cond: ((((ig ->> 'follower_count'::text))::integer >= 1000) AND (((ig ->> 'follower_count'::text))::integer <= 10000))
Rows Removed by Index Recheck: 14697
Heap Blocks: exact=35075 lossy=26495
-> Bitmap Index Scan on idx_btree_ig_follower_count2 (cost=0.00..36.26 rows=1582 width=0) (actual time=108.116..108.116 rows=279764 loops=1)
Index Cond: ((((ig ->> 'follower_count'::text))::integer >= 1000) AND (((ig ->> 'follower_count'::text))::integer <= 10000))
Planning time: 0.238 ms
Execution time: 3290.259 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment