Re: weird long time query
От
Pavel Stehule
Тема
Re: weird long time query
Дата
Msg-id
CAFj8pRAmdc9t84fEysmu_oN18YY18n6LUK3JGXV76TZyxqS-bw@mail.gmail.com
Ответ на
weird long time query (Kaijiang Chen)
Список
Дерево обсуждения
weird long time query Kaijiang Chen <chenkaijiang@gmail.com>
Re: weird long time query Tom Lane <tgl@sss.pgh.pa.us>
Re: weird long time query Kaijiang Chen <chenkaijiang@gmail.com>
How to prevent POSTGRES killing linux system from accepting too much inserts? "James(王旭)" <wangxu@gu360.com>
Re: How to prevent POSTGRES killing linux system from accepting toomuch inserts? Osahon Oduware <osahon.gis@gmail.com>
Re: How to prevent POSTGRES killing linux system from accepting toomuch inserts? Merlin Moncure <mmoncure@gmail.com>
Re: How to prevent POSTGRES killing linux system from accepting toomuch inserts? Jeff Janes <jeff.janes@gmail.com>
Re: weird long time query Pavel Stehule <pavel.stehule@gmail.com>
út 17. 12. 2019 v 11:45 odesílatel Kaijiang Chen <chenkaijiang@gmail.com> napsal:
I'm using postgres 9.4.17 on centos 7.I check the running queries with the following SQL:SELECT
procpid,
start,
now() - start AS lap,
current_query
FROM
(SELECT
backendid,
pg_stat_get_backend_pid(S.backendid) AS procpid,
pg_stat_get_backend_activity_start(S.backendid) AS start,
pg_stat_get_backend_activity(S.backendid) AS current_query
FROM
(SELECT pg_stat_get_backend_idset() AS backendid) AS S
) AS S
WHERE
current_query <> '<IDLE>'
ORDER BY
lap DESC;
I think so this query is weird - probably this query was finished
you should to use constraint
WHERE state <> 'idle';
Regards
Pavel
Then, I found a SQL that has run for some days (and still running):procpid | 32638
start | 2019-11-25 16:29:29.529318+08
lap | 21 days 18:24:54.707369
current_query | DEALLOCATE pdo_stmt_00000388I tried to kill it with: SELECT pg_cancel_backend(32638) but it takes no effects.What's this query and what shall I do for it?Best WishesKaijiang
В списке pgsql-performance по дате отправления
От: Andres Freund
Дата:
От: Laurenz Albe
Дата:
