How to view running SQL or SQL executed in the past hour?

Follow

jieguo

• September 26, 2023 06:08

How to view running SQL or SQL executed in the past hour?

0

• 

  jieguo

  • September 26, 2023 07:09
  • Edited

  I have solved!

  https://support.heavy.ai/hc/en-us/articles/360047918473-Viewing-Logs-of-the-HeavyDB-#:~:text=The%20syntax%20is%20SQLlogging%20%28true%29%2C%20entered%20under%20the,SQL%20generated%20and%20monitor%20the%20response%20timing%20involved. 

  cd /var/lib/heavyai/storage/log
  tail -f heavydb.INFO 
  
  

  https://docs.heavy.ai/installation-and-configuration/config-parameters/configuration-parameters-for-heavydb 

  

  1

  Comment actions Permalink
• 

  Candido Dessanti

  • September 29, 2023 00:58

  Hi,

  Turning on the enable-logs-system-tables parameter using heavy is an easier way to do that.conf file.
  
  After adding the parameter to the configuration file and restarting the database, a new table called request_logs will pop-up in the information_schema's database.

  Switch to information_schema's database with

  alter session set currect_database='information_schma';

  To get the queries that runs in the past hour, just run this SQL to get all the query you run in the last hour with timings

  select log_timestamp,query_string,execution_time_ms 
  from request_logs 
  where log_timestamp > dateadd('hour',2-1,now());

  The 2-1 is now() will return the timestamp in UTC, and being in UTC+2, I have to add 2 to get the local time.
  
  Hope this help,
  Candido

  1

  Comment actions Permalink

Please sign in to leave a comment.