table lookup for pg_stat_progress_vacuum doesn't work

Поиск
Список
Период
Сортировка
От
Тема table lookup for pg_stat_progress_vacuum doesn't work
Дата
Msg-id FR2P281MB01564C115A4122B07655840BD3C50@FR2P281MB0156.DEUP281.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответы Re: table lookup for pg_stat_progress_vacuum doesn't work
Список pgsql-admin

Hello !

We want to lookup the table name for entries we see in pg_stat_progress_vacuum.

When we do this based on relid from pg_stat_progress_vacuum we don’t find an entry in the pg_class table (no match where pg_stat_progress_vacuum.relid=pg_class.oid).

Should that happen at all and where can I do the lookup if not in pg_class ?

 

Here is one example how it looks like:

select relid::regclass as tablename, relid  from pg_stat_progress_vacuum

 

tablename                         relid

449463                                 449463                 No tablename, no entry in pg_class for this id

pg_largeobject                 2613                      That’s how it should look like.   

 

Best regards

Uwe

 

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: Create Cluster --- Change the Block Size
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: table lookup for pg_stat_progress_vacuum doesn't work