pg_stat_statements
track planning and execution statistics of all SQL statements executed
Overview
| 6990 | pg_stat_statements | pg_stat_statements | 1.11 | STAT | PostgreSQL | C |
Attributes
| Yes | No | Yes | Yes | Yes | Unknown | No | - |
Packages
| EL | CONTRIB | postgresql$v-contrib | 1.11 | - | 17 16 15 14 13 |
| Debian | CONTRIB | postgresql-$v | 1.11 | - | 17 16 15 14 13 |
Dependent Extensions
The following extensions depend on this extension: pg_stat_kcache, powa
Availability
| PG17 | PG16 | PG15 | PG14 | PG13 | |
|---|---|---|---|---|---|
el8.x86_64 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
el8.aarch64 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
el9.x86_64 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
el9.aarch64 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
d12.x86_64 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
d12.aarch64 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
u22.x86_64 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
u22.aarch64 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
u24.x86_64 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
u24.aarch64 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
CONTRIB
PGDG
PIGSTY
Download
This extension is built-in with PostgreSQL and does not need separate download.
Install
Extension pg_stat_statements is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Create this extension on PostgreSQL database with:
CREATE EXTENSION pg_stat_statements;