diff options
author | Dessalines <tyhou13@gmx.com> | 2020-01-11 17:30:44 -0500 |
---|---|---|
committer | Dessalines <tyhou13@gmx.com> | 2020-01-11 17:30:44 -0500 |
commit | 253f4aa6a1f3d7d8e6477addd4331e5eb7118d28 (patch) | |
tree | 212e62e9ed66aa3a6b5f944bbf0d2b9282d55c5c /server/query_testing/generate_explain_reports.sh | |
parent | 5f3190037542a32295a98098c8cee3b291538912 (diff) |
Back to just indexes.
Diffstat (limited to 'server/query_testing/generate_explain_reports.sh')
-rwxr-xr-x | server/query_testing/generate_explain_reports.sh | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/server/query_testing/generate_explain_reports.sh b/server/query_testing/generate_explain_reports.sh index ddfa5a82..e1a2ff51 100755 --- a/server/query_testing/generate_explain_reports.sh +++ b/server/query_testing/generate_explain_reports.sh @@ -14,6 +14,9 @@ psql -qAt -U lemmy -f explain.sql > comment_view.json echo "explain (analyze, format json) select * from community_view where user_id is null order by hot_rank desc" > explain.sql psql -qAt -U lemmy -f explain.sql > community_view.json +echo "explain (analyze, format json) select * from site_view limit 1" > explain.sql +psql -qAt -U lemmy -f explain.sql > site_view.json + grep "Execution Time" *.json rm explain.sql |