How to get the size (MB) of a non-filesystem dataset?

Angels

Hello,

I would like to get the size in MB of a postgreSQL dataset, but I can't find the metric as it is in a filesystem managed dataset.

PostgreSQL metrics:

Filesystem managed metrics:

They are not in the Edit tab, where it is possible to add metrics and custom metrics.

PostgreSQL Edit Tab:

 Filesystem managed Edit Tab:

 

Is it possible? If not, why?

Thanks in advance.

Regards

 

  

JordanB

Hi @Angels
,

As a workaround, you can use a SQL probe with a select statement to retrieve the size of the table.

select pg_size_pretty(pg_relation_size('"table_name"'));

Please let us know if you have any questions.

Thanks,

Jordan

 

JordanB

Hi @Angels
,

Unfortunately, there is not. You would need to create the probe on each dataset.

Please let us know if you have any other questions.

Thanks!

Jordan

Angels

Hi @JordanB
,

Yes, it works! Thank you very much.

Is it possible to create that metric for all the datasets in the flow?

Thanks!