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
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"? |