How to discover which Firebase Paths are causing heavy DB Load?

[Naaman-Saif]

Hi, we are using Firebase Realtime Database, which has 100s of connection at a time

This is how our Stackdriver(Monitoring) looks like for Firebase. We want to find out which firebase paths are being accessed for this specific request.

[marcanthonyb]

Hi @Naaman-Saif ,

You can gather data about your Realtime Database's performance through a few different tools, depending on the level of granularity you need:

• High-level overview: Use the the profiler tool for a list of unindexed queries and a realtime overview of read/write operations.
• Billed usage estimate: Use the usage metrics available in the Firebase console to see your billed usage and high-level performance metrics.
• Detailed drilldown: Use Cloud Monitoring for a more granular look at how your database is performing over time.

I would suggest using the profiler tool to better understand your usage patterns and see where the hotspots are in your reads and writes.

For more information, you may want to look into this documentation.

Regards,
Marc