https://daimler-truck-shop.de/staging/navigation/564794e6417846258fcf257ff02522f6

Query Metrics

14.00 ms Query Time
1 Node(s)
10 Indices

Queries

# Execution Time Info
1 7.73 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}}]}},{"bool":{"should":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["647322a26b1642e4905c9b953eb4541c","91757f06d2af45aa89e80f8c54171044","7e8e9f9e02cb49b4b2b091542a171b45","c1b23bfa220e4e2980fd62ef3eba2b4e","fd71abf7e353441b869bddd56d692223","eb01d011defd4ad6937b115051fd0b66","aa996a8acb99499d926b27228fd2ae9a","73af11b82c7546869b04a93d3d8f3238","371392218dc043718892ded1ea0d01f3","cefd2901712144029b33a3d734723ddd","4e7f257000c94808ac8e773994cd533c","5d4b982532cd47fca39044f93b6b1023","4d82d5a1f5864451a6e1761d7120f1bc","2dabba249fe940b895487c2023567f06","bc1fc3a8dc504561bcfb8c13bca1f729"]}}}}]}},{"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 7.11 ms Request:
{"index":"live_product_1bf86c20e08d4ab6a9bc35004f282789","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["8ed9c10d37fb400ab8b7e71c2b77c30e","53737d2904a24a168c90f2f08e3eac1c","4a5505c9cd4f4818a5a763c1c9ddc7e2","8e0c51a360b94aa599467b5d44046074","48ab01b21ee14b19bed5d213432822d4","2588704d9f87463584c22a15ad66dcc0","6979d3369c8d452e85f7a7676e79ea99","e44889ed8a8c470cb404e3d21ace4924","b0eb0e3926b04c9e99b64b80530eab59","4e2c0c2c35cf4f528b4b7178ee9ed78e","451971c56e2f475483af834c414593e7","eab99831a86d4b0f87d37440cdea7752","5fa8515596db41b4b66b22484fc56b1c","c0fd7078f97f455387b91b33b7870bc2","3b7718b9920b4754beb30aaac2720d86","591dc74971214119b44ece8aaad7816a","bba852d027e247d0a6963b047b92a856","b368f4b21516459cb7117bd46e5bfa77","c0c0e2b5fa304fb893581783ee7cc458","f1cdfbd5d5f14ff492bb50cbd8dc5738","1080a3879f5049bb99e3ce8f2318c842","f441a30c9319493191ea981f9d72ec71","352be041b38348399148b48d5a165414","89c9281372f84c9eaeb859181da49296","4bf75a6e3b664a03a48e1c360339377c","c8595ac5a2044c7092d6f5d258abc445","c44e40e8681344a9bc622d99bbaa76d4","42394e1ccf0c4ce8a483bbc8a841fc66","87d61de02ca049d3a4c6bb76c18607ab","854a1410bbb14e678be69a4e932d43f1","b65918584ea043d18a30a779676ac803","3f16432d379c40c3bf452d881ac56427","d828f710eaa942afaaba26336588f008","fe97ad0a83a3425b824d3f7baf539106","db1e904e906345a59a7d176b41aef289","75d2d739108d45f8b863f977f0341756","b55aafdd417f4585a40333adb2bc8283","299482a2af9540258756b35abfbf38ea","6e9211ac50dc4b7e8fa74f5e8577df40","d3d2694bf2014776b20bb4c1ce0f3dc3","d74541223fab47968e859d01a359794f","f5ee59d05f77494fbf4625060eddbece","cea8c7bec51a491f93f6900e25ae962d","48ac6acf12a84bb18cfdfa21be79deaa","de9078154655415ab7b7fa7619f0903b","b73232ea7cf249a69cd860e63da864de","963bd9a3a96f494eb443f2d8665c8374","5ebb53700fd745a3a1e2236cc7cd0be4","33a702ff5e1e455195a35eabc78a5581","2f0d686ae7e245d9800e9915528c61bf"]}},{"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 10625
staging_product_d5cccd27ea6445358587252a326c85df_1675164332 open 3, 3 3528
live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675058506 open 3, 3 10625
local_product_d5cccd27ea6445358587252a326c85df_1675158183 open 3, 3 4734
staging_product_1bf86c20e08d4ab6a9bc35004f282789_1675164332 open 3, 3 3528
live_product_d5cccd27ea6445358587252a326c85df_1675058506 open 3, 3 10625
local_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675158183 open 3, 3 2886
local_product_1bf86c20e08d4ab6a9bc35004f282789_1675158183 open 3, 3 4734