Contents
pgstattuple
A contrib module providing functions for tuple-level statistics
pgstattuple
is a contrib module providing various functions for obtaining tuple-level statistics.
pgstattuple
was added in PostgreSQL 7.2.
Change history
- PostgreSQL 14
- function
pgstattuple_approx()
can report on TOAST tables (commit ee0202d5)
- function
- PostgreSQL 10
- PostgreSQL 9.5
- function
pgstattuple_approx()
added (commit 5850b20f)
- function
- PostgreSQL 9.4
- PostgreSQL 9.3
- function
pgstatginindex()
added (commit 357cbaae)
- function
- PostgreSQL 9.1
- PostgreSQL 8.4
pgstatindex()
andpg_relpages()
adapted to handle tables and indexes with over 2 billion pages (commit d287818e)
- PostgreSQL 8.3
- following functions moved to new contrib module pageinspect (commit 64058429):
bt_metap()
bt_page_items()
bt_page_stats()
- function execution restricted to superusers (commit 38c75ecf)
- following functions moved to new contrib module pageinspect (commit 64058429):
- PostgreSQL 8.2
- following functions added (commit 74924d29):
pgstatindex()
pg_relpages()
bt_metap()
bt_page_items()
bt_page_stats()
- following functions added (commit 74924d29):
- PostgreSQL 7.2
- added (commit 9a23885f), although it was not included in the release notes
References
- PostgreSQL documentation: pgstattuple