DEV Community

leo
leo

Posted on

OpenGauss common log introduction: performance log

performance log
The performance log mainly focuses on access performance issues of external resources. The performance log refers to the log that the database system detects the running status of physical resources during operation, and the performance detection when accessing external resources, including access detection information of external resources such as disks. When a performance problem occurs, you can use the performance log to locate the cause of the problem in a timely manner, which can greatly improve the problem-solving efficiency.

Log file storage path

The performance log directory of the database node is in the corresponding directory in "$GAUSSLOG/gs_profile".

Log file naming format

Naming rules for performance logs of database nodes:

postgresql-create-time.prf

By default, a new log file will be generated at 0 o'clock every day or when the log file is larger than 20MB or the database instance (database node) is restarted.

Description of log content

The default format of the log content of each line of the database node:

Host name + date + time + instance name + thread number + log content.

Top comments (0)