pg_stat_activity.query_start in the future?

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема pg_stat_activity.query_start in the future?
Дата
Msg-id 20180817161103.GA22271@telsasoft.com
обсуждение исходный текст
Ответы Re: pg_stat_activity.query_start in the future?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
I'm buried and not having any good ideas how to diagnose this or what else to
send, so here it is.  Feel free to tell me why I'm the one whose confused..

postgres=# SELECT pid, now(), query_start, state, query FROM pg_stat_activity WHERE pid=27757;
  pid  |              now              |          query_start          | state  |                            query
                     
 

-------+-------------------------------+-------------------------------+--------+-------------------------------------------------------------
 27757 | 2018-08-17 11:10:16.568429-04 | 2018-08-17 10:17:52.814282-04 | active | autovacuum: VACUUM ANALYZE
public.eric_enodeb_cell_20180815
(1 row)

postgres=# \! ps -O lstart 27757
  PID                  STARTED S TTY          TIME COMMAND
27757 Fri Aug 17 08:53:20 2018 S ?        00:11:56 postgres: autovacuum worker process   xxxxxton        
postgres=# \! date
Fri Aug 17 11:10:58 EDT 2018

Justin


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Difference between "autovacuum_naptime" and"autovacuum_vacuum_cost_delay"?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_stat_activity.query_start in the future?