Re: pg_stat_activity.query_start in the future?

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