GET https://gz.tecgento.de/navigation/0193303ea54c725e9b7a7af147b6716f

Query Metrics

1418.00 ms Query Time
1 Node(s)
24 Indices

Queries

# Execution Time Info
1 1416.44 ms Request:
{"index":"gzautoteile_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"018ecdf9873a71dfab55f3f644e66628"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0193303ea54c725e9b7a7af147b6716f"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n    def field_name = params['field'] + '.' + languages[i] + suffix;\n\n    if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n        def fieldValue = doc[field_name].value;\n\n        return fieldValue.toString();\n    }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
2 1.60 ms Request:
{"index":"gzautoteile_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"018ecdf9873a71dfab55f3f644e66628"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0193303ea54c725e9b7a7af147b6716f"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule018ecdf7dfcf734e88063baf7883edbf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018ecdf7dfd8736e957028c59fd5078a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018ecdf7e8f9711a8f9eb33ae57bac05_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018ecdf7dfee72db9c430bb49724d987_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019294672b8d7d4b902c0eb9869c6e7c_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.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,"timeout":"5s"},"search_type":"query_then_fetch"}

Cluster Status

{
    "cluster_name": "elasticsearch",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "active_primary_shards": 83,
    "active_shards": 83,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 39,
    "unassigned_primary_shards": 0,
    "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": 68.0327868852459
}

Indices

Name Status Replication (pri, rep) Doc Count
.internal.alerts-transform.health.alerts-default-000001 open 1, 0 0
henkel_product_1755524218 open 3, 3 1077096
.internal.alerts-ml.anomaly-detection.alerts-default-000001 open 1, 0 0
.internal.alerts-observability.slo.alerts-default-000001 open 1, 0 0
hypneu_product_1761225792 open 1, 1 24297411
.internal.alerts-observability.apm.alerts-default-000001 open 1, 0 0
.internal.alerts-streams.alerts-default-000001 open 1, 0 0
.internal.alerts-default.alerts-default-000001 open 1, 0 0
.internal.alerts-security.attack.discovery.alerts-default-000001 open 1, 0 0
.internal.alerts-observability.metrics.alerts-default-000001 open 1, 0 0
.internal.alerts-ml.anomaly-detection-health.alerts-default-000001 open 1, 0 0
.internal.alerts-security.alerts-default-000001 open 1, 0 0
.internal.alerts-stack.alerts-default-000001 open 1, 0 0
.internal.alerts-observability.logs.alerts-default-000001 open 1, 0 0
.internal.alerts-observability.uptime.alerts-default-000001 open 1, 0 0
magento2_product_1_v1 open 1, 1 0
.kibana-observability-ai-assistant-conversations-000001 open 1, 0 0
.internal.alerts-observability.threshold.alerts-default-000001 open 1, 0 0
sw6tec_product_1741024231 open 3, 3 13694206
.internal.alerts-dataset.quality.alerts-default-000001 open 1, 0 0
.kibana-observability-ai-assistant-kb-000001 open 1, 0 0
sw6tec_product_1764166372 open 1, 1 14211250
gzautoteile_product_1741095151 open 3, 3 14374475
sw_product_1747747808 open 3, 3 13948621