#4265 slow mongo queries NEEDS ENSURE INDEX

v1.0.0
closed
Cory Johns
performance (126) v2 (44) sf-2 (994)
General
Dave Brondsema
2015-08-20
2012-05-22
Dave Brondsema
No

These are examples of frequent slow queries. They probably just need indexes added. Maybe some query/code changes too.

Tue May 22 14:15:22 [conn521668] query project-data.artifact_feed query: { $query: { project_id: ObjectId('4e264007b9363c5665000359'), app_config_id: ObjectId('4e264008b9363c5665000360') }, $orderby: { pubdate: -1 } } ntoreturn:10 nscanned:1242030 nreturned:1 reslen:666 5234ms
Tue May 22 01:02:58 [conn513383] query pyforge.fs query: { $query: { category: "icon", project_id: ObjectId('4f7dae721be1ce3cb50009de') } } nscanned:39209 nreturned:1 reslen:167 1993ms
Tue May 22 00:23:21 [conn515210] query project-data.ticket query: { import_id: "tracker/447449/3510504" } ntoreturn:1 nscanned:2071437 reslen:20 1055ms

Discussion

  • Dave Brondsema

    Dave Brondsema - 2012-06-01
    • size: --> 2
     

  • Dave Brondsema

    Dave Brondsema - 2012-06-07
    • labels: performance --> performance, v2
     

  • Cory Johns - 2012-06-08
    • status: open --> in-progress
    • assigned_to: Cory Johns
     

  • Cory Johns - 2012-06-08
    • summary: slow mongo queries --> slow mongo queries NEEDS ENSURE INDEX
    • status: in-progress --> code-review
    • qa: Tim Van Steenburgh
     

  • Cory Johns - 2012-06-08

    allura: cj/4265

    • qa: Tim Van Steenburgh --> Ｄａｖｅ Brondsema
     

  • Dave Brondsema

    Dave Brondsema - 2012-06-08
    • status: code-review --> closed
     

Log in to post a comment.