What do null column values for pg_stat_progress_vacuum mean?

Поиск
Список
Период
Сортировка
От Mark Haylock
Тема What do null column values for pg_stat_progress_vacuum mean?
Дата
Msg-id CACnJOOpYYLjYLvgGXZTs4yDBLVhK5fys4yhYveZnmCASgKZrzw@mail.gmail.com
обсуждение исходный текст
Ответы Re: What do null column values for pg_stat_progress_vacuum mean?
Re: What do null column values for pg_stat_progress_vacuum mean?
Список pgsql-general
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.



В списке pgsql-general по дате отправления:

Предыдущее
От: greigwise
Дата:
Сообщение: Table with many NULLS for indexed column yields strange query plan
Следующее
От: Mark Haylock
Дата:
Сообщение: Re: What do null column values for pg_stat_progress_vacuum mean?