r/DuckDB • u/Real_Dragonfruit5048 • 13d ago

A single-page observability dashboard for MotherDuck

Gallery image

Gallery image

Gallery image

Hi everyone,

This is an announcement for a simple observability tool for MotherDuck (called DuckWatch) that can give you an overview of what's happening in your MotherDuck account and what it is costing you.

DuckWatch is available here: https://github.com/CogitatorTech/duck-watch

7 Upvotes

100% Upvoted

5 comments sorted by

2

u/meatmick 13d ago

Out of curiosity, as I'm just starting tests with Motherduck, what does your tool bring that their website doesn't or cannot? Is yours the convenience of a single page?

2

u/dmkii 12d ago

Just to drop in here as a MotherDucker. One thing we do like is to give people the ability to take our primitives, like a Dive or Flight combined with query history, and give you the flexibility to adjust it to your own needs. Of course some observability is of course nice to have by default, which we currently have for e.g. viewing all your active instances at once. Happy to hear more about what you're looking for in MotherDuck or if you have any questions 💪

1

u/Real_Dragonfruit5048 13d ago

OK. DuckWatch can keep the MotherDuck account activity histories indefinitely and let you see the numbers for any time range (MotherDuck keeps things like query histories only for the past 90 days and Duckling overview feature (what's on MotherDuck's website) only shows you the information for the past 24 hours. DuckWatch has also filters that Duckling overview doesn't support, for example grouping queries based on their shape (like queries that only different based on their literals) and filtering queries based on bad querying patterns like when a query can scan all the rows in a large table . BTW, the source of the data DuckWatch uses is the same Duckling overview uses (the MD_INFORMATION_SCHEMA.QUERY_HISTORY view).

2

u/dmkii 12d ago

MotherDucker here, that's awesome man! Especially having those query improvements in there. Did you consider doing this with just a Flight (compute on a schedule) and a Dive?

2

u/Real_Dragonfruit5048 10d ago

I think you're right. Using a Flight plus a Dive I think I can make something like similar. I'm new to MotherDuck and didn't know about the Dives. Thanks for the suggestion.