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