[SERVER-16650] explain aggregation doesn't output timing information Created: 23/Dec/14  Updated: 15/Jan/15  Resolved: 15/Jan/15

Status: Closed
Project: Core Server
Component/s: Aggregation Framework, Geo, Querying
Affects Version/s: 2.6.6
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: guipulsar Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Operating System: ALL
Steps To Reproduce:

db.tablegui.aggregate([
   {
     $geoNear: {
        near: { type: "Point", coordinates: [2.298800, 48.854355] },
        distanceField: "dist.calculated",
        query: { code_postal:  { $gt : 30000 }   },
       limit:500, 
        spherical: true 
     }
   }
    , { $project : { _id : 0  , ville : 1 , code_postal:1 , "dist.calculated":1  } } 
 
] , {explain:true} 
   );

Participants:

 Description   

explain aggregation doesn't work at all (and doesn't output error)..



 Comments   
Comment by Ramon Fernandez Marina [ 15/Jan/15 ]

pulsar, as Dan mentioned the output of aggregation contains no timing information. You may want to investigate increasing your log verbosity in combination with the slowms setting and the profiler.

Feel free to open a feature request ticket as well. Please include details on how the new feature would be used and what the detailed output would be.

Regards,
Ramón.

Comment by guipulsar [ 31/Dec/14 ]

so there are actually no solutions to get a time consuming output for this kind of query (aggregation) ?!

Comment by Daniel Pasette (Inactive) [ 31/Dec/14 ]

This is the correct output for the aggregation command. Execution statistics output for aggregation is not currently supported.

Comment by guipulsar [ 23/Dec/14 ]

seems i have some kind of report when i query on the shell ,
but without time informationa, the output shell is this:

{
	"stages" : [
		{
			"$geoNear" : {
				"near" : {
					"type" : "Point",
					"coordinates" : [
						2.2988,
						48.854355
					]
				},
				"distanceField" : "dist.calculated",
				"limit" : NumberLong(500),
				"query" : {
					"code_postal" : {
						"$gt" : 30000
					}
				},
				"spherical" : true,
				"distanceMultiplier" : 1,
				"uniqueDocs" : false
			}
		},
		{
			"$project" : {
				"_id" : false,
				"ville" : true,
				"code_postal" : true,
				"dist" : {
					"calculated" : true
				}
			}
		}
	],
	"ok" : 1
}

Comment by guipulsar [ 23/Dec/14 ]

the output of this query is :
/* 0 */
{
"result" : [
{
"code_postal" : 75015,
"ville" : "Paris",
"dist" :

{ "calculated" : 10196136.37698665 }

},

{
"code_postal" : 75014,
"ville" : "Paris",
"dist" :

{ "calculated" : 19906486.1210345 }

}
],
"ok" : 1
}

Comment by guipulsar [ 23/Dec/14 ]

thats the pb, there is no outputt explain at all..

Comment by J Rassi [ 23/Dec/14 ]

Could you please post the output you observe when running this aggregation explain?

Generated at Thu Feb 08 03:41:48 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.