Query Metrics
21.00 ms
Query Time
1
Node(s)
27
Indices
Queries
#▲ | Execution Time | Info |
---|---|---|
1 | 11.50 ms |
Request:
{"index":"sw_dev_product","track_total_hits":true,"body":{"post_filter":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}}]}},"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}],"must":[{"bool":{"should":[{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"webcam","boost":120,"slop":1,"max_expansions":30}}},{"wildcard":{"productNumber":{"value":"*webcam*","boost":100}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"webcam","boost":90,"fuzziness":1}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"webcam","boost":60,"fuzziness":1}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"query":"webcam","boost":40,"fuzziness":1}}},{"wildcard":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.keyword":{"value":"*webcam*","boost":100}}},{"match":{"ean.search":{"query":"webcam","boost":100,"fuzziness":0}}},{"match":{"manufacturerNumber.ngram":{"query":"webcam","boost":100,"fuzziness":"auto"}}}],"minimum_should_match":"1"}}]}},"sort":[{"_score":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-filtered-count":{"filter":{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"} |
2 | 6.56 ms |
Request:
{"index":"sw_dev_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}],"must":[{"bool":{"should":[{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"webcam","boost":120,"slop":1,"max_expansions":30}}},{"wildcard":{"productNumber":{"value":"*webcam*","boost":100}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"webcam","boost":90,"fuzziness":1}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"webcam","boost":60,"fuzziness":1}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"query":"webcam","boost":40,"fuzziness":1}}},{"wildcard":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.keyword":{"value":"*webcam*","boost":100}}},{"match":{"ean.search":{"query":"webcam","boost":100,"fuzziness":0}}},{"match":{"manufacturerNumber.ngram":{"query":"webcam","boost":100,"fuzziness":"auto"}}}],"minimum_should_match":"1"}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018de6e8b2f4732eabd46ad6cf99d51b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","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":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},"aggregations":{"properties":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},"aggregations":{"properties":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}},"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}}}},"propertiesCount":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},"aggregations":{"propertiesCount":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},"aggregations":{"propertiesCount":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}},"aggregations":{"propertiesCount":{"terms":{"field":"propertyIds","size":10000}}}}}}}},"brands":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},"aggregations":{"brands":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},"aggregations":{"brands":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}},"aggregations":{"brands":{"terms":{"field":"manufacturerId","size":10000}}}}}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"} |
3 | 2.20 ms |
Request:
{"index":"sw_dev_product_manufacturer","track_total_hits":true,"body":{"from":0,"size":9,"timeout":"5s"},"search_type":"query_then_fetch"} |
4 | 1.69 ms |
Request:
{"index":"sw_dev_category","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"active":true}},{"bool":{"should":[{"wildcard":{"path":{"value":"*|d7b7b163000841a1876dbff5548c039f|*"}}},{"wildcard":{"path":{"value":"*|85198047d8e44d18b38cc9080624d1df|*"}}},{"wildcard":{"path":{"value":"*|85198047d8e44d18b38cc9080624d1df|*"}}}]}}]}}]}},"from":0,"size":9,"timeout":"5s"},"search_type":"query_then_fetch"} |
Cluster Status
{ "cluster_name": "showpare", "status": "yellow", "timed_out": false, "number_of_nodes": 1, "number_of_data_nodes": 1, "discovered_master": true, "discovered_cluster_manager": true, "active_primary_shards": 34, "active_shards": 34, "relocating_shards": 0, "initializing_shards": 0, "unassigned_shards": 45, "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": 43.037974683544306 }
Indices
Name▲ | Status | Replication (pri, rep) | Doc Count |
---|---|---|---|
.ql-datasources | open | 1, 0 | 0 |
security-auditlog-2025.01.20 | open | 1, 1 | 125 |
security-auditlog-2025.01.22 | open | 1, 1 | 300 |
security-auditlog-2025.01.21 | open | 1, 1 | 396 |
security-auditlog-2025.01.24 | open | 1, 1 | 235 |
security-auditlog-2025.01.23 | open | 1, 1 | 1641 |
security-auditlog-2025.01.26 | open | 1, 1 | 91 |
security-auditlog-2025.01.25 | open | 1, 1 | 83 |
security-auditlog-2025.01.28 | open | 1, 1 | 98 |
.opendistro_security | open | 1, 0 | 10 |
security-auditlog-2025.01.27 | open | 1, 1 | 164 |
security-auditlog-2025.01.29 | open | 1, 1 | 98 |
.opensearch-observability | open | 1, 0 | 0 |
sw_dev_product_1737186629 | open | 3, 3 | 60673 |
sw_dev_category_1737186629 | open | 3, 3 | 0 |
security-auditlog-2025.01.31 | open | 1, 1 | 147 |
security-auditlog-2025.01.30 | open | 1, 1 | 118 |
.kibana_92668751_admin_1 | open | 1, 0 | 1 |
security-auditlog-2025.01.15 | open | 1, 1 | 187 |
security-auditlog-2025.01.14 | open | 1, 1 | 122 |
security-auditlog-2025.01.17 | open | 1, 1 | 77 |
.kibana_1 | open | 1, 0 | 0 |
sw_dev_product_manufacturer_1737186629 | open | 3, 3 | 0 |
security-auditlog-2025.01.16 | open | 1, 1 | 356 |
security-auditlog-2025.01.19 | open | 1, 1 | 49 |
security-auditlog-2025.01.18 | open | 1, 1 | 248 |
.plugins-ml-config | open | 1, 0 | 1 |