https://daimler-truck-shop.de/staging/navigation/1ef8eb3c76a54e89b2f0364e5c84c899

Query Metrics

20.00 ms Query Time
1 Node(s)
10 Indices

Queries

# Execution Time Info
1 9.05 ms Request:
{"index":"live_product_1bf86c20e08d4ab6a9bc35004f282789","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":"1ef8eb3c76a54e89b2f0364e5c84c899"}}}},{"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 5.96 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":"1ef8eb3c76a54e89b2f0364e5c84c899"}}}},{"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.90 ms Request:
{"index":"live_product_1bf86c20e08d4ab6a9bc35004f282789","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["4341198a87e94ac899b552909f3ab014","5bd5d7a310ba448faacea30d9d678f2b","535d3319b3c54a6f996e3bd3e6448b45","13e8222e514841dc8984fe2d773732b6","72fde92c3da8492785a8f02668db6ff8","9e805fecadc34599acb9ca87f6f2dd72","f9801181608542c58e8188caff09fcf4","305d4c5c50c246bfb5b378c7a754cdfa","3d432a8653d94116a062531f1a39aacc","24f94dce4c9e492e9fa9168bc5ec5401","82a07a2d63e34d65b8e37cdf25d7ced3","afef1b0d698940ac80b59376c2ef9c5e","cc65980e6817414d9e752f804360e60e","044c1d8e5d6446789994d59d12cc6ca7","4988d137e84f4924864973001717965b","d7268b6f32704e1a818a307c3dd46c1e","5bb4be65104841f0a0ca6bba9fd30da1","38f3a6eb5a594d81bb21ace8e88e650e","8bf7f807af5c4e5bb470912b19cb2bac","c80e4a4809294b00b8984a3915e97cec","28e535bfa2974840aa9cba4ecb2a1bc2","c2b23d6eadd24cb7a45beb637b4db7e0","32800424254c4a26979573fce501d6fb","d8ec4dfabd484bc0b92f21fe2fce7dc4","61d3354d9e62443b9a35943db8d067fb","f5d4b9dfa4a6436185bfe13b36de71f2","62307f6df9464fa0a9431885c3841f1c","299456ce7f3344e682ccb17b2143e855","932b4f3272d843479782c2285081ff27","fe009fad931547579c1962924d5c8134","42c02eb168934fb2ab6f77f9030ced23","502689f544314f9f9d0f245452b55cf8","f06bb1df8e814c5a850a4a4c23ae0547","f58136fb1fcd4b8b99110326f30ce24e","181430d66f4946e28093b8c23bc4ce3c","c056c1106e3f4aad8d1ac0a2c56882e1","9b13fa0861794f0fad8eee6623fd9bed","8b02ce010f804e8c8e72c0c5f7ae4875","b99e1640b38a4c57bc26a5a055d58775","e642b06dc73c46a39cdb9e59603ebb98","8831d405f5894b0ab1886db193708a2a"]}},{"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 10585
live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675058506 open 3, 3 10585
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 10585
local_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675158183 open 3, 3 2886
local_product_1bf86c20e08d4ab6a9bc35004f282789_1675158183 open 3, 3 4734