{
	"queryPlanner" : {
		"plannerVersion" : 1,
		"namespace" : "WWWBRON_SF2_T2_S86_mongo.cat_claim",
		"indexFilterSet" : false,
		"parsedQuery" : {
			"$and" : [
				{
					"packet_type" : {
						"$eq" : 0
					}
				},
				{
					"adult" : {
						"$gte" : 2
					}
				},
				{
					"checkin" : {
						"$in" : [
							ISODate("2019-01-04T03:00:00.000+03:00"),
							ISODate("2019-01-05T03:00:00.000+03:00"),
							ISODate("2019-01-07T03:00:00.000+03:00"),
							ISODate("2019-01-09T03:00:00.000+03:00"),
							ISODate("2019-12-26T03:00:00.000+03:00"),
							ISODate("2019-12-28T03:00:00.000+03:00"),
							ISODate("2019-12-29T03:00:00.000+03:00"),
							ISODate("2019-12-30T03:00:00.000+03:00")
						]
					}
				},
				{
					"nights" : {
						"$in" : [
							7,
							8,
							9,
							10,
							11,
							12,
							13,
							14,
							15
						]
					}
				},
				{
					"people_count" : {
						"$in" : [
							2,
							3,
							4
						]
					}
				},
				{
					"for_delete" : {
						"$not" : {
							"$exists" : true
						}
					}
				},
				{
					"hstop" : {
						"$not" : {
							"$exists" : true
						}
					}
				}
			]
		},
		"queryHash" : "9036420B",
		"planCacheKey" : "D56FE695",
		"winningPlan" : {
			"stage" : "SORT",
			"sortPattern" : {
				"idx_price" : 1
			},
			"limitAmount" : 600,
			"inputStage" : {
				"stage" : "SORT_KEY_GENERATOR",
				"inputStage" : {
					"stage" : "FETCH",
					"filter" : {
						"$and" : [
							{
								"packet_type" : {
									"$eq" : 0
								}
							},
							{
								"adult" : {
									"$gte" : 2
								}
							},
							{
								"for_delete" : {
									"$not" : {
										"$exists" : true
									}
								}
							},
							{
								"hstop" : {
									"$not" : {
										"$exists" : true
									}
								}
							}
						]
					},
					"inputStage" : {
						"stage" : "IXSCAN",
						"keyPattern" : {
							"checkin" : 1,
							"nights" : 1,
							"people_count" : 1,
							"idx_price" : 1
						},
						"indexName" : "IX_checkin",
						"isMultiKey" : false,
						"multiKeyPaths" : {
							"checkin" : [ ],
							"nights" : [ ],
							"people_count" : [ ],
							"idx_price" : [ ]
						},
						"isUnique" : false,
						"isSparse" : false,
						"isPartial" : false,
						"indexVersion" : 2,
						"direction" : "forward",
						"indexBounds" : {
							"checkin" : [
								"[new Date(1546560000000), new Date(1546560000000)]",
								"[new Date(1546646400000), new Date(1546646400000)]",
								"[new Date(1546819200000), new Date(1546819200000)]",
								"[new Date(1546992000000), new Date(1546992000000)]",
								"[new Date(1577318400000), new Date(1577318400000)]",
								"[new Date(1577491200000), new Date(1577491200000)]",
								"[new Date(1577577600000), new Date(1577577600000)]",
								"[new Date(1577664000000), new Date(1577664000000)]"
							],
							"nights" : [
								"[7.0, 7.0]",
								"[8.0, 8.0]",
								"[9.0, 9.0]",
								"[10.0, 10.0]",
								"[11.0, 11.0]",
								"[12.0, 12.0]",
								"[13.0, 13.0]",
								"[14.0, 14.0]",
								"[15.0, 15.0]"
							],
							"people_count" : [
								"[2.0, 2.0]",
								"[3.0, 3.0]",
								"[4.0, 4.0]"
							],
							"idx_price" : [
								"[MinKey, MaxKey]"
							]
						}
					}
				}
			}
		},
		"rejectedPlans" : [ ]
	},
	"serverInfo" : {
		"host" : "mongodb01",
		"port" : 27017,
		"version" : "4.2.1",
		"gitVersion" : "edf6d45851c0b9ee15548f0f847df141764a317e"
	},
	"ok" : 1
}