[taler-grid5k] 188/189: add more output to explain.py

[gnunet]

This is an automated email from the git hooks/post-receive script.

marco-boss pushed a commit to branch master
in repository grid5k.

commit 4718cb775553d11bd72094a8ffd3ae7c0e39f96f
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Tue Apr 26 23:08:11 2022 +0200

    add more output to explain.py
---
 additional/explain-visualizer/explain.py | 17 +++++++++++++----
 1 file changed, 13 insertions(+), 4 deletions(-)

diff --git a/additional/explain-visualizer/explain.py 
b/additional/explain-visualizer/explain.py
index 36c02b9..e201c50 100755
--- a/additional/explain-visualizer/explain.py
+++ b/additional/explain-visualizer/explain.py
@@ -13,7 +13,9 @@ import sys
 
 try:
     import sqlparse
+    have_sqlparse = True
 except ImportError:
+    have_sqlparse = False
     print("NOTE: install sqlparse to get prettier sql statements")
 
 
@@ -106,7 +108,7 @@ def print_query(sql):
     Print an sql query to stdout
     """
     print("\n" + "=" * 80 + "\n")
-    if sqlparse:
+    if have_sqlparse:
         print(sqlparse.format(sql, 
                               reindent=True, 
                               keyword_case='upper', 
@@ -305,6 +307,9 @@ def parse_visualize_and_get_summary(analyze_json) -> str:
     print("\nPartitions Hit:")
     print("---------------\n")
     total_partitions_hit = print_summary_and_get_total('partitions_hit')
+    print("\nPartitions Hit on full Execution (will be hit if filters match):")
+    print("---------------\n")
+    total_possible_hits = 
print_summary_and_get_total('would_have_hit_partitions')
     print("\nNon Indexed Scans on:")
     print("---------------------\n")
     total_non_indexed_scans = print_and_get_non_indexed()
@@ -326,7 +331,7 @@ def parse_visualize_and_get_summary(analyze_json) -> str:
       time,
       plan['Actual Rows'],
       total_sub_rows,
-      total_partitions_hit,
+      str(total_partitions_hit)+" ("+str(total_possible_hits)+")",
       total_non_indexed_scans
     )
 
@@ -537,8 +542,12 @@ def main():
 
     global args
     args = parser.parse_args()
-
-    args.func()
+    
+    try:
+        args.func()
+    except:
+        parser.print_help()
+        parser.exit()
 
 
 if __name__ == '__main__':

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.