We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
v1.20.1
PostgreSQL
I ran db.my_collection.findOne({'some_key' : 'match_value'}), it took many time to complete . And I found output like below:
db.my_collection.findOne({'some_key' : 'match_value'})
Query {"commandTag": "SELECT 1", "pid": 44279, "sql": "SELECT _jsonb FROM \"my_db\".\"my_collection_xxxx\" WHERE _jsonb->$1 @> $2", "args": ["some_key","\"some_value\""], "time": "457.106837ms"}
note that it use @> (means "contains") other than = operator.
@>
=
I ran explain: db.runCommand({ explain: { findOne: "my_collection", query: { "some_key": {$eq: "match_value"}} }} )
db.runCommand({ explain: { findOne: "my_collection", query: { "some_key": {$eq: "match_value"}} }} )
"filterPushdown" : true
"filterPushdown" : false
The text was updated successfully, but these errors were encountered:
That should be solved by the upcoming 2.0
Sorry, something went wrong.
ferretdb-bot
No branches or pull requests
FerretDB version
v1.20.1
Backend
PostgreSQL
Environment
What did you do?
I ran
db.my_collection.findOne({'some_key' : 'match_value'})
, it took many time to complete . And I found output like below:note that it use
@>
(means "contains") other than=
operator.I ran explain:
db.runCommand({ explain: { findOne: "my_collection", query: { "some_key": {$eq: "match_value"}} }} )
What did you expect to see?
"filterPushdown" : true
What did you see instead?
"filterPushdown" : false
The text was updated successfully, but these errors were encountered: