Query Metrics
12.00 ms
Query Time
1
Node(s)
23
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 8.33 ms |
Request:
{"index":"sw_all4team_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":"a4d331012b00410ab817a4dd8c7bc7f0"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"01899826b73871a6a71048f038dff684"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":16,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
|
| 2 | 3.68 ms |
Request:
{"index":"sw_all4team_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":"a4d331012b00410ab817a4dd8c7bc7f0"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"01899826b73871a6a71048f038dff684"}}}},{"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_rule1eac567d7d314563bfa3305e2e8446bb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule9628985660b5415c9ee8f65bade111bf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleeb63558ebb734bde8518103eff3442cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule8444b9bcc809444aa5a3fe1f3260a9cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule43a89e1a4b454d078913ef45f83aafdf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6e3190c99cf44a80a3b9407e5e813c45_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": "opensearch",
"status": "yellow",
"timed_out": false,
"number_of_nodes": 1,
"number_of_data_nodes": 1,
"discovered_master": true,
"discovered_cluster_manager": true,
"active_primary_shards": 46,
"active_shards": 46,
"relocating_shards": 0,
"initializing_shards": 0,
"unassigned_shards": 108,
"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": 29.87012987012987
}
Indices
| Name▲ | Status | Replication (pri, rep) | Doc Count |
|---|---|---|---|
| top_queries-2026.01.10-65760 | open | 1, 1 | 13 |
| top_queries-2026.01.11-65761 | open | 1, 1 | 13 |
| sw_all4team_product_1716941102 | open | 3, 3 | 5216241 |
| top_queries-2026.01.09-65738 | open | 1, 1 | 13 |
| sw_all4team_product_1717545902 | open | 3, 3 | 5217183 |
| sw_all4team_product_1717113901 | open | 3, 3 | 5216814 |
| sw_all4team_product_1717027502 | open | 3, 3 | 5216573 |
| .opendistro_security | open | 1, 0 | 10 |
| sw_all4team_product_1717286702 | open | 3, 3 | 5217102 |
| top_queries-2026.01.08-65737 | open | 1, 1 | 13 |
| sw_all4team_product_1717373101 | open | 3, 3 | 5217108 |
| top_queries-2026.01.14-65764 | open | 1, 1 | 1810 |
| sw_all4team_product_1716336301 | open | 3, 3 | 6258372 |
| .plugins-ml-config | open | 1, 0 | 1 |
| .opensearch-observability | open | 1, 0 | 0 |
| sw_all4team_product_1717632302 | open | 3, 3 | 5217457 |
| sw_all4team_product_1717718701 | open | 3, 3 | 5217475 |
| top_queries-2026.01.13-65763 | open | 1, 1 | 1323 |
| top_queries-2026.01.15-65765 | open | 1, 1 | 721 |
| security-auditlog-2023.07.13 | open | 1, 1 | 44 |
| sw_all4team_product_1717200302 | open | 3, 3 | 5217018 |
| sw_all4team_product_1717459502 | open | 3, 3 | 5217133 |
| top_queries-2026.01.12-65762 | open | 1, 1 | 227 |