/* Tidy (DELETE FROM) the public.note table */
DELETE FROM public.note WHERE "createdAt" < NOW() - INTERVAL '10 days';
DELETE FROM public.note_bookmark;
DELETE FROM public.note_edit;
DELETE FROM public.note_like;
DELETE FROM public.note_reaction;
DELETE FROM public.note_thread_muting;
DELETE FROM public.note_unread;
DELETE FROM public.note_watching;
DELETE FROM public.oauth_app;
DELETE FROM public.oauth_token;

/* Tidy (ANALYZE) any table that has had a DELETE performed upon it */
ANALYZE public.note,
	public.note_bookmark,
	public.note_edit,
	public.note_like,
	public.note_reaction,
	public.note_thread_muting,
	public.note_unread,
	public.note_watching,
    public.oauth_app,
    public.oauth_token;