Query Metrics
12.00 ms
Query Time
1
Node(s)
55
Indices
Queries
#▲ | Execution Time | Info |
---|---|---|
1 | 7.62 ms |
Request:
{"index":"sw_stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","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":"8bf13830e35647b5911db25834d86400"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"f75e35d0914644518032c8a90ca0cfb4"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"name":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"}}} |
2 | 1.32 ms |
Request:
{"index":"sw_stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"8bf13830e35647b5911db25834d86400"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"f75e35d0914644518032c8a90ca0cfb4"}}}},{"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_rule212203daac8543ec9d615c6c58f69ce8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule18228f6fca1d4b55b5a5f9a816098eed_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule3461734309da497fbf6eea5a006584cd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule3858957016644de4ae48c0500bf3ccc8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleaf05689589154ddebe8114ed04250636_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulebe2fe8cd631145a894252de95ab8e885_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee1378db7808a478f919e0d740d5d6c1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec6d8c92db24740dcb7e263453d5ce8bd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"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}} |
3 | 1.37 ms |
Request:
{"index":"sw_stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["2933894fc3d54106a9870271bae2ca98","d705260197964b18868e8375d11d40c8","614f51d1bbd44f2f838df0072419a2cb"]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"8bf13830e35647b5911db25834d86400"}}]}}}},{"term":{"active":true}}]}}]}},"from":0,"size":10000}} |
4 | 1.72 ms |
Request:
{"index":"sw_stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["d705260197964b18868e8375d11d40c8","4c840e15c25849acbe1610ba68b52aa1","96ce5ed01d4e4b988e082a8516cb25de","614f51d1bbd44f2f838df0072419a2cb","537290f7b70d49e59167ac8aa0c0c375","2933894fc3d54106a9870271bae2ca98"]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"8bf13830e35647b5911db25834d86400"}}]}}}},{"term":{"active":true}}]}}]}},"from":0,"size":10000}} |
Cluster Status
{"cluster_name":"schramm-werkstaetten","status":"yellow","timed_out":false,"number_of_nodes":1,"number_of_data_nodes":1,"active_primary_shards":169,"active_shards":169,"relocating_shards":0,"initializing_shards":0,"unassigned_shards":432,"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":28.1198003327787}
Indices
Name▲ | Status | Replication (pri, rep) | Doc Count |
---|---|---|---|
sw_stage_category_f9e43878b64d426abcdb820a918ca029_1678714270 | open | 3, 0 | 277 |
sw_prod_product_f9e43878b64d426abcdb820a918ca029_1727787633 | open | 3, 3 | 8141 |
sw_prod_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727787633 | open | 3, 3 | 280 |
sw_stage_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1650636855 | open | 3, 0 | 291 |
sw_prod_category_f9e43878b64d426abcdb820a918ca029_1721738852 | open | 3, 3 | 282 |
sw_prod_category_f9e43878b64d426abcdb820a918ca029_1727791995 | open | 3, 3 | 280 |
sw_stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1649684760 | open | 3, 0 | 9314 |
sw_prod_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727783146 | open | 3, 3 | 280 |
sw_prod_category_f9e43878b64d426abcdb820a918ca029_1727783146 | open | 3, 3 | 280 |
sw_stage_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727765714 | open | 3, 3 | 4 |
sw_prod_product_f9e43878b64d426abcdb820a918ca029_1727791808 | open | 3, 3 | 8141 |
sw_prod_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727791808 | open | 3, 3 | 4 |
sw_prod_category_f9e43878b64d426abcdb820a918ca029_1727787142 | open | 3, 3 | 280 |
sw_stage_product_f9e43878b64d426abcdb820a918ca029_1727765714 | open | 3, 3 | 5080 |
sw_prod_product_manufacturer_f9e43878b64d426abcdb820a918ca029_1727787633 | open | 3, 3 | 4 |
sw_stage_product_f9e43878b64d426abcdb820a918ca029_1678714270 | open | 3, 0 | 5080 |
sw_prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727787633 | open | 3, 3 | 8141 |
sw_stage_category_f9e43878b64d426abcdb820a918ca029_1727765714 | open | 3, 3 | 277 |
sw_stage_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727765714 | open | 3, 3 | 277 |
sw_stage_product_manufacturer_f9e43878b64d426abcdb820a918ca029_1678714270 | open | 3, 0 | 4 |
sw_prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727791808 | open | 3, 3 | 8141 |
sw_prod_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727791995 | open | 3, 3 | 280 |
sw_stage_product_manufacturer_f9e43878b64d426abcdb820a918ca029_1727765714 | open | 3, 3 | 4 |
sw_prod_product_f9e43878b64d426abcdb820a918ca029_1727791995 | open | 3, 3 | 8141 |
sw_prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727783146 | open | 3, 3 | 8141 |
sw_prod_product_manufacturer_f9e43878b64d426abcdb820a918ca029_1727787628 | open | 3, 3 | 4 |
sw_prod_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1721738852 | open | 3, 3 | 282 |
sw_prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727787628 | open | 3, 3 | 8141 |
sw_prod_product_f9e43878b64d426abcdb820a918ca029_1721738852 | open | 3, 3 | 8141 |
.geoip_databases | open | 1, 0 | 40 |
sw_stage_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1650636855 | open | 3, 0 | 4 |
sw_prod_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727787633 | open | 3, 3 | 4 |
sw_prod_product_manufacturer_f9e43878b64d426abcdb820a918ca029_1727791808 | open | 3, 3 | 4 |
sw_stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727765714 | open | 3, 3 | 5080 |
sw_prod_product_manufacturer_f9e43878b64d426abcdb820a918ca029_1721738852 | open | 3, 3 | 4 |
sw_prod_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727787142 | open | 3, 3 | 280 |
sw_prod_product_f9e43878b64d426abcdb820a918ca029_1727783146 | open | 3, 3 | 8141 |
sw_prod_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727787628 | open | 3, 3 | 4 |
sw_prod_product_f9e43878b64d426abcdb820a918ca029_1727787628 | open | 3, 3 | 8141 |
sw_prod_product_manufacturer_f9e43878b64d426abcdb820a918ca029_1727791995 | open | 3, 3 | 4 |
sw_prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1721738852 | open | 3, 3 | 8141 |
sw_prod_category_f9e43878b64d426abcdb820a918ca029_1727787628 | open | 3, 3 | 280 |
sw_prod_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727787628 | open | 3, 3 | 280 |
sw_prod_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727787142 | open | 3, 3 | 4 |
sw_prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727787142 | open | 3, 3 | 8141 |
sw_prod_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727791995 | open | 3, 3 | 4 |
sw_prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727791995 | open | 3, 3 | 8141 |
sw_prod_category_f9e43878b64d426abcdb820a918ca029_1727787633 | open | 3, 3 | 280 |
sw_prod_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1721738852 | open | 3, 3 | 4 |
sw_prod_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727791808 | open | 3, 3 | 280 |
sw_prod_category_f9e43878b64d426abcdb820a918ca029_1727791808 | open | 3, 3 | 280 |
sw_prod_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727783146 | open | 3, 3 | 4 |
sw_prod_product_manufacturer_f9e43878b64d426abcdb820a918ca029_1727787142 | open | 3, 3 | 4 |
sw_prod_product_manufacturer_f9e43878b64d426abcdb820a918ca029_1727783146 | open | 3, 3 | 4 |
sw_prod_product_f9e43878b64d426abcdb820a918ca029_1727787142 | open | 3, 3 | 8141 |