Query Metrics
25.00 ms
Query Time
1
Node(s)
19
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 25.86 ms |
Request:
{"index":"sw6_product","search_type":"query_then_fetch","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"nested":{"path":"tags","query":{"terms":{"tags.id":["019223c86dda7f3dbd33618225af9149"]}}}}]}},{"bool":{"must_not":[{"term":{"id":"0e9e9d23b364493d5723e00cdaf50000"}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"35770e9aa5af44e5b861a83b1d6baca3"}}]}}}},{"term":{"active":true}}]}}]}}]}},"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"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
|
Cluster Status
{
"cluster_name": "elasticsearch",
"status": "yellow",
"timed_out": false,
"number_of_nodes": 1,
"number_of_data_nodes": 1,
"active_primary_shards": 63,
"active_shards": 63,
"relocating_shards": 0,
"initializing_shards": 0,
"unassigned_shards": 171,
"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": 26.923076923076923
}
Indices
| Name▲ | Status | Replication (pri, rep) | Doc Count |
|---|---|---|---|
| sw6_admin-property-group-listing_1729458351 | open | 3, 3 | 1 |
| sw6_admin-landing-page-listing_1729458350 | open | 3, 3 | 0 |
| sw6_admin-payment-method-listing_1729458351 | open | 3, 3 | 25 |
| sw6_admin-sales-channel-listing_1729458351 | open | 3, 3 | 2 |
| sw6_admin-customer-listing_1729458350 | open | 3, 3 | 12 |
| sw6_admin-order-listing_1729458351 | open | 3, 3 | 34 |
| sw6_admin-product-stream-listing_1729458352 | open | 3, 3 | 39 |
| sw6_admin-promotion-listing_1729458351 | open | 3, 3 | 3 |
| sw6_product_2c06df6dde78421e8d5c8bbf1301d08e_1729458435 | open | 3, 3 | 5178 |
| sw6_admin-cms-page-listing_1729458350 | open | 3, 3 | 13 |
| sw6_admin-media-listing_1729458351 | open | 3, 3 | 1479 |
| sw6_product_1737381753 | open | 3, 3 | 5271 |
| sw6_admin-customer-group-listing_1729458350 | open | 3, 3 | 10 |
| sw6_admin-category-listing_1729458351 | open | 3, 3 | 48 |
| sw6_admin-shipping-method-listing_1729458351 | open | 3, 3 | 9 |
| sw6_admin-newsletter-recipient-listing_1729458352 | open | 3, 3 | 2 |
| sw6_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1729458435 | open | 3, 3 | 5178 |
| sw6_admin-product-listing_1729458351 | open | 3, 3 | 778 |
| sw6_admin-manufacturer-listing_1729458351 | open | 3, 3 | 2 |