Обсуждение: pg_stat_activity.query_start in the future?

Поиск
Список
Период
Сортировка

pg_stat_activity.query_start in the future?

От
Justin Pryzby
Дата:
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


Re: pg_stat_activity.query_start in the future?

От
Adrian Klaver
Дата:
On 08/17/2018 09:11 AM, Justin Pryzby wrote:
> 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

Looks to me like the autovacuum process started at ~08:53 and the most 
recent query in that process ran at ~10:17


https://www.postgresql.org/docs/10/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW

"query_start     timestamp with time zone     Time when the currently active 
query was started, or if state is not active, when the last query was 
started"
> 
> Justin
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com