pg_stat_activity.query_start in the future?

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_stat_activity.query_start in the future?
Date: 2018-08-17 16:11:03
Message-ID: 20180817161103.GA22271@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-08-17 16:17:18 Re: pg_stat_activity.query_start in the future?
Previous Message Adrian Klaver 2018-08-17 13:25:37 Re: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"?