| From: | Julie Nishimura <juliezain(at)hotmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | killing vacuum analyze process |
| Date: | 2019-09-03 23:02:20 |
| Message-ID: | DM6PR08MB50181EC70E5A8560E230A9DFACB90@DM6PR08MB5018.namprd08.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-09-03 23:11:29 | Re: killing vacuum analyze process |
| Previous Message | James Sewell | 2019-09-03 22:45:57 | Re: Upgrade 96 -> 11 |