Re: [HACKERS] [PATCH v3] pg_progress() SQL function to monitorprogression of long running SQL queries/utilities - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [HACKERS] [PATCH v3] pg_progress() SQL function to monitorprogression of long running SQL queries/utilities
Date
Msg-id CAFj8pRDVH7WbHhwZKi3SmLhF+3LPfhbNf6cr5Lh0t6W-9WbwMQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] [PATCH v3] pg_progress() SQL function to monitorprogression of long running SQL queries/utilities  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] [PATCH v3] pg_progress() SQL function to monitorprogression of long running SQL queries/utilities
List pgsql-hackers


2017-07-26 15:27 GMT+02:00 Robert Haas <robertmhaas@gmail.com>:
On Wed, Jun 21, 2017 at 10:01 AM, Remi Colinet <remi.colinet@gmail.com> wrote:
> test=# SELECT  pid, ppid, bid, concat(repeat(' ', 3 * indent),name), value,
> unit FROM pg_progress(0,0);
>   pid  | ppid | bid |      concat      |      value       |  unit
> -------+------+-----+------------------+------------------+---------
>  14106 |    0 |   4 | status           | query running    |
>  14106 |    0 |   4 | relationship     | progression      |
>  14106 |    0 |   4 |    node name     | Sort             |
>  14106 |    0 |   4 |    sort status   | on tapes writing |
>  14106 |    0 |   4 |    completion    | 0                | percent
>  14106 |    0 |   4 |    relationship  | Outer            |
>  14106 |    0 |   4 |       node name  | Seq Scan         |
>  14106 |    0 |   4 |       scan on    | t_10m            |
>  14106 |    0 |   4 |       fetched    | 25049            | block
>  14106 |    0 |   4 |       total      | 83334            | block
>  14106 |    0 |   4 |       completion | 30               | percent
> (11 rows)
>
> test=#

Somehow I imagined that the output would look more like what EXPLAIN produces.

me too.

Regards

Pavel
 

> If the one shared memory page is not enough for the whole progress report,
> the progress report transfert between the 2 backends is done with a series
> of request/response. Before setting the latch, the monitored backend write
> the size of the data dumped in shared memory and set a status to indicate
> that more data is to be sent through the shared memory page. The monitoring
> backends get the result and sends an other signal, and then wait for the
> latch again. The monitored backend does not collect a new progress report
> but continues to dump the already collected report. And the exchange goes on
> until the full progress report has been dumped.

This is basically what shm_mq does.  We probably don't want to
reinvent that code, as it has taken a surprising amount of debugging
to get it fully working.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

pgsql-hackers by date:

Previous
From: Pavel Golub
Date:
Subject: [HACKERS] AlterUserStmt anmd RoleSpec rules in grammar.y
Next
From: Ashutosh Sharma
Date:
Subject: Re: [HACKERS] pl/perl extension fails on Windows