pg_permissions is a simple set of views to see all permissions in a PostgreSQL database.

This extensions tracks WHERE clauses predicates and JOIN predicates. Statistics will report whether the predicate was evaluated as an index scan or not, how many time the expression appeared, how many times the operator was executed and how filtering the expression is. If pg_stat_statements is enabled, it can also track to which statements the predicate belongs.

Roaring bitmaps are compressed bitmaps which tend to outperform conventional compressed bitmaps such as WAH, EWAH or Concise. In some instances, roaring bitmaps can be hundreds of times faster and they often offer significantly better compression. They can even be faster than uncompressed bitmaps.

This PostgreSQL extension shows the query plans of all currently running SQL statements. Plan output format can be plain text (default), JSON, YAML, or XML.

pg_snakeoil provides functions scanning PostgreSQL data for viruses using the ClamAV anti-virus engine.

The pg_squeeze PostgreSQL extension removes unused space from a table and optionally sorts tuples according to particular index, as if the CLUSTER command was executed concurrently with regular reads/writes.