killing vacuum analyze process
| От | Julie Nishimura |
|---|---|
| Тема | killing vacuum analyze process |
| Дата | |
| Msg-id | DM6PR08MB50181EC70E5A8560E230A9DFACB90@DM6PR08MB5018.namprd08.prod.outlook.com обсуждение исходный текст |
| Ответы |
Re: killing vacuum analyze process
|
| Список | 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)
В списке pgsql-general по дате отправления: