postgresql - 是否有任何可能或选项来获取导致 postgres 从服务器内存不足的查询

Question

从 postgres 日志中：

2020-06-23 10:15:36 UTC [6052]: [1-1] db=,user= LOG:  could not write temporary statistics file 
"pg_stat_tmp/db_16387.tmp": No space left on device
 2020-06-23 10:15:36 UTC [6052]: [2-1] db=,user= LOG:  could not close temporary statistics file 
"pg_stat_tmp/global.tmp": No space left on device
2020-06-23 10:15:37 UTC [6039]: [8-1] db=,user= FATAL:  could not extend file 
"base/16387/1102307.196": No space left on device
2020-06-23 10:15:37 UTC [6039]: [9-1] db=,user= HINT:  Check free disk space.
2020-06-23 10:15:37 UTC [6039]: [10-1] db=,user= CONTEXT:  xlog redo insert(init): rel 1 
1663/16387/1102307; tid 25769659/1
2020-06-23 10:15:40 UTC [19987]: [11-1] db=prime,user=prime_user ERROR:  could not write block 
6537 of temporary file: No space left on device

是否有任何可能性，并且 postgres 维护有关长期运行查询的日志？

标签： postgresqlpostgresql-9.4