https://daimler-truck-shop.de/staging/navigation/378885da3d8e4b168700b4c093a645f0

Query Metrics

14.00 ms Query Time
1 Node(s)
10 Indices

Queries

# Execution Time Info
1 7.16 ms Request:
{"index":"live_product_1bf86c20e08d4ab6a9bc35004f282789","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":"378885da3d8e4b168700b4c093a645f0"}}}},{"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}}
2 6.95 ms Request:
{"index":"live_product_1bf86c20e08d4ab6a9bc35004f282789","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["fa39673d81b04a1894e8b478f5902d1b","e85338f5f8544c76b96b9ed55c450896","d5991d6ccb3041a5891f0a2a2a2e9859","cf3d520be4a84fe99b5979adc0e0836b","c93a66f007d44b7d8eedcc8223c93431","c483802431a84bee8187fd542814c21f","bbb46607827048979a4af7917dcef18a","76be085efac1447bb4affc2be28e6276","6d2c44ab643340a88b431f443d083621","658cfca4565346018edee7520271d095","4cd175396a2b477f8503658a8a46743f","4ab73284985b44349ac90be9c90da00b","3b3f49e211df446aae7de0b2af086285","2a20dbc12e6a44d8a535df4925f0034c","0fd28672e1884365a2ea607e87b2f0a3","0a5581fbcb0e4ab5b9bee648fee5acd1","09129e7ada6b43d2b569ff4920094e81","060bbdfe94144a808a6c83fc651d54dc","0046f9421b394795b4410044573abed4","3f96d3b2f8084714aca5a6f08a33f4c6","12f02206a506419c96db395c01ce4939","f9801181608542c58e8188caff09fcf4","f06bb1df8e814c5a850a4a4c23ae0547","051b4757cc1a474282b6e4712d39d2ec","72574c6f551a4160aafba0ab16e517e5","e881ef48d2664791867085d3dba01232","e642b06dc73c46a39cdb9e59603ebb98","164c15fe2e814304931e041c28b95f02","e454e91a783e4c718f2c1330b718dec3","b99e1640b38a4c57bc26a5a055d58775","2e3660ba6e684b2d985d2ed66b7b465c","d0d25e7a31a5454daed9a83ebbc076e6","ce0bde5e31b44c3193452f97a5eaea48","17c88e8191d3478fa7fa7e7a8025c493","0315a00e340f4a61922b41b005a0dce6","b51d7004e98341ca9f69a55f140638a7","1962d6f5e766414f919f3ca994afb60c","afef1b0d698940ac80b59376c2ef9c5e","0995d1bc12254a89b1e6534e7acf08ae","9bc80705014649798d813b476db95789","97e4909ead4a41aba6c0dc94c5a37712","959ec65a27b24fd193aaf7461a262c4e","86ee5e41fe224a3684ed13e2aaf43c89","7317a9c9a36a4858b22670cba856219d","6be2fd2c4a314fc585c77945acb0b6fb","5fb91e252cb94f3dbb78a016c081726c","5e53ca0302d54e69b5ba75e33e335fff","5bb4be65104841f0a0ca6bba9fd30da1","2634280611d542e685c7a26891265e40","38c123717cb54c3d90e29e014eb9b46f"]}},{"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 10616
live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675058506 open 3, 3 10625
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 10625
local_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675158183 open 3, 3 2886
local_product_1bf86c20e08d4ab6a9bc35004f282789_1675158183 open 3, 3 4734