[COMPASS-6832] [Insights] Add signal for unindexed query Created: 15/May/23  Updated: 29/Oct/23  Resolved: 21/Jun/23

Status: Closed
Project: Compass
Component/s: None
Affects Version/s: None
Fix Version/s: 1.38.1

Type: Task Priority: Major - P3
Reporter: Sergey Petushkov Assignee: Sergey Petushkov
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Epic Link: COMPASS-6441
Story Points: 5
Documentation Changes: Not Needed
Sprint: Iteration Dreadnoughtus

 Description   

We will run explain in queryPlanner more for every query to identify if the index was used. No additional trigger thresholds will be added



 Comments   
Comment by Githook User [ 28/Jun/23 ]

Author:

{'name': 'Sergey Petushkov', 'email': 'petushkov.sergey@gmail.com', 'username': 'gribnoysup'}

Message: feat(compass-crud): show insight when query is unindexed COMPASS-6832 (#4540)

  • feat(compass-crud): show insight when query is unindexed
  • chore(compass-crud): use collection scan stage to detect when to show the insight

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-collection): useEffect instead of useMemo

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-crud): remove unused variables from tests

---------

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>
Branch: beta-releases
https://github.com/mongodb-js/compass/commit/4539b5c0d9d01efb459d6f34a11a5206106bccc7

Comment by Githook User [ 20/Jun/23 ]

Author:

{'name': 'Sergey Petushkov', 'email': 'petushkov.sergey@gmail.com', 'username': 'gribnoysup'}

Message: feat(compass-crud): show insight when query is unindexed COMPASS-6832 (#4540)

  • feat(compass-crud): show insight when query is unindexed
  • chore(compass-crud): use collection scan stage to detect when to show the insight

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-collection): useEffect instead of useMemo

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-crud): remove unused variables from tests

---------

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>
Branch: 1.38-releases
https://github.com/mongodb-js/compass/commit/4539b5c0d9d01efb459d6f34a11a5206106bccc7

Comment by Githook User [ 19/Jun/23 ]

Author:

{'name': 'Sergey Petushkov', 'email': 'petushkov.sergey@gmail.com', 'username': 'gribnoysup'}

Message: feat(compass-crud): show insight when query is unindexed COMPASS-6832 (#4540)

  • feat(compass-crud): show insight when query is unindexed
  • chore(compass-crud): use collection scan stage to detect when to show the insight

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-collection): useEffect instead of useMemo

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-crud): remove unused variables from tests

---------

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>
Branch: autobeta
https://github.com/mongodb-js/compass/commit/4539b5c0d9d01efb459d6f34a11a5206106bccc7

Comment by Githook User [ 16/Jun/23 ]

Author:

{'name': 'Sergey Petushkov', 'email': 'petushkov.sergey@gmail.com', 'username': 'gribnoysup'}

Message: feat(compass-crud): show insight when query is unindexed COMPASS-6832 (#4540)

  • feat(compass-crud): show insight when query is unindexed
  • chore(compass-crud): use collection scan stage to detect when to show the insight

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-collection): useEffect instead of useMemo

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-crud): remove unused variables from tests

---------

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>
Branch: activity-telemetry
https://github.com/mongodb-js/compass/commit/4539b5c0d9d01efb459d6f34a11a5206106bccc7

Comment by Githook User [ 16/Jun/23 ]

Author:

{'name': 'Sergey Petushkov', 'email': 'petushkov.sergey@gmail.com', 'username': 'gribnoysup'}

Message: feat(compass-crud): show insight when query is unindexed COMPASS-6832 (#4540)

  • feat(compass-crud): show insight when query is unindexed
  • chore(compass-crud): use collection scan stage to detect when to show the insight

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-collection): useEffect instead of useMemo

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-crud): remove unused variables from tests

---------

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>
Branch: guide-cue-implementation
https://github.com/mongodb-js/compass/commit/4539b5c0d9d01efb459d6f34a11a5206106bccc7

Comment by Githook User [ 16/Jun/23 ]

Author:

{'name': 'Sergey Petushkov', 'email': 'petushkov.sergey@gmail.com', 'username': 'gribnoysup'}

Message: feat(compass-crud): show insight when query is unindexed COMPASS-6832 (#4540)

  • feat(compass-crud): show insight when query is unindexed
  • chore(compass-crud): use collection scan stage to detect when to show the insight

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-collection): useEffect instead of useMemo

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-crud): remove unused variables from tests

---------

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>
Branch: compass-6835-massive-n-of-collections-signal
https://github.com/mongodb-js/compass/commit/4539b5c0d9d01efb459d6f34a11a5206106bccc7

Comment by Githook User [ 16/Jun/23 ]

Author:

{'name': 'Sergey Petushkov', 'email': 'petushkov.sergey@gmail.com', 'username': 'gribnoysup'}

Message: feat(compass-crud): show insight when query is unindexed COMPASS-6832 (#4540)

  • feat(compass-crud): show insight when query is unindexed
  • chore(compass-crud): use collection scan stage to detect when to show the insight

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-collection): useEffect instead of useMemo

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>

  • chore(compass-crud): remove unused variables from tests

---------

Co-authored-by: Anna Henningsen <anna.henningsen@mongodb.com>
Branch: main
https://github.com/mongodb-js/compass/commit/4539b5c0d9d01efb459d6f34a11a5206106bccc7

Comment by Githook User [ 16/Jun/23 ]

Author:

{'name': 'Sergey Petushkov', 'email': 'petushkov.sergey@gmail.com', 'username': 'gribnoysup'}

Message: Merge branch 'main' into compass-6832-insight-unindexed-query
Branch: compass-6832-insight-unindexed-query
https://github.com/mongodb-js/compass/commit/91b854e81d9754fd4204fa4147cfc18f9f657eea

Generated at Wed Feb 07 22:44:29 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.