From: Tom Lane <tgl@sss.pgh.pa.us>
To: Johann Spies <johann.spies@gmail.com>
cc: pgsql-performance@postgresql.org
Subject: Re: Long running query: How to monitor the progress
In-reply-to: 
 <CAGZ55DTvuGvVkcQO4vgNrbQOkFZedGy+5Y5A1qFB3PT5HN2GiA@mail.gmail.com>
References: 
 <CAGZ55DTvuGvVkcQO4vgNrbQOkFZedGy+5Y5A1qFB3PT5HN2GiA@mail.gmail.com>
Comments: In-reply-to Johann Spies <johann.spies@gmail.com>
 message dated "Tue, 25 Aug 2015 09:22:45 +0200"
Date: Tue, 25 Aug 2015 09:50:42 -0400
Message-ID: <19480.1440510642@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Johann Spies <johann.spies@gmail.com> writes:
> Some of hour queries to extract the data and insert it in other tables runs
> for days and in one case we have created a table with 758million unique
> records.

> Now my question. Is there a way to monitor the progress of a long running
> query like this?

You could watch how fast the target table is physically growing, perhaps.
Or I think contrib/pgstattuple could be used to count uncommitted tuples
in it.

			regards, tom lane


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance