Re: Analyze command running for 2063 minutes so far

2019-06-28 Thread tony
On 2019-06-28 10:15, Tom Lane wrote: t...@exquisiteimages.com writes: I started an Analyze command on a database Wednesday evening at around 9:00PM. it is now Friday morning at 8:00 and it is still running. ... I did try to execute: SELECT pg_cancel_backend(4029); and SELECT pg_terminate_backend

Re: Analyze command running for 2063 minutes so far

2019-06-28 Thread Tom Lane
t...@exquisiteimages.com writes: > I started an Analyze command on a database Wednesday evening at around > 9:00PM. it is now Friday morning at 8:00 and it is still running. > ... > I did try to execute: > SELECT pg_cancel_backend(4029); > and > SELECT pg_terminate_backend(4029); > but neither had

Analyze command running for 2063 minutes so far

2019-06-28 Thread tony
Hello, I started an Analyze command on a database Wednesday evening at around 9:00PM. it is now Friday morning at 8:00 and it is still running. If I execute the query: select max(last_analyze) from pg_stat_user_tables; The result I receive is: 6/27/2019 8:27 AM So it appears that no analyze