Saving workflows run history

Hi there.

I'm curious, is there a way to store and review workflow run history without accessing specific workflow?
I want to have access to all workflows run histories (name, timestamp, status) that have run this month. Is there already functionality for this or do I need to create a custom one?

Hey @mathias! If you are Self-Hosted (instead of Cloud), you could query for this, but otherwise (on Cloud), a custom option (like pushing run history data to a database) would be best.

1 Like

Hey,
Would you be able to explain a bit more about querying this data on self hosted?
Thanks

You can configure a Postgres resource to hit the storage database for your instance 7 (this is separate from Retool Database) using the same credentials that are in your instance's environment variables!

The default setup would look something like this:

image

For example, there's a users table in the database with information like this:

image

Hi Victoria,
Can you please elaborate on how to access run history from within the workflow?We have a cloud system, and would really benefit from a monitoring workflow metrics tool / dashboard.
Thanks!

Hello @David_Paez!

Unfortunately Victoria is no longer with the team.

However, I did find docs on how to access run history for workflows!

Check that out here :slightly_smiling_face:

At the bottom of the page, it details how to extend the retention period.

Also here is a link to the docs for workflow usage monitoring!

Unfortunately it isn't much of a dashboard but Retool is great for building dashboards.

Hope this helps!

Hi Jack,
Thanks for your message.

I know about the run history on the button of the page. What I'm looking for is somekind of WorkflowAPI that or DB access that I can access to gain insights into my workflow run metrics. The usage monitoring provided by Retool is not enough and I want to build my own dashboard.

Thanks!

Ah ok good to know.

I can definitely check with the team to see if there is more data stored in the instance Retool Postgres DB. Are you self hosted or on the cloud?

What metrics are a priority for you to have access to? I may need to make a feature request :sweat_smile:

It looks like run history has a list of recent runs, each with their date, time, their status and the usage monitoring has workflow bandwidth, runs, and total number of active workflows for the current period.