The pgx_stat_sql view displays statistics related to SQL statement executions, with each type of SQL statement displayed on a separate line.
Table C.4 pgx_stat_sql viewColumn | Type | Description |
|---|
selects | bigint | Number of SELECT statements executed |
inserts | bigint | Number of INSERT statements executed |
deletes | bigint | Number of DELETE statements executed |
updates | bigint | Number of UPDATE statements executed |
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 |
