Friday, 9 September 2022

Postgresql - List all table rows count in the schema

 SELECT 

        schemaname,

        relname,

        n_live_tup AS EstimatedCount 

FROM pg_stat_user_tables 

ORDER BY n_live_tup 

DESC LIMIT 5;

No comments:

Snowflake - Cost Optimization

Reduce auto-suspend to 60 seconds Reduce virtual warehouse size Ensure minimum clusters are set to 1 Consolidate warehouses Separate warehou...