behave: make select sql longer for gpperfmon test
Create a more extensive workload for the sql to make it last longer.
The previous sql was completing too fast and so when the actual pid read
happens, there pid no longer exists and causes the result to be 0.
@@ -108,7 +108,7 @@ Feature: gpperfmon
"""
When below sql is executed in "gptest" db
"""
- select count(*) from sales;
+ select count(*),sum(pow(amt,2)) from sales;
"""
Then wait until the results from boolean sql "SELECT count(*) > 0 FROM queries_history where cpu_elapsed > 1 and query_text like 'select count(*)%'" is "true"
Then wait until the results from boolean sql "SELECT count(*) > 0 FROM queries_history where skew_cpu > 0.05 and db = 'gptest'" is "true"
