Hello there,
PostgreSQL 9.6.2 on x86_64-pc-linux-gnu
It seems like we have one process running since 8/19. Is it any repercussion if we kill it?
postgres=# select * from pg_stat_activity where pid = '18986';
-[ RECORD 1 ]----+-------------------------------------------------------------------------
datid | 2342921
datname | symphony_middleware
pid | 18986
usesysid | 10
usename | postgres
application_name |
client_addr |
client_hostname |
client_port |
backend_start | 2019-08-19 02:00:59.683198+00
xact_start | 2019-08-19 02:03:54.191741+00
query_start | 2019-08-19 02:03:54.191741+00
state_change | 2019-08-19 02:03:54.191742+00
wait_event_type | BufferPin
wait_event | BufferPin
state | active
backend_xid |
backend_xmin | 1075730757
query | autovacuum: VACUUM ANALYZE public.resource_build (to prevent wraparound)