Query Metrics
9
Database Queries
13.43 ms
Execution Time
3.00 ms
Query Time
Queries
| #▲ | Execution Time | Query Time | Info |
|---|---|---|---|
| 1 | 1.49 ms | 0.00 ms |
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["boospa"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace
curl -XPOST 'http://localhost:9200/bitbag_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["boospa"]}}]}},"size":20}'
|
| 2 | 4.45 ms | 3.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["COMM_MODULE_SHOP"]}},{"terms":{"product_taxons.keyword":["boospa"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"aggs":{"protocol":{"terms":{"field":"attribute_protocol_en_US.keyword"}},"voltage":{"terms":{"field":"option_voltage.keyword"}},"module_type":{"terms":{"field":"attribute_module_type_en_US.keyword"}},"flight_time":{"terms":{"field":"attribute_flight_time_en_US.keyword"}},"camera_resolution":{"terms":{"field":"attribute_camera_resolution_en_US.keyword"}},"max_speed":{"terms":{"field":"attribute_max_speed_en_US.keyword"}},"weight":{"terms":{"field":"attribute_weight_en_US.keyword"}},"battery_type":{"terms":{"field":"attribute_battery_type_en_US.keyword"}},"control_range":{"terms":{"field":"attribute_control_range_en_US.keyword"}},"payload_capacity":{"terms":{"field":"attribute_payload_capacity_en_US.keyword"}},"dimensions":{"terms":{"field":"attribute_dimensions_en_US.keyword"}},"rayon-angle":{"terms":{"field":"attribute_rayon-angle_en_US.keyword"}},"revetement":{"terms":{"field":"attribute_revetement_en_US.keyword"}},"color_consolidated":{"terms":{"field":"option_color_consolidated.keyword"}},"power_consolidated":{"terms":{"field":"option_power_consolidated.keyword"}},"impedance_consolidated":{"terms":{"field":"option_impedance_consolidated.keyword"}},"single_board_computers_processor":{"terms":{"field":"option_single_board_computers_processor.keyword"}},"single_board_computers_ram":{"terms":{"field":"option_single_board_computers_ram.keyword"}},"antenna_consolidated":{"terms":{"field":"option_antenna_consolidated.keyword"}},"speed_consolidated":{"terms":{"field":"option_speed_consolidated.keyword"}},"efficiency_consolidated":{"terms":{"field":"option_efficiency_consolidated.keyword"}},"regulation_consolidated":{"terms":{"field":"option_regulation_consolidated.keyword"}},"capacity_consolidated":{"terms":{"field":"option_capacity_consolidated.keyword"}},"primary_consolidated":{"terms":{"field":"option_primary_consolidated.keyword"}},"secondary_consolidated":{"terms":{"field":"option_secondary_consolidated.keyword"}},"version_consolidated":{"terms":{"field":"option_version_consolidated.keyword"}},"data_consolidated":{"terms":{"field":"option_data_consolidated.keyword"}},"poles_consolidated":{"terms":{"field":"option_poles_consolidated.keyword"}},"mounting_consolidated":{"terms":{"field":"option_mounting_consolidated.keyword"}},"audio_xlr_pins":{"terms":{"field":"option_audio_xlr_pins.keyword"}},"audio_xlr_gender":{"terms":{"field":"option_audio_xlr_gender.keyword"}},"control_consolidated":{"terms":{"field":"option_control_consolidated.keyword"}},"contact_consolidated":{"terms":{"field":"option_contact_consolidated.keyword"}},"sensitivity_consolidated":{"terms":{"field":"option_sensitivity_consolidated.keyword"}},"wavelength_consolidated":{"terms":{"field":"option_wavelength_consolidated.keyword"}},"motion_sensor_pir_angle":{"terms":{"field":"option_motion_sensor_pir_angle.keyword"}},"finish_consolidated":{"terms":{"field":"option_finish_consolidated.keyword"}},"head_consolidated":{"terms":{"field":"option_head_consolidated.keyword"}},"features_consolidated":{"terms":{"field":"option_features_consolidated.keyword"}},"rpm_consolidated":{"terms":{"field":"option_rpm_consolidated.keyword"}},"diameter_consolidated":{"terms":{"field":"option_diameter_consolidated.keyword"}},"brand_consolidated":{"terms":{"field":"option_brand_consolidated.keyword"}},"iot_sensors_protocol":{"terms":{"field":"option_iot_sensors_protocol.keyword"}},"connectivity_consolidated":{"terms":{"field":"option_connectivity_consolidated.keyword"}},"accuracy_consolidated":{"terms":{"field":"option_accuracy_consolidated.keyword"}},"reach_consolidated":{"terms":{"field":"option_reach_consolidated.keyword"}},"payload_consolidated":{"terms":{"field":"option_payload_consolidated.keyword"}},"torque_consolidated":{"terms":{"field":"option_torque_consolidated.keyword"}},"nozzle_size_consolidated":{"terms":{"field":"option_nozzle_size_consolidated.keyword"}},"sensors_consolidated":{"terms":{"field":"option_sensors_consolidated.keyword"}},"components_consolidated":{"terms":{"field":"option_components_consolidated.keyword"}},"plc_basic_inputs":{"terms":{"field":"option_plc_basic_inputs.keyword"}},"plc_basic_outputs":{"terms":{"field":"option_plc_basic_outputs.keyword"}},"moisture_sensor_basic_output":{"terms":{"field":"option_moisture_sensor_basic_output.keyword"}},"calibration_consolidated":{"terms":{"field":"option_calibration_consolidated.keyword"}},"moisture_sensor_pro_interface":{"terms":{"field":"option_moisture_sensor_pro_interface.keyword"}},"temperature_consolidated":{"terms":{"field":"option_temperature_consolidated.keyword"}},"programs_consolidated":{"terms":{"field":"option_programs_consolidated.keyword"}},"controller_smart_valves":{"terms":{"field":"option_controller_smart_valves.keyword"}},"controller_weather_based_integration":{"terms":{"field":"option_controller_weather_based_integration.keyword"}},"flight_time_consolidated":{"terms":{"field":"option_flight_time_consolidated.keyword"}},"camera_consolidated":{"terms":{"field":"option_camera_consolidated.keyword"}},"fixed_wing_basic_wingspan":{"terms":{"field":"option_fixed_wing_basic_wingspan.keyword"}},"fixed_wing_pro_endurance":{"terms":{"field":"option_fixed_wing_pro_endurance.keyword"}},"fc_basic_gyro":{"terms":{"field":"option_fc_basic_gyro.keyword"}},"fc_basic_firmware":{"terms":{"field":"option_fc_basic_firmware.keyword"}},"fc_advanced_gnss":{"terms":{"field":"option_fc_advanced_gnss.keyword"}},"blades_consolidated":{"terms":{"field":"option_blades_consolidated.keyword"}},"quadcopter_cinematic_gimbal":{"terms":{"field":"option_quadcopter_cinematic_gimbal.keyword"}},"battery_consolidated":{"terms":{"field":"option_battery_consolidated.keyword"}},"robot_tank_terrain":{"terms":{"field":"option_robot_tank_terrain.keyword"}},"robot_explorer_autonomy":{"terms":{"field":"option_robot_explorer_autonomy.keyword"}},"thickness_consolidated":{"terms":{"field":"option_thickness_consolidated.keyword"}},"hardness_consolidated":{"terms":{"field":"option_hardness_consolidated.keyword"}},"level_consolidated":{"terms":{"field":"option_level_consolidated.keyword"}},"bore_consolidated":{"terms":{"field":"option_bore_consolidated.keyword"}},"stroke_consolidated":{"terms":{"field":"option_stroke_consolidated.keyword"}},"current":{"terms":{"field":"option_current.keyword"}},"resistance":{"terms":{"field":"option_resistance.keyword"}},"capacitance":{"terms":{"field":"option_capacitance.keyword"}},"frequency":{"terms":{"field":"option_frequency.keyword"}},"flash":{"terms":{"field":"option_flash.keyword"}},"tolerance":{"terms":{"field":"option_tolerance.keyword"}},"material":{"terms":{"field":"option_material.keyword"}},"type":{"terms":{"field":"option_type.keyword"}},"length":{"terms":{"field":"option_length.keyword"}},"isolation":{"terms":{"field":"option_isolation.keyword"}}},"size":0}
Path: bitbag_shop_products_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 1 View formatted query View cURL query View query backtrace
curl -XPOST 'http://localhost:9200/bitbag_shop_products_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["COMM_MODULE_SHOP"]}},{"terms":{"product_taxons.keyword":["boospa"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"aggs":{"protocol":{"terms":{"field":"attribute_protocol_en_US.keyword"}},"voltage":{"terms":{"field":"option_voltage.keyword"}},"module_type":{"terms":{"field":"attribute_module_type_en_US.keyword"}},"flight_time":{"terms":{"field":"attribute_flight_time_en_US.keyword"}},"camera_resolution":{"terms":{"field":"attribute_camera_resolution_en_US.keyword"}},"max_speed":{"terms":{"field":"attribute_max_speed_en_US.keyword"}},"weight":{"terms":{"field":"attribute_weight_en_US.keyword"}},"battery_type":{"terms":{"field":"attribute_battery_type_en_US.keyword"}},"control_range":{"terms":{"field":"attribute_control_range_en_US.keyword"}},"payload_capacity":{"terms":{"field":"attribute_payload_capacity_en_US.keyword"}},"dimensions":{"terms":{"field":"attribute_dimensions_en_US.keyword"}},"rayon-angle":{"terms":{"field":"attribute_rayon-angle_en_US.keyword"}},"revetement":{"terms":{"field":"attribute_revetement_en_US.keyword"}},"color_consolidated":{"terms":{"field":"option_color_consolidated.keyword"}},"power_consolidated":{"terms":{"field":"option_power_consolidated.keyword"}},"impedance_consolidated":{"terms":{"field":"option_impedance_consolidated.keyword"}},"single_board_computers_processor":{"terms":{"field":"option_single_board_computers_processor.keyword"}},"single_board_computers_ram":{"terms":{"field":"option_single_board_computers_ram.keyword"}},"antenna_consolidated":{"terms":{"field":"option_antenna_consolidated.keyword"}},"speed_consolidated":{"terms":{"field":"option_speed_consolidated.keyword"}},"efficiency_consolidated":{"terms":{"field":"option_efficiency_consolidated.keyword"}},"regulation_consolidated":{"terms":{"field":"option_regulation_consolidated.keyword"}},"capacity_consolidated":{"terms":{"field":"option_capacity_consolidated.keyword"}},"primary_consolidated":{"terms":{"field":"option_primary_consolidated.keyword"}},"secondary_consolidated":{"terms":{"field":"option_secondary_consolidated.keyword"}},"version_consolidated":{"terms":{"field":"option_version_consolidated.keyword"}},"data_consolidated":{"terms":{"field":"option_data_consolidated.keyword"}},"poles_consolidated":{"terms":{"field":"option_poles_consolidated.keyword"}},"mounting_consolidated":{"terms":{"field":"option_mounting_consolidated.keyword"}},"audio_xlr_pins":{"terms":{"field":"option_audio_xlr_pins.keyword"}},"audio_xlr_gender":{"terms":{"field":"option_audio_xlr_gender.keyword"}},"control_consolidated":{"terms":{"field":"option_control_consolidated.keyword"}},"contact_consolidated":{"terms":{"field":"option_contact_consolidated.keyword"}},"sensitivity_consolidated":{"terms":{"field":"option_sensitivity_consolidated.keyword"}},"wavelength_consolidated":{"terms":{"field":"option_wavelength_consolidated.keyword"}},"motion_sensor_pir_angle":{"terms":{"field":"option_motion_sensor_pir_angle.keyword"}},"finish_consolidated":{"terms":{"field":"option_finish_consolidated.keyword"}},"head_consolidated":{"terms":{"field":"option_head_consolidated.keyword"}},"features_consolidated":{"terms":{"field":"option_features_consolidated.keyword"}},"rpm_consolidated":{"terms":{"field":"option_rpm_consolidated.keyword"}},"diameter_consolidated":{"terms":{"field":"option_diameter_consolidated.keyword"}},"brand_consolidated":{"terms":{"field":"option_brand_consolidated.keyword"}},"iot_sensors_protocol":{"terms":{"field":"option_iot_sensors_protocol.keyword"}},"connectivity_consolidated":{"terms":{"field":"option_connectivity_consolidated.keyword"}},"accuracy_consolidated":{"terms":{"field":"option_accuracy_consolidated.keyword"}},"reach_consolidated":{"terms":{"field":"option_reach_consolidated.keyword"}},"payload_consolidated":{"terms":{"field":"option_payload_consolidated.keyword"}},"torque_consolidated":{"terms":{"field":"option_torque_consolidated.keyword"}},"nozzle_size_consolidated":{"terms":{"field":"option_nozzle_size_consolidated.keyword"}},"sensors_consolidated":{"terms":{"field":"option_sensors_consolidated.keyword"}},"components_consolidated":{"terms":{"field":"option_components_consolidated.keyword"}},"plc_basic_inputs":{"terms":{"field":"option_plc_basic_inputs.keyword"}},"plc_basic_outputs":{"terms":{"field":"option_plc_basic_outputs.keyword"}},"moisture_sensor_basic_output":{"terms":{"field":"option_moisture_sensor_basic_output.keyword"}},"calibration_consolidated":{"terms":{"field":"option_calibration_consolidated.keyword"}},"moisture_sensor_pro_interface":{"terms":{"field":"option_moisture_sensor_pro_interface.keyword"}},"temperature_consolidated":{"terms":{"field":"option_temperature_consolidated.keyword"}},"programs_consolidated":{"terms":{"field":"option_programs_consolidated.keyword"}},"controller_smart_valves":{"terms":{"field":"option_controller_smart_valves.keyword"}},"controller_weather_based_integration":{"terms":{"field":"option_controller_weather_based_integration.keyword"}},"flight_time_consolidated":{"terms":{"field":"option_flight_time_consolidated.keyword"}},"camera_consolidated":{"terms":{"field":"option_camera_consolidated.keyword"}},"fixed_wing_basic_wingspan":{"terms":{"field":"option_fixed_wing_basic_wingspan.keyword"}},"fixed_wing_pro_endurance":{"terms":{"field":"option_fixed_wing_pro_endurance.keyword"}},"fc_basic_gyro":{"terms":{"field":"option_fc_basic_gyro.keyword"}},"fc_basic_firmware":{"terms":{"field":"option_fc_basic_firmware.keyword"}},"fc_advanced_gnss":{"terms":{"field":"option_fc_advanced_gnss.keyword"}},"blades_consolidated":{"terms":{"field":"option_blades_consolidated.keyword"}},"quadcopter_cinematic_gimbal":{"terms":{"field":"option_quadcopter_cinematic_gimbal.keyword"}},"battery_consolidated":{"terms":{"field":"option_battery_consolidated.keyword"}},"robot_tank_terrain":{"terms":{"field":"option_robot_tank_terrain.keyword"}},"robot_explorer_autonomy":{"terms":{"field":"option_robot_explorer_autonomy.keyword"}},"thickness_consolidated":{"terms":{"field":"option_thickness_consolidated.keyword"}},"hardness_consolidated":{"terms":{"field":"option_hardness_consolidated.keyword"}},"level_consolidated":{"terms":{"field":"option_level_consolidated.keyword"}},"bore_consolidated":{"terms":{"field":"option_bore_consolidated.keyword"}},"stroke_consolidated":{"terms":{"field":"option_stroke_consolidated.keyword"}},"current":{"terms":{"field":"option_current.keyword"}},"resistance":{"terms":{"field":"option_resistance.keyword"}},"capacitance":{"terms":{"field":"option_capacitance.keyword"}},"frequency":{"terms":{"field":"option_frequency.keyword"}},"flash":{"terms":{"field":"option_flash.keyword"}},"tolerance":{"terms":{"field":"option_tolerance.keyword"}},"material":{"terms":{"field":"option_material.keyword"}},"type":{"terms":{"field":"option_type.keyword"}},"length":{"terms":{"field":"option_length.keyword"}},"isolation":{"terms":{"field":"option_isolation.keyword"}}},"size":0}'
|
| 3 | 1.20 ms | 0.00 ms |
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["boospa"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace
curl -XPOST 'http://localhost:9200/bitbag_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["boospa"]}}]}},"size":20}'
|
| 4 | 1.20 ms | 0.00 ms |
{"query":{"match_all":{}},"size":1000}
Path: bitbag_taxon_tree_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 1 View formatted query View cURL query View query backtrace
curl -XPOST 'http://localhost:9200/bitbag_taxon_tree_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"match_all":{}},"size":1000}'
|
| 5 | 0.84 ms | 0.00 ms |
{"query":{"match_all":{}},"size":1000}
Path: bitbag_taxon_tree_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 1 View formatted query View cURL query View query backtrace
curl -XPOST 'http://localhost:9200/bitbag_taxon_tree_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"match_all":{}},"size":1000}'
|
| 6 | 1.08 ms | 0.00 ms |
{"query":{"match_all":{}},"size":1000}
Path: bitbag_taxon_tree_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 1 View formatted query View cURL query View query backtrace
curl -XPOST 'http://localhost:9200/bitbag_taxon_tree_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"match_all":{}},"size":1000}'
|
| 7 | 0.67 ms | 0.00 ms |
{"query":{"match_all":{}},"size":1000}
Path: bitbag_taxon_tree_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 1 View formatted query View cURL query View query backtrace
curl -XPOST 'http://localhost:9200/bitbag_taxon_tree_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"match_all":{}},"size":1000}'
|
| 8 | 0.99 ms | 0.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["COMM_MODULE_SHOP"]}},{"terms":{"product_taxons.keyword":["boospa"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"sort":[{"product_created_at":{"order":"asc","unmapped_type":"keyword"}}],"size":0,"track_total_hits":true}
Path: bitbag_shop_products_dev/_search
Query: search_type=query_then_fetch Method: POST (Http on localhost:9200) Item count: 1 View formatted query View cURL query View query backtrace
curl -XPOST 'http://localhost:9200/bitbag_shop_products_dev/_search?search_type=query_then_fetch' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["COMM_MODULE_SHOP"]}},{"terms":{"product_taxons.keyword":["boospa"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"sort":[{"product_created_at":{"order":"asc","unmapped_type":"keyword"}}],"size":0,"track_total_hits":true}'
|
| 9 | 1.51 ms | 0.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["COMM_MODULE_SHOP"]}},{"terms":{"product_taxons.keyword":["boospa"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"sort":[{"product_created_at":{"order":"asc","unmapped_type":"keyword"}}],"from":0,"size":10}
Path: bitbag_shop_products_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 1 View formatted query View cURL query View query backtrace
curl -XPOST 'http://localhost:9200/bitbag_shop_products_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["COMM_MODULE_SHOP"]}},{"terms":{"product_taxons.keyword":["boospa"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"sort":[{"product_created_at":{"order":"asc","unmapped_type":"keyword"}}],"from":0,"size":10}'
|