via https://stackoverflow.com/a/2611745
1
2
3
4
5
6
7
|
SELECT
sum(reltuples)
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE
nspname NOT IN ('pg_catalog', 'information_schema') AND
relkind='r';
|
1
2
3
4
5
6
7
8
|
SELECT
nspname AS schemaname,relname,reltuples
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE
nspname NOT IN ('pg_catalog', 'information_schema') AND
relkind='r'
ORDER BY reltuples DESC;
|
# NOTE: I am not responsible for any expired content.
[email protected]:03:57+08:00
[email protected]:04:24+08:00
[email protected]://github.com/ferstar/blog/issues/40