diff options
author | Dessalines <tyhou13@gmx.com> | 2020-01-12 13:04:13 -0500 |
---|---|---|
committer | Dessalines <tyhou13@gmx.com> | 2020-01-12 13:04:13 -0500 |
commit | b79fc265f17ccf9ba1c78a4cf4273941744763a4 (patch) | |
tree | 774381e4c620c64deaf6b1bdae6fd15bbba5baf9 /server/query_testing | |
parent | 146e40597997b10a25ed2044dea234d6799c87a3 (diff) |
Adding an apache bench (ab) report.
Diffstat (limited to 'server/query_testing')
-rwxr-xr-x | server/query_testing/apache_bench_report.sh | 24 | ||||
-rwxr-xr-x | server/query_testing/generate_explain_reports.sh | 3 |
2 files changed, 27 insertions, 0 deletions
diff --git a/server/query_testing/apache_bench_report.sh b/server/query_testing/apache_bench_report.sh new file mode 100755 index 00000000..95b9a6c4 --- /dev/null +++ b/server/query_testing/apache_bench_report.sh @@ -0,0 +1,24 @@ +#!/bin/sh + +declare -a arr=( +"https://mastodon.social/" +"https://peertube.social/" +"https://dev.lemmy.ml/" +"https://dev.lemmy.ml/feeds/all.xml" +"https://dev.lemmy.ml/.well-known/nodeinfo" +"https://fediverse.blog/.well-known/nodeinfo" +) + +## now loop through the above array +for i in "${arr[@]}" +do + ab -c 10 -t 10 "$i" > out.abtest + grep "Server Hostname:" out.abtest + grep "Document Path:" out.abtest + grep "Requests per second" out.abtest + grep "(mean, across all concurrent requests)" out.abtest + grep "Transfer rate:" out.abtest + echo "---" +done + +rm *.abtest diff --git a/server/query_testing/generate_explain_reports.sh b/server/query_testing/generate_explain_reports.sh index e1a2ff51..40b2bcee 100755 --- a/server/query_testing/generate_explain_reports.sh +++ b/server/query_testing/generate_explain_reports.sh @@ -8,6 +8,9 @@ psql -qAt -U lemmy -f explain.sql > user_view.json echo "explain (analyze, format json) select * from post_view where user_id is null order by hot_rank desc" > explain.sql psql -qAt -U lemmy -f explain.sql > post_view.json +echo "explain (analyze, format json) select * from post" > explain.sql +psql -qAt -U lemmy -f explain.sql > post.json + echo "explain (analyze, format json) select * from comment_view where user_id is null" > explain.sql psql -qAt -U lemmy -f explain.sql > comment_view.json |