Query Metrics
81.00 ms
Query Time
1
Node(s)
42
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 43.61 ms |
Request:
{"index":"sw_product","search_type":"query_then_fetch","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"term":{"productNumber":"SW10047"}},{"term":{"productNumber":"SW10046"}},{"term":{"productNumber":"B00440918"}},{"term":{"productNumber":"B00223563"}},{"term":{"productNumber":"B00223562"}}]}},{"bool":{"must_not":[{"term":{"id":"90b5b4ac942548899bd755e62717f055"}}]}},{"exists":{"field":"displayGroup"}},{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_2a5cd912562c4aebbbd2ee2c9f3d14bb":{"gte":10}}}]}},{"bool":{"should":[{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"terms":{"parent.swagDynamicAccessRules.id":["092cbf7d7bb845cf871f8bc35847021a","2cf59896af66475896ec8abd03ac26b6","3858957016644de4ae48c0500bf3ccc8","3c9d7d926b6a47fe8d4ae20d0a993424","69e0e90bd44d465989887976752efdfc","e1378db7808a478f919e0d740d5d6c1a","e92b366fe0ce497b9b5e2b4c2a2cb0f6","fa9feb38521b4c508af91afafcf89eaa","26d71577e36549c88b704bb9e7f73918","28caae75a5624f0d985abd0eb32aa160","53d34850dc394bd7806d5818c3011a2d","71012c3c5bf6413d83b96241e47bd9dd"]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}},{"nested":{"path":"swagDynamicAccessRules","query":{"terms":{"swagDynamicAccessRules.id":["092cbf7d7bb845cf871f8bc35847021a","2cf59896af66475896ec8abd03ac26b6","3858957016644de4ae48c0500bf3ccc8","3c9d7d926b6a47fe8d4ae20d0a993424","69e0e90bd44d465989887976752efdfc","e1378db7808a478f919e0d740d5d6c1a","e92b366fe0ce497b9b5e2b4c2a2cb0f6","fa9feb38521b4c508af91afafcf89eaa","26d71577e36549c88b704bb9e7f73918","28caae75a5624f0d985abd0eb32aa160","53d34850dc394bd7806d5818c3011a2d","71012c3c5bf6413d83b96241e47bd9dd"]}}}},{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"parent.swagDynamicAccessRules.id"}}]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}}]}}]}}]}},"sort":[{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"order":"ASC"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
|
| 2 | 37.61 ms |
Request:
{"index":"sw_product","search_type":"query_then_fetch","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"term":{"productNumber":"SW10047"}},{"term":{"productNumber":"SW10046"}},{"term":{"productNumber":"B00440918"}},{"term":{"productNumber":"B00223563"}},{"term":{"productNumber":"B00223562"}}]}},{"bool":{"must_not":[{"term":{"id":"90b5b4ac942548899bd755e62717f055"}}]}},{"exists":{"field":"displayGroup"}},{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_2a5cd912562c4aebbbd2ee2c9f3d14bb":{"gte":10}}}]}},{"bool":{"should":[{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"terms":{"parent.swagDynamicAccessRules.id":["092cbf7d7bb845cf871f8bc35847021a","2cf59896af66475896ec8abd03ac26b6","3858957016644de4ae48c0500bf3ccc8","3c9d7d926b6a47fe8d4ae20d0a993424","69e0e90bd44d465989887976752efdfc","e1378db7808a478f919e0d740d5d6c1a","e92b366fe0ce497b9b5e2b4c2a2cb0f6","fa9feb38521b4c508af91afafcf89eaa","26d71577e36549c88b704bb9e7f73918","28caae75a5624f0d985abd0eb32aa160","53d34850dc394bd7806d5818c3011a2d","71012c3c5bf6413d83b96241e47bd9dd"]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}},{"nested":{"path":"swagDynamicAccessRules","query":{"terms":{"swagDynamicAccessRules.id":["092cbf7d7bb845cf871f8bc35847021a","2cf59896af66475896ec8abd03ac26b6","3858957016644de4ae48c0500bf3ccc8","3c9d7d926b6a47fe8d4ae20d0a993424","69e0e90bd44d465989887976752efdfc","e1378db7808a478f919e0d740d5d6c1a","e92b366fe0ce497b9b5e2b4c2a2cb0f6","fa9feb38521b4c508af91afafcf89eaa","26d71577e36549c88b704bb9e7f73918","28caae75a5624f0d985abd0eb32aa160","53d34850dc394bd7806d5818c3011a2d","71012c3c5bf6413d83b96241e47bd9dd"]}}}},{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"parent.swagDynamicAccessRules.id"}}]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}}]}}]}}]}},"sort":[{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"order":"ASC"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
|
Cluster Status
{
"cluster_name": "shopware-cluster",
"status": "yellow",
"timed_out": false,
"number_of_nodes": 1,
"number_of_data_nodes": 1,
"discovered_master": true,
"discovered_cluster_manager": true,
"active_primary_shards": 77,
"active_shards": 77,
"relocating_shards": 0,
"initializing_shards": 0,
"unassigned_shards": 168,
"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": 31.428571428571427
}
Indices
| Name▲ | Status | Replication (pri, rep) | Doc Count |
|---|---|---|---|
| sw-admin-product-stream-listing_1768212054 | open | 3, 3 | 0 |
| sw_product_manufacturer_1768215358 | open | 1, 1 | 9036 |
| sw_product_1765898309 | open | 1, 1 | 0 |
| sw_product_manufacturer_1765898309 | open | 1, 1 | 0 |
| sw-admin-sales-channel-listing_1768212052 | open | 3, 3 | 8 |
| sw_product_1765897898 | open | 1, 1 | 0 |
| sw_product_1768215358 | open | 1, 1 | 11204316 |
| top_queries-2026.02.12-95553 | open | 1, 0 | 73 |
| sw-admin-order-listing_1768212047 | open | 3, 3 | 1 |
| sw-admin-customer-group-listing_1768212043 | open | 3, 3 | 0 |
| sw_product_manufacturer_1765897898 | open | 1, 1 | 0 |
| sw_product_manufacturer_1765899678 | open | 1, 1 | 9036 |
| sw-admin-media-listing_1768212044 | open | 3, 3 | 22 |
| top_queries-2026.02.10-95551 | open | 1, 0 | 44 |
| .opensearch-observability | open | 1, 0 | 0 |
| sw-admin-property-group-listing_1768212050 | open | 3, 3 | 16 |
| sw_category_1768211368 | open | 1, 1 | 8743 |
| sw-admin-promotion-listing_1768212050 | open | 3, 3 | 0 |
| sw_product_1765899678 | open | 1, 1 | 11229400 |
| top_queries-2026.02.07-95527 | open | 1, 0 | 316 |
| sw-admin-customer-listing_1768212042 | open | 3, 3 | 0 |
| sw-admin-payment-method-listing_1768212048 | open | 3, 3 | 0 |
| sw-admin-quote-listing_1768212055 | open | 3, 3 | 0 |
| top_queries-2026.02.13-95554 | open | 1, 0 | 18 |
| sw_product_manufacturer_1768211368 | open | 1, 1 | 9036 |
| sw_category_1768215358 | open | 1, 1 | 8829 |
| sw_category_1765897898 | open | 1, 1 | 0 |
| top_queries-2026.02.06-95526 | open | 1, 0 | 298 |
| top_queries-2026.02.11-95552 | open | 1, 0 | 17 |
| sw-admin-manufacturer-listing_1768212044 | open | 3, 3 | 3 |
| top_queries-2026.02.09-95529 | open | 1, 0 | 21 |
| sw_product_1768211368 | open | 1, 1 | 11229400 |
| sw_category_1765899678 | open | 1, 1 | 8743 |
| sw-admin-category-listing_1768212053 | open | 3, 3 | 16 |
| top_queries-2026.02.08-95528 | open | 1, 0 | 71 |
| .plugins-ml-config | open | 1, 0 | 1 |
| sw_category_1765898309 | open | 1, 1 | 0 |
| sw-admin-newsletter-recipient-listing_1768212053 | open | 3, 3 | 0 |
| sw-admin-cms-page-listing_1768212041 | open | 3, 3 | 0 |
| sw-admin-product-listing_1768212048 | open | 3, 3 | 24 |
| sw-admin-shipping-method-listing_1768212052 | open | 3, 3 | 0 |
| sw-admin-landing-page-listing_1768212043 | open | 3, 3 | 0 |