Query Metrics
4.00 ms
Query Time
1
Node(s)
25
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 3.29 ms |
Request:
{"index":"sw_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":"250c23c94a704f8ba1b4819c38901688"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"1ef4ef5f5b67444aa7b9d9179df92343"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"number","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;\n }\n}\n\nif (params['order'] == 'asc') {\n return Double.MAX_VALUE;\n}\n\nreturn Double.MIN_VALUE;\n","lang":"painless","params":{"field":"customFields","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"custom_product_rosland_set_year","order":"desc"}},"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":36,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
|
| 2 | 1.35 ms |
Request:
{"index":"sw_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":"250c23c94a704f8ba1b4819c38901688"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"1ef4ef5f5b67444aa7b9d9179df92343"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule64bf19224e314563aba24460dda765f8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule89d3fe06bd7c478194fe9179a9602df5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled980a6dfc7774cd192e0b1a183764274_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbc995737796b164a7b5355b5d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbca2673cf9fb2d67da0cd8a62_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0197e9e4d10e7293b705c1d0eee95b29_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0197e9e4d446718a91aafc7b03ab341a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6235b68395cd475f90278d41d7b1b36c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleac5af03b5965434681e7c4cb42720d2b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecc1de6f5416545d3a68a00f78e8f20f3_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": "elasticsearch",
"status": "yellow",
"timed_out": false,
"number_of_nodes": 1,
"number_of_data_nodes": 1,
"active_primary_shards": 124,
"active_shards": 124,
"relocating_shards": 0,
"initializing_shards": 0,
"unassigned_shards": 263,
"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": 32.041343669250644
}
Indices
| Name▲ | Status | Replication (pri, rep) | Doc Count |
|---|---|---|---|
| sw_product_1756237100 | open | 1, 1 | 252329 |
| roslandn_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1685973755 | open | 3, 3 | 0 |
| roslandn_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1685973732 | open | 3, 3 | 0 |
| rosland_product_1712914068 | open | 3, 3 | 228333 |
| sw-admin-sales-channel-listing_1696198995 | open | 3, 3 | 4 |
| sw-admin-product-stream-listing_1696198998 | open | 3, 3 | 45 |
| sw-admin-category-listing_1696198945 | open | 3, 3 | 0 |
| sw-admin-shipping-method-listing_1696198996 | open | 3, 3 | 6 |
| rosland_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1696198942 | open | 3, 3 | 17524 |
| sw-admin-landing-page-listing_1696198989 | open | 3, 3 | 0 |
| sw-admin-newsletter-recipient-listing_1696198998 | open | 3, 3 | 173 |
| sw-admin-customer-listing_1696198987 | open | 3, 3 | 2918 |
| sw-admin-product-listing_1696198993 | open | 3, 3 | 4963 |
| sw-admin-cms-page-listing_1696198986 | open | 3, 3 | 194 |
| sw-admin-payment-method-listing_1696198992 | open | 3, 3 | 68 |
| sw-admin-order-listing_1696198991 | open | 3, 3 | 3477 |
| sw-admin-customer-group-listing_1696198988 | open | 3, 3 | 4 |
| rosland_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1696198953 | open | 3, 3 | 158814 |
| sw-admin-category-listing_1696198997 | open | 3, 3 | 421 |
| sw-admin-manufacturer-listing_1696198990 | open | 3, 3 | 37 |
| sw-admin-shipping-method-listing_1696198944 | open | 3, 3 | 0 |
| sw_product_1717666750 | open | 3, 3 | 223964 |
| sw-admin-media-listing_1696198991 | open | 3, 3 | 22533 |
| sw-admin-promotion-listing_1696198994 | open | 3, 3 | 25 |
| sw-admin-property-group-listing_1696198994 | open | 3, 3 | 20 |