pgstattuple

A contrib module providing various functions to obtain tuple-level statistics

pgstattuple is a contrib module providing various functions to obtain tuple-level statistics.

pgstattuple was added in PostgreSQL 7.2 (commit 9a23885f).

Change history

PostgreSQL 10
- function pgstathashindex() added (commit e759854a)
- reduce locking when examining a hash index (commit d4b5d4ca)
- GRANT permissions used to control pgstattuple function usage (commit fd321a1d)
PostgreSQL 9.5
- function pgstattuple_approx() added (commit 5850b20f)
PostgreSQL 9.4
- functions converted to use regclass types as the argument (commit 1dc11866)
PostgreSQL 9.3
- function pgstatginindex() added (commit 357cbaae)
PostgreSQL 9.1
- converted to an extension (commit 629b3af2)
PostgreSQL 8.4
- pgstatindex() and pg_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)
PostgreSQL 8.2
- following functions added (commit 74924d29):
  - pgstatindex()
  - pg_relpages()
  - bt_metap()
  - bt_page_items()
  - bt_page_stats()
PostgreSQL 7.2
- added (commit 9a23885f), although it was not included in the release notes

References

PostgreSQL documentation: pgstattuple

Categories

See also