From: | Mark Haylock <mh(at)trineo(dot)co(dot)nz> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: What do null column values for pg_stat_progress_vacuum mean? |
Date: | 2020-03-06 02:46:35 |
Message-ID: | CACnJOOrp6UcPQrSDUu-x61Nco1BQ8REVtAKQ+SYCG6Kp+BZj8A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sorry I've failed to mention which postgres version this is with:
PostgreSQL 10.11.
On Fri, Mar 6, 2020 at 3:39 PM Mark Haylock <mh(at)trineo(dot)co(dot)nz> wrote:
>
> Hi,
>
> We have an autovacuum process that has been running for almost 27 hours:
>
> SELECT * FROM pg_stat_activity WHERE pid = 11731;
> -[ RECORD 1 ]----+---------------------------------------
> datid | 16385
> datname | database_name
> pid | 11731
> usesysid |
> usename |
> application_name |
> client_addr |
> client_hostname |
> client_port |
> backend_start | 2020-03-04 23:40:14.828138+00
> xact_start | 2020-03-04 23:40:14.849367+00
> query_start | 2020-03-04 23:40:14.849367+00
> state_change | 2020-03-04 23:40:14.849368+00
> wait_event_type |
> wait_event |
> state | active
> backend_xid |
> backend_xmin | 3801997676
> query | autovacuum: VACUUM public.responses
> backend_type | autovacuum worker
>
> A row shows up in pg_stat_progress_vacuum, but it contains null values
> for every column.
>
> SELECT * FROM pg_stat_progress_vacuum WHERE pid = 11731;
> -[ RECORD 1 ]------+---------------
> pid | 11731
> datid | 16385
> datname | d2j496215lfs41
> relid |
> phase |
> heap_blks_total |
> heap_blks_scanned |
> heap_blks_vacuumed |
> index_vacuum_count |
> max_dead_tuples |
> num_dead_tuples |
>
> I see nothing in the documentation to suggest that this is an expected
> state - what does it mean?
>
> Thanks,
> Mark.
--
Mark Haylock - Developer
Sydney | Christchurch | Auckland | Boulder
e: mh(at)trineo(dot)com | w: trineo.com | ph: +64 3 377 4001
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2020-03-06 08:59:33 | Re: Real application clustering in postgres. |
Previous Message | Mark Haylock | 2020-03-06 02:39:29 | What do null column values for pg_stat_progress_vacuum mean? |