Search Postgresql Archives

killing vacuum analyze process

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux