revision-id: 1752d7dfcdb9cb9c6d668ad9276b9feab8b06336 () parent(s): 4ffc3da2ff971ae6b99d150ee52514c89478a9c2 author: Sergei Petrunia committer: Sergei Petrunia timestamp: 2019-02-28 10:24:14 -0500 message: Fix permissions for 20-run-queries-pg.sh, better result print-out --- mariadb-tpcds-tooling2/20-run-queries-pg.sh | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/mariadb-tpcds-tooling2/20-run-queries-pg.sh b/mariadb-tpcds-tooling2/20-run-queries-pg.sh old mode 100644 new mode 100755 index 86d959a..c1e21ff --- a/mariadb-tpcds-tooling2/20-run-queries-pg.sh +++ b/mariadb-tpcds-tooling2/20-run-queries-pg.sh @@ -9,7 +9,9 @@ done (./postgresql-11.2-inst/bin/psql tpcds | tee pg-result.txt) << END select - query_stream, count(*), sum(query_time_ms) / (60*1000) + query_stream, + count(*) as n_queries, + sum(query_time_ms) / (60*1000) as total_time_sec from my_tpcds_result group by