pgsql

[amdgaming]

pgsql有 可以查出 某一段时间 比较慢的sql吗？
比如oracle awr 或者差相关的 视图等等 可以做到的

[trainee]

要打开postgresql.conf中的设置 log_min_duration_statement： Causes the duration of each completed statement to be logged if the statement ran for at least the specified number of milliseconds. Setting this to zero prints all statement durations. Minus-one (the default) disables logging statement durations. For example, if you set it to 250ms then all SQL statements that run 250ms or longer will be logged. Enabling this parameter can be helpful in tracking down unoptimized queries in your applications. Only superusers can change this setting.