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)