Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
โ
โโ
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
โ
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
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
โ
Hi @JordanB,
Yes, it works! Thank you very much.
Is it possible to create that metric for all the datasets in the flow?
Thanks!
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