Query goal: | Find the number of rows in base tables. |
Query type: | General (Overview of some aspect of the database.) |
Query license: | MIT License |
Data source: | system catalog only |
SQL query: | Click on query to copy it
ANALYZE; SELECT n.nspname AS schema_name, c.relname AS table_name, c.reltuples FROM pg_catalog.pg_class c INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace INNER JOIN pg_catalog.pg_authid u ON u.oid = c.relowner WHERE c.relkind IN ('r') AND (n.nspname = 'public' OR u.rolname <> 'postgres') ORDER BY reltuples DESC, n.nspname, c.relname; |
Collection name | Collection description |
---|---|
Find problems by overview | Queries that results point to different aspects of database that might have problems. A human reviewer has to decide based on the results as to whether there are problems or not . |
Category name | Category description |
---|---|
Data at the database logical level | Queries of this category provide information about data in base tables. |