Need information regarding different Appian log files

I appreciate your support, both of you. I got the required information.

1) Which log file is used to view users' activity like password Change, user type change, reactivate/deactivate, username change?
System log/Audit/password_resets.csv,user_management.csv.....

2) Which log file to view the process failure in detail?
System log/design_errors.csv

3) Log file to view the user login audit?
System log/login-audit.csv

4) Log file to give details about slow queries?
System log/perf_monitor_rdbms.csv