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/

pg_stat_statements

pg_stat_statements is a contrib module implemented as an extension for tracking execution statistics of SQL statements.

pg_stat_statements was introduced in PostgreSQL 8.4.

Change history

• PostgreSQL 14
  • now tracks the total number of rows retrieved or affected by CREATE TABLE AS, SELECT INTO, CREATE MATERIALIZED VIEW and FETCH commands (commit 6023b7ea)
  • now tracks the total number of rows processed by REFRESH MATERIALIZED VIEW (commit b62e6056)
  • view pg_stat_statements_info added to display statistics about pg_stat_statements operations (initial commit 9fbc3f31)
• PostgreSQL 13
  • configuration option pg_stat_statements.track_utility to track WAL usage statistics (commit 6b466bf5)
  • configuration option pg_stat_statements.track_planning to track planning statistics (commit 17e03282)
• PostgreSQL 12
  • statistics can now be reset for specific databases, users, and queries (commit 43cbedab)
• PostgreSQL 11
  • query ID expanded to 64 bits to reduce the chance of collisions (commit cff440d3)
• PostgreSQL 10
  • ignored constants shown as "$N" rather than "?" (commit a6f22e83)
• PostgreSQL 9.5
  • statistics for minimum, maximum, mean, and standard deviation times added (commit 717f7095)
• PostgreSQL 9.4
  • query text stored in file (commit f0d6f202)
  • records can be returned without the query text (commit f0d6f202)
  • internal query hash identifier exposed (commit 91484409)
• PostgreSQL 9.2
  • SQL text normalization (commit 7313cc01)
  • dirtied buffer counts added (commit 22543674)
  • track_iotiming information exposed (commit 5b4f3466)
• PostgreSQL 9.1
  • converted to an extension (commit 629b3af2)
• PostgreSQL 9.0
  • buffer access counters added (commit 8964dbd5)
• PostgreSQL 8.4
  • added (commit 7466eeac; note that several proceeding commits added infrastructure required for this extension(

References

Useful links

Categories

See also