table lookup for pg_stat_progress_vacuum doesn't work - Mailing list pgsql-admin

From
Subject table lookup for pg_stat_progress_vacuum doesn't work
Date
Msg-id FR2P281MB01564C115A4122B07655840BD3C50@FR2P281MB0156.DEUP281.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: table lookup for pg_stat_progress_vacuum doesn't work  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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 by date:

Previous
From: Ron
Date:
Subject: Re: Create Cluster --- Change the Block Size
Next
From: Laurenz Albe
Date:
Subject: Re: table lookup for pg_stat_progress_vacuum doesn't work