Query Metrics
62.00 ms
Query Time
1
Node(s)
54
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 18.59 ms |
Request:
{"index":"sw_stage_action_search_term_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"nested":{"path":"action","query":{"bool":{"must":[{"term":{"action.active":true}},{"term":{"action.salesChannelId":"bcd1f8c7116049609b5c76b472a00703"}}]}}}}],"must":[{"dis_max":{"queries":[{"match":{"fullText":{"query":"2025","boost":1,"zero_terms_query":"all"}}},{"match":{"fullTextBoosted":{"query":"2025","boost":2,"zero_terms_query":"all"}}}],"tie_breaker":0.4}}]}},"from":0,"size":10000}}
|
| 2 | 4.27 ms |
Request:
{"index":"sw_stage_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"dis_max":{"queries":[{"match":{"fullText":{"query":"2025","boost":1,"zero_terms_query":"all"}}},{"multi_match":{"query":"2025","fields":["translated.name.sesp","translated.name.ngram"],"boost":2,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"match":{"fullTextBoosted":{"query":"2025","boost":2,"zero_terms_query":"all"}}},{"multi_match":{"query":"2025","fields":["translated.description.sesp"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}}],"tie_breaker":0.4}},"from":0,"size":30}}
|
| 3 | 16.82 ms |
Request:
{"index":"sw_stage_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"active":true}},{"bool":{"should":[{"wildcard":{"path":{"value":"*539ea054800a4502802c00b805c35eab*"}}},{"wildcard":{"path":{"value":"*08c25a00e8584e9496d35353c4b49b0f*"}}}]}}]}}],"must":[{"dis_max":{"queries":[{"match":{"fullTextBoosted":{"query":"2025","boost":2,"zero_terms_query":"all"}}},{"multi_match":{"query":"2025","fields":["translated.description.sesp"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["translated.metaTitle.sesp","translated.metaTitle.ngram"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["translated.name.sesp","translated.name.ngram","translated.name.shingle"],"boost":2,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"match":{"fullText":{"query":"2025","boost":1,"zero_terms_query":"all"}}}],"tie_breaker":0.4}}]}},"from":0,"size":30}}
|
| 4 | 5.85 ms |
Request:
{"index":"sw_stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must_not":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["0082497f74bc4084bfb5dc8291a329e0"]}}}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"bcd1f8c7116049609b5c76b472a00703"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}],"must":[{"dis_max":{"queries":[{"multi_match":{"query":"2025","fields":["translated.metaDescription.sesp"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["productNumber.sesp"],"boost":2,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"nested":{"path":"manufacturer","query":{"multi_match":{"query":"2025","fields":["manufacturer.translated.description.sesp","manufacturer.translated.description.ngram"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}}}},{"match":{"fullText":{"query":"2025","boost":1,"zero_terms_query":"all"}}},{"multi_match":{"query":"2025","fields":["translated.description.sesp","translated.description.ngram"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["translated.name.sesp","translated.name.ngram"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"match":{"fullTextBoosted":{"query":"2025","boost":2,"zero_terms_query":"all"}}},{"multi_match":{"query":"2025","fields":["ean.sesp"],"boost":2,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["categoryTree.sesp","categoryTree.ngram"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["translated.keywords.sesp"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["translated.customFields.custom_product_data_Beschreibung.sesp"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"nested":{"path":"manufacturer","query":{"multi_match":{"query":"2025","fields":["manufacturer.translated.name.sesp","manufacturer.translated.name.ngram"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}}}}],"tie_breaker":0.4}}]}},"sort":[{"_score":{"order":"DESC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":30,"collapse":{"field":"displayGroup"}}}
|
| 5 | 17.13 ms |
Request:
{"index":"sw_stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must_not":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["0082497f74bc4084bfb5dc8291a329e0"]}}}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"bcd1f8c7116049609b5c76b472a00703"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}],"must":[{"dis_max":{"queries":[{"multi_match":{"query":"2025","fields":["translated.metaDescription.sesp"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["productNumber.sesp"],"boost":2,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"nested":{"path":"manufacturer","query":{"multi_match":{"query":"2025","fields":["manufacturer.translated.description.sesp","manufacturer.translated.description.ngram"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}}}},{"match":{"fullText":{"query":"2025","boost":1,"zero_terms_query":"all"}}},{"multi_match":{"query":"2025","fields":["translated.description.sesp","translated.description.ngram"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["translated.name.sesp","translated.name.ngram"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"match":{"fullTextBoosted":{"query":"2025","boost":2,"zero_terms_query":"all"}}},{"multi_match":{"query":"2025","fields":["ean.sesp"],"boost":2,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["categoryTree.sesp","categoryTree.ngram"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["translated.keywords.sesp"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"multi_match":{"query":"2025","fields":["translated.customFields.custom_product_data_Beschreibung.sesp"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}},{"nested":{"path":"manufacturer","query":{"multi_match":{"query":"2025","fields":["manufacturer.translated.name.sesp","manufacturer.translated.name.ngram"],"boost":1,"fuzziness":0,"type":"most_fields","zero_terms_query":"all"}}}}],"tie_breaker":0.4}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule3858957016644de4ae48c0500bf3ccc8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule70bcb4f7aeac4eb7bbb23269b7a6266c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule7790239089bd44439c2a4d519ea58430_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule8c2c497f2f1243dc8a502462ed6f4cfc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulea7246a3c8502487a85f878e470cf2622_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulebc36052461e14167930f1b52f966fde3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulef073d13e9c0349ce86c2bfee47493b92_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulef85f09910a1b488497bb4c17931a8346_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","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}}}}},"size":0}}
|
Cluster Status
{"cluster_name":"aab5e87a1a7745be8c5937f2b6118d5f","status":"yellow","timed_out":false,"number_of_nodes":1,"number_of_data_nodes":1,"active_primary_shards":232,"active_shards":232,"relocating_shards":0,"initializing_shards":0,"unassigned_shards":315,"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":42.413162705667276}
Indices
| Name▲ | Status | Replication (pri, rep) | Doc Count |
|---|---|---|---|
| .ds-logs-enterprise_search.audit-default-2024.07.16-000001 | open | 1, 0 | 7 |
| sw_stage_category_6c1e69e6f1144632906b2fdeec7f6e72_1724223927 | open | 3, 3 | 154 |
| sw_stage_action_6c1e69e6f1144632906b2fdeec7f6e72_1724223927 | open | 3, 3 | 0 |
| sw_stage_product_b5cd0675682b45d4a2a2c35917a8ae0a_1724223927 | open | 3, 3 | 14395 |
| .internal.alerts-ml.anomaly-detection.alerts-default-000001 | open | 1, 0 | 0 |
| sw_stage_action_search_term_6c1e69e6f1144632906b2fdeec7f6e72_1724223927 | open | 3, 3 | 0 |
| .internal.alerts-observability.slo.alerts-default-000001 | open | 1, 0 | 0 |
| sw_stage_action_b635a23d07054e7f938a58cea6fe663c_1724223927 | open | 3, 3 | 0 |
| sw_stage_category_3d4a16b683684fd681ae03fb41f17c82_1724223927 | open | 3, 3 | 154 |
| .internal.alerts-observability.metrics.alerts-default-000001 | open | 1, 0 | 0 |
| sw_stage_action_3d4a16b683684fd681ae03fb41f17c82_1724223927 | open | 3, 3 | 0 |
| sw_stage_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1724223927 | open | 3, 3 | 154 |
| sw_stage_action_search_term_3d4a16b683684fd681ae03fb41f17c82_1724223927 | open | 3, 3 | 0 |
| .internal.alerts-stack.alerts-default-000001 | open | 1, 0 | 0 |
| sw_stage_action_47e194b1911245eba07bbd3500d4ac48_1724223927 | open | 3, 3 | 0 |
| .internal.alerts-observability.uptime.alerts-default-000001 | open | 1, 0 | 0 |
| sw_stage_action_b5cd0675682b45d4a2a2c35917a8ae0a_1724223927 | open | 3, 3 | 0 |
| sw_stage_category_47e194b1911245eba07bbd3500d4ac48_1724223927 | open | 3, 3 | 154 |
| sw_stage_action_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1724223927 | open | 3, 3 | 0 |
| .kibana-observability-ai-assistant-conversations-000001 | open | 1, 0 | 0 |
| sw_stage_product_manufacturer_47e194b1911245eba07bbd3500d4ac48_1724223927 | open | 3, 3 | 4 |
| .internal.alerts-observability.threshold.alerts-default-000001 | open | 1, 0 | 0 |
| .elastic-connectors-sync-jobs-v1 | open | 1, 0 | 0 |
| sw_stage_action_search_term_b635a23d07054e7f938a58cea6fe663c_1724223927 | open | 3, 3 | 0 |
| sw_stage_category_b5cd0675682b45d4a2a2c35917a8ae0a_1724223927 | open | 3, 3 | 154 |
| .internal.alerts-transform.health.alerts-default-000001 | open | 1, 0 | 0 |
| sw_stage_product_47e194b1911245eba07bbd3500d4ac48_1724223927 | open | 3, 3 | 14395 |
| sw_stage_action_ee727ccaf2a840898214f13974ab8738_1724223927 | open | 3, 3 | 0 |
| sw_stage_product_manufacturer_b5cd0675682b45d4a2a2c35917a8ae0a_1724223927 | open | 3, 3 | 4 |
| sw_stage_action_search_term_ee727ccaf2a840898214f13974ab8738_1724223927 | open | 3, 3 | 0 |
| .internal.alerts-observability.apm.alerts-default-000001 | open | 1, 0 | 0 |
| .internal.alerts-default.alerts-default-000001 | open | 1, 0 | 0 |
| sw_stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1724223927 | open | 3, 3 | 14395 |
| .elastic-connectors-v1 | open | 1, 0 | 0 |
| .internal.alerts-ml.anomaly-detection-health.alerts-default-000001 | open | 1, 0 | 0 |
| sw_stage_product_manufacturer_b635a23d07054e7f938a58cea6fe663c_1724223927 | open | 3, 3 | 4 |
| .internal.alerts-security.alerts-default-000001 | open | 1, 0 | 0 |
| .ds-logs-enterprise_search.audit-default-2024.08.15-000002 | open | 1, 0 | 0 |
| sw_stage_action_search_term_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1724223927 | open | 3, 3 | 0 |
| sw_stage_action_search_term_47e194b1911245eba07bbd3500d4ac48_1724223927 | open | 3, 3 | 0 |
| .internal.alerts-observability.logs.alerts-default-000001 | open | 1, 0 | 0 |
| sw_stage_product_6c1e69e6f1144632906b2fdeec7f6e72_1724223927 | open | 3, 3 | 14395 |
| sw_stage_product_b635a23d07054e7f938a58cea6fe663c_1724223927 | open | 3, 3 | 14395 |
| sw_stage_action_search_term_b5cd0675682b45d4a2a2c35917a8ae0a_1724223927 | open | 3, 3 | 0 |
| sw_stage_product_ee727ccaf2a840898214f13974ab8738_1724223927 | open | 3, 3 | 14395 |
| sw_stage_product_manufacturer_ee727ccaf2a840898214f13974ab8738_1724223927 | open | 3, 3 | 4 |
| sw_stage_product_manufacturer_6c1e69e6f1144632906b2fdeec7f6e72_1724223927 | open | 3, 3 | 4 |
| sw_stage_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1724223927 | open | 3, 3 | 4 |
| sw_stage_product_3d4a16b683684fd681ae03fb41f17c82_1724223927 | open | 3, 3 | 14395 |
| sw_stage_category_b635a23d07054e7f938a58cea6fe663c_1724223927 | open | 3, 3 | 154 |
| sw_stage_category_ee727ccaf2a840898214f13974ab8738_1724223927 | open | 3, 3 | 154 |
| .kibana-observability-ai-assistant-kb-000001 | open | 1, 0 | 0 |
| .ds-logs-enterprise_search.api-default-2024.07.23-000002 | open | 1, 0 | 0 |
| sw_stage_product_manufacturer_3d4a16b683684fd681ae03fb41f17c82_1724223927 | open | 3, 3 | 4 |