https://daimler-truck-shop.de/staging/navigation/251448b91bc742de85643f5fccd89051

Query Metrics

18.00 ms Query Time
1 Node(s)
10 Indices

Queries

# Execution Time Info
1 8.66 ms Request:
{"index":"live_product_d5cccd27ea6445358587252a326c85df","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":"251448b91bc742de85643f5fccd89051"}}}},{"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 3.56 ms Request:
{"index":"live_product_d5cccd27ea6445358587252a326c85df","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":"251448b91bc742de85643f5fccd89051"}}}},{"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 2.24 ms Request:
{"index":"live_product_d5cccd27ea6445358587252a326c85df","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["4643e9bd428e4900b1d264eb5d96732d"]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}}]}},"from":0,"size":10000}}
4 3.88 ms Request:
{"index":"live_product_d5cccd27ea6445358587252a326c85df","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["59f9f1a6a67548f286690e53ad686fe2","46cd1fbe439f4519818cb6d0e4942d45","508eaea4e22c4a64bbec43d26291f8eb","317ac0a74beb414b8f6ad371817f5b18","2efe910c14b946a3add4464dcda47cec","bd0b5294afed4c108ffdb30ce1e5c97d","8f2850e475bb46c39c7e30d1a77f8602","e941d9f4d1c84dba913da9c6801a76be","0c512bf535874c44a32e4cc55d208a0d","6efa879c82bc4d908bec6c0189d43911","cc129eeec4ee4dc28ca0ca2ec66453ed","55488ae1e78a454db30902b3890ceb12","f90d2f23342143efbd8f266038ef1d9b","a528469b54364d0a96f179ba7337d685","67569049b3c14e7ca199926975f3ecf9","63c16e98898f46fc96715a5b48fe2985","1c45101d462b4ae1837dbd6fe1bf0f8b","f1e1088c3afe4d71b74347092a814400","da8964c57b064fa68a37e91c349edd6a","f9d2979d2113452aaf45b0c728b7df9b","174f18c6b99b42f7abe0f9da159c9f91","dedeabba1dc04cd099c2ab7698fc2ab8","da0548c050a1436d9878068ff9fd9b13","fbfd7e4c70c94d69a6822fd6a38caefc","58e859c67a264215943f43eaf768ba5c","06d04ad4fad44f539ced42c9d0bf1615","3d432a8653d94116a062531f1a39aacc","0e59d274b7ee428bbad3173bc77a4346","a2d79bc9be3f44bc87f6112aa15f139f","1e02ce42bbc149ba84dcd0ebda96235b","04c06a76e2744a6d9ee0fe63e289c88e","9637575a9c9f4b2383c045697f75cad0","8d67264abe3941bba0f81aa50ca1d7aa","aa73f3425d924ebab4a5b37a3bbde7ff","7747d58e2ea14bb9abee9e9e3c9c7f0b","b1b866c4625e40ba8b20875dfaa56de3","0b422643f19c4ca99214527ee30a7bf8","bd0f9a2c589f4672b533299501de7084","aaf206e41d2343deb6c7d35321749347","50a40affe16649aabf47267746ab770f","05afd3f6dcf24a6a98673ef5fd3b7bee","b89f8002581b4b1da1f4415627bf0049","51eb792e53704a89a32be7cddcdd5d7f","5835fbf8cca74c01a6317cbf8d6a5eec","6c05fb4c02fb4d3fa668201bf6deede2","4643e9bd428e4900b1d264eb5d96732d","1cf8ad74c04643bf8794d39dad76bd7c","9180d77060a3400291b57105c80a4898","d9bbe5c7c26d4af48a2d89544982cf0b","44296c3d6a414098af897cbb6dbdc49c"]}},{"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 10645
live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675058506 open 3, 3 10645
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 10645
local_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675158183 open 3, 3 2886
local_product_1bf86c20e08d4ab6a9bc35004f282789_1675158183 open 3, 3 4734