Hi all! I want to know if there any way to free sp...
# prefect-community
l
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...
Copy code
query {
  database {
    name: prefet_server
    table: flow_run
    action: flush
    where: date <= '2020-12-31'
		
  }
}
z
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
l
@Zanie Thanks! I'll check