diff options
Diffstat (limited to 'contrib/pgstattuple/sql')
| -rw-r--r-- | contrib/pgstattuple/sql/pgstattuple.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/contrib/pgstattuple/sql/pgstattuple.sql b/contrib/pgstattuple/sql/pgstattuple.sql index cfa540302da..5111be0e625 100644 --- a/contrib/pgstattuple/sql/pgstattuple.sql +++ b/contrib/pgstattuple/sql/pgstattuple.sql @@ -100,6 +100,11 @@ select pgstattuple('test_partition'); select pgstattuple_approx('test_partition'); select pg_relpages('test_partition'); +-- toast tables should work +select pgstattuple((select reltoastrelid from pg_class where relname = 'test')); +select pgstattuple_approx((select reltoastrelid from pg_class where relname = 'test')); +select pg_relpages((select reltoastrelid from pg_class where relname = 'test')); + -- not for the index calls though, of course select pgstatindex('test_partition'); select pgstatginindex('test_partition'); |