how do I see which tables are being used the most within my project since I hit my usage limit?
title. I hit my usage limit for my database but I have multiple tables for different projects within that database. Is there anyway I can tell exactly which table was used the most and hit the usage limit?
3 Replies
generous-apricot•11mo ago
Hey! Did you run into the data transfer limit?
It should reset at the beginning of each month
other-emeraldOP•11mo ago
I believe that is correct. I’m just wondering if there’s any way I can know which table was used the most since that’s the project I need to set better limits for
generous-apricot•11mo ago
Unfortunately we currently don't provide query insights out of the box. However, you can use
pg_stat_statements (but there are some caveats ) https://neon.tech/docs/extensions/pg_stat_statements#reset-statisticsNeon
The pg_stat_statements extension - Neon Docs
The pg_stat_statements extension provides a detailed statistical view of SQL statement execution within a Postgres database. It tracks information such as execution counts, total and average execution...