GET https://wagmbh-test-stage2.revier-shopware.de/navigation/2d3b0855f2c04b87b76a0e92bf8df044

Query Metrics

22.00 ms Query Time
1 Node(s)
25 Indices

Queries

# Execution Time Info
1 17.25 ms Request:
{"index":"stage2_product","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":"bfed4ac5fd564ff89843590cdf498c1c"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"2d3b0855f2c04b87b76a0e92bf8df044"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"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"},"search_type":"query_then_fetch"}
2 4.78 ms Request:
{"index":"stage2_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":"bfed4ac5fd564ff89843590cdf498c1c"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"2d3b0855f2c04b87b76a0e92bf8df044"}}}},{"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_rule6b046b97e2c24135a7578de54954c286_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule97ee4ade75bd4b26808c00f4c861d1b9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulecf9863d210ef4c33b0b13ed3416d4682_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulec2362338eaec42239815ae21a6b60183_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruleb585c17a68fd492bbb0507497e5f9b32_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"tdxcats":{"nested":{"path":"categoriesRo"},"aggregations":{"tdxcats":{"terms":{"field":"categoriesRo.id","size":10000}}}},"length":{"stats":{"field":"length"}},"width":{"stats":{"field":"width"}},"height":{"stats":{"field":"height"}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}

Cluster Status

{
    "cluster_name": "opensearch-cluster",
    "status": "green",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 68,
    "active_shards": 68,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_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": 100.0
}

Indices

Name Status Replication (pri, rep) Doc Count
.ql-datasources open 1, 0 0
stage2_category_1723549257 open 3, 0 656
stage3_category_1738934394 open 3, 0 1232
stage2_category_1726559133 open 3, 0 646
stage3_product_manufacturer_1738934394 open 3, 0 240
stage3_product_manufacturer_1738934152 open 3, 0 231
.opensearch-observability open 1, 0 0
stage3_product_1738934394 open 3, 0 542352
stage3_product_1738934152 open 3, 0 489632
stage3_category_1738934152 open 3, 0 656
walive_product_1738934814 open 3, 0 545957
stage2_category_1726562259 open 3, 0 656
stage2_category_1726562116 open 3, 0 656
.kibana_1 open 1, 0 4
stage2_product_manufacturer_1726562259 open 3, 0 220
stage2_product_manufacturer_1726562116 open 3, 0 220
walive_category_1738934814 open 3, 0 684
.plugins-ml-config open 1, 0 1
stage2_product_manufacturer_1723549257 open 3, 0 220
stage2_product_manufacturer_1726559133 open 3, 0 239
stage2_product_1723549257 open 3, 0 440859
stage2_product_1726562259 open 3, 0 448601
stage2_product_1726562116 open 3, 0 448601
stage2_product_1726559133 open 3, 0 508943
walive_product_manufacturer_1738934814 open 3, 0 240