(CASEWHEN(status_codebetween200and299)THEN1ELSE0END)assuccess_count,SUM(CASEWHEN(status_codebetween200and299)THEN0ELSE1END)aserror_count,SUM(response_time_msec) /COUNT(1)ASaverage_response_time_msecFROMhttp_request-- roll up only data new since last_rollup_timeWHEREdate_trunc('minute', ...
実行前のテーブルの状態は、前述のbulk insert実施後を想定 パターン1 case式で分岐させる updatetest_tablesetname=caseidwhen1then'one_upd'when2then'two_upd'when3then'three_upd'end,note=caseidwhen1then'ichi'when2then'ni'when3then'san'endwhereidin(1,2,3); パターン2 各値をパラメータ...