https://schramm-werkstaetten-stage.scalecommerce.cloud/navigation/6b80d2c7a8e3424da757cfa084578284

Query Metrics

7.00 ms Query Time
1 Node(s)
55 Indices

Queries

# Execution Time Info
1 3.59 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":"6b80d2c7a8e3424da757cfa084578284"}}}},{"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.51 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":"6b80d2c7a8e3424da757cfa084578284"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"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.43 ms Request:
{"index":"sw_stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["a0a18747150b40acbd06f0c0717d3c11","d1fa2946007b493fa045d7118ad7d2ea","301f41d66abe4892bdf49ee0b27dbd13","c307a36a3fde4fb6985f7f52debfe376","ea57f836831d46afbbb7f98f1a5efd50","392e8fb6c9914af0a1d92284638c1a0e","60c1737457e44e669f436669c4bc0347","9d57f1cc189842c29125cc67dbf8c35e","ecc4bd8c2d97430d9b28a037f9896834","23b10ad68c8c4e27a45bcad126053808"]}},{"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.39 ms Request:
{"index":"sw_stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["ea57f836831d46afbbb7f98f1a5efd50","60c1737457e44e669f436669c4bc0347","ecc4bd8c2d97430d9b28a037f9896834","a0a18747150b40acbd06f0c0717d3c11","9d57f1cc189842c29125cc67dbf8c35e","301f41d66abe4892bdf49ee0b27dbd13","c307a36a3fde4fb6985f7f52debfe376","392e8fb6c9914af0a1d92284638c1a0e","23b10ad68c8c4e27a45bcad126053808","d1fa2946007b493fa045d7118ad7d2ea","adc441ebd8ea4030924a5c67fa81e7be","d3e142e31ae14672bdd759d17dd19fa7"]}},{"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_category_f9e43878b64d426abcdb820a918ca029_1727787142 open 3, 3 280
sw_prod_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727791808 open 3, 3 4
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_category_f9e43878b64d426abcdb820a918ca029_1727787628 open 3, 3 280
sw_prod_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727787628 open 3, 3 280
sw_prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1721738852 open 3, 3 8141
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_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1721738852 open 3, 3 4
sw_prod_category_f9e43878b64d426abcdb820a918ca029_1727787633 open 3, 3 280
sw_prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727791995 open 3, 3 8141
sw_prod_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727791808 open 3, 3 280
sw_prod_product_manufacturer_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1727783146 open 3, 3 4
sw_prod_category_f9e43878b64d426abcdb820a918ca029_1727791808 open 3, 3 280
sw_prod_product_manufacturer_f9e43878b64d426abcdb820a918ca029_1727787142 open 3, 3 4
sw_prod_product_f9e43878b64d426abcdb820a918ca029_1727787142 open 3, 3 8141
sw_prod_product_manufacturer_f9e43878b64d426abcdb820a918ca029_1727783146 open 3, 3 4