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(dot)klaver(at)aklaver(dot)com