search

powa-team / powa-archivist

powa-archivist: the powa PostgreSQL extension
http://powa.readthedocs.io/
PostgreSQL License
52 stars 20 forks source link

store relname in the powa db #3

Closed menardorama closed 7 years ago

menardorama commented 8 years ago

HI,

I'm trying to implement powa-archivist in my organisation and in order to get reporting on table activity I would need to have the relname of the tables.

But all I can see is that relid only is stored; I see also that the fetching is done against the C library but relname is not retreived.

Would it be possible to collect also the relname and store it in small table (like dbid, relid, relname) ?

Thanks

rjuju commented 8 years ago

Hello, We only store the relid because getting the relname would require a connexion to each database for every snapshot, because we would then need to maintain it (changing the relname doesn't change the relid). The C function allows retrieving the info from the statistics collector without any database connexion.

Resolving the name will be done in the UI, same as for quals.