SELECT n.nspname AS schema, c.relname AS relation, CASE c.relkind WHEN $1 THEN $2 WHEN $3 then $4 ELSE $5 END AS type, pg_table_size(c.oid) AS size_bytes FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname NOT IN ($6, $7) AND n.nspname !~ $8 AND c.relkind IN ($9, $10, $11) ORDER BY pg_table_size(c.oid) DESC, 2 ASC /*pghero*/|
Approx. Time
Origin
|
|
|---|---|
| pghero | 100% |
Total Time ms
Loading...
Average Time ms
Loading...
Calls
Loading...
Tables
| Name | Rows | Indexes |
|---|---|---|
| pg_class | 10,017 |
|
| pg_namespace | 4 |
|