We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
|
*
Limit
-
|
[...] |
10
rows
|
||||||||||||||||
|
*
Gather Merge
-
|
[...] |
750
rows
|
||||||||||||||||
|
*
Sort
-
|
[...] |
375
rows avg in
3 loops
|
||||||||||||||||
|
*
Nested Loop
-
|
[...] |
375
rows avg in
3 loops
|
||||||||||||||||
|
*
Parallel Seq Scan
directory_network_entity
|
[...] |
74,908
rows avg in
3 loops
|
||||||||||||||||
|
*
Function Scan
to_tsquery query
|
[...] |
1
rows avg in
224,724 loops
|
Limit (cost=1499607.64..1499608.80 rows=10 width=94)
-> Gather Merge (cost=1499607.64..1499695.14 rows=750 width=94)
Workers Planned: 2
-> Sort (cost=1498607.61..1498608.55 rows=375 width=94)
Sort Key: ((ts_rank_cd(directory_network_entity.general_search_vectors, query.query, 32) + ('2'::double precision * ts_rank_cd(directory_network_entity.identifiers_search_vectors, query.query, 32)))) DESC
-> Nested Loop (cost=0.25..1498599.51 rows=375 width=94)
Join Filter: (query.query @@ directory_network_entity.identifiers_search_vectors)
-> Parallel Seq Scan on directory_network_entity (cost=0.00..1496910.08 rows=74908 width=179)
-> Function Scan on to_tsquery query (cost=0.25..0.26 rows=1 width=32)