| 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: | Whole Thread | Raw Message | 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
| 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 |