Description
Give a long running query with forestdb indexer storage mode.
Example:
SELECT tb_G2324.* FROM ( SELECT t_5.*,(SELECT min(t_1.productId) FROM t_5.simple_table_2 t_1 WHERE t_1.primary_key_id=t_5.primary_key_id GROUP BY t_1.price ORDER BY t_1.price limit 1) ABC FROM multiple_table_db_2089_simple_table_1 t_5 WHERE NOT EXISTS (SELECT * FROM multiple_table_db_2089_simple_table_1 t_1 USE KEYS [t_5.primary_key_id] WHERE (((t_1.int_field1 >= 4941 AND t_1.varchar_field1 NOT BETWEEN "ADdJWOgabw" and "zyIoRqXGFe" AND t_1.bool_field1 = false)) OR ((t_1.bool_field1 != true AND t_1.primary_key_id LIKE '%549%'))) AND (((NOT ((((NOT (((t_1.bool_field1 = false OR t_1.int_field1 >= 4941)) OR (t_1.decimal_field1 IS NULL))) AND (NOT (((t_1.bool_field1 = false) AND ((t_1.decimal_field1 IS NOT NULL AND ((t_1.primary_key_id IN [ "1" , "10" , "100" , "1000" , "101" ]) OR (t_1.primary_key_id IN [ "1" , "10" , "100" , "1000" , "101" ])) OR (t_1.char_field1 IS NOT NULL) AND t_1.bool_field1 = true)) OR ((NOT (t_1.bool_field1) OR t_1.primary_key_id IS NULL)) AND ((NOT (t_1.bool_field1) AND t_1.int_field1 > 4941))) AND (NOT (((t_1.int_field1 IS NULL OR t_1.primary_key_id NOT LIKE "549")) AND ((t_1.bool_field1 != false OR t_1.primary_key_id LIKE '549%')) OR ((t_1.bool_field1 = true OR t_1.varchar_field1 NOT LIKE "ZZoCkwEdTf")) AND (t_1.bool_field1 = false)))))) AND ((((t_1.bool_field1 = true OR t_1.primary_key_id IS NOT NULL)) OR ((t_1.varchar_field1 IS NOT NULL AND t_1.int_field1 > 4941))) OR (NOT (t_1.varchar_field1 IN [ "ADdJWOgabw" , "AMhtKtoSvS" , "ARbPXkhaMp" , "ARjUlGZevq" , "ARphGaTplS" ])))) AND (((NOT (t_1.varchar_field1 NOT LIKE '%ZZoCkwEdTf') AND t_1.decimal_field1 != 4789)) AND ((t_1.bool_field1 AND t_1.decimal_field1 = 4789))))) AND (((t_1.primary_key_id <= "549" AND t_1.decimal_field1 IN [ 0 , 6 , 9 , 10 , 16 ])) AND (((t_1.int_field1 < 4941) AND (t_1.decimal_field1 = 4789) AND t_1.char_field1 NOT BETWEEN "A" and "Z" AND t_1.bool_field1 = true)) OR (t_1.char_field1 < "N") AND ((t_1.char_field1 <> "N" AND t_1.decimal_field1 IS NOT NULL)))) AND (NOT (((((NOT ((t_1.int_field1 IN [ 10 , 37 , 41 , 48 , 55 ]) OR (t_1.decimal_field1 = 4789)) AND t_1.varchar_field1 IS NOT NULL AND t_1.bool_field1 != true)) AND ((t_1.int_field1 IN [ 10 , 37 , 41 , 48 , 55 ] AND t_1.primary_key_id IN [ "1" , "10" , "100" , "1000" , "101" ] AND t_1.bool_field1 != true)) OR ((NOT (t_1.decimal_field1 IN [ 0 , 6 , 9 , 10 , 16 ])) AND (t_1.int_field1 < 4941)) AND (t_1.bool_field1)) AND (((t_1.bool_field1 = true OR t_1.varchar_field1 IN [ "ADdJWOgabw" , "AMhtKtoSvS" , "ARbPXkhaMp" , "ARjUlGZevq" , "ARphGaTplS" ])) OR (((t_1.decimal_field1 > 4789 OR t_1.primary_key_id NOT BETWEEN "1" and "999")) AND ((t_1.bool_field1 OR t_1.decimal_field1 > 4789))))) OR (((t_1.int_field1 >= 4941) OR (t_1.decimal_field1 BETWEEN 0 and 9991)) OR ((NOT (t_1.bool_field1) AND t_1.int_field1 >= 4941)))))) ) ) tb_G2324 order by meta().id limit 5 ; |
Please feel free to use the cluster:
Not able to click on monitoring tab or any other tab after running the query. Once the web page cancel/wait page appears, you can click on wait and then you are able to click on monitoring or other tabs.