summaryrefslogtreecommitdiff
path: root/databases/postgresql90-monitoring/DESCR
blob: a7d6d0fd01670fade893d9e09c7d1111226c7b38 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
This package provides the following PostgreSQL modules:
  - auto_explain
  - pg_buffercache
  - pg_stat_statements
  - pgstattuple

The "auto_explain" module provides a means for logging execution
plans of slow statements automatically, without having to run
EXPLAIN(7) by hand. This is especially helpful for tracking down
un-optimized queries in large applications.

The "pg_buffercache" module provides a means for examining what's
happening in the shared buffer cache in real time.

The "pg_stat_statements" module provides a means for tracking
execution statistics of all SQL statements executed by a server.

The "pgstattuple" module provides various functions to obtain
tuple-level statistics.