Yvain's questions

Ubuntu 18.04 PostgreSQL 10.10 Mattermost 5.15

在最重要的启动过程中永远保持

{"level":"info","ts":1570609055.2422519,"caller":"sqlstore/supplier.go:223","msg":"Pinging SQL 主数据库"}

运行此查询

SELECT pid, age(clock_timestamp(), query_start), usename, query, state
FROM pg_stat_activity
WHERE query != '' AND query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;

给我

 pid  |      age       | usename |         query         | state
------+----------------+---------+-------------------------------
 8700 | 00:08:54.84669 | mmuser  | SELECT * FROM Systems | idle

从那里，我如何诊断是什么让这个查询永无止境？