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 viewColumn | 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 |