Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Bitmap Heap Scan on urls (cost=38.34..866.61 rows=818 width=675) (actual time=54.515..92707.842 rows=77427 loops=1)
- Filter: ('19 covid'::text <% search_words)
- Rows Removed by Filter: 767
- Heap Blocks: exact=48651
- Buffers: shared hit=324427
- -> Bitmap Index Scan on urls_search_words_idx1 (cost=0.00..38.14 rows=818 width=0) (actual time=45.755..45.756 rows=78194 loops=1)
- Index Cond: (search_words %> '19 covid'::text)
- Buffers: shared hit=374
- Planning Time: 0.815 ms
- Execution Time: 92716.785 ms
- Table "dmp_test.urls"
- Column | Type | Collation | Nullable | Default
- ---------------------+-----------------------------+-----------+----------+-------------------------------------------
- id | bigint | | not null | nextval('dmp_test.urls_id_seq'::regclass)
- url | text | | |
- creation_date | timestamp without time zone | | |
- users_count | integer | | |
- age_to_17 | integer | | |
- age_to_24 | integer | | |
- age_to_40 | integer | | |
- age_to_90 | integer | | |
- men | integer | | |
- women | integer | | |
- income_level_a | integer | | |
- income_level_b | integer | | |
- income_level_c | integer | | |
- income_level_c_plus | integer | | |
- title | text | | |
- description | text | | |
- keywords | text | | |
- search_words | text | | |
- Indexes:
- "urls_id_index" btree (id)
- "urls_search_words_idx" gin (search_words)
- "urls_search_words_idx1" gin (search_words)
Add Comment
Please, Sign In to add comment
