table lookup for pg_stat_progress_vacuum doesn't work

From: <Uwe(dot)deReuter(at)t-systems(dot)com>
To: <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: table lookup for pg_stat_progress_vacuum doesn't work
Date: 2020-12-16 07:25:11
Message-ID: FR2P281MB01564C115A4122B07655840BD3C50@FR2P281MB0156.DEUP281.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2020-12-16 07:31:02 Re: table lookup for pg_stat_progress_vacuum doesn't work
Previous Message Laurenz Albe 2020-12-15 19:03:59 Re: Create Cluster --- Change the Block Size