Top
Enterprise Postgres 17 Operation Guide

D.5 pgx_stat_sql

The pgx_stat_sql view displays statistics related to SQL statement executions, with each type of SQL statement displayed on a separate line.

Table D.5 pgx_stat_sql view

Column

Type

Description

selects

bigint

Number of SELECT statements executed

In database multiplexing mode, this number includes the SELECT statements executed in Mirroring Controller. Mirroring Controller executes the SELECT statement using the interval specified for the heartbeat_interval of the server definition file (milliseconds).

inserts

bigint

Number of INSERT statements executed

deletes

bigint

Number of DELETE statements executed

updates

bigint

Number of UPDATE statements executed

selects_with_parallelism

bigint

Number of times parallel scan was used in SELECT statements

inserts_with_parallelism

bigint

Not used

deletes_with_parallelism

bigint

Not used

updates_with_parallelism

bigint

Not used

copies_with_parallelism

bigint

Not used

declares

bigint

Number of DECLARE statements executed (number of cursor OPENs)

fetches

bigint

Number of FETCH statements executed

checkpoints

bigint

Number of CHECKPOINT statements executed

clusters

bigint

Number of CLUSTER statements executed

copies

bigint

Number of COPY statements executed

reindexes

bigint

Number of REINDEX statements executed

truncates

bigint

Number of TRUNCATE statements executed

locks

bigint

Number of times a lock occurred

stats_reset

timestamp with timezone

Last time at which this statistic was reset