pgPedia

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Top / P

• Browse categories
• PostgreSQL releases
  • PostgreSQL 15 (dev)
  • PostgreSQL 14 (beta3)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

pgstattuple

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)
• 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)
  • rows from uncommitted transactions no longer counted as dead (commit 80c79ab2)
• 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

Categories

See also