Query Metrics
3.00 ms
Query Time
1
Node(s)
28
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 3.17 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"d41d8cd98f00b204e9800998ecf8427e"}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"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"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"},"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": 86,
"active_shards": 86,
"relocating_shards": 0,
"initializing_shards": 0,
"unassigned_shards": 252,
"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": 25.443786982248522
}
Indices
| Name▲ | Status | Replication (pri, rep) | Doc Count |
|---|---|---|---|
| sw-admin-payment-method-listing_1732606828 | open | 3, 3 | 45 |
| shopware6-stage_product_1725962023 | open | 3, 3 | 698878 |
| shopware6-new_product_1723452452 | open | 3, 3 | 698878 |
| sw-admin-mollie-refund_1732606829 | open | 3, 3 | 0 |
| shopware6-stage_product_01894ed2cf1a70659e13690a9aca16a3_1723451325 | open | 3, 3 | 411469 |
| sw-admin-promotion-listing_1732606828 | open | 3, 3 | 9 |
| shopware6-stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1723451325 | open | 3, 3 | 411469 |
| sw-admin-media-listing_1732606828 | open | 3, 3 | 10049 |
| sw-admin-product-stream-listing_1732606829 | open | 3, 3 | 7353 |
| sw-admin-manufacturer-listing_1732606827 | open | 3, 3 | 127 |
| sw-admin-newsletter-recipient-listing_1732606829 | open | 3, 3 | 1 |
| sw-admin-cms-page-listing_1732606827 | open | 3, 3 | 65 |
| sw-admin-product-listing_1732606828 | open | 3, 3 | 9462 |
| shopware6-stage_product_1717777228 | open | 3, 3 | 698886 |
| shopware6-stage_product_1725967126 | open | 3, 3 | 773930 |
| sw-admin-sales-channel-listing_1732606828 | open | 3, 3 | 2 |
| shopware6-new_product_1723451173 | open | 3, 3 | 698866 |
| sw-admin-landing-page-listing_1732606827 | open | 3, 3 | 16 |
| sw-admin-customer-group-listing_1732606827 | open | 3, 3 | 2 |
| shopware6-stage_product_1725967107 | open | 3, 3 | 698878 |
| sw-admin-category-listing_1732606829 | open | 3, 3 | 374 |
| sw-admin-mollie-subscription_1732606829 | open | 3, 3 | 0 |
| sw-admin-order-listing_1732606828 | open | 3, 3 | 462 |
| shopware6-stage_product_1725958313 | open | 3, 3 | 698878 |
| sw-admin-property-group-listing_1732606828 | open | 3, 3 | 137 |
| sw-admin-customer-listing_1732606827 | open | 3, 3 | 133 |
| sw-admin-shipping-method-listing_1732606828 | open | 3, 3 | 3 |
| shopware6-stage_product_1725962160 | open | 3, 3 | 698878 |