Thread
#prefect-community
    Luis Gallegos

    Luis Gallegos

    1 year ago
    Hi all! I want to know if there any way to free space of the database psql running with docker, over the UI or a clean way like graphql. And avoid make forced directly in the database. Something like...
    query {
      database {
        name: prefet_server
        table: flow_run
        action: flush
        where: date <= '2020-12-31'
    		
      }
    }
    Michael Adkins

    Michael Adkins

    1 year ago
    Hi @Luis Gallegos you'll have to probably connect to the database and run pure SQL for this since it's not a query it's a mutation. That said, almost everything has
    updated
    /
    created
    timestamps and should be relatively easy to delete. Most deletes cascade as well so if you delete a flow then it'll also delete related flow runs.
    There are auto-generated hasura mutations you could use but we do not formally support them https://hasura.io/docs/1.0/graphql/core/mutations/delete.html
    Luis Gallegos

    Luis Gallegos

    1 year ago
    @Michael Adkins Thanks! I'll check