Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- \d таблицы
- 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)
- План запроса
- Gather (cost=1000.00..91919.75 rows=746 width=915) (actual time=9.046..56794.546 rows=72880 loops=1)
- Workers Planned: 5
- Workers Launched: 5
- Buffers: shared hit=592964
- -> Parallel Seq Scan on urls_with_search_words (cost=0.00..90845.15 rows=149 width=915) (actual time=36.509..56691.112 rows=12147 loops=6)
- Filter: ('19 covid'::text <% search_words)
- Rows Removed by Filter: 112105
- Buffers: shared hit=592964
- Planning Time: 0.102 ms
- Execution Time: 56799.064 ms
Advertisement
Add Comment
Please, Sign In to add comment
