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 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Useful articles

System catalog tables
System catalog views
System statistics views
Progress reporting views

Contrib modules
Storage parameters (relopts)

xlog renaming in Pg 10

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

explain.depesz.com/

pgrowlocks

pgrowlocks is a contrib module which provides a function, pgrowlocks(), to show row locking information for a specified table.

pgrowlocks was added in PostgreSQL 8.2.

Change history

• PostgreSQL 10
  • members of the new default role "pg_stat_scan_tables" may now execute pgrowlocks() (commit 25fff407)
• PostgreSQL 9.6 (version 1.2)
  • parallel query support added (commit 9164deea)
• PostgreSQL 9.3 (version 1.1)
  
  • following changes made to pgrowlocks() result columns (commit 0ac5ad51):
    
    • column lock_type removed
    • column mode added
• PostgreSQL 9.1 (version 1.0)
  • converted to an extension (commit 629b3af2)
• PostgreSQL 8.2
  • added (commit 66126f96)

References

Categories