https://daimler-truck-shop.de/staging/navigation/ffeddef33bb64121834b57ed29ada3d8

Query Metrics

19.00 ms Query Time
1 Node(s)
10 Indices

Queries

# Execution Time Info
1 9.55 ms Request:
{"index":"live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"post_filter":{"bool":{"filter":[{"bool":{}}]}},"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"ffeddef33bb64121834b57ed29ada3d8"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"stock":{"order":"DESC"}}],"aggregations":{"total-filtered-count":{"filter":{"bool":{}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}},"from":0,"size":50,"collapse":{"field":"displayGroup"}}}
2 4.02 ms Request:
{"index":"live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"ffeddef33bb64121834b57ed29ada3d8"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule20af0824a454454e9990d95b444fa21d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleebd6d5cf8ded4a0c8d2c9d6f3e07a632_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01fe82e0af2f44088220280fa0620a21_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled4618787540a424daa04e260988afd3b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6c64ee35e8c44f6caced8d2ec8edae92_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6fed02ebe194464094b2eb785108f7dd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulececdc5ee788c4554b7a812d4fea46b1b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"gbmed_labelling_tyres_fuel":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.fuel"}}]}},{"term":{"gbmedLabellingTyres.fuel":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_fuel":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_fuel":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_fuel":{"terms":{"field":"gbmedLabellingTyres.fuel","size":10000}}}}}}}},"gbmed_labelling_tyres_grip":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.grip"}}]}},{"term":{"gbmedLabellingTyres.grip":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_grip":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_grip":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_grip":{"terms":{"field":"gbmedLabellingTyres.grip","size":10000}}}}}}}},"gbmed_labelling_tyres_noise":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.noise"}}]}},{"term":{"gbmedLabellingTyres.noise":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_noise":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_noise":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_noise":{"terms":{"field":"gbmedLabellingTyres.noise","size":10000}}}}}}}},"gbmed_labelling_tyres_decibel":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.decibel"}}]}},{"term":{"gbmedLabellingTyres.decibel":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_decibel":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_decibel":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_decibel":{"stats":{"field":"gbmedLabellingTyres.decibel"}}}}}}}}},"size":0}}
3 5.98 ms Request:
{"index":"live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["eed0f81e258c4c2db50cc1c037526d11","317ac0a74beb414b8f6ad371817f5b18","c7e31a2b2d2c424e8365eab5a5d48647","f935d82b7d594411b2b0edf94e2229dd","c4cfc876846d467da5b947137f1896ed","8801fd13cdd144ee82e5450ae38b4867","627793e7864a4fd185e036b86071a5d4","403062d8acf94342a4df8a45b8b3738d","c1e5ab0fce1c4e84a7ed6c7113f2f399","ba9aa1fc24a1438b9551eaeb246a9156","136e417c788f48169a941a1533cc47d0","48c93b58c7b449fbb6037cba3f0e91b3","73b50997cd9c4a889ded82b7845db4b8","5704b2fb1fae458d81bef1ba69985bb2","ef9ddbbcdf424622a1ebd9f2bfd5c1f0","52fca9c619b449b6b56129aed33a2f3f","67a152de611e4c32887d4f12754547ea","e6b06659d1104adb875c40c4abf218ba","5ab81c17a5cf4b9e88055c6ad9fc8cfd","48b4677ae5ad4c85b619e4368cd4d55d","08fb784263304f5da26e4dd44bfb1d62","75a29603665b4537b86d467991962bd1","6c34410bcb0c43fabaf34e042fd3d1f3","40427f1a7e374513b9b5c933c9453787","86ee5e41fe224a3684ed13e2aaf43c89","b366f5e8fc084a52b251427fee7ecb30","6f967bbf4e214808952050b8a7d9a0d3","e9316d85b33d4045a67ab6385c6b5d32","34075f672436494da6ea8ea392deac7e","5e53ca0302d54e69b5ba75e33e335fff","6d2c44ab643340a88b431f443d083621","5cbf7cebbd5b47aa85630f26add6a7fb","89b7ace751994cdbb5732e989c530876","6fc5423735aa4d19acde861fb0ae329a","8a12350a9ad9400db3a18be897b75e83","73522bbb97874535bfc9ef9e40c022ac","0a3fa0ad4a294595b1ab987b3f81e117","3e4540502a804a5da4169cf43d8d0a3b","ae5af01bcb844da6a32451f1af7ebd21","3c9a444285f345cbbe6ff0ca0b3923ec","21f7658a45b8403d8a667580f30d68ea","f113faee1e4f4818b7c9428456d16343","1962d6f5e766414f919f3ca994afb60c","96727210e6f8468dae49a796a576e561","b02c806efed641d78e5db74544669f73","0cb5da32f3aa489bad2d6bd9aa4f4ff6","51eb792e53704a89a32be7cddcdd5d7f","2d213a91d7a2463291202ed6d21df394","9180d77060a3400291b57105c80a4898","87929340ccfb4e6b9378253390547008"]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}}]}},"from":0,"size":10000}}

Cluster Status

{"cluster_name":"elasticsearch","status":"yellow","timed_out":false,"number_of_nodes":1,"number_of_data_nodes":1,"active_primary_shards":34,"active_shards":34,"relocating_shards":0,"initializing_shards":0,"unassigned_shards":81,"delayed_unassigned_shards":0,"number_of_pending_tasks":0,"number_of_in_flight_fetch":0,"task_max_waiting_in_queue_millis":0,"active_shards_percent_as_number":29.565217391304348}

Indices

Name Status Replication (pri, rep) Doc Count
.geoip_databases open 1, 0 39
staging_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675164332 open 3, 3 3528
live_product_1bf86c20e08d4ab6a9bc35004f282789_1675058506 open 3, 3 10559
live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675058506 open 3, 3 10559
staging_product_d5cccd27ea6445358587252a326c85df_1675164332 open 3, 3 3528
staging_product_1bf86c20e08d4ab6a9bc35004f282789_1675164332 open 3, 3 3528
local_product_d5cccd27ea6445358587252a326c85df_1675158183 open 3, 3 4734
live_product_d5cccd27ea6445358587252a326c85df_1675058506 open 3, 3 10559
local_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675158183 open 3, 3 2886
local_product_1bf86c20e08d4ab6a9bc35004f282789_1675158183 open 3, 3 4734